类型转换
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,...
DingRTC
3.0.0 createClient()创建一个客户端实例以进行 RTC 通信 3.0.0 createCustomAudioTrack()创建一个自定义的音频轨道。你可以使用这个方法将自己维护的 MediaStreamTrack 转换成一个可以用于 SDK 的音频轨道。3.0.0 createCustomVideoTrack...
单源最短路径
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命令...
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...
API服务变更
表 5.RTC 3.0 应用通信监测 变更类型 API 描述 新增 DescribeCallList 分页查询时间范围内通信信息。新增 DescribeCall 查询单次通信详情。新增 DescribePubUserListBySubUser 订阅端获取通信中发布端用户列表。新增 ...
构造测试数据
(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...
DescribeCallList
BadExpUserCnt Integer 0 通信体验差的用户数。RequestId String 231470C1-ACFB-4C9F-844F-4CFE1E3804C5 请求ID。示例 请求示例 POST api/call/describeCallList?AppId=9qb1*&StartTs=1615806196&EndTs=1615892596&PageNo=1&PageSize=10 ...
混流布局
5 id x y width height zorder 0 0.1718 0.1718 0.325 0.325 0 1 0.5031 0.1718 0.325 0.325 0 2 0.00625 0.503 0.325 0.325 0 3 0.3375 0.503 0.325 0.325 0 4 0.66875 0.503 0.325 0.325 0 画廊模式_6 id x y width height zorder 0 0....
数据类型
3.0 DingRtcLocalVideoStats 本地视频统计信息 3.0 DingRtcRemoteVideoStats 远端视频统计信息 3.0 DingRtcLocalAudioStats 本地音频统计信息 3.0 DingRtcRemoteAudioStats 远端音频统计信息 3.0 DingRtcAudioVolumeInfo 用户音量信息 3.0 ...
数据类型
3.0 RtcEngineDeviceState 设备状态。3.0 RtcEngineUserOfflineReason 用户离线原因。3.0 RtcEngineOnByeType OnBye类型。3.0 RtcEngineConnectionStatus 网络连接状态。3.0 RtcEngineConnectionStatusChangeReason 网络连接状态变更原因。...
线性回归
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 ...
- 产品推荐
- 这些文档可能帮助您