类型转换

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

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

预测

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

双样本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 ...

随机森林

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

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

构造测试数据

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

H3函数

输入无效网格编码 SELECT H3_H3ToString(0)AS H3Address;输入为空 SELECT H3_H3ToString(NULL)AS H3Address;返回结果:+-+|H3Address|+-+|+-+H3_StringToH3 将STRING类型的H3网格编码转换为LONG类型。如果输入空字符串或无效的H3网格字符串...

H3函数

输入无效网格编码 SELECT H3_H3ToString(0)AS H3Address;输入为空 SELECT H3_H3ToString(NULL)AS H3Address;返回结果:+-+|H3Address|+-+|+-+H3_StringToH3 将STRING类型的H3网格编码转换为LONG类型。如果输入空字符串或无效的H3网格字符串...

MaxCompute账单用量明细分析

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

GBDT回归

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

GBDT二分类

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

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

逻辑回归多分类

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

SQL语句示例

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,"北京上海深圳...

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

字符串相似度-topN

命令如下: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 ...

协同过滤etrec

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

PageRank

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

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,.))。除上述情况以外...
共有200条 < 1 2 3 4 ... 200 >
跳转至: GO
产品推荐
云服务器 安全管家服务 安全中心
这些文档可能帮助您
文件存储 CPFS 数据传输服务 区块链服务 智能语音交互 弹性公网IP 短信服务
新人特惠 爆款特惠 最新活动 免费试用