相交类算子
示例 WITH box AS(SELECT ST_MakeBox3d(0,0,0,5,5,5)a,ST_MakeBox3dt(6,6,3,'2010-04-12 00:00:00',8,8,5,'2013-02-01 00:00:00')b)SELECT a/b AS OpZ,a#b AS OpT,a&b AS Op2D,a&b AS Op3d,a&b AS Op2DT,a&b AS Op3DT from box;opz|opt|op2...
包含算子
0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT a/>/b AS OpZ,a#>#b AS OpT,a@>b AS Op2D,a@>b AS Op3D,a@>b AS Op2DT,a@>b AS Op3DT from...
包含算子
0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT a/>/b AS OpZ,a#>#b AS OpT,a@>b AS Op2D,a@>b AS Op3D,a@>b AS Op2DT,a@>b AS Op3DT from...
包含算子
0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT a/>/b AS OpZ,a#>#b AS OpT,a@>b AS Op2D,a@>b AS Op3D,a@>b AS Op2DT,a@>b AS Op3DT from...
包含算子
0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT a/>/b AS OpZ,a#>#b AS OpT,a@>b AS Op2D,a@>b AS Op3D,a@>b AS Op2DT,a@>b AS Op3DT from...
被包含算子
0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT b/<@/ aAS OpZ,b#<@# aAS OpT,b<@ aAS Op2D,b</@ aAS Op3D,b<#@ aAS Op2DT,b</#@ aAS Op3DT from...
被包含算子
0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT b/<@/ aAS OpZ,b#<@# aAS OpT,b<@ aAS Op2D,b</@ aAS Op3D,b<#@ aAS Op2DT,b</#@ aAS Op3DT from...
被包含算子
0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT b/<@/ aAS OpZ,b#<@# aAS OpT,b<@ aAS Op2D,b</@ aAS Op3D,b<#@ aAS Op2DT,b</#@ aAS Op3DT from...
被包含算子
0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT b/<@/ aAS OpZ,b#<@# aAS OpT,b<@ aAS Op2D,b</@ aAS Op3D,b<#@ aAS Op2DT,b</#@ aAS Op3DT from...
FROM_UNIXTIME
示例 测试数据 unixtime1(BIGINT)nullstr(VARCHAR)1505404800 NULL 测试语句 SELECT FROM_UNIXTIME(unixtime1)as var1,FROM_UNIXTIME(unixtime1,'MMdd-yyyy')as var2,FROM_UNIXTIME(unixtime1,nullstr)as var3 FROM T1;测试结果 var1...
TO_DATE
示例 测试数据 表 1.T1 date1(INT)date2(VARCHAR)date3(VARCHAR)100 2017-09-15 20170915 测试语句 SELECT TO_DATE(date1)as var1,TO_DATE(date2)as var2,TO_DATE(date3,'yyyyMMdd')as var3 FROM T1;测试结果 var1(DATE)var2(DATE)var3...
DATE_SUB
示例 测试数据 date1(VARCHAR)nullstr(VARCHAR)2017-10-15 NULL 测试语句 SELECT DATE_SUB(date1,30)as var1,DATE_SUB(TIMESTAMP '2017-10-15 23:00:00',30)as var2,DATE_SUB(nullstr,30)as var3 FROM T1;测试结果 var1(DATE)var2(DATE)var...
DATE_ADD
示例 测试数据 datetime1(VARCHAR)nullstr(VARCHAR)2017-09-15 00:00:00 NULL 测试语句 SELECT DATE_ADD(datetime1,30)as var1,DATE_ADD(TIMESTAMP '2017-09-15 23:00:00',30)as var2,DATE_ADD(nullstr,30)as var3 FROM T1;测试结果 var1...
DATEDIFF
DATEDIFF(datetime2,TIMESTAMP '2017-10-15 23:00:00')as int3,DATEDIFF(datetime2,nullstr)as int4,DATEDIFF(nullstr,TIMESTAMP '2017-10-15 23:00:00')as int5,DATEDIFF(nullstr,datetime2)as int6,DATEDIFF(TIMESTAMP '2017-10-15 23:00...
PARSE_URL
PARSE_URL(url1,'REF')as var5,PARSE_URL(url1,'PROTOCOL')as var6,PARSE_URL(url1,'FILE')as var7,PARSE_URL(url1,'AUTHORITY')as var8,PARSE_URL(nullstr,'QUERY')as var9,PARSE_URL(url1,'USERINFO')as var10,PARSE_URL(nullstr,'QUERY'...
DATE_FORMAT
测试数据 date1(VARCHAR)datetime1(VARCHAR)nullstr(VARCHAR)0915-2017 2017-09-15 00:00:00 NULL 测试语句 SELECT DATE_FORMAT(datetime1,'yyMMdd')as var1,DATE_FORMAT(nullstr,'yyMMdd')as var2,DATE_FORMAT(datetime1,nullstr)as var3,...
全表统计
create table summary_test_input as select*from(select 'a' as col1,1 as col2,0.001 as col3 from dual union all select 'b' as col1,2 as col2,100.01 as col3 from dual)tmp;PAI命令 PAI-name stat_summary-project algo_public-...
Modularity
id,'3' as group_out_id,'4' as flow_in_id,'3' as group_in_id union all select '3' as flow_out_id,'3' as group_out_id,'4' as flow_in_id,'3' as group_in_id union all select '4' as flow_out_id,'3' as group_out_id,'6' as flow_...
ST_ContainsProperly
g2),ST_ContainsProperly(g1,g2),ST_ContainsProperly(g1,g3)FROM(SELECT 'POLYGON((0 0,0 3,3 3,3 0,0 0))':geometry as g1,'POLYGON((0 0,0 1,1 1,1 0,0 0))':geometry as g2,'POLYGON((1 1,1 2,2 2,2 1,1 1))':geometry as g3)as test;...
ST_ContainsProperly
g2),ST_ContainsProperly(g1,g2),ST_ContainsProperly(g1,g3)FROM(SELECT 'POLYGON((0 0,0 3,3 3,3 0,0 0))':geometry as g1,'POLYGON((0 0,0 1,1 1,1 0,0 0))':geometry as g2,'POLYGON((1 1,1 2,2 2,2 1,1 1))':geometry as g3)as test;...
ST_ContainsProperly
g2),ST_ContainsProperly(g1,g2),ST_ContainsProperly(g1,g3)FROM(SELECT 'POLYGON((0 0,0 3,3 3,3 0,0 0))':geometry as g1,'POLYGON((0 0,0 1,1 1,1 0,0 0))':geometry as g2,'POLYGON((1 1,1 2,2 2,2 1,1 1))':geometry as g3)as test;...
票证批量导出轻应用
图片上传成功 图片上传成功后会展示在图片列表中，以文件解析顺序排列；若上传失败则会有相应错误提示；已上传图片可进行“查看”或“删除”；若需要清空图片列表，则可点击“清空列表”；识别环节 点击“开始识别”识别已上传成功的图片...
创建安全联合分析任务
mpcsql_out PARTITION(job_name='groupby_oneside_distinct_twoside_test')SELECT t1.education_num as col1_int,COUNT(t1.workclass)as col2_string,COUNT(DISTINCT(t2.sex))as col3_string FROM alice.host_train_adult_100 t1 JOIN bob....
H3函数
语法 boolean H3_AreNeighborCells(Long H3Cell1,Long H3Cell2)boolean H3_AreNeighborCells(string H3Cell1,string H3Cell2)参数说明 参数 说明 H3Cell1、H3Cell2 H3网格编码，类型为LONG或STRING。示例 示例一：输入两个LONG格式的H3网格...
H3函数
语法 boolean H3_AreNeighborCells(Long H3Cell1,Long H3Cell2)boolean H3_AreNeighborCells(string H3Cell1,string H3Cell2)参数说明 参数 说明 H3Cell1、H3Cell2 H3网格编码，类型为LONG或STRING。示例 示例一：输入两个LONG格式的H3网格...
性能白皮书（Nexmark性能测试）
reserve BIGINT,dateTime TIMESTAMP(3),expires TIMESTAMP(3),seller BIGINT,category BIGINT,extra VARCHAR>,bid ROW,bidder BIGINT,price BIGINT,channel VARCHAR,url VARCHAR,dateTime TIMESTAMP(3),extra VARCHAR>,dateTime AS CASE ...
性能测试指南
MKTSEGMENT AS C_MKTSEGMENT,s.S_NAME AS S_NAME,s.S_ADDRESS AS S_ADDRESS,s.S_CITY AS S_CITY,s.S_NATION AS S_NATION,s.S_REGION AS S_REGION,s.S_PHONE AS S_PHONE,p.P_NAME AS P_NAME,p.P_MFGR AS P_MFGR,p.P_CATEGORY AS P_CATEGORY,...
SQL语句示例
DATE)-1 AND 省区='四川' AND QUARTER(日期)IN(2,3))AS subquery 同比 当前周期相对于历史同一时间段的数据变化情况 经销商"毛龙"今年第一季度的销售总额同比增长了多少？SELECT(Q1_sales_this_year-Q1_sales_last_year)/Q1_sales_last_...
同比和环比函数
查询和分析结果为分列显示 查询和分析语句（调试）*|SELECT diff[1]AS today,diff[2]AS yesterday,diff[3]AS ratio FROM(SELECT compare(PV,86400)AS diff FROM(SELECT count(*)AS PV FROM log))compare函数计算结果为数组形式，其中 diff ...
k-Core
out_id,'3' as flow_in_id union all select '2' as flow_out_id,'4' as flow_in_id union all select '3' as flow_out_id,'4' as flow_in_id union all select '3' as flow_out_id,'5' as flow_in_id union all select '3' as flow_out_id...
Hologres开发：周期性调度
campaign as campaign,pdays as pdays,previous as previous,poutcome as poutcome,emp_var_rate as emp_var_rate,cons_price_idx as cons_price_idx,cons_conf_idx as cons_conf_idx,euribor3m as euribor3m,nr_employed as nr_employed,y...
TPC-DS测试集
date between(cast('2000-05-19' as date)-30 days)and(cast('2000-05-19' as date)+30 days)(cast('1999-4-01' as date)+60 days)(cast('1999-5-01' as date)+60 days)and d_date between cast('2001-06-09' as date)and(cast('2001-06-09...
核密度估计函数
示例 代码示例：*|select date_trunc('second',cast(t1[1]as bigint))as time,t1[2]as real,t1[3]as pdf from(select kernel_density_estimation(time,num,'gaussian')as res from(select_time_-_time_%10 as time,COUNT(*)*1.0 as num ...
嵌套子查询
查询和分析语句*|SELECT diff[1]AS today,diff[2]AS yesterday,diff[3]AS ratio FROM(SELECT compare(PV,86400)AS diff FROM(SELECT count(*)AS PV FROM log))查询和分析结果 3337.0 表示当前1小时（例如2020-12-25 14:00:00~2020-12-25 15...
边聚类系数
'5' as flow_in_id union all select '3' as flow_out_id,'4' as flow_in_id union all select '4' as flow_out_id,'5' as flow_in_id union all select '4' as flow_out_id,'8' as flow_in_id union all select '5' as flow_out_id,'6' as...
类型转换
5.0 as f1,1 as f2 from dual union all select false as f0,3.0 as f1,1 as f2 from dual union all select true as f0,4.0 as f1,1 as f2 from dual union all select false as f0,3.0 as f1,1 as f2 from dual union all select true as...
计数三角形
out_id,'5' as flow_in_id union all select '1' as flow_out_id,'6' as flow_in_id union all select '2' as flow_out_id,'3' as flow_in_id union all select '3' as flow_out_id,'4' as flow_in_id union all select '4' as flow_out_id...
使用CloudLens for SLS监控Project资源配额
ratio,round(COALESCE(M.name2,0)/cast(json_extract(cmdb.quota,'$.write_cnt_per_min')as double)*100,3)as write_cnt_ratio from"resource.sls.cmdb.project"as cmdb LEFT JOIN(select project,round(MAX(name1)/1000000000,3)as name1,...
点聚类系数
out_id,'5' as flow_in_id union all select '1' as flow_out_id,'6' as flow_in_id union all select '2' as flow_out_id,'3' as flow_in_id union all select '3' as flow_out_id,'4' as flow_in_id union all select '4' as flow_out_id...
单张图片
配置字段说明 字段 说明 图片路径 设置展示的图片，会覆盖掉 背景图 或 矢量图 中的配置。如果该字段为空，DataV会读取配置中的 背景图 或 矢量图 进行展示。超链接地址 设置单击后跳转页面的URL，会覆盖掉 超链接 中的配置。如果该字段为...
- 产品推荐
- 这些文档可能帮助您