飞线层

[{"from":"116.85059,31.69078","to":"118.69629,36.20882"},{"from":"120.89355,37.09024","to":"116.93848,31.61597"},{"from":"121.28906,29.34388","to":"117.20215,31.12820"},{"from":"118.16895,31.57854","to":"119.79492,32.47270...

COMMON TABLE EXPRESSION（CTE）

使用示例 假设现有如下代码：insert overwrite table srcp partition(p='abc')select*from(select a.key,b.value from(select*from src where key is not null)a join(select*from src2 where value>0)b on a.key=b.key)c union all select...

开发ODPS Script任务

f:=select*from@d union select*from@e union select*from@a;insert overwrite table dest select*from@f;g:=select e.key,c.value from@e join@c on e.key=c.key;insert overwrite table dest2 SELECT*from@g;说明 本示例中需要用到的三张...

开发ODPS Script任务

f:=select*from@d union select*from@e union select*from@a;insert overwrite table dest select*from@f;g:=select e.key,c.value from@e join@c on e.key=c.key;insert overwrite table dest2 SELECT*from@g;说明 本示例中需要用到的三张...

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 ...

表表达式

该表表达式包含一个 FROM 子句，该子句后面可以根据需要选用 WHERE、GROUP BY 和 HAVING 子句。最简单的表表达式只是引用磁盘上的一个表，一个所谓的基本表，但是我们可以用更复杂的表表达式以多种方法修改或组合基本表。表表达式里可选的 ...

表表达式

例如 FROM ``T1`` CROSS JOIN ``T2`` INNER JOIN ``T3`` ON ``condition 和 FROM ``T1``,``T2`` INNER JOIN ``T3`` ON ``condition 并不完全相同，因为第一种情况中的 condition 可以引用 T1，但在第二种情况中却不行。条件连接 T1 {[INNER...

COMMON TABLE EXPRESSION（CTE）

使用示例 假设现有如下代码：insert overwrite table srcp partition(p='abc')select*from(select a.key,b.value from(select*from src where key is not null)a join(select*from src2 where value>0)b on a.key=b.key)c union all select...

CTE（2.0版）

WITH子句中定义的关系可以互相连接：WITH x AS(SELECT a FROM t),y AS(SELECT a AS b FROM x),z AS(SELECT b AS c FROM y)SELECT c FROM z;CTE后面必须直接跟使用CTE的SQL语句（如SELECT、INSERT、UPDATE等），否则CTE将失效。CTE后面也...

异常事务处理方案

delete from business_activiy where tx_id="XXXXXX"delete from business_action where tx_id="XXXXXX"使用如下命令，将用户的业务数据库中 dtx_branch_info 和 dtx_row_lock 表中 txid 数据清除：delete from dtx_branch_info where tx_...

SELECT

语法[WITH with_query[,.]]SELECT[ALL|DISTINCT]select_expr[,.][FROM from_item[,.]][WHERE condition][GROUP BY[ALL|DISTINCT]grouping_element[,.]][HAVING condition][{ UNION|INTERSECT|EXCEPT }[ALL|DISTINCT]select][ORDER BY ...

FMT 模式 SQL 支持说明

是 JOIN、INNER JOIN、LEFT JOIN、RIGHT JOIN、FULL JOIN SELECT col1,col2 FROM tb1 JOIN tb2 ON tb1.col1=tb2.col2 是 否 UNION、UNION ALL SELECT col1,col2 FROM tb1 UNION SELECT col1,col2 FROM tb2 是 否 嵌套查询 SELECT col1,col2...

DQL操作

Select select column[s]from|][join table on 条件表达式][where 条件表达式][group by column[s]][having 条件表达式][order by column[s]asc|desc][limit m[,n]];更多信息请参见 Select。Join SELECT select_expression,select_...

WITH

WITH子句中定义的关系可以互相连接 WITH x AS(SELECT a FROM t),y AS(SELECT a AS b FROM x),z AS(SELECT b AS c FROM y)SELECT c FROM z;CTE执行优化 3.1.9.3及以上内核版本的集群支持使用CTE执行优化功能，该功能默认关闭，您可以通过...

TPC-H测试集

SQL7 select supp_nation,cust_nation,l_year,sum(volume)as revenue from(select n1.n_name as supp_nation,n2.n_name as cust_nation,extract(year from l_shipdate)as l_year,l_extendedprice*(1-l_discount)as volume from supplier,...

SQL脚本模式

f:=SELECT*FROM@d UNION SELECT*FROM@e UNION SELECT*FROM@a;INSERT OVERWRITE table dest PARTITION(d='20171111')SELECT*FROM@f;g:=SELECT e.key,c.value FROM@e JOIN@c ON e.key=c.key;INSERT OVERWRITE TABLE dest2 PARTITION(d='...

查询数据

Q7 select supp_nation,cust_nation,l_year,sum(volume)as revenue from(select n1.n_name as supp_nation,n2.n_name as cust_nation,extract(year from l_shipdate)as l_year,l_extendedprice*(1-l_discount)as volume from supplier,...

批计算谓词下推配置

例如 select*from table where a=10 and b;如果a=10返回的结果只有1000条，b返回的结果有一亿条，则在存储层将1000条结果与一亿条结果做合并比较耗时，此时把b提到计算层，Spark只需要对存储层返回的1000条数据作过滤，大大降低了存储层的...

数据集信息和示例查询

Q7 select supp_nation,cust_nation,l_year,sum(volume)as revenue from(select n1.n_name as supp_nation,n2.n_name as cust_nation,extract(year from l_shipdate)as l_year,l_extendedprice*(1-l_discount)as volume from supplier,...

JOIN操作类型

SELECT id FROM tj_shop WHERE id IN(SELECT id FROM tj_item)SELECT id FROM tj_shop WHERE EXISTS(SELECT id FROM tj_item WHERE tj_shop.id=id)Anti Join：反连接，Anti JOIN中，右表只用于过滤左表的数据而不出现在结果集中。...

管道管理

import Console from '@alicloud/tea-console';import OpenApi,*as$OpenApi from '@alicloud/openapi-client';import Env from '@alicloud/darabonba-env';import Util from '@alicloud/tea-util';import mts20140618,*as$mts20140618 from...

Window Top-N

select a,b,c,window_start from(select*,row_number()over(partition by b,window_start,window_end order by c)as rk from(select a,sum(b)as b,max(c)as c,window_start,window_end from table(tumble(table MyTable,descriptor(ts),...

管道管理

import os from aliyunsdkcore.client import AcsClient from aliyunsdkcore.acs_exception.exceptions import ClientException from aliyunsdkcore.acs_exception.exceptions import ServerException from aliyunsdkcore.auth.credentials...

不兼容SQL重写

示例 错误写法 select*from(select*from(select cast(login_user_cnt as int)as uv,'3' as shuzi from test_login_cnt where type='device' and type_name='mobile')v order by v.uv desc)v order by v.shuzi limit 20;报错信息 FAILED:...

JOIN操作类型

SELECT id FROM tj_shop WHERE id IN(SELECT id FROM tj_item)SELECT id FROM tj_shop WHERE EXISTS(SELECT id FROM tj_item WHERE tj_shop.id=id)Anti Join：版本要求>=Ha3 3.7.5 反连接，Anti JOIN中，右表只用于过滤左表的数据而不出现...

高性能版Spark全密态计算引擎性能测试报告

SELECT supp_nation,cust_nation,l_year,sum(volume)AS revenue FROM(SELECT n1.n_name AS supp_nation,n2.n_name AS cust_nation,extract(year FROM l_shipdate)AS l_year,l_extendedprice*(1-l_discount)AS volume FROM supplier,...

普通模式和Hive兼容模式下SQL的差异

select cast((a&b)as string)from values(-9223372036854775807L,-9223372036854775792L)t(a,b);返回NULL Hive兼容模式 set odps.sql.hive.compatible=true;select cast((a&b)as string)from values(-9223372036854775807L,-...

画像分析-BSI优化方案（Beta）

SELECT sum(kv[1])AS total_gmv,-总GMV sum(kv[1])/sum(kv[2])AS avg_gmv-人均GMV FROM(SELECT bsi_sum(t1.gmv_bsi,t2.crowd)AS kv FROM bsi_gmv t1,(SELECT rb_and(a.bitmap,b.bitmap)AS crowd FROM(SELECT bitmap FROM rb_tag WHERE tag_...

DML操作

功能 是否支持 插入或覆写数据（INSERT INTO|INSERT OVERWRITE）支持 insert {into|overwrite} table[partition()]<select_statement>from<from_statement>;支持指定列插入数据：insert into table[partition()](,<col_name>.)...

SELECT

case when 作为条件表达式 SELECT*FROM(SELECT CASE WHEN warehouse_id=48 THEN warehouse_id WHEN warehouse_id=24 THEN id ELSE wave_status END AS aa FROM s_wmp_package_wave WHERE wave_status=0)t WHERE t.aa>10 LIMIT 10;...

TPC-H Benchmark

Q7 SELECT supp_nation,cust_nation,l_year,sum(volume)AS revenue FROM(SELECT n1.n_name AS supp_nation,n2.n_name AS cust_nation,extract(year FROM l_shipdate)AS l_year,l_extendedprice*(1-l_discount)AS volume FROM supplier,...

并行查询Hint语法

x>0 SELECT/*+SET_VAR(max_parallel_degree=n)*/*FROM.-n>0 关闭并行查询 您可以使用如下任意一种方式关闭并行查询：SELECT/*+NO_PARALLEL()*/.FROM.;SELECT/*+SET_VAR(max_parallel_degree=0)*/*FROM.通过Hint指定并行表 并行查询提供了 ...

SELECT

case when 作为条件表达式 SELECT*FROM(SELECT CASE WHEN warehouse_id=48 THEN warehouse_id WHEN warehouse_id=24 THEN id ELSE wave_status END AS aa FROM s_wmp_package_wave WHERE wave_status=0)t WHERE t.aa>10 LIMIT 10;...

DML操作

功能 是否支持 插入或覆写数据（INSERT INTO|INSERT OVERWRITE）支持 insert {into|overwrite} table[partition()]<select_statement>from<from_statement>;支持指定列插入数据：insert into table[partition()](,<col_name>.)...

WITH查询（公共表表达式）

在某些情况中可以采取引用一个递归 WITH 的输出来操作这个限制，例如：WITH RECURSIVE included_parts(sub_part,part)AS(SELECT sub_part,part FROM parts WHERE part='our_product' UNION ALL SELECT p.sub_part,p.part FROM included_...

嵌套子查询

查询和分析语句*|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...

变更Sink

INSERT INTO MySink1 SELECT a,sum(b),max(c)FROM MyTable GROUP BY a;INSERT INTO MySink2 SELECT a,b,c FROM MyTable WHERE a>10;删除MySink1对应的Query，该变更属于完全兼容变更。该Query中的group aggregate对应的状态会被丢弃。...

计算下推

多元索引不包含a,b,c,d，扫描全表读取数据，不支持算子下推*/SELECT b,c,d FROM exampletable;多元索引包含b,c,d，通过多元索引读取数据，支持算子下推*/支持下推的算子 算子类型 下推算子 下推限制 逻辑运算符 AND、OR 不支持NOT算子下推...

飞线层（v1.x版本）

{"from":"117.99316,40.84706","to":"116.85059,31.69078"},{"from":"118.30078,36.56260","to":"117.24609,40.97990"},{"from":"119.35547,26.86328","to":"120.41016,32.28713"},{"from":"113.07129,31.42866","to":"106.04004,31.31610...

管理访问凭据

from alibabacloud_ecs20140526.models import DescribeRegionsRequest#Credentials和云产品SDK都需引入Config from alibabacloud_tea_openapi.models import Config from alibabacloud_credentials.models import Config as CreConfig ...
共有200条 < 1 2 3 4 ... 200 >
跳转至： GO
产品推荐
云服务器 安全管家服务 安全中心
这些文档可能帮助您
弹性公网IP 短信服务 人工智能平台 PAI 金融分布式架构 对象存储 物联网平台

新品推荐

新人特惠 爆款特惠 最新活动 免费试用
新人特惠 爆款特惠 最新活动 免费试用