PIVOT、UNPIVOT
.)，MaxCompute自动生成一组String的值来代替，规则如下：UNPIVOT(measure1 for axis in(c1,c2,c3,.))：此情况下生成的值是(c1,c2,c3,.)，即原语法改写为：UNPIVOT(measure1 for axis in(c1 as c1,c2 as c2,c3 as c3,.))。除上述情况以外...
时序补点函数
0.043698605551761895 1.5513948E9|0.04400292632222124 1.5513984E9|0.04727081764249449 1.551402E9|0.054632234293121314 1.5514056E9|0.05331214064978596 1.5514092E9|0.05093117289934144 1.5514128E9|0.053620170319174806 1....
窗口函数
查询和分析语句*|SELECT department,staff_name,salary,round(salary*1.0/sum(salary)over(partition by department),3)AS salary_percentage 查询和分析结果 cume_dist函数 cume_dist函数用于统计窗口分区内各个值的累计分布。即计算窗口...
工业资产指标&数据分析最佳实践
asset.level2 as level_2-可自定义别名,空间资产模型第三层级,asset.level3 as level_3-可自定义别名,空间资产模型第四层级,asset.level4 as level_4,metric.ts_second as"统计日期(ymdhms)",metric.ts_minute as"统计日期(minute)",metric...
SQL Server性能分析与优化
查看数据库IO使用情况 SELECT DB_NAME(fs.database_id)AS[Database Name],CAST(fs.io_stall_read_ms/(1.0+fs.num_of_reads)AS NUMERIC(10,1))AS[avg_read_stall_ms],CAST(fs.io_stall_write_ms/(1.0+fs.num_of_writes)AS NUMERIC(10,1))AS...
CREATE TABLE AS
Hologres从V1.3.21版本开始，支持使用CREATE TABLE AS语句创建表，复制表结构的同时也可以选择复制数据。本文为您介绍在Hologres中CREATE TABLE AS的用法。背景信息 CREATE TABLE AS的功能为：创建一个与源表结构或者查询Query结果相同的新...
缺失值填充
datetime from dual union all select '04' as col_string,13 as col_bigint,10.4 as col_double,cast(null as boolean)as col_boolean,cast('2016-07-05 10:00:00' as datetime)as col_datetime from dual union all select '05' as col_...
查询执行器介绍
其中的23.601s都用在了获取了下层输出上，只有约0.3s用于分组聚合。HashJoin算子open耗时0.290s，用于拉取右表（下方的Gather）数据并构建哈希表；next耗时23.584s，用于拉取左表数据以及查询哈希表得到JOIN结果。Gather算子仅仅用于汇总多...
管理MongoDB Catalog（公测中）
Bson类型 Flink SQL类型 Boolean BOOLEAN Int32 INT Int64 BIGINT Binary BYTES Double DOUBLE Decimal128 DECIMAL String STRING ObjectId STRING DateTime TIMESTAMP_LTZ(3)Timestamp TIMESTAMP_LTZ(0)Array STRING Document STRING 相关...
关系函数
示例 示例1 SELECT ST_Overlaps(ST_GeomFromText('LINESTRING(0 0,0 2)'),ST_GeomFromText('LINESTRING(0 1,0 3)'))as overlaps;返回结果：+-+|overlaps|+-+|true|+-+示例2 SELECT ST_Overlaps(ST_GeomFromText('LINESTRING(0 0,0 2)'),ST_...
关系函数
示例 示例1 SELECT ST_Overlaps(ST_GeomFromText('LINESTRING(0 0,0 2)'),ST_GeomFromText('LINESTRING(0 1,0 3)'))as overlaps;返回结果：+-+|overlaps|+-+|true|+-+示例2 SELECT ST_Overlaps(ST_GeomFromText('LINESTRING(0 0,0 2)'),ST_...
关系函数
示例 示例1 SELECT ST_Overlaps(ST_GeomFromText('LINESTRING(0 0,0 2)'),ST_GeomFromText('LINESTRING(0 1,0 3)'))as overlaps;返回结果：+-+|overlaps|+-+|true|+-+示例2 SELECT ST_Overlaps(ST_GeomFromText('LINESTRING(0 0,0 2)'),ST_...
配置监控与告警
select dt,today,yesterday,round((today-yesterday)*100.0/yesterday,3)as inc_ration from(select dt,(case when diff[1]is null then 0 else diff[1]end)as today,(case when diff[2]is null then 0 else diff[2]end)as yesterday from...
JSON_TUPLE
select sc.Id,q.item0,q.item1 from school sc lateral view json_tuple(sc.json,"Class1.Student[0].scoreRankIn3Year[2]","Class1.Student[0].scoreRankIn3Year[2][1]")q as item0,item1;返回结果如下。id|item0|item1|+-+-+-+|1|[3,2,6]...
嵌套子查询
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:00:00）的网站访问量。...
同比和环比函数
查询和分析结果为分列显示 查询和分析语句（调试）*|SELECT time,diff[1]AS day1,diff[2]AS day2,diff[3]AS day3,diff[4]AS ratio1,diff[5]AS ratio2 FROM(SELECT time,ts_compare(PV,86400,172800)AS diff FROM(SELECT count(*)as PV,date...
奇异值分解
0.0009 3:0.0416 4:0.17664 6:0.36460 8:0.091330' as col0 from dual union all select '0:0.09229 2:0.4872172 5:0.5267 8:0.4544 9:0.23317' as col0 from dual union all select '1:0.8312 3:0.9317 5:0.5680 7:0.5560 9:0.0508' as ...
开展协同
说明 以下版本客户端支持在云电脑桌面上加入共享协同：Windows客户端 V6.3.1及以上版本 macOS客户端 V6.3.0及以上版本 盒式云电脑终端AS01 V6.3.0及以上版本 无影魔方AS05 V6.3.0及以上版本 无影23.8寸一体机US01 V6.3.0及以上版本 作为...
登录盒式云电脑终端AS01
本文以 盒式云电脑终端AS01 V6.3.0版本为例，为您介绍如何登录无影硬件终端。简明版 无影终端登录模块支持多种登录方式和多种高级功能，例如单点登录SSO（Single Sign-On）、多因素认证MFA（Multi-Factor Authentication）等，简明版文档以...
PyODPS的空值处理
100,t1.`f4`)AS `f4` FROM WB_BestPractice_dev.`pytable2` t1 Instance ID:20191010071209190gyl56292 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...
登录无影魔方AS05
本文以 无影魔方AS05 V6.3.0版本为例，为您介绍如何登录无影硬件终端。简明版 无影终端登录模块支持多种登录方式和多种高级功能，例如单点登录SSO（Single Sign-On）、多因素认证MFA（Multi-Factor Authentication）等，简明版文档以密码...
ST_Touches
st_touches-t(1 row)不满足 DE-9IM 结果的情况：SELECT ST_Touches(g1,g2),ST_Relate(g1,g2)FROM(SELECT 'LINESTRING(0 0,0 2)':geometry as g1,'LINESTRING(0 1,0 3)':geometry as g2)as test;st_touches|st_relate-+-f|1010F0102(1 row)
ST_Touches
st_touches-t(1 row)不满足 DE-9IM 结果的情况：SELECT ST_Touches(g1,g2),ST_Relate(g1,g2)FROM(SELECT 'LINESTRING(0 0,0 2)':geometry as g1,'LINESTRING(0 1,0 3)':geometry as g2)as test;st_touches|st_relate-+-f|1010F0102(1 row)
ST_Touches
st_touches-t(1 row)不满足 DE-9IM 结果的情况：SELECT ST_Touches(g1,g2),ST_Relate(g1,g2)FROM(SELECT 'LINESTRING(0 0,0 2)':geometry as g1,'LINESTRING(0 1,0 3)':geometry as g2)as test;st_touches|st_relate-+-f|1010F0102(1 row)
相交类算子
示例 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...
相交类算子
示例 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...
相交类算子
示例 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...
相交类算子
示例 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...
性能测试指南
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,...
处理函数
本文介绍时空函数中的处理函数。引擎与版本 处理函数仅适用于宽表引擎。无版本要求。函数列表 Lindorm Ganos支持...SELECT ST_AsText(ST_Collect(ST_MakePoint(0,0),ST_MakePoint(0,1)))AS g;返回结果：+-+|g|+-+|MULTIPOINT((0 0),(0 1))|+-...
处理函数
本文介绍时空函数中的处理函数。引擎与版本 处理函数仅适用于宽表引擎。无版本要求。函数列表 Lindorm Ganos支持...SELECT ST_AsText(ST_Collect(ST_MakePoint(0,0),ST_MakePoint(0,1)))AS g;返回结果：+-+|g|+-+|MULTIPOINT((0 0),(0 1))|+-...
Data Explorer案例
查询和分析语句|select"sql",diff[1]as current_value,diff[2]as previous_value,(diff[1]-diff[2])as change_value FROM(select"sql",compare("count",86400)as diff FROM(select"sql",count,count*1.0/sum(count)over()as percent FROM...
性能白皮书（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 ...
数值函数（2.0版）
col0|+-+|3.0|LOG10 log10(double)命令说明：求以10位底的对数 返回值类型：DOUBLE 示例：select log10(100);col0|+-+|2.0|PI pi()命令说明：返回pi 返回值类型：DOUBLE 示例：select pi();col0|+-+|3.141592653589793|POWER power(double,...
使用Copilot+增强分析实现一站式智能数据查询与可视化
SELECT CASE WHEN CAST(SUBSTR(behavior_time,12)AS BIGINT)>=0 AND CAST(SUBSTR(behavior_time,12)AS BIGINT)<3 THEN '00点-03点' WHEN CAST(SUBSTR(behavior_time,12)AS BIGINT)>=3 AND CAST(SUBSTR(behavior_time,12)AS BIGINT)点-06点'...
获取和安装盒式云电脑终端AS01
5 USB 3.0接口。6 USB 2.0接口。7 HDMI接口。8 VGA接口。9 RJ45网络接口。10 电源接口。11 重置键。安装接线 以下为您介绍如何安装机身及连接线缆。说明 下文展示的安装和接线示意图仅供参考，业务中请以实际产品为准。将显示器和盒式机身...
滚动窗口
10-10 10:00:00.0 2017-10-10 10:01:00.0 Jark 3 2017-10-10 10:01:00.0 2017-10-10 10:02:00.0 Jark 2 2017-10-10 10:02:00.0 2017-10-10 10:03:00.0 Timo 1 使用Processing Time统计每个用户每分钟在指定网站的单击数示例 测试数据 ...
聚合函数
查询和分析语句（调试）*|SELECT count_if(request_uri like '%file-0')AS count 查询和分析结果 geometric_mean函数 geometric_mean函数用于计算 x 的几何平均数。语法 geometric_mean(x)参数说明 参数 说明 x 参数值为double、bigint或...
COMMON TABLE EXPRESSION（CTE）
使用CTE的方式重写以上语句，命令示例如下：with a as(select*from src where key is not null),b as(select*from src2 where value>0),c as(select*from src3 where value>0),d as(select a.key,b.value from a join b on a.key=b.key),e ...
COMMON TABLE EXPRESSION（CTE）
使用CTE的方式重写以上语句，命令示例如下：with a as(select*from src where key is not null),b as(select*from src2 where value>0),c as(select*from src3 where value>0),d as(select a.key,b.value from a join b on a.key=b.key),e ...
- 产品推荐
- 这些文档可能帮助您