地理位置查询
request=array('table_name'=>'php_sdk_test','index_name'=>'php_sdk_test_search_index','search_query'=>array('offset'=>0,'limit'=>2,'get_total_count'=>true,'query'=>array('query_type'=>QueryTypeConst:GEO_DISTANCE_QUERY,'...
列存在性查询
request=array('table_name'=>'php_sdk_test','index_name'=>'php_sdk_test_search_index','search_query'=>array('offset'=>0,'limit'=>2,'get_total_count'=>true,'query'=>array('query_type'=>QueryTypeConst:EXISTS_QUERY,'query'=>...
多条件组合查询
request=array('table_name'=>'php_sdk_test','index_name'=>'php_sdk_test_search_index','search_query'=>array('offset'=>0,'limit'=>2,'get_total_count'=>true,'query'=>array('query_type'=>QueryTypeConst:BOOL_QUERY,'query'=>...
折叠（去重）
示例$request=array('table_name'=>'php_sdk_test','index_name'=>'php_sdk_test_search_index','search_query'=>array('offset'=>0,'limit'=>10,'get_total_count'=>true,'collapse'=>array('field_name'=>'keyword'),'query'=>array('...
创建多元索引
示例$request=array('table_name'=>'php_sdk_test','index_name'=>'php_sdk_test_search_index','schema'=>array('field_schemas'=>array(array('field_name'=>'keyword','field_type'=>FieldTypeConst:KEYWORD,'index'=>true,'enable_sort...
DescribeProduct
param</Key><Type>LIST</Type><Order>15</Order><Label>产品参数</Label></ProductExtra></ProductExtras><Name>V3【回归】服务类-按周期</Name><ShortDescription>aaa</ShortDescription><ShopInfo><Telephones><Telephone>1581016*...
SQL 修饰
name2=expr2 是 是 ORDER BY SELECT col_name1,col_name2 FROM tb1_name ORDER BY col_name1 是 是 GROUP BY SELECT col_name1,col_name2 FROM tb1_name GROUP BY col_name1 是 是 LIKE SELECT col_name1,col_name2 FROM tb1_name WHERE ...
GetTrafficByRegion
示例 请求示例 http://pcdn.aliyuncs.com/?&Action=GetTrafficByRegion &Version=2017-04-11 &<公共参数>正常返回示例 XML 格式<GetTrafficByRegionResponse><TrafficDataList><TrafficData><Name>北京</Name><Traffic>448096774168859...
容器服务
eventId.metadata.namespace"as namespace,"eventId.involvedObject.name"as node_name,COUNT(*)as cnt from log GROUP by namespace,node_name 有数据匹配，cnt>0 标签自定义：namespace、node_name sls_app_ack_ccm_at_del_slb_fail ...
排序、去重、采样、数据变换
df.min_max_scale(columns=['fid'],group=['name'])name id fid 0 name1 4 1.000000 1 name1 4 0.645161 2 name1 3 0.000000 3 name1 3 0.612903 4 name2 2 1.000000 5 name2 3 0.000000 结果显示，name1 和 name2 两组均按组中的最值进行...
配置清单支持的元数据类型
应用信息"Version":"1.0","Attributes":[{"DataType":"STRING","Name":"Name"/应用名 },{"DataType":"STRING","Name":"ApplicationType"/应用类型 },{"DataType":"STRING","Name":"Publisher"/应用发布者 },{"DataType":"STRING","Name":...
Hive支持的DDL语句
[,CONSTRAINT constraint_name FOREIGN KEY(col_name,.)REFERENCES table_name(col_name,.)DISABLE NOVALIDATE[,CONSTRAINT constraint_name UNIQUE(col_name,.)DISABLE NOVALIDATE RELY/NORELY][,CONSTRAINT constraint_name CHECK[check_...
COMMENT
[argmode][argname]argtype[,.]|[[argmode][argname]argtype[,.]]ORDER BY[argmode][argname]argtype[,.]参数 object_name relation_name.column_name aggregate_name constraint_name function_name operator_name policy_name procedure_...
ALTER EXTENSION
name|TEXT SEARCH DICTIONARY object_name|TEXT SEARCH PARSER object_name|TEXT SEARCH TEMPLATE object_name|TRANSFORM FOR type_name LANGUAGE lang_name|TYPE object_name|VIEW object_name 并且 aggregate_signature 是：*|[argmode]...
DDL语句
创建分桶表 CREATE TABLE<table_name>(<column_name1>[NOT NULL][comment"text"],<column_name2>[NOT NULL][comment"text"],<column_name3>[NOT NULL][comment"text"],.)clustered by(column_name1,column_name2.)stored as holodesk;...
字符串函数
语法 LEN(column_name)示例 SELECT goods_name,LEN(goods_name)AS name_length FROM orders;返回结果如下：+-+-+|goods_name|name_length|+-+-+|goods_name_3|12|IFNULL 如果 expr1 的值为空，则返回 expr2 的值。如果 expr1 的值不为空，...
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_...
查看NLB监控信息
\"productCategory\",\"value\":\"nlb\"},{\"name\":\"is_alarm\",\"value\":\"true\"},{\"name\":\"HighResolution\",\"value\":\"false\"},{\"name\":\"HighResolutionPeriod\",\"value\":\"\"},{\"name\":\"dataType\",\"value\":\"\"},...
alicloud_cr_chain
namespace_name=alicloud_cr_ee_namespace.default.name chain_config { routers { from { node_name="DOCKER_IMAGE_BUILD"} to { node_name="DOCKER_IMAGE_PUSH"} } routers { from { node_name="DOCKER_IMAGE_PUSH"} to { node_name=...
自定义RAM Policy
name]DeleteTable instance/[instance_name]/table/[table_name]GetRow instance/[instance_name]/table/[table_name]PutRow instance/[instance_name]/table/[table_name]UpdateRow instance/[instance_name]/table/[table_name]DeleteRow...
alicloud_cr_ee_sync_rule
namespace_name=alicloud_cr_ee_namespace.target.name tag_filter=".*"repo_name=alicloud_cr_ee_repo.source.name target_repo_name=alicloud_cr_ee_repo.target.name } Argument Reference The following arguments are supported:...
优化聚合与排序
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`,`name` FROM `t1` ...
中间件
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 版本中已经不再需要，您可以选择删除或按需保留。...name=...
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<>...
ST_Name
返回material或texture对应的名称。...示例 示例一：SELECT ST_Name(ST_SetName(the_material,'material_name')）FROM t_table-material_name 示例二：SELECT ST_Name(ST_SetName(the_texture,'t_name')）FROM t_table-t_name
ST_Name
返回material或texture对应的名称。...示例 示例一：SELECT ST_Name(ST_SetName(the_material,'material_name')）FROM t_table-material_name 示例二：SELECT ST_Name(ST_SetName(the_texture,'t_name')）FROM t_table-t_name
如何合理选择数据特征
日志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_。配置 实体...
各类型节点自动解析场景
各类型节点自动添加的本节点输出命名规则为：EMR：workspace_name.db_name.table_name ADBPG：workspace_name.db_name.schema_name.table_name ADBMySQL：workspace_name.db_name.schema_name.table_name Hologres：workspace_name.db_name...
alicloud_ots_tunnel
ots_instance""default"{ name="${var.name}-${random_integer.default.result}"description=var.name accessed_by="Any"tags={ Created="TF",For="example",} } resource"alicloud_ots_table""default"{ instance_name=alicloud_ots_...
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
Provides a DCDN Accelerated Domain resource.For information about domain config and how to use it,see Batch set config.->NOTE:Available since v1.131.0.Example Usage Basic Usage variable"domain_name"{ default="alibaba-...
ADB for PostgreSQL支持的语法
LANGUAGE object_name|RESOURCE QUEUE object_name|ROLE object_name|RULE rule_name ON table_name|SCHEMA object_name|SEQUENCE object_name|TABLESPACE object_name|TRIGGER trigger_name ON table_name|TYPE object_name|VIEW object_...
alicloud_ots_secondary_index
instance_name-(Required,ForceNew)The name of the OTS instance in which table will located.table_name-(Required,ForceNew)The name of the OTS table.If changed,a new table would be created.index_name-(Required,ForceNew)The ...
表统计信息查看与分析
取两天的差值))d-7 天数据日变化量 ON t.db_name=d.db_name AND t.schema_name=d.schema_name AND t.table_name=d.table_name ORDER BY t.total_storage_size desc,d.collect_date desc,d.db_name,d.schema_name,d.table_name;场景5：查询...
排序优化和执行
返回信息如下：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`,`...
SQL语法
LANGUAGE object_name|RESOURCE QUEUE object_name|ROLE object_name|RULE rule_name ON table_name|SCHEMA object_name|SEQUENCE object_name|TABLESPACE object_name|TRIGGER trigger_name ON table_name|TYPE object_name|VIEW object_...
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 ...
USER_DISPLAY_NAME
命令语法 USER_DISPLAY_NAME的命令语法如下所示：SELECT user_display_name(user_name)参数说明 参数说明如下表所示。参数 描述 user_name 阿里云账号ID。通常为数字形式，例如 13532241323xxx 或RAM用户 p4_23402030200xxx。返回值为邮箱...
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_...
- 产品推荐
- 这些文档可能帮助您