字符串函数
返回结果如下：+-+-+|goods_name|name_length|+-+-+|goods_name_3|12|IFNULL 如果 expr1 的值为空，则返回 expr2 的值。如果 expr1 的值不为空，则返回 expr1 的值。语法 IFNULL(expr1,expr2)说明 expr1 和 expr2 的数据类型相同。如果 ...
ALTER TABLE
(column_name column_definition,.)|ADD[CONSTRAINT[symbol]]FOREIGN KEY(fk_column_name)REFERENCES pk_table_name(pk_column_name)|ADD FULLTEXT[INDEX|KEY]index_name(column_name)[index_option]|ADD {INDEX|KEY}[index_name](column_...
alicloud_cr_chain
create=false default_visibility="PUBLIC"} resource"alicloud_cr_ee_repo""default"{ instance_id=alicloud_cr_ee_instance.default.id namespace=alicloud_cr_ee_namespace.default.name name=var.name summary="this is summary of my ...
alicloud_cr_ee_sync_rule
cr_ee_namespace.source.name name=var.name summary="this is summary of my new repo"repo_type="PUBLIC"detail="this is a public repo"} resource"alicloud_cr_ee_repo""target"{ instance_id=alicloud_cr_ee_instance.target.id ...
中间件
iot.hosting.${initialize.k8s.mysql.name}.mysqlUrl jdbc:mysql:/${initialize.k8s.mysql.name}:3306/${initialize.k8s.mysql.mysqlDatabase} sqlserver 数据库用户名 iot.hosting.${initialize.k8s.mssql.name}.mssqlUser 数据库密码 iot...
清理隐私权限
由于 Android 系统的升级变迁和 mPaaS 自身业务的发展等历史原因，在默认的 portal 工程中会存在一部分冗余权限，如下列表所示。这些权限在当前的 mPaaS 版本中已经不再需要，您可以选择删除或按需保留。高危可清理权限 以下 5 个是高危...
Quick BI如何进行交叉分析
name_A from user_cross_analytic group by user_id,channel_name)a left join(select user_id,channel_name as channel_name_B from user_cross_analytic group by user_id,channel_name)b on a.user_id=b.user_id and a.channel_name_A<>...
如何合理选择数据特征
日志B 配置查询和分析语句为*|select_time_-_time_%60 as_time_,avg(if(metric_name='cpu_util',value,0))as value,service_name,host_name from log group by_time_,service_name,host_name limit 1000。配置 时间项 为_time_。配置 实体...
alicloud_ots_tunnel
name>:<tunnel_name>.tunnel_id-The tunnel id of the OTS which could not be changed.tunnel_rpo-The latest consumption time of the tunnel,unix time in nanosecond.tunnel_stage-The stage of OTS tunnel,valid values:...
alicloud_ram_users
This data source provides a list of RAM users in an Alibaba Cloud account according to the specified filters.->NOTE:Available since v1.0.0+.Example Usage provider"alicloud"{ region=...names=["${alicloud_ram_user.default.name...
alicloud_dcdn_domain_config
see Batch set config.->NOTE:Available since v1.131.0.Example Usage Basic Usage variable"domain_name"{ default="alibaba-example.com" } resource "alicloud_dcdn_domain" "example" { domain_name= var.domain_name scope="overseas...
alicloud_ots_secondary_index
referenced from Table's primary keys or predefined columns.Attributes Reference The following attributes are exported:id-The resource ID.The value is<instance_name>:<table_name>:<indexName>:<indexType>.Timeouts The ...
排序优化和执行
返回信息如下：Project(name="name")MemSort(sort="name ASC,name0 ASC")Project(name="name",name0="name0")BKAJoin(condition="id=id",type="inner")Gather(concurrent=true)LogicalView(tables="t1",shardCount=2,sql="SELECT `id`,`...
PyODPS的空值处理
1,0))+IF(t1.`f4` IS NOT NULL,1,0))>=4 Instance ID:20191010071154980g2hic292 id name f1 f2 f3 f4 0 0 name1 1.0 NaN 3.0 4.0 1 1 name1 2.0 NaN NaN 1.0 2 2 name1 3.0 4.0 1.0 NaN 3 3 name1 NaN 1.0 2.0 3.0 4 4 name1 1.0 NaN 3.0 ...
SECURITY LABEL
语法 SECURITY LABEL[FOR provider]ON { TABLE object_name|COLUMN table_name.column_name|AGGREGATE aggregate_name(aggregate_signature)|DATABASE object_name|DOMAIN object_name|EVENT TRIGGER object_name|FOREIGN TABLE object_...
alicloud_ram_group_membership
name="user_display_name1"mobile="86-18688888889"email="hello.uuu@aaa.com" comments = "yoyoyo" } resource "alicloud_ram_group_membership" "membership" { group_name= alicloud_ram_group.group.name user_names=[alicloud_ram_user...
容器安全策略规则库说明
v1 kind:Pod metadata:name:bad namespace:test-gatekeeper spec:containers:name:mycontainer image:redis env:name:SECRET_USERNAME valueFrom:secretKeyRef:name:mysecret key:username-name:SECRET_PASSWORD valueFrom:secretKeyRef:...
DBMS_ASSERT
qualified_sql_name-HelloPolarDB(1 row)-invalid name SELECT DBMS_ASSERT.QUALIFIED_SQL_NAME('Hello PolarDB')FROM dual;ERROR:invalid qualified SQL name SCHEMA_NAME 该函数用于 验证输入的字符串是否是一个现有的模式名称。语法 ...
表的创建和使用
新增和删除列 ALTER TABLE db_name.table_name ADD COLUMN column_name bigint ALTER TABLE db_name.table_name ADD COLUMN column_name bigint default 1234 ALTER TABLE db_name.table_name ADD COLUMN column_name bigint comment '...
alicloud_fcv2_function
store""default"{ project=alicloud_log_project.default.name name=var.name retention_period="3000"shard_count=1 }#add index for logstore,which is used to query logs locals { sls_default_token=",'\;()[]{}?\t\r"} resource...
ListDeviceTypes
Action=ListDeviceTypes&<公共请求参数>正常返回示例 XML 格式<ListDeviceTypesResponse><RequestId>E94C9864-56FB-44AD-AC0C-A1CEFB332254</RequestId><DeviceTypes><Name>路由器</Name><DeviceType>router</DeviceType></DeviceTypes>...
apply_config_to_machine_group
请求语法 aliyunlog log apply_config_to_machine_group-project_name=<value>-config_name=<value>-group_name=[-access-id=][-access-key=][-sts-token=][-region-endpoint=][-client-name=][-jmes-filter=][-format-output=][-decode-...
算法输出定义
true,"isSearchEngineField":true,"isMessageQueueField":true },{"name":"objId","type":"string","mandatory":true,"isDatabaseField":true,"isSearchEngineField":true,"isMessageQueueField":true },{"name":"objType","type":"string...
JSON索引
语法 CREATE TABLE table_name(column_name column_type,index index_name(column_name|column_name->'$.json_path'))DISTRIBUTED BY HASH(column_name);参数说明 参数 说明 index_name JSON索引名称。重要 索引名称唯一，不能相同。column...
Package的权限控制
grant<actions>on<object_type><object_name>to[user|role]<name>privilegeproperties("refobject"="true","refproject"="<project_name>","package"="<package_name>");对表的列授权。grant<actions>on table<table_name>[()]to[user|role...
alicloud_ots_table
String or Binary is allowed.Attributes Reference The following attributes are exported:id-The resource ID.The value is<instance_name>:<table_name>.Import OTS table can be imported using id,e.g.$terraform import alicloud_...
alicloud_fc_trigger
fc_function""default"{ service=alicloud_fc_service.default.name name="terraform-example"description="example"oss_bucket=alicloud_oss_bucket.default.id oss_key=alicloud_oss_bucket_object.default.key memory_size="512"runtime...
DML 语句
是 UPDATE UPDATE tb1_name SET col_name1=expr1[,col_name2=expr2.][WHERE where_definition]是 DELETE DELETE FROM tb1_name[WHERE where_definition]是 SELECT SELECT[ALL|DISTINCT|DISTINCTROW]select_expr,.FROM tb1_name[WHERE where...
alicloud_ram_policies
names-A list of ram group names.policies-A list of policies.Each element contains the following attributes:id-ID of the policy.name-Name of the policy.policy_name-Name of the policy.type-Type of the policy.description-...
alicloud_cen_flowlogs
name-(Optional)The name of the SLS project.log_store_name-(Optional)The name of the log store which is in the project_name SLS project.flow_log_name-(Optional)The name of flowlog.description-(Optional)The description of ...
alicloud_dts_consumer_channel
Provides a DTS Consumer Channel resource.For information about DTS Consumer Channel and how to use it,see What is Consumer Channel.->NOTE:Available since v1.146.0.Example Usage Basic Usage variable"name"{ default=...
ALTER MATERIALIZED VIEW
语法 ALTER MATERIALIZED VIEW[IF EXISTS]name action[,.]ALTER MATERIALIZED VIEW name DEPENDS ON EXTENSION extension_name ALTER MATERIALIZED VIEW[IF EXISTS]name RENAME[COLUMN]column_name TO new_column_name ALTER MATERIALIZED ...
数据共享SQL
参数说明：参数 说明 share_name.schema_name.table_name 目标端查询的共享表名字，需为3段式表示：share_name：Share的本地别名（若没有设置别名可使用Share的名称）。schema_name：共享表所在源库的Schema的名称。table_name：共享表的表...
alicloud_log_dashboard
id-The resource ID in terraform of Log Dashboard.It formats as<project_name>:<dashboard_name>.Import Log Dashboard can be imported using the id,e.g.$terraform import alicloud_log_dashboard.example<project_name>:<dashboard_...
配置skinLayout属性
点播H5默认配置 skinLayout:[{name:"bigPlayButton",align:"blabs",x:30,y:80},{ name:"H5Loading",align:"cc"},{name:"errorDisplay",align:"tlabs",x:0,y:0},{name:"infoDisplay"},{name:"tooltip",align:"blabs",x:0,y:56},{name:...
权限命令集
角色管理 创建角色（项目级别）命令 create role<role_name>[privilegeproperties("type"="admin|resource")];示例 创建一个Worker资源类角色，命令示例如下。create role Worker;创建一个sale_admin管理类角色，命令示例如下。create role...
部署DBFS CSI插件
通过部署CSI插件，您可以通过PV和PVC方式挂载使用DBFS存储卷。本文介绍如何部署DBFS CSI插件。索引 前提条件 步骤一：RAM授权 步骤二：部署CSI插件 相关文档 前提条件 已创建Kubernetes托管版集群 已通过kubectl工具连接集群 步骤一：RAM......
alicloud_vod_domains
This data source provides the Vod Domains of the current Alibaba Cloud user.->NOTE:Available in v1.136.0+.Example Usage Basic Usage resource"alicloud_vod_domain""default"{ domain_name="your_domain_name"scope="domestic...
alicloud_ots_tunnels
ids-A list of tunnel IDs.names-A list of tunnel names.tunnels-A list of tunnels.Each element contains the following attributes:id-The resource ID.The value is<instance_name>:<table_name>:<tunnel_name>.instance_name-The OTS...
alicloud_ecs_key_pair
name has been deprecated from provider version 1.121.0.New field key_pair_name instead.key_name_prefix-(Optional,ForceNew)The key pair name's prefix.It is conflict with key_pair_name.If it is specified,terraform will using...
- 产品推荐
- 这些文档可能帮助您