AliOS Things 概述
2021-06-10 JavaScript轻应用框架v3.0发布 新增案例：JavaScript和Python双引擎运行环境，一个镜像同时包含两套轻应用框架 HaaS200支持PSRAM，4MB内存全解锁 HaaS200 OTA支持压缩升级，增加更多空间给系统分区 优化HaaS200烧录成功率 增加...
类型转换
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 ...
通过Zipkin上报Java应用数据
通过Spring 2.5 MVC或Spring 3.0 MVC插件埋点 您可以选择通过Spring 2.5 MVC或Spring 3.0 MVC插件进行埋点。说明 如需获取Demo，请单击下载 源码，进入 springMvcDemo\webmvc3|webmvc25 目录，并根据Readme运行程序。在 applicationContext...
通过Zipkin上报Java应用数据
通过Spring 2.5 MVC或Spring 3.0 MVC插件埋点 您可以选择通过Spring 2.5 MVC或Spring 3.0 MVC插件进行埋点。说明 如需获取Demo，请单击下载 源码，进入 springMvcDemo\webmvc3|webmvc25 目录，并根据Readme运行程序。在 applicationContext...
聚类模型评估
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_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 ...
随机森林
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 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...
窗口函数
查询和分析语句*|SELECT department,staff_name,salary,round(salary*1.0/sum(salary)over(partition by department),3)AS salary_percentage 查询和分析结果 cume_dist函数 cume_dist函数用于统计窗口分区内各个值的累计分布。即计算窗口...
性能白皮书（Nexmark性能测试）
reserve BIGINT,dateTime TIMESTAMP(3),expires TIMESTAMP(3),seller BIGINT,category BIGINT,extra VARCHAR>,bid ROW,bidder BIGINT,price BIGINT,channel VARCHAR,url VARCHAR,dateTime TIMESTAMP(3),extra VARCHAR>,dateTime AS CASE ...
构建工具
av(V7.3.0)-av是一个轻量级的多媒体组件，主要包含AV基础框架、播放器和音频服务三部分。ble_mesh(V7.3.0)-ble_host and mesh stack board_dummy(V7.3.0)-csi_dummy development board configure.button(V7.3.0)-按键服务组件,支持通过GPIO...
MySQL 8.0 Server层最新架构详解
Table scan on R4(cost=0.25.0.25 rows=1)->Filter:(R4.c1=R3.c1)(cost=0.35.0.35 rows=0)->Table scan on R3(cost=0.25.0.25 rows=1)->Nested loop inner join(cost=0.50.0.50 rows=0)->Table scan on R2(cost=0.25.0.25 rows=1)->Filter...
乐鑫ESP8266移植SDK
ESP8266_RTOS_SDK在v3.0之后的版本已做了esp-idf框架的改造，对于v3.0之前的非esp-idf框架版本，用户可自行调整并参见此教程完成对接。安装工具链和编译工具 手动 下载macOS工具链，将工具链解压存放在~/esp 目录下：mkdir-p~/esp cd~/esp ...
数据倾斜调优
方法1：select/*+skewjoin(a)*/*from T0 a join T1 b on cast(a.c0 as string)=cast(b.c0 as string)and a.c1=b.c1;方法2：select/*+skewjoin(b)*/*from(select cast(a.c0 as string)as c00 from T0 a)b join T1 c on b.c00=c.c0;加...
服务端集成
使用该项目，您需要获取以下产品的权限：云产品 权限策略 授权方式 视频直播 AliyunLiveFullAccess 创建RAM用户并授权 视频点播 AliyunVODFullAccess 创建RAM用户并授权 通过源码构建及部署 根据源码的说明文档配置并执行，源码地址：Java...
服务端集成
使用该项目，您需要获取以下产品的权限：云产品 权限策略 授权方式 视频直播 AliyunLiveFullAccess 创建RAM用户并授权 视频点播 AliyunVODFullAccess 创建RAM用户并授权 通过源码构建及部署 根据源码的说明文档配置并执行，源码地址：Java...
乐鑫ESP32开发板移植
I(829)phy:phy_version:4180,cb3948e,Sep 12 2019,16:39:13,0,0 I(829)wifi:mode:sta(30:ae:a4:04:81:84)I(829)wifi station:wifi_init_sta finished.I(949)wifi:new:,0>,old:,0>,ap:,255>,sta:,0>,prof:1 I(949)wifi:state:init->auth(b0)...
构造测试数据
(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 ...
卡方拟合性检验
默认所有概率值相等 示例 测试数据 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...
H3函数
语法 boolean H3_AreNeighborCells(Long H3Cell1,Long H3Cell2)boolean H3_AreNeighborCells(string H3Cell1,string H3Cell2)参数说明 参数 说明 H3Cell1、H3Cell2 H3网格编码，类型为LONG或STRING。示例 示例一：输入两个LONG格式的H3网格...
H3函数
语法 boolean H3_AreNeighborCells(Long H3Cell1,Long H3Cell2)boolean H3_AreNeighborCells(string H3Cell1,string H3Cell2)参数说明 参数 说明 H3Cell1、H3Cell2 H3网格编码，类型为LONG或STRING。示例 示例一：输入两个LONG格式的H3网格...
MaxCompute账单用量明细分析
SELECT t.ds,t.projectid,t.storage,CASE WHEN t.storage<0.5 THEN t.storage*0.01-当项目的实际数据存储量大于0 MB小于等于512MB时，计费单价为0.01元/GB/天 WHEN t.storage>=0.5 THEN t.storage*0.004-当项目的实际数据存储量大于512MB时...
SDK选择与下载
b9ed7cb15a4f4f0a160a3d311686b3c7 下载地址：Flutter Plugin源码 Flutter Plugin版本 Demo源码 Flutter框架直播推流SDK 短视频SDK 阿里云短视频SDK（ApsaraVideo Short Video SDK，后续统称“短视频SDK”）是MediaBox音视频SDK的子产品之...
特征编码
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 ...
逻辑回归二分类
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 ...
全表统计
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...
线性回归
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....
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_...
- 产品推荐
- 这些文档可能帮助您