专线备份

说明 软件版本为1.0系列版本的SAG-1000设备没有单独的用于接入专线的端口，请勿在智能接入网关Web管理控制台配置BGP路由时将端口的对端AS配置为高速通道的AS号（对端AS代表用于接入专线的端口的接口属性），如果您进行了配置，那么您的智能...

几何模型

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

分析网站日志

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

查询与分析语句

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

Demo App《软件许可协议》

软件许可协议 在接受本协议之前，请您仔细阅读本协议的全部内容（特别是以粗体及/或下划线标注的内容）。如果您对本协议的条款有疑问的，请通过阿里云相关业务部门进行询问，阿里云将向您解释条款内容。如果您不同意本协议的任意内容，或者...

几何模型

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

几何模型

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

几何模型

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

常用操作及兼容性说明

GO 表操作 新建表 USE testdb GO CREATE TABLE dbo.tb_test(id int not null IDENTITY(1,1)PRIMARY KEY,name varchar(50))GO 查询表 SELECT sche.name AS schema_name,tb.name AS table_name FROM sys.tables AS tb INNER JOIN sys.schemas...

什么是FPGA云服务器

FPGA云服务器平台FaaS（FPGA as a Service）在云端提供统一硬件平台与中间件，可大大降低加速器的开发与部署成本。您无需了解底层硬件即可快速开发和部署自己的定制加速器，也可以直接使用加速器提供商提供的加速服务。FaaS包括三个组件：...

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

快速拉起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 '...

如何在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...

快速拉起向量召回服务

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

逻辑回归二分类

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

性能白皮书（Nexmark性能测试）

说明 Nexmark 和 Git 属于第三方网站，访问时可能出现延迟或无法访问的情况。测试工具 Nexmark源表：基于Nexmark源表按照测试TPS要求生成测试数据。Transformations：Nexmark的19个Queries。Blackhole结果表：排除上下游存储的性能影响，...

使用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)点...

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

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

快速拉起基于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 '...

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

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

逻辑回归多分类

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

测试方法

关于如何生成TPC-H测试数据，具体请参考 TPC-H官方文档。TPC-H测试数据生成后，需要分别转换成Parquet和ORC格式，上传到OSS。分别在开源Presto和DLA Presto中建表。示例如下：对于开源Presto集群，可以在presto中建表（需要修改配置，默认...

RDS SQL Server CPU使用率高问题排查

.[wait_type])AS[WaitType],CAST(MAX([W1].[WaitS])AS DECIMAL(16,2))AS[Wait_S],CAST(MAX([W1].[ResourceS])AS DECIMAL(16,2))AS[Resource_S],CAST(MAX([W1].[SignalS])AS DECIMAL(16,2))AS[Signal_S],MAX([W1].[WaitCount])AS[WaitCount]...

As函数

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

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

使用EAIS推理TensorFlow模型

假设您的TensorFlow模型推理初始源代码如下所示：#导入tensorflow模块 import tensorflow as tf model_file="xxx.pb"with tf.gfile.FastGFile(model_file,'rb')as f:graph_def=tf.GraphDef()graph_def.ParseFromString(f.read())tf.import_...

标准化

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 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 ...
共有200条 < 1 2 3 4 ... 200 >
跳转至： GO
产品推荐
云服务器 安全管家服务 安全中心
这些文档可能帮助您
云数据库 RDS 智能接入网关 威胁情报服务 区块链服务 弹性公网IP 短信服务

新品推荐

新人特惠 爆款特惠 最新活动 免费试用
新人特惠 爆款特惠 最新活动 免费试用