CREATE VIEW
CREATE VIEW comedies AS SELECT f.*,country_code_to_name(f.country_code)AS country,(SELECT avg(r.rating)FROM user_ratings r WHERE r.film_id=f.id)AS avg_rating FROM films f WHERE f.kind='Comedy';该视图将支持 INSERT、UPDATE ...
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_...
PREPARE
预备语句是一种服务器端对象，它可以被用来优化性能。当 PREPARE 语句被执行时，指定的语句会被解析、分析并且重写。当后续发出一个 EXECUTE 命令时，该预备语句会被规划并且执行。这种工作的划分避免了重复性的解析分析工作，不过允许执行...
CREATE RULE
例如，尽管下面的两条规则定义都被 PolarDB所接受，SELECT 命令将导致 PolarDB报告一个错误，因为会产生一条规则的递归扩展：CREATE RULE"_RETURN"AS ON SELECT TO t1 DO INSTEAD SELECT*FROM t2;CREATE RULE"_RETURN"AS ON SELECT TO t2 ...
ModifyCollationTimeZone-修改系统字符集排序规则和...
取值：Chinese_PRC_CI_AS Chinese_PRC_CS_AS Chinese_PRC_BIN Latin1_General_CI_AS Latin1_General_CS_AS SQL_Latin1_General_CP1_CI_AS SQL_Latin1_General_CP1_CS_AS Japanese_CI_AS Japanese_CS_AS Chinese_Taiwan_Stroke_CI_AS ...
ModifyCollationTimeZone-修改系统字符集排序规则和...
取值：Chinese_PRC_CI_AS Chinese_PRC_CS_AS Chinese_PRC_BIN Latin1_General_CI_AS Latin1_General_CS_AS SQL_Latin1_General_CP1_CI_AS SQL_Latin1_General_CP1_CS_AS Japanese_CI_AS Japanese_CS_AS Chinese_Taiwan_Stroke_CI_AS ...
漏斗和留存函数
WITH level_detail AS(SELECT level,COUNT(1)AS count_user FROM(SELECT actor_id,windowFunnel(1800,'default',created_at,type='CreateEvent',type='PushEvent',type='IssuesEvent')AS level FROM hologres_dataset_github_event....
窗口函数
简介 普通的聚合函数只能用来计算一行内的结果或把所有行聚合成一行结果，而窗口函数支持为每一行生成一个结果。窗口函数包含分区、排序和框架这3个核心元素。更多信息，请参见 Window Function Concepts and Syntax。function over(...
查询改写功能
物化视图语句如下：CREATE MATERIALIZED VIEW mv0 REFRESH NEXT now()+interval 1 day ENABLE QUERY REWRITE AS SELECT l.returnflag,l.linestatus,SUM(l.extendedprice*(1-l.discount))AS sum_disc_price,count(*)AS count_order FROM ...
特征编码
3 as campaign,6 as pdays,2 as previous,-1.7 as emp_var_rate,94.055 as cons_price_idx,-39.8 as cons_conf_idx,0.729 as euribor3m,4991.6 as nr_employed,1 as y union all select 39 as age,2 as campaign,999 as pdays,0 as ...
SQL脚本
select age,(case sex when 'male' then 1 else 0 end)as sex,(case cp when 'angina' then 0 when 'notang' then 1 else 2 end)as cp,trestbps,chol,(case fbs when 'true' then 1 else 0 end)as fbs,(case restecg when 'norm' then 0 ...
选择列表
例如：SELECT a AS value,b+c AS sum FROM.如果没有使用 AS 指定输出列名，那么系统会分配一个缺省的列名。对于简单的列引用，它是被引用列的名字。对于函数调用，它是函数的名字。对于复杂表达式，系统会生成一个通用的名字。只有在新列...
通过pg_stat_activity分析诊断正在执行的SQL
如果上述SQL有返回结果，说明有SQL被Lock阻塞，需要进一步明确相互Block的SQL信息：SELECT w.query as waiting_query,w.pid as w_pid,w.usename as w_user,l.query as locking_query,l.pid as l_pid,l.usename as l_user,t.schemaname|'.'|...
标签传播聚类
in_id,0.7 as edge_weight union all select '5' as flow_out_id,'8' as flow_in_id,0.7 as edge_weight union all select '6' as flow_out_id,'7' as flow_in_id,0.6 as edge_weight union all select '6' as flow_out_id,'8' as flow_in_...
逻辑回归二分类
cast(0 as double)as f1,cast(0 as double)as f2,cast(1 as double)as f3,cast(1 as bigint)as label from dual union all select cast(1 as double)as f0,cast(0 as double)as f1,cast(0 as double)as f2,cast(0 as double)as f3,cast(0 ...
GBDT回归
cast(0 as double)as f1,cast(0 as double)as f2,cast(1 as double)as f3,cast(1 as bigint)as label from dual union all select cast(1 as double)as f0,cast(0 as double)as f1,cast(0 as double)as f2,cast(0 as double)as f3,cast(0 ...
GBDT二分类
cast(0 as double)as f1,cast(0 as double)as f2,cast(1 as double)as f3,cast(1 as bigint)as label from dual union all select cast(1 as double)as f0,cast(0 as double)as f1,cast(0 as double)as f2,cast(0 as double)as f3,cast(0 ...
EXPLAIN
explain 的结果中会显示输出结果的排序方式、分发的Key、Value以及用来求Hash值的列。FileSinkOperator（FS）：描述最终数据的存储操作。如果查询中有 insert 语句块，explain 结果中会显示目标表名称。LimitOperator（LIM）：描述查询语句...
EXPLAIN
explain 的结果中会显示输出结果的排序方式、分发的Key、Value以及用来求Hash值的列。FileSinkOperator（FS）：描述最终数据的存储操作。如果查询中有 insert 语句块，explain 结果中会显示目标表名称。LimitOperator（LIM）：描述查询语句...
数据探索函数
示例一：加法模型 SELECT X11_DECOMPOSE('{"model":"additive","period":"3"}',value,idx)as(trend,seasonal,residual,num,idx)FROM Values(32.50284661,0),(30.00239172,1),(4.47326732,2),(15.73310388,3),(21.49780825,4),(18.17761162,...
性能白皮书（Nexmark性能测试）
INSERT INTO discard_sink SELECT P.name,P.city,P.state,A.id FROM auction AS A INNER JOIN person AS P on A.seller=P.id WHERE A.category=10 and(P.state='OR' OR P.state='ID' OR P.state='CA');q4 CREATE TEMPORARY TABLE nexmark_...
逻辑回归多分类
cast(1 as double)as f1,cast(0 as double)as f2,cast(0 as double)as f3,cast(0 as bigint)as label from dual union all select cast(0 as double)as f0,cast(0 as double)as f1,cast(1 as double)as f2,cast(0 as double)as f3,cast(2 ...
类型转换
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...
ST_OffsetCurve
styleParameters参数如下：参数名称 描述 类型 默认值 说明 quad_segs 用来近似四分之一圆的弧段数 integer 8 数值越大，弧段越圆滑。join 连接方式 string round 可选值为：round mitre bevel mitre_limit 切割率限制 float-只影响采用...
快速拉起基于PAI的X2I召回服务
id,'10007' AS item_id,1639756800 AS time UNION-20211218 SELECT 'u0003' AS user_id,'10008' AS item_id,1639670400 AS time UNION-20211217 SELECT 'u0003' AS user_id,'10009' AS item_id,1639584000 AS time UNION-20211216 SELECT '...
PS-SMART二分类训练
0.9 as f4,-1.04 as f5,1 as label union all select 1.02 as f0,-0.88 as f1,0.82 as f2,1.82 as f3,1.55 as f4,0.53 as f5,0 as label union all select 1.19 as f0,-1.18 as f1,-1.1 as f2,2.26 as f3,1.22 as f4,0.92 as f5,0 as label...
ST_OffsetCurve
styleParameters参数如下：参数名称 描述 类型 默认值 说明 quad_segs 用来近似四分之一圆的弧段数 integer 8 数值越大，弧段越圆滑。join 连接方式 string round 可选值为：round mitre bevel mitre_limit 切割率限制 float-只影响采用...
ST_OffsetCurve
styleParameters参数如下：参数名称 描述 类型 默认值 说明 quad_segs 用来近似四分之一圆的弧段数 integer 8 数值越大，弧段越圆滑。join 连接方式 string round 可选值为：round mitre bevel mitre_limit 切割率限制 float-只影响采用...
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...
并行查询Hint语法
如果同时指定了 strategy1 和 strategy2，则用来指定 table_name 表和其前面一张表的并行join方式。说明 table_name 前面的表可以是一张物理表，或者是前面join的中间结果表。示例：SELECT/*+PARALLEL(t1)PARALLEL(t2)PQ_DISTRIBUTE(t2 PQ_...
边聚类系数
'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...
参数化视图
对于表变量，如果表a的Schema可以被用于插入到表b中，则意味着表a可以用来匹配和表b的Schema相同的表类型参数。您可以明确地声明返回类型，以提升代码的可读性。create view if not exists pv3(@a table(k string,v bigint),@b string)...
ST_Split
通过切割一个Geometry对象，返回一个GeometryCollection对象。...示例 使用LINESTRING切割POLYGON：SELECT blade,ST_Split(input,blade)from(select ST_MakeEnvelope(0,0,2,2)as input,'LINESTRING(1-1,1 3)':geometry as blade)as t;
归一化
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_...
树深度
create table TreeDepth_func_test_edge as select*from(select '0' as flow_out_id,'1' as flow_in_id union all select '0' as flow_out_id,'2' as flow_in_id union all select '1' as flow_out_id,'3' as flow_in_id union all select ...
ST_Split
通过切割一个Geometry对象，返回一个GeometryCollection对象。...示例 使用LINESTRING切割POLYGON：SELECT blade,ST_Split(input,blade)from(select ST_MakeEnvelope(0,0,2,2)as input,'LINESTRING(1-1,1 3)':geometry as blade)as t;
单源最短路径
out_id,"d"as flow_in_id,1.0 as edge_weight union all select"b"as flow_out_id,"e"as flow_in_id,2.0 as edge_weight union all select"e"as flow_out_id,"d"as flow_in_id,1.0 as edge_weight union all select"c"as flow_out_id,"e"as...
ST_Split
通过切割一个Geometry对象，返回一个GeometryCollection对象。...示例 使用LINESTRING切割POLYGON：SELECT blade,ST_Split(input,blade)from(select ST_MakeEnvelope(0,0,2,2)as input,'LINESTRING(1-1,1 3)':geometry as blade)as t;
计数三角形
create table TriangleCount_func_test_edge as select*from(select '1' as flow_out_id,'2' as flow_in_id union all select '1' as flow_out_id,'3' as flow_in_id union all select '1' as flow_out_id,'4' as flow_in_id union all ...
CREATE TABLE AS
语法 CREATE[GLOBAL TEMPORARY]TABLE table_name[(column_name[,.])][ON COMMIT { PRESERVE ROWS|DELETE ROWS }][TABLESPACE tablespace]AS query 说明 CREATE TABLE AS 创建一个表，并使用 SELECT 命令计算的数据填充该表。表列具有与 ...
- 产品推荐
- 这些文档可能帮助您