使用CloudLens for SLS分析资源用量

t1.BillingItem as BillingItem,t1.Usage as Usage,t2."费用"as"费用(元)",t2."同比上月"as"同比上月(%)",t3."存储空间"as"存储空间"FROM t1 left join t2 on t1.InstanceID=t2.InstanceID left join t3 on t1.InstanceID=t3....

使用SQL语句自定义分析账单

查询和分析语句 source:bill|SELECT diff[1]AS"本月费用",diff[2]AS"上月费用",diff[3]*100-100 as"同比增加%"FROM(SELECT compare(amount,604800)as diff FROM(SELECT sum(PretaxAmount)AS amount FROM log))查询和分析结果 例如:按照...

使用新版成本管家

SELECT diff[1]AS"本月费用",diff[2]AS"上月费用",diff[3]*100-100 as"同比增加%"FROM(SELECT compare(amount,604800)as diff FROM(SELECT sum(PretaxAmount)AS amount FROM instance_bill))查询和分析结果 示例4:分析产品计费项信息 ...

查询与分析语句

SELECT user_id,host AS"域名",Rate_200 AS"200比例",Rate_302 AS"302比例",Rate_404 AS"404比例",Rate_405 AS"405比例",Rate_444 AS"444比例",Rate_499 AS"499比例",Rate_500 AS"500比例",Rate_502 AS"502比例",Rate_503 AS"503比例",Rate...

查询与分析语句

SELECT user_id,host AS"域名",Rate_200 AS"200比例",Rate_302 AS"302比例",Rate_404 AS"404比例",Rate_405 AS"405比例",Rate_444 AS"444比例",Rate_499 AS"499比例",Rate_500 AS"500比例",Rate_502 AS"502比例",Rate_503 AS"503比例",Rate...

特征编码

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

快速拉起X2I召回服务

id,'10007' AS item_id,1639756800 AS time UNION-20211218 SELECT 'u0003' AS user_id,'10008' AS item_id,1639670400 AS time UNION-20211217 SELECT 'u0003' AS user_id,'10009' AS item_id,1639584000 AS time UNION-20211216 SELECT '...

Modularity

id,'3' as group_out_id,'4' as flow_in_id,'3' as group_in_id union all select '3' as flow_out_id,'3' as group_out_id,'4' as flow_in_id,'3' as group_in_id union all select '4' as flow_out_id,'3' as group_out_id,'6' as flow_...

容器服务

eventId.reason:DeleteLoadBalancerFailed|SELECT ARRAY_AGG("eventId.message")as message,"eventId.metadata.namespace"as namespace,"eventId.involvedObject.kind"as kind,"eventId.involvedObject.name"as object_name,COUNT(*)as cnt...

快速拉起多路召回服务

id,'10007' AS item_id,1639756800 AS time UNION-20211218 SELECT 'u0003' AS user_id,'10008' AS item_id,1639670400 AS time UNION-20211217 SELECT 'u0003' AS user_id,'10009' AS item_id,1639584000 AS time UNION-20211216 SELECT '...

快速拉起向量召回服务

id,'10007' AS item_id,1639756800 AS time UNION-20211218 SELECT 'u0003' AS user_id,'10008' AS item_id,1639670400 AS time UNION-20211217 SELECT 'u0003' AS user_id,'10009' AS item_id,1639584000 AS time UNION-20211216 SELECT '...

如何在SLS设置SQL语句查询操作审计的事件

event.eventId"as eventId,"event.eventName"as eventName,"event.eventRW"as eventRW,"event.eventSource"as eventSource,from_unixtime(_time_)as eventTime,"event.eventType"as eventType,"event.eventVersion"as eventVersion,"event...

逻辑回归二分类

