函数总览

dt_WE dt_add 函数中传递给 weekday 参数的值，用于表示特定星期三的偏移量。dt_TH dt_add 函数中传递给 weekday 参数的值，用于表示特定星期四的偏移量。dt_FR dt_add 函数中传递给 weekday 参数的值，用于表示特定星期五的偏移量。dt_SA ...

ST_{2D|2DT|3D|3DT}Intersects_IndexLeft

语法 bool ST_{2D|2DT|3D|3DT}Intersects_IndexLeft(trajectory traj1,trajectory traj2,timestamp ts,timestamp te);参数 参数名称 描述 traj1 需要判断的轨迹对象，或者产生子轨迹的原始轨迹。traj2 需要判断的轨迹对象，或者产生子轨迹...

ST_{2D|2DT|3D|3DT}Intersects_IndexLeft

语法 bool ST_{2D|2DT|3D|3DT}Intersects_IndexLeft(trajectory traj1,trajectory traj2,timestamp ts,timestamp te);参数 参数名称 描述 traj1 需要判断的轨迹对象，或者产生子轨迹的原始轨迹。traj2 需要判断的轨迹对象，或者产生子轨迹...

ST_{T|2D|2DT|3D|3DT}Contains

bool ST_{2D|2DT|3D|3DT}Contains(boxndf box,trajectory traj,timestamp ts,timestamp te);参数 参数名称 描述 geom 需要判断的几何对象。traj 需要判断的轨迹对象，或者产生子轨迹的原始轨迹。box 需要判断的外包框对象。r 需要判读的...

Java SDK使用说明

List<Integer>getIntVals(String outputName)功能：如果输出Tensor的DataType为DT_INT32、DT_UINT8、DT_INT16、DT_INT8、DT_QINT8、DT_QUINT8、DT_QINT32、DT_QINT16、DT_QUINT16或DT_UINT16，则调用该接口获取指定输出Tensor的 data。...

向量动态量化

更多参考 数据集 量化策略 索引比 召回比 QPS比 Cohere 10M 768 Cosine DT_VECTOR_INT8 33%95.28%170%GIST 1M 960 L2 DT_VECTOR_INT8 35%99.54%134%OpenAI 5M 1536 Cosine DT_VECTOR_INT8 34%67.34%189%Deep1B 10M 96 Cosine DT_VECTOR_INT...

使用SQL访问HBase表

