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...
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....
数值函数（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...
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...
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...
预测
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 ...
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 ...
数学函数
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)...
线性回归
9.02 as x1,3 as x2,'0:9.02 1:3' as sparsecol1 from dual union all select 100 as y,10.56 as x1,0 as x2,'0:10.56' as sparsecol1 from dual)tmp;使用PAI命令，提交线性回归组件参数。PAI-name linearregression-project algo_public-...
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...
双样本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 ...
工业资产指标&数据分析最佳实践
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...
随机森林
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 ...
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 ...
构造测试数据
(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...
标准化
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...
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|...
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' ...
CREATE TABLE AS
从分区子表创建新表，并自动同步数据，新表只会同步这一张子表的数据 CREATE TABLE public.new_table_3 AS TABLE public.src_table_child1;从Select Query的结果复制一张新表，同时设置新表属性。创建源表 BEGIN;CREATE TABLE public.src_...
UDF（地理空间）
CREATE FUNCTION ST_Aggr_Intersection AS 'com.esri.hadoop.hive.ST_Aggr_Intersection' USING 'spatial-sdk-hive.jar,esri-geometry-api.jar';CREATE FUNCTION ST_Aggr_Union AS '...
缺失值填充
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...
正态检验
create table normality_test_input as select*from(select 1 as x from dual union all select 2 as x from dual union all select 3 as x from dual union all select 4 as x from dual union all select 5 as x from dual union all ...
PS-SMART多分类
create table smart_multiclass_input lifecycle 3 as select*from(select '2' as label,'1:0.55 2:0.15 3:0.82 4:0.99 5:0.17' as features union all select '1' as label,'1:1.26 2:1.36 3:0.13 4:2.82 5:0.41' as features union all ...
CREATE VIEW
创建视图 v3 时，不设置 SQL SECURITY（即系统默认使用 INVOKER），语句如下：CREATE VIEW v3 AS SELECT id_province,user_info FROM t1 WHERE id_province=1;权限对比 仅通过高权限账号授予 user1 查询3个视图的权限，语句如下：GRANT ...
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 ...
特征编码
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 ...
ST_Zmflag
示例 不同类型的返回值：SELECT ST_Zmflag('POINT(0 1)':geometry)as_2D,ST_Zmflag('POINTM(0 1 2)':geometry)as_3DM,ST_Zmflag('POINT(0 1 2)':geometry)as_3DZ,ST_Zmflag('POINT(0 1 2 3)':geometry)as_4D;2d|_3dm|_3dz|_4d-+-+-+-0|1|2|...
- 产品推荐
- 这些文档可能帮助您