cast(0 as double)as f1,cast(0 as double)as f2,cast(1 as double)as f3,cast(1 as bigint)as label from dual union all select cast(1 as double)as f0,cast(0 as double)as f1,cast(0 as double)as f2,cast(0 as double)as f3,cast(0 ...

标签传播聚类

in_id,0.7 as edge_weight union all select '5' as flow_out_id,'8' as flow_in_id,0.7 as edge_weight union all select '6' as flow_out_id,'7' as flow_in_id,0.6 as edge_weight union all select '6' as flow_out_id,'8' as flow_in_...

GBDT回归

cast(0 as double)as f1,cast(0 as double)as f2,cast(1 as double)as f3,cast(1 as bigint)as label from dual union all select cast(1 as double)as f0,cast(0 as double)as f1,cast(0 as double)as f2,cast(0 as double)as f3,cast(0 ...

快速拉起基于PAI的X2I召回服务

id,'10007' AS item_id,1639756800 AS time UNION-20211218 SELECT 'u0003' AS user_id,'10008' AS item_id,1639670400 AS time UNION-20211217 SELECT 'u0003' AS user_id,'10009' AS item_id,1639584000 AS time UNION-20211216 SELECT '...

GBDT二分类

cast(0 as double)as f1,cast(0 as double)as f2,cast(1 as double)as f3,cast(1 as bigint)as label from dual union all select cast(1 as double)as f0,cast(0 as double)as f1,cast(0 as double)as f2,cast(0 as double)as f3,cast(0 ...

TPC-DS测试集

date between(cast('2000-05-19' as date)-30 days)and(cast('2000-05-19' as date)+30 days)(cast('1999-4-01' as date)+60 days)(cast('1999-5-01' as date)+60 days)and d_date between cast('2001-06-09' as date)and(cast('2001-06-09...

使用行为过滤表实现曝光过滤功能

id,'10007' AS item_id,1639756800 AS time UNION-20211218 SELECT 'u0003' AS user_id,'10008' AS item_id,1639670400 AS time UNION-20211217 SELECT 'u0003' AS user_id,'10009' AS item_id,1639584000 AS time UNION-20211216 SELECT '...

操作审计

topic_:actiontrail_audit_event and event.serviceName:Cloudfw and event.eventName:PutDisableFwSwitch|SELECT account_id,ram_user_id,resourceArray[num]as asset_ip,arbitrary(user_type)as user_type,arbitrary(user_name)as user_...

类型转换

5.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 true as f0,4.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 true as...

性能测试指南

MKTSEGMENT AS C_MKTSEGMENT,s.S_NAME AS S_NAME,s.S_ADDRESS AS S_ADDRESS,s.S_CITY AS S_CITY,s.S_NATION AS S_NATION,s.S_REGION AS S_REGION,s.S_PHONE AS S_PHONE,p.P_NAME AS P_NAME,p.P_MFGR AS P_MFGR,p.P_CATEGORY AS P_CATEGORY,...

逻辑回归多分类

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

As函数

As是将请求的结果以别名方式命名。示例 select count(*)as countRow from test;select c1 as testC from test where c1='2';

MaxCompute账单用量明细分析

按照 存储费用计费规则,小于等于512 MB数据收取1分。如果这份数据只用于测试,您可以通过以下方式解决此问题。仅表数据不再使用,请执行 Drop Table 语句删除Project下的表数据。Project不再使用,请通过MaxCompute控制台的 项目管理 ...

UDF(地理空间)

CREATE FUNCTION ST_Aggr_Intersection AS 'com.esri.hadoop.hive.ST_Aggr_Intersection' USING 'spatial-sdk-hive.jar,esri-geometry-api.jar';CREATE FUNCTION ST_Aggr_Union AS '...

边聚类系数

'5' as flow_in_id union all select '3' as flow_out_id,'4' as flow_in_id union all select '4' as flow_out_id,'5' as flow_in_id union all select '4' as flow_out_id,'8' as flow_in_id union all select '5' as flow_out_id,'6' as...

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

归一化

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

支持的示例查询模板

SELECT a.resource_type AS resource_type_disk,b.resource_type AS resource_type_instance,a.resource_id AS disk_id,a.region_id AS instance_region_id,b.resource_id AS instance_id,b.region_id AS disk_region_id FROM resources a ...

标准化

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

使用Copilot+增强分析实现一站式智能数据查询与可视化

time,12)AS BIGINT)点-15点' WHEN CAST(SUBSTR(behavior_time,12)AS BIGINT)>=15 AND CAST(SUBSTR(behavior_time,12)AS BIGINT)点-18点' WHEN CAST(SUBSTR(behavior_time,12)AS BIGINT)>=18 AND CAST(SUBSTR(behavior_time,12)AS BIGINT)点...

Dataphin即席查询报错“Metering data exceed max ...

'1,0')AS TINY_URL,SMS_SIGN AS SMS_SIGN,JOIN_ID AS JOIN_ID,MOBILE_SHA256 AS MOBILE_SHA256,RECIEVE_STATUS AS RECIEVE_STATUS,TEMPLATE_CODE AS TEMPLATE_CODE,RCD_TIME AS RCD_TIME,CRT_DATE AS CRT_DATE,RECEIVED_PROVIDER AS ...

树深度

create table TreeDepth_func_test_edge as select*from(select '0' as flow_out_id,'1' as flow_in_id union all select '0' as flow_out_id,'2' as flow_in_id union all select '1' as flow_out_id,'3' as flow_in_id union all select ...

计数三角形

create table TriangleCount_func_test_edge as select*from(select '1' as flow_out_id,'2' as flow_in_id union all select '1' as flow_out_id,'3' as flow_in_id union all select '1' as flow_out_id,'4' as flow_in_id union all ...

单源最短路径

out_id,"d"as flow_in_id,1.0 as edge_weight union all select"b"as flow_out_id,"e"as flow_in_id,2.0 as edge_weight union all select"e"as flow_out_id,"d"as flow_in_id,1.0 as edge_weight union all select"c"as flow_out_id,"e"as...

CREATE TABLE AS

语法 CREATE[GLOBAL TEMPORARY]TABLE table_name[(column_name[,.])][ON COMMIT { PRESERVE ROWS|DELETE ROWS }][TABLESPACE tablespace]AS query 说明 CREATE TABLE AS 创建一个表,并使用 SELECT 命令计算的数据填充该表。表列具有与 ...

线性回归

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

CTE(2.0版)

WITH子句中定义的关系可以互相连接:WITH x AS(SELECT a FROM t),y AS(SELECT a AS b FROM x),z AS(SELECT b AS c FROM y)SELECT c FROM z;CTE后面必须直接跟使用CTE的SQL语句(如SELECT、INSERT、UPDATE等),否则CTE将失效。CTE后面也...

CAST函数

返回结果如下:+-+|CAST(5 AS BOOLEAN)|+-+|1|+-+CAST AS DECIMAL(m,d)|FLOAT|INT|INTEGER|SMALLINT|TINYINT CAST(expr AS[DECIMAL(m,d)|FLOAT|INT|INTEGER|SMALLINT|TINYINT])命令说明 将 expr 转换为DECIMAL(m,d)、FLOAT、INT、INTEGER、...
共有200条 < 1 2 3 4 ... 200 >
跳转至: GO
产品推荐
云服务器 安全管家服务 安全中心
这些文档可能帮助您
应用身份服务 (IDaaS) 区块链服务 资源编排 弹性公网IP 短信服务 人工智能平台 PAI
新人特惠 爆款特惠 最新活动 免费试用