Pig开发手册
Use the FOREACH-GENERATE command to assign names to the fields.uniq_frequency3=FOREACH uniq_frequency2 GENERATE$1 as hour,$0 as ngram,$2 as score,$3 as count,$4 as mean;Use the FILTER command to move all records with a ...
计算成本控制
SELECT t.id,SUM(t.val)AS val FROM(SELECT id,SUM(col3)AS val FROM table3 GROUP BY id UNION ALL SELECT id,SUM(col4)AS val FROM table4 GROUP BY id)t GROUP BY t.id;可以优化为-SELECT t.id,SUM(t.val)AS val FROM(SELECT id,col3 AS...
Salesforce on Alibaba Cloud 产品服务协议-V1.3
For the use of Salesforce on Alibaba Cloud products(hereinafter collectively referred to as"SFDC China Products")ordered by You pursuant to the Order Forms during the term of this Agreement,please refer to Appendix 3 ...
ST_As3DGrid
语法 geomgrid[]ST_As3DGrid(geometry geom3d,integer precision,bool degenerated default false);geomgrid[]ST_As3DGrid(meshgeom geom3d,integer precision,bool degenerated default false);geomgrid[]ST_As3DGrid(sfmesh geom3d,...
ST_As3DGrid
语法 geomgrid[]ST_As3DGrid(geometry geom3d,integer precision,bool degenerated default false);geomgrid[]ST_As3DGrid(meshgeom geom3d,integer precision,bool degenerated default false);geomgrid[]ST_As3DGrid(sfmesh geom3d,...
ST_As3DGrid
语法 geomgrid[]ST_As3DGrid(geometry geom3d,integer precision,bool degenerated default false);geomgrid[]ST_As3DGrid(meshgeom geom3d,integer precision,bool degenerated default false);geomgrid[]ST_As3DGrid(sfmesh geom3d,...
ST_As3dTiles
语法 boolean ST_As3dTiles(sfmesh sfmesh_object,cstring table_name,cstring options default '{}');返回值 返回值 描述 true 导出成功。false 导出失败。参数 参数名称 描述 sfmesh_object 需要处理的sfmesh对象。table_name 业务表名称...
ST_As3dTiles
语法 boolean ST_As3dTiles(sfmesh sfmesh_object,cstring table_name,cstring options default '{}');返回值 返回值 描述 true 导出成功。false 导出失败。参数 参数名称 描述 sfmesh_object 需要处理的sfmesh对象。table_name 业务表名称...
ST_AsText
unnest-GZ00262064446046072072-采用拆分编码 SELECT unnest(ST_AsText(ST_As3DGrid('srid=4490;POINT(116.31522216796875 39.910277777777778 1001.8)':geometry,20),-1,true));unnest-G00131032223023031031,+10010-H3编码 SELECT ST_...
ST_AsText
unnest-GZ00262064446046072072-采用拆分编码 SELECT unnest(ST_AsText(ST_As3DGrid('srid=4490;POINT(116.31522216796875 39.910277777777778 1001.8)':geometry,20),-1,true));unnest-G00131032223023031031,+10010-H3编码 SELECT ST_...
ST_AsText
unnest-GZ00262064446046072072-采用拆分编码 SELECT unnest(ST_AsText(ST_As3DGrid('srid=4490;POINT(116.31522216796875 39.910277777777778 1001.8)':geometry,20),-1,true));unnest-G00131032223023031031,+10010-H3编码 SELECT ST_...
ST_AsBinary
st_asbinary-\x0102000f74271236 select st_asbinary(unnest(st_as3dgrid('srid=4490;POINT(116.31522216796875 39.910277777777778 1001.8)':geometry,20)));st_asbinary-\x0102401474271236362412000000-H3Grid select st_asbinary(st_h3...
ST_AsBinary
st_asbinary-\x0102000f74271236 select st_asbinary(unnest(st_as3dgrid('srid=4490;POINT(116.31522216796875 39.910277777777778 1001.8)':geometry,20)));st_asbinary-\x0102401474271236362412000000-H3Grid select st_asbinary(st_h3...
ST_AsBinary
st_asbinary-\x0102000f74271236 select st_asbinary(unnest(st_as3dgrid('srid=4490;POINT(116.31522216796875 39.910277777777778 1001.8)':geometry,20)));st_asbinary-\x0102401474271236362412000000-H3Grid select st_asbinary(st_h3...
特征编码
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 ...
聚类模型评估
create table if not exists pai_cluster_evaluation_test_input as select*from(select 1 as id,1 as f0,2 as f3 from dual union all select 2 as id,1 as f0,3 as f3 from dual union all select 3 as id,1 as f0,4 as f3 from dual ...
PS-SMART二分类训练
create table smart_binary_input lifecycle 3 as select*from(select 0.72 as f0,0.42 as f1,0.55 as f2,-0.09 as f3,1.79 as f4,-1.2 as f5,0 as label union all select 1.23 as f0,-0.33 as f1,-1.55 as f2,0.92 as f3,-0.04 as f4,-0....
Table2KV
create table test as select*from(select 0 as rowid,1 as col0,1.1 as col1,2 as col2 from dual union all select 1 as rowid,0 as col0,1.2 as col1,3 as col2 from dual union all select 2 as rowid,1 as col0,2.3 as col1,4 as col2...
K近邻
create table pai_knn_test_input as select*from(select 1 as f0,2 as f1,'good' as class from dual union all select 1 as f0,3 as f1,'good' as class from dual union all select 1 as f0,4 as f1,'bad' as class from dual union all...
数值函数（2.0版）
col0|+-+|0.5709993917553757|select random(cast(3 as tinyint));col0|+-+|2|select random(cast(3 as smallint));col0|+-+|0|select random(cast(3 as int));col0|+-+|1|select random(cast(3 as bigint));col0|+-+|0|RADIANS radians...
标签传播聚类
id,'4' as flow_in_id,0.6 as edge_weight union all select '4' as flow_out_id,'6' as flow_in_id,0.3 as edge_weight union all select '5' as flow_out_id,'6' as flow_in_id,0.6 as edge_weight union all select '5' as flow_out_id,...
预测
create table pai_rf_test_input as select*from(select 1 as f0,2 as f1,"good"as class from dual union all select 1 as f0,3 as f1,"good"as class from dual union all select 1 as f0,4 as f1,"bad"as class from dual union all ...
K均值聚类
使用其他初始质心的方式 create table pai_kmeans_test_input as select*from(select 'id1' as id,1 as f0,2 as f1 from dual union all select 'id2' as id,1 as f0,3 as f1 from dual union all select 'id3' as id,1 as f0,4 as f1 from...
数学函数
col0|+-+|0.5709993917553757|select random(cast(3 as tinyint));col0|+-+|2|select random(cast(3 as smallint));col0|+-+|1|select random(cast(3 as int));col0|+-+|1|select random(cast(3 as bigint));col0|+-+|1|ROUND round(x)...
GISV On-cloud Migration Service Content
information,data,charts,as well as necessary system permissions and remote access channels to enable the service to be provided by Party B.All such materials will be subject to the confidentiality terms under this ...
使用CloudLens for SLS分析资源用量
t2 as(select InstanceID,round(di[1],3)as"费用",concat(cast(round(di[3]*100-100,3)as varchar),'%')"同比上月"from(select InstanceID,compare(cost,2592000)as di FROM(select InstanceID,round(sum(PretaxAmount),2)as cost FROM ...
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,.))。除上述情况以外...
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,.))。除上述情况以外...
双样本T检验
memSizePerCore=max(1024,int(kOneCoreDataSize*2))return coreNum,memSizePerCore 使用示例 测试数据 create table pai_test_input as select*from(select 1 as f0,2 as f1 from dual union all select 1 as f0,3 as f1 from dual union ...
标准化
string,11 as col_bigint,10.2 as col_double,False as col_boolean,cast('2016-07-02 10:00:00' as datetime)as col_datetime from dual union all select '02' as col_string,cast(null as bigint)as col_bigint,10.3 as col_double,True...
归一化
string,11 as col_bigint,10.2 as col_double,False as col_boolean,cast('2016-07-02 10:00:00' as datetime)as col_datetime from dual union all select '02' as col_string,cast(null as bigint)as col_bigint,10.3 as col_double,True...
工业资产指标&数据分析最佳实践
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...
CAST函数
返回结果如下：+-+|CAST(4.3 AS BOOLEAN)|+-+|1|+-+示例4 将INT的数据类型 5 转换为BOOLEAN类型，语句如下：SELECT CAST(5 AS BOOLEAN);返回结果如下：+-+|CAST(5 AS BOOLEAN)|+-+|1|+-+CAST AS DECIMAL(m,d)|FLOAT|INT|INTEGER|SMALLINT|...
CREATE TABLE AS
从分区子表创建新表，并自动同步数据，新表只会同步这一张子表的数据 CREATE TABLE public.new_table_3 AS TABLE public.src_table_child1;从Select Query的结果复制一张新表，同时设置新表属性。创建源表 BEGIN;CREATE TABLE public.src_...
随机森林
create table pai_rf_test_input as select*from(select 1 as f0,2 as f1,"good"as class from dual union all select 1 as f0,3 as f1,"good"as class from dual union all select 1 as f0,4 as f1,"bad"as class from dual union all ...
Pig作业配置
Use the FOREACH-GENERATE command to assign names to the fields.uniq_frequency3=FOREACH uniq_frequency2 GENERATE$1 as hour,$0 as ngram,$2 as score,$3 as count,$4 as mean;Use the FILTER command to move all records with a ...
UDF（地理空间）
本文为您介绍如何使用开源地理空间UDF分析空间数据。前提条件 请确认您已完成以下操作：已安装Git。已安装Maven并设置环境变量。已安装MaxCompute客户端。更多安装MaxCompute客户端信息，请参见 安装并配置MaxCompute客户端。...
构造测试数据
(56),(57),(58),(59),(60),(61),(62),(63)t(c0))select k,from_unixtime(1617120000)as t,from_unixtime(1617120000+3600000*c)as b,c from(select 100+row_number()over(partition by 1)-1 as k,cast(round(rand()*3,0)as bigint)+3 as c ...
缺失值填充
string,11 as col_bigint,10.2 as col_double,False as col_boolean,cast('2016-07-02 10:00:00' as datetime)as col_datetime from dual union all select '02' as col_string,cast(null as bigint)as col_bigint,10.3 as col_double,True...
Quick BI中如何计算某个度量值不同范围的记录总数
select city,county,total,分组汇总,count('分组汇总')as '计算总数' from(select distinct col_1 as 'city',col_2 as 'county',col_3 as 'total',CASE WHEN col_3>=0 and col_3度量值100以下' WHEN col_3>100 and col_3度量值100到500' ...
- 产品推荐
- 这些文档可能帮助您