3.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 false as f0,4.0 as f1,1 as f2 from dual union all select true as f0,3.0 as f1,1 as f2 from dual union all select false ...
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 ...
否 示例 输入表 create table pai_pearson_test_input as select*from(select 1.0 as f0,0.11 as f1 union all select 2.0 as f0,0.12 as f1 union all select 3.0 as f0,0.13 as f1 union all select 5.0 as f0,0.15 as f1 union all ...
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...
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 ...
create table pai_kmeans_test_sparse_input as select*from(select 1 as id,"s1"as id_s,"0:0.1,1:0.2"as kvs0,"2:0.3,3:0.4"as kvs1 from dual union all select 2 as id,"s2"as id_s,"0:1.1,2:1.2"as kvs0,"4:1.3,5:1.4"as kvs1 from ...
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 ...
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 ...
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,...
in_id,1.0 as edge_weight union all select"f"as flow_out_id,"g"as flow_in_id,3.0 as edge_weight union all select"a"as flow_out_id,"d"as flow_in_id,4.0 as edge_weight)tmp;对应的数据结构图:添加SQL脚本组件,输入以下PAI命令...
create table epdf_test as select*from(select 1.0 as col1 from dual union all select 2.0 as col1 from dual union all select 3.0 as col1 from dual union all select 4.0 as col1 from dual union all select 5.0 as col1 from dual...
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...
(53),(54),(55),(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 ...
输入无效网格编码 SELECT H3_H3ToString(0)AS H3Address;输入为空 SELECT H3_H3ToString(NULL)AS H3Address;返回结果:+-+|H3Address|+-+|+-+H3_StringToH3 将STRING类型的H3网格编码转换为LONG类型。如果输入空字符串或无效的H3网格字符串...
输入无效网格编码 SELECT H3_H3ToString(0)AS H3Address;输入为空 SELECT H3_H3ToString(NULL)AS H3Address;返回结果:+-+|H3Address|+-+|+-+H3_StringToH3 将STRING类型的H3网格编码转换为LONG类型。如果输入空字符串或无效的H3网格字符串...
CASE WHEN source_type='OdpsSpot' THEN SUM((computationsqlinput/1024/1024/1024))*computationsqlcomplexity*0.1 ELSE SUM((computationsqlinput/1024/1024/1024))*computationsqlcomplexity*0.3 END AS sqlmoney FROM maxcomputefee ...
默认所有概率值相等 示例 测试数据 create table pai_chisq_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 all select '1' as f0,'4' as f1 from dual union all...
f0 f1 f2 f3 label 1.0 0.0 0.0 0.0 0 0.0 0.0 1.0 0.0 1 0.0 0.0 0.0 1.0 1 0.0 1.0 0.0 0.0 0 1.0 0.0 0.0 0.0 0 0.0 1.0 0.0 0.0 0 使用PAI命令,提交逻辑回归二分类组件的训练参数。drop offlinemodel if exists lr_test_model;PAI-...
f0 f1 f2 f3 label 1.0 0.0 0.0 0.0 0 0.0 0.0 1.0 0.0 1 0.0 0.0 0.0 1.0 1 0.0 1.0 0.0 0.0 0 1.0 0.0 0.0 0.0 0 0.0 1.0 0.0 0.0 0 使用PAI命令,提交GBDT回归组件的训练参数。drop offlinemodel if exists gbdt_ls_test_model;PAI-name...
f0 f1 f2 f3 label 1.0 0.0 0.0 0.0 0 0.0 0.0 1.0 0.0 1 0.0 0.0 0.0 1.0 1 0.0 1.0 0.0 0.0 0 1.0 0.0 0.0 0.0 0 0.0 1.0 0.0 0.0 0 使用PAI命令,提交GBDT二分类组件的训练参数。drop offlinemodel if exists gbdt_lr_test_model;PAI-...
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...
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 ...
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 summary_test_input as select*from(select 'a' as col1,1 as col2,0.001 as col3 from dual union all select 'b' as col1,2 as col2,100.01 as col3 from dual)tmp;PAI命令 PAI-name stat_summary-project algo_public-...
SELECT(Q3_sales-Q2_sales)/Q2_sales AS QoQ_growth FROM(SELECT SUM(CASE WHEN QUARTER(日期)=2 THEN 销售金额 ELSE 0 END)AS Q2_sales,SUM(CASE WHEN QUARTER(日期)=3 THEN 销售金额 ELSE 0 END)AS Q3_sales FROM ai_libai_dealer_sales ...
'A' as label,'A' as prediction,'{"A":0.7,"B":0.3}' as detail union all select '3' as id,'A' as label,'A' as prediction,'{"A":0.9,"B":0.1}' as detail union all select '4' as id,'B' as label,'B' as prediction,'{"A":0.2,"B":0...
命令如下:create table pai_ft_string_similarity_input as select*from(select 0 as id,"北京"as col0,"北京"as col1 union all select 1 as id,"北京"as col0,"北京上海"as col1 union all select 2 as id,"北京"as col0,"北京上海深圳...
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_...
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_...
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-\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-\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-\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...
命令如下:CREATE TABLE pai_ft_string_similarity_topn_input AS SELECT*FROM(SELECT 0 AS id,'北京' AS col0 UNION ALL SELECT 1 AS id,'北京上海' AS col0 UNION ALL SELECT 2 AS id,'北京上海深圳' AS col0)tmp;执行成功后,pai_ft_...
create table pai_doc_similarity_input as select*from(select 0 as id,"北京 上海"as col0,"北京 上海"as col1 union all select 1 as id,"北京 上海"as col0,"北京 上海 深圳"as col1)tmp 执行成功后,输入表pai_doc_similarity_input的...
0 as x2,'0:3.89' as sparsecol1 from dual union all select 40 as y,4.19 as x1,0 as x2,'0:4.19' as sparsecol1 from dual union all select 50 as y,5.76 as x1,0 as x2,'0:5.76' as sparsecol1 from dual union all select 60 as y,6....
string,0 as col_bigint,1.0 as col_double union all select '01' as col_string,1 as col_bigint,cast(null as double)as col_double union all select '01' as col_string,1 as col_bigint,1.0 as col_double union all select '00' as ...
create table etrec_test_input as select*from(select cast(0 as string)as user,cast(0 as string)as item from dual union all select cast(0 as string)as user,cast(1 as string)as item from dual union all select cast(1 as string...
create table PageRankWithWeight_func_test_edge as select*from(select 'a' as flow_out_id,'b' as flow_in_id,1.0 as weight union all select 'a' as flow_out_id,'c' as flow_in_id,1.0 as weight union all select 'b' as flow_out_...
.),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,.))。除上述情况以外...