创建名为dt，family名为f1的HBase示例表 try(Admin admin=connection.getAdmin()){ Table table=connection.getTable(TableName.valueOf("dt"));HTableDescriptor htd=new HTableDescriptor(TableName.valueOf("dt"));htd.addFamily(new ...

使用SQL访问HBase表

创建名为dt，family名为f1的HBase示例表 try(Admin admin=connection.getAdmin()){ Table table=connection.getTable(TableName.valueOf("dt"));HTableDescriptor htd=new HTableDescriptor(TableName.valueOf("dt"));htd.addFamily(new ...

ST_{T|2D|2DT|3D|3DT}Contains

bool ST_{2D|2DT|3D|3DT}Contains(boxndf box,trajectory traj,timestamp ts,timestamp te);参数 参数名称 描述 geom 需要判断的几何对象。traj 需要判断的轨迹对象，或者产生子轨迹的原始轨迹。box 需要判断的外包框对象。r 需要判读的...

ST_{T|2D|2DT|3D|3DT}Contains

bool ST_{2D|2DT|3D|3DT}Contains(boxndf box,trajectory traj,timestamp ts,timestamp te);参数 参数名称 描述 geom 需要判断的几何对象。traj 需要判断的轨迹对象，或者产生子轨迹的原始轨迹。box 需要判断的外包框对象。r 需要判读的...

ST_{T|2D|2DT|3D|3DT}Contains

bool ST_{2D|2DT|3D|3DT}Contains(boxndf box,trajectory traj,timestamp ts,timestamp te);参数 参数名称 描述 geom 需要判断的几何对象。traj 需要判断的轨迹对象，或者产生子轨迹的原始轨迹。box 需要判断的外包框对象。r 需要判读的...

EasyRec Processor（推荐打分服务）

EAS 内置的EasyRec Processor支持将EasyRec或TensorFlow训练的推荐模型部署为打分服务，并具备集成特征工程的能力。通过联合优化特征工程和TensorFlow模型，EasyRec Processor能够实现高性能的打分服务。本文为您介绍如何部署及调用EasyRec...

包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT a/>/b AS OpZ,a#>#b AS OpT,a@>b AS Op2D,a@>b ...

DescribeAntChainTransactionStatisticsV2

Dt Long 1609171200000 时间 CreatTime Long 1609258222000 创建时间 LastSumBlockHeight Long 11511 最后统计的区块高度 TransCount Long 4 交易总量 AntChainId String 8bd720bde18c4b37b0f4a1c7834db163 区块链ID 示例 请求示例 http(s)...

包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT a/>/b AS OpZ,a#>#b AS OpT,a@>b AS Op2D,a@>b ...

包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT a/>/b AS OpZ,a#>#b AS OpT,a@>b AS Op2D,a@>b ...

被包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT b/,b#,b,b,b<#@ a AS Op2DT,b</#@ a AS Op3DT from ...

加工引擎启动错误

错误示例 e_set("time1","2019-06-03 2:41:26")e_set("time2",dt_totimestamp(v("time1")))#正确示例 e_set("time1","2019-06-03 2:41:26")e_set("time2",dt_totimestamp(dt_parse(v("time1"))))#正确示例 e_set("time1","2019-06-03 2:41:...

包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT a/>/b AS OpZ,a#>#b AS OpT,a@>b AS Op2D,a@>b ...

高级配置：模型服务预热

req=TFRequest('serving_default')req.add_feed('sentence1',[200,15],TFRequest.DT_INT32,[1]*200*15)req.add_feed('sentence2',[200,15],TFRequest.DT_INT32,[1]*200*15)req.add_feed('y',[200,2],TFRequest.DT_INT32,[2]*200*2)req.add_...

被包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT b/,b#,b,b,b<#@ a AS Op2DT,b</#@ a AS Op3DT from ...

被包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT b/,b#,b,b,b<#@ a AS Op2DT,b</#@ a AS Op3DT from ...

RDS迁移至MaxCompute实现动态分区

执行动态分区SQL，按照临时表的字段dt自动分区，dt字段中相同的数据值，会按照这个数据值自动创建一个分区值。例如dt中有些数据是20181025，会自动在ODPS分区表中创建一个分区，dt=20181025。动态分区SQL如下。可以注意到SQL中select的字段...

指定索引类型

CREATE INDEX idx_2dt ON trajectory_table USING GiST(traj trajgist_2dt);删除索引。DROP INDEX idx_2dt;设置多外包框切分方法，以每条轨迹固定切分为4个外包框为例。SET ganos.trajectory.index_split_config='{"cut_point.even_divide...

被包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT b/,b#,b,b,b<#@ a AS Op2DT,b</#@ a AS Op3DT from ...

指定索引类型

CREATE INDEX idx_2dt ON trajectory_table USING GiST(traj trajgist_2dt);删除索引。DROP INDEX idx_2dt;设置多外包框切分方法，以每条轨迹固定切分为4个外包框为例。SET ganos.trajectory.index_split_config='{"cut_point.even_divide...

DescribeAntChainLatestTransactionV2

Message String OK 请求消息 ResultCode String OK 结果码 Result Array of Result 请求结果 Dt Long 1609171200000 时间 CreatTime Long 1609171200000 创建时间 LastSumBlockHeight Long 11511 最后统计的区块高度 Alias String 8bd720...

指定索引类型

CREATE INDEX idx_2dt ON trajectory_table USING GiST(traj trajgist_2dt);删除索引。DROP INDEX idx_2dt;设置多外包框切分方法，以每条轨迹固定切分为4个外包框为例。SET ganos.trajectory.index_split_config='{"cut_point.even_divide...

DescribeAccountAuthority-查看账号权限

test 示例 正常返回示例 JSON 格式 {"DdlAuthority":true,"DmlAuthority":"all","RequestId":"F5178C10-1407-4987-9133-DE4DC9119F75","TotalDatabases":["db1,db2"],"TotalDictionaries":["dt1,dt2"],"AllowDictionaries":["dt1"],...

UPSERT

示例 单次写入 UPSERT INTO dt(p1,p2,c1,c2)VALUES(10,20,30,40);UPSERT INTO dt(p1,p2,c2)VALUES(10,20,40);仅写入一行的部分列 UPSERT INTO dt(p1,p2,c1)VALUES(10,20,30);再写入同一行的其他列 批量写入 UPSERT INTO dt(p1,p2,c1,c2)...

新增附加列

dt_fromtimestamp_millis(1626837629123,'GMT+08')DATETIME转UTC时间戳（秒）dt_parsetimestamp(value,[timezone])value:DATETIME timezone：时区，可选参数 整数 dt_parsetimestamp(`datetime_col`)dt_parsetimestamp(`datetime_col`,'GMT...

相交类算子

示例 WITH box AS(SELECT ST_MakeBox3d(0,0,0,5,5,5)a,ST_MakeBox3dt(6,6,3,'2010-04-12 00:00:00',8,8,5,'2013-02-01 00:00:00')b)SELECT a/b AS OpZ,a#b AS OpT,a&b AS Op2D,a&b AS Op3d,a&b AS Op2DT,a&b AS Op3DT from box;opz|opt|op2...

相交类算子

示例 WITH box AS(SELECT ST_MakeBox3d(0,0,0,5,5,5)a,ST_MakeBox3dt(6,6,3,'2010-04-12 00:00:00',8,8,5,'2013-02-01 00:00:00')b)SELECT a/b AS OpZ,a#b AS OpT,a&b AS Op2D,a&b AS Op3d,a&b AS Op2DT,a&b AS Op3DT from box;opz|opt|op2...

加工数据

INSERT OVERWRITE TABLE dw_user_info_all_d PARTITION(dt='${bizdate}')SELECT COALESCE(a.uid,b.uid)AS uid,b.gender,b.age_range,b.zodiac,a.region,a.device,a.identity,a.method,a.url,a.referer,a.`time` FROM(SELECT*FROM ods_log_...

GisT索引

operator_family：指定索引所使用的算子族，可以省略，默认值为 trajgist_ops_3dt。说明 建立索引后，可以加速各类算子以及ST_ndIntersect、ST_ndDWithin、ST_ndContains、ST_ndWithin函数的查询。支持算子族 当前支持6个索引的算子族，...

相交类算子

示例 WITH box AS(SELECT ST_MakeBox3d(0,0,0,5,5,5)a,ST_MakeBox3dt(6,6,3,'2010-04-12 00:00:00',8,8,5,'2013-02-01 00:00:00')b)SELECT a/b AS OpZ,a#b AS OpT,a&b AS Op2D,a&b AS Op3d,a&b AS Op2DT,a&b AS Op3DT from box;opz|opt|op2...

相交类算子

示例 WITH box AS(SELECT ST_MakeBox3d(0,0,0,5,5,5)a,ST_MakeBox3dt(6,6,3,'2010-04-12 00:00:00',8,8,5,'2013-02-01 00:00:00')b)SELECT a/b AS OpZ,a#b AS OpT,a&b AS Op2D,a&b AS Op3d,a&b AS Op2DT,a&b AS Op3DT from box;opz|opt|op2...

PyODPS查看一级分区

insert overwrite table user_detail partition(dt,region)select userid,job,education,dt,region from user_detail_ods;单击 运行，将数据插入到分区表 user_detail 中。使用PyODPS查看一级分区。登录 DataWorks控制台。在左侧导航栏，...

DELETE

DELETE FROM delete_test AS dt WHERE dt.b is null;DELETE FROM delete_test AS dt WHERE dt.b='';更多关于DELETE的详情，请参见 PostgreSQL DELETE。常见问题 在执行DELETE命令时，为什么监控指标中存储用量上涨非常多，写入完成后存储...

DROP TABLE

删除表。使用说明 Lindorm宽表引擎版本为2.2.16至2.4.1时，需要先手动执行 OFFLINE TABLE，才能执行DROP TABLE。OFFLINE TABLE的用法，请参见 OFFLINE TABLE。...DROP TABLE dt;DROP TABLE IF EXISTS dt;DROP TABLE my_schema.dt;
共有14条 < 1 2 3 4 ... 14 >
跳转至： GO
产品推荐
云服务器 安全管家服务 安全中心
这些文档可能帮助您
弹性公网IP 短信服务 人工智能平台 PAI 金融分布式架构 对象存储 物联网平台

新品推荐

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