预测
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 LabelPropagationClassification_func_test_edge as select*from(select 'a' as flow_out_id,'b' as flow_in_id,0.2 as edge_weight union all select 'a' as flow_out_id,'c' as flow_in_id,0.8 as edge_weight union all ...
缺失值填充
datetime from dual union all select '04' as col_string,13 as col_bigint,10.4 as col_double,cast(null as boolean)as col_boolean,cast('2016-07-05 10:00:00' as datetime)as col_datetime from dual union all select '05' as col_...
聚类模型评估
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 ...
数据集信息和示例查询
Q1 select l_returnflag,l_linestatus,sum(l_quantity)as sum_qty,sum(l_extendedprice)as sum_base_price,sum(l_extendedprice*(1-l_discount))as sum_disc_price,sum(l_extendedprice*(1-l_discount)*(1+l_tax))as sum_charge,avg(l_...
获取和安装无影魔方AS05
无影魔方AS05 为硬件终端，您需要提前购买获取并安装，才可以登录客户端然后连接无影云服务（包括 无影云电脑、无影云应用 和 无影云盘）。本文为您介绍 无影魔方AS05 的获取方式、部件说明和安装调测操作。前提条件 已获取 无影魔方AS05。...
SPL与SQL的使用场景对照
parse(Time,'%Y-%m-%d%H:%i')字段提取 正则提取 select cast(Status as BIGINT)as Status,date_parse(Time,'%Y-%m-%d%H:%i')AS Time JSON提取 select cast(Status as BIGINT)as Status,date_parse(Time,'%Y-%m-%d%H:%i')AS Time 正则提取：...
创建触发器
语法 定义新触发器 CREATE TRIGGER 概要 CREATE[OR REPLACE]TRIGGER name { BEFORE|AFTER|INSTEAD OF } { INSERT|UPDATE|DELETE }[OR { INSERT|UPDATE|DELETE }][,.]ON table[REFERENCING { OLD AS old|NEW AS new }.][FOR EACH ROW][WHEN ...
高性能版Spark全密态计算引擎性能测试报告
SELECT l_returnflag,l_linestatus,sum(l_quantity)AS sum_qty,sum(l_extendedprice)AS sum_base_price,sum(l_extendedprice*(1-l_discount))AS sum_disc_price,sum(l_extendedprice*(1-l_discount)*(1+l_tax))AS sum_charge,avg(l_...
Quick BI的MySQL数据库数据集中如何使用with as
概述 Quick BI的MySQL数据库数据集中如何使用with as。详细信息 Quick BI的MySQL数据库数据集中如何使用with as语法。with e as(select*from EMP),d as(select*from DEPT)select `job` from e,d where e.deptno=d.deptno;适用于 Quick BI
三元组转kv
create table triple2kv_test_input as select*from(select '01' as id,'a' as word,10 as count from dual union all select '01' as id,'b' as word,20 as count from dual union all select '01' as id,'c' as word,30 as count from ...
分析网站日志
select date_format(from_unixtime(_time_-_time_%60),'%H:%i:%S')as minutes,approx_distinct(remote_addr)as uv,count(1)as pv,avg(request_time)as avg group by minutes order by minutes asc limit 100000 在 查询分析配置 中，设置 X...
几何模型
Covers(smallc,bigc)As smallcoversbig,ST_Covers(bigc,ST_ExteriorRing(bigc))As bigcoversexterior,ST_Contains(bigc,ST_ExteriorRing(bigc))As bigcontainsexterior FROM(SELECT ST_Buffer(ST_GeomFromText('POINT(1 2)'),10)As smallc,...
常见分析案例
status:500|select_topic_,max_by(error_count,window_time)/1.0/sum(error_count)as error_ratio,sum(error_count)as total_error from(select_topic_,count(*)as error_count,_time_-_time_%300 as window_time from log group by_topic_...
几何模型
Covers(smallc,bigc)As smallcoversbig,ST_Covers(bigc,ST_ExteriorRing(bigc))As bigcoversexterior,ST_Contains(bigc,ST_ExteriorRing(bigc))As bigcontainsexterior FROM(SELECT ST_Buffer(ST_GeomFromText('POINT(1 2)'),10)As smallc,...
几何模型
ST_Covers(smallc,bigc)As smallcoversbig,ST_Covers(bigc,ST_ExteriorRing(bigc))As bigcoversexterior,ST_Contains(bigc,ST_ExteriorRing(bigc))As bigcontainsexterior FROM(SELECT ST_Buffer(ST_GeomFromText('POINT(1 2)'),10)As ...
简介
topic_:polardbx_sqlaudit and instance_id:pxc-*|SELECT sql_code as"SQL模板ID",round(total_time*1.0/sum(total_time)over()*100,2)as"总体耗时比例(%)",execute_times as"执行次数",round(avg_time)as"平均执行时间",round(avg_rows)as...
Github公开事件数据
重要 您无需为公开数据集的数据支付存储费用，但是您需要支付 执行查询语句产生的相应计算费用，费用计算规则请参见 计算费用（包年包月）或 计算费用（按量付费）。由于公开数据集需要跨项目访问，您在DataWorks的数据地图中无法查找到...
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_...
Quick BI使用MaxCompute数据源创建SQL数据集时报错
A32_14_,ALL_T_1_.`code` AS T_A51_15_,ALL_T_1_.`income` AS T_AC2_16_,ALL_T_1_.`business_type` AS T_AC5_17_,ALL_T_1_.`time` AS T_AED_18_,ALL_T_1_.`account_serial_number` AS T_A49_19_,ALL_T_1_.`pid` AS T_AF1_20_,ALL_T_1_.`...
使用KubeAPI操作审计
审计功能开启后，审计日志会产生费用，计费方式请参见 按使用功能计费。步骤一：启用KubeAPI操作审计功能 新建ASM实例 登录 ASM控制台，在左侧导航栏，选择 服务网格>网格管理。在 网格管理 页面，单击 创建新网格，选中 启用网格审计，...
基于GitHub公开事件数据集的离线实时一体化实践
JSON_OBJECT(col,'$.repo.id')AS BIGINT)AS repo_id,GET_JSON_OBJECT(col,'$.repo.name')AS repo_name,CAST(GET_JSON_OBJECT(col,'$.org.id')AS BIGINT)AS org_id,GET_JSON_OBJECT(col,'$.org.login')AS org_login,GET_JSON_OBJECT(col,'$....
基于GitHub公开事件数据集的离线实时一体化实践
JSON_OBJECT(col,'$.repo.id')AS BIGINT)AS repo_id,GET_JSON_OBJECT(col,'$.repo.name')AS repo_name,CAST(GET_JSON_OBJECT(col,'$.org.id')AS BIGINT)AS org_id,GET_JSON_OBJECT(col,'$.org.login')AS org_login,GET_JSON_OBJECT(col,'$....
按使用功能计费
日志服务按使用功能计费模式，按照您使用到的资源及功能颗粒度计费，有利于您基于实际需求精细化管理日志服务资源的费用。特性 说明 计费说明 按量付费，即后付费，是指您购买的资源按照实际用量结算，在每个结算周期生成账单并从账户中...
DML语句
with delete merge into h0 as target using(select 1 as id,'a1' as name,10.0 as price)source on target.id=source.id when matched then update set id=source.id,name=source.name,price=source.price when matched and name='delete'...
SSML标记语言说明
语法<say-as interpret-as="string">文本</say-as>属性 属性名称 属性类型 属性值 是否必选 描述 interpret-as String cardinal/digits/telephone/name/address/id/characters/punctuation/date/time/currency/measure 是 指示出标签内文本...
使用KubeAPI操作审计
审计功能开启后，审计日志会产生费用，计费方式请参见 按使用功能计费。步骤一：启用KubeAPI操作审计功能 新建ASM实例 登录 ASM控制台，在左侧导航栏，选择 服务网格>网格管理。在 网格管理 页面，单击 创建新网格，选中 启用网格审计，...
分析Apache日志
method 访问PV/UV统计 图展示最近一天内的PV数和UV数，所关联的查询分析语句如下所示：*|select date_format(date_trunc('hour',_time_),'%m-%d%H:%i')as time,count(1)as pv,approx_distinct(remote_addr)as uv group by date_format(date...
几何模型
Covers(smallc,bigc)As smallcoversbig,ST_Covers(bigc,ST_ExteriorRing(bigc))As bigcoversexterior,ST_Contains(bigc,ST_ExteriorRing(bigc))As bigcontainsexterior FROM(SELECT ST_Buffer(ST_GeomFromText('POINT(1 2)'),10)As smallc,...
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...
SQL Server性能分析与优化
查看数据库IO使用情况 SELECT DB_NAME(fs.database_id)AS[Database Name],CAST(fs.io_stall_read_ms/(1.0+fs.num_of_reads)AS NUMERIC(10,1))AS[avg_read_stall_ms],CAST(fs.io_stall_write_ms/(1.0+fs.num_of_writes)AS NUMERIC(10,1))AS...
SSML标记语言介绍
as interpret-as="address">富路国际1号楼3单元304</say-as><say-as interpret-as="nick">李四6689</say-as>文本头部之前可以省略XML Header。标签内的文字内容如果包含XML的特殊字符，需要做字符转义，常用的特殊字符对应关系如下。...
产品计费
计费项 计费说明 计费方式 转换计费方式 计费标准 计算资源（vCPU、内存和GPU）即实例规格涉及的计算资源费用（包括vCPU、内存和GPU）。同一实例规格在不同地域的价格可能有所差异，更多信息，请参见 云产品定价页。包年包月 按量付费 按量...
Kafka实时入湖
get_json_object(cast(value as string),'$.id')as id,get_json_object(cast(value as string),'$.eventType')as eventType,get_json_object(cast(value as string),'$.bizCode')as bizCode 过滤ID字段值大于1000的数据。通过一个filter算...
数据开发
独享数据集成资源组的计费说明请参见 独享数据集成资源组计费说明：包年包月。说明 本教程将使用 华东2（上海）地域 的独享数据集成资源组进行示例演示，需注意独享数据集成资源组不支持跨地域操作。配置独享数据集成资源组。登录 ...
Trajectory常见问题
基于单点更新轨迹 With point_traj as(select ST_MakeTrajectory('STPOINT':leaftype,x,y,4326,t,ARRAY['speed'],NULL,s,NULL)AS traj FROM(select array_agg(x order by id)as x,array_agg(y order by id)as y,array_agg(t order by id)as...
使用实时物化视图加速带可变参数的查询
disc_price,sum(l_extendedprice*(1-l_discount)*(1+l_tax))as sum_charge,count(*)as count_order,sum(l_extendedprice)as sum_price,sum(l_discount)as sum_disc,count(l_quantity)as count_qty,count(l_extendedprice)as count_price,...
CREATE MATERIALIZED VIEW
计费规则 物化视图费用包含如下两部分：存储费用 物化视图会占用物理存储空间，会产生存储费用。当MaxCompute项目的规格类型为包年包月标准版或按量计费标准版时，存储费用按量计费。更多计费信息，请参见 存储费用。当MaxCompute项目的...
日志分析
rows)as"平均影响行数",CASE WHEN length(sql)>200 THEN concat(substr(sql,1,200),'.')ELSE trim(lpad(sql,200,' '))end as"样例SQL"FROM(SELECT sql_code,count(1)as execute_times,sum(response_time)as total_time,avg(response_time)...
IP函数
查询和分析语句*|SELECT AVG(request_time)AS avg_request_time,MAX(request_time)AS max_request_time,MAX_BY(requestId,request_time)AS requestId,ip_to_city(client_ip)AS city GROUP BY city 查询和分析结果 ip_to_city_geo函数 ip_to...
- 产品推荐
- 这些文档可能帮助您