外包框运算
每个矩形框包含的维度可能不同，有的矩形框只记录x、y维度信息，有些则可能记录x,y,z,t四个维度的信息。在查询时，可以利用轨迹或几何类型的外包矩形框来辅助查询。例如下图就是一条在x,y,t空间中的运动的轨迹和它对应的外包矩形框。在...
外包框运算
每个矩形框包含的维度可能不同，有的矩形框只记录x、y维度信息，有些则可能记录x,y,z,t四个维度的信息。在查询时，可以利用轨迹或几何类型的外包矩形框来辅助查询。例如下图就是一条在x,y,t空间中的运动的轨迹和它对应的外包矩形框。在...
pull_log_dump
from_time String 是 2021-06-01 18:00:00+8:00 开始时间，Unix时间戳格式或者“%Y-%m-%d%H:%M:%S”格式，例如“2018-01-02 12:12:10+8:00”。to_time String 是 2021-06-01 18:25:00+8:00 结束时间，Unix时间戳格式或者“%Y-%m-%d%H:%M:%S...
RecognizeRollTicket-增值税发票卷票识别
190,"y":800 },{"x":191,"y":818 },{"x":120,"y":821 }],"valueProb":100 },{"key":"totalAmount","keyProb":100,"value":"600.00","valuePos":[{"x":121,"y":785 },{"x":181,"y":783 },{"x":182,"y":796 },{"x":121,"y":799 }],"valueProb...
数据探索概览
name:h2o_feet time level description location water_level 2015-08-18T00:00:00Z between 6 and 9 feet coyote_creek 8.12 2015-08-18T00:00:00Z below 3 feet santa_monica 2.064 2015-08-18T00:06:00Z between 6 and 9 feet coyote_...
进阶功能
subtitle",align:"tr",x:15,y:12},{name:"setting",align:"tr",x:15,y:12},{name:"volume",align:"tr",x:15,y:10},{name:"snapshot",align:"tr",x:5,y:12},]}]H5模式下截图需要设置video的允许匿名跨域访问属性。示例如下：extraInfo:{ ...
Linux实例负载高问题排查和异常处理
Linux 5.10.134-13.al8.x86_64(iZ2zegjvrdtgifd77gadyqZ)03/09/2023_x86_64_(8 CPU)02:34:00 PM tps rtps wtps bread/s bwrtn/s 02:34:01 PM 6.00 0.00 6.00 0.00 80.00 02:34:02 PM 55.00 0.00 55.00 0.00 632.00 02:34:03 PM 1.00 0.00 1...
RecognizeNonTaxInvoice-非税收入发票识别
valueProb":100},{"key":"totalAmount","keyProb":100,"value":"600.00","valuePos":[{"x":1702,"y":1113},{"x":1702,"y":1163},{"x":1576,"y":1163},{"x":1576,"y":1113}],"valueProb":100},{"key":"additionalInfo","keyProb":100,...
RecognizeShoppingReceipt-购物小票识别
100,"value":"20:26:00","valuePos":[{"x":442,"y":648},{"x":553,"y":651},{"x":552,"y":679},{"x":441,"y":676}],"valueProb":100},{"key":"contactNumber","keyProb":100,"value":"","valueProb":100},{"key":"shopAddress","keyProb":...
ST_{X|Y|Z|T}Max
获取BoxNDF类型中指定维度的最大值。...st_tmax-2020-01-01 00:00:00 select ST_zmax(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmax-NaN select ST_tmax(ST_MakeBox2d(0,0,20,20));st_tmax-infinity
ST_{X|Y|Z|T}Max
获取BoxNDF类型中指定维度的最大值。...st_tmax-2020-01-01 00:00:00 select ST_zmin(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmin-NaN select ST_tmin(ST_MakeBox2d(0,0,20,20));st_tmin-infinity
双轴折线图
数据格式：数据的显示格式，仅对时间型的数据有效，请参照%Y/m/d%H:%M:%S 的格式进行配置。仅在 数据类型 为 时间型 时可配置。轴标签：x轴标签的样式，可单击 图标控制x轴轴标签的显隐。说明 数据格式与设置格式不统一会导致组件显示异常...
常见疑问点
startTime:10:00:00 endTime:18:00:00 step:1h query:count(up)调小step参数，例如我们将step参数设置为3分钟，以上述 InstantVectorSelector 场景为例，一定有多次“选点”能够选取原始的数据点。此方案是让“选取”流程变得更密集，以...
ST_{X|Y|Z|T}Max
获取BoxNDF类型中指定维度的最大值。...st_tmax-2020-01-01 00:00:00 select ST_zmin(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmin-NaN select ST_tmin(ST_MakeBox2d(0,0,20,20));st_tmin-infinity
分区剪枝
QUERY PLAN-Append(cost=0.00.34.09 rows=567 width=20)->Seq Scan on measurement_y2023q4(cost=0.00.31.25 rows=567 width=20)Filter:(logdate>='01-OCT-23 00:00:00':date)(3 rows)执行期初始剪枝 同样通过上文 measurement 表来了解...
进阶功能
subtitle",align:"tr",x:15,y:12},{name:"setting",align:"tr",x:15,y:12},{name:"volume",align:"tr",x:15,y:10},{name:"snapshot",align:"tr",x:5,y:12},]}]H5模式下截图需要设置video的允许匿名跨域访问属性。示例如下：extraInfo:{ ...
GetResourceConfigurationTimeline
DISCOVERED","CaptureTime":"1605316711000","ConfigurationDiff":"{\"ExpiredTime\":[\"2020-10-26T16:00Z\",\"2020-11-26T16:00Z\"]}","ResourceId":"i-bp19xem7lt97h973*","ResourceName":"ECS-test","Region":"cn-hangzhou",...
ST_{X|Y|Z|T}Max
获取BoxNDF类型中指定维度的最大值。...st_tmax-2020-01-01 00:00:00 select ST_zmin(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmin-NaN select ST_tmin(ST_MakeBox2d(0,0,20,20));st_tmin-infinity
ListIoTCloudConnectorGroups-查询实例组列表信息
iotccg-g00epppbi9di9y*IoTCloudConnectorGroupName array 否 实例组的名称。最多支持 20 个实例组的名称。string 否 实例组的名称。最多支持 20 个实例组的名称。名称长度为 2~128 个英文或中文字符，以大小写字母或中文开头，可包含数字...
分区剪枝
QUERY PLAN-Append(cost=0.00.34.09 rows=567 width=20)->Seq Scan on measurement_y2023q4(cost=0.00.31.25 rows=567 width=20)Filter:(logdate>='01-OCT-23 00:00:00':date)(3 rows)执行期初始剪枝 同样通过上文 measurement 表来了解...
分区剪枝
QUERY PLAN-Append(cost=0.00.34.09 rows=567 width=20)->Seq Scan on measurement_y2023q4(cost=0.00.31.25 rows=567 width=20)Filter:(logdate>='01-OCT-23 00:00:00':date)(3 rows)执 行期初 始剪枝 同样通过上文 measurement 表来了解...
RecognizeUsedCarInvoice-二手车统一销售发票识别
valuePos":[{"x":1601,"y":1587},{"x":1601,"y":1633},{"x":1138,"y":1638},{"x":1137,"y":1591}],"valueProb":100},{"key":"brandMode","keyProb":100,"value":"奥迪WAUYGB4H","valuePos":[{"x":2330,"y":1616},{"x":2330,"y":1677},{"x...
RecognizeVehicleCertification-车辆合格证识别
y":1073},{"x":1628,"y":1073},{"x":1628,"y":1032}],"valueProb":100},{"key":"tireSize","keyProb":100,"value":"12.00R2016PR","valuePos":[{"x":545,"y":1133},{"x":546,"y":1094},{"x":839,"y":1099},{"x":839,"y":1139}],"valueProb...
基本概念
盘前交易时间：美国东部时间上午4:00-9:30对应北京时间16:00-21:30 盘后交易时间：美国东部时间晚上16:00-20:00对应北京时间4:00-8:00 美股涨跌幅限制 美股采用的是无涨跌幅限制，同时实行熔断机制。美国证交所会对个股设置“限制价格波动...
自动化管理分区
DELIMITER|CREATE EVENT IF NOT EXISTS drop_partition ON SCHEDULE EVERY 1 DAY STARTS '2022-05-21 02:00:00' ON COMPLETION PRESERVE DO BEGIN set@pname=concat('alter table orders drop partition p',date_format(curdate(),'%Y%m%d'...
FindPrepublishesByVersionId
01-01 00:00:00 创建时间 GmtCreateTimestamp Long 1684530000000 创建时间戳 GmtModify String 2018-01-01 00:01:00 修改时间 GmtModifyTimestamp Long 1684530000000 修改时间戳 Id String 1 ID IsActive String Y 预发布是否为启用状态 ...
优化器（Analyze）
数值类型（TINYINT、SMALLINT、INT、BIGINT、DOUBLE、DECIMAL、NUMERIC）字符类型（STRING、VARCHAR、CHAR）二进制类型（BINARY）布尔类型（BOOLEAN）日期类型（TIMESTAMP、DATE、INTERVAL）复杂类型（MAP、STRUCT、ARRAY）min（最小值）Y ...
FindPrepublishesByParentId
预发布名 DeviceModelId String 12 设备型号ID IsTotalPrepublish String N 是否为总量预发布 BarrierCount String 1000 预发布允许设备数 IsActive String Y 预发布是否为启用状态 GmtCreate String 2018-01-01 00:00:00 创建时间 ...
ListIoTCloudConnectors-查询云连接器实例信息
test","IoTCloudConnectorDescription":"test","WildcardDomainEnabled":false,"CreateTime":0,"ModifyTime":0,"IoTCloudConnectorGroupId":"iotccg-g00epppbi9di9y*","Mode":"PassThrough","IpFeature":"192.168.0.1","Type":"Standard",...
基本折线图（v3.0及以上版本）
数据格式 数据的显示格式，仅对时间型的数据有效，请参照%Y/m/d%H:%M:%S 的格式进行配置。范围 x轴的最小值和最大值的范围值，仅对 数值型 和 时间型 的数据有效。最大值：x轴的最大值，支持自定义输入。默认为auto，系统会根据数据最大值...
Joining Relations Hints
QUERY PLAN-Hash Join(cost=86814.29.123103.29 rows=500000 width=20)Hash Cond:(h.aid=a.aid)->Hash Join(cost=21.45.15081.45 rows=500000 width=20)Hash Cond:(h.bid=b.bid)->Seq Scan on pgbench_history h(cost=0.00.8185.00 rows=...
Joining Relations Hints
QUERY PLAN-Hash Join(cost=86814.29.123103.29 rows=500000 width=20)Hash Cond:(h.aid=a.aid)->Hash Join(cost=21.45.15081.45 rows=500000 width=20)Hash Cond:(h.bid=b.bid)->Seq Scan on pgbench_history h(cost=0.00.8185.00 rows=...
SELECT语句
操作符 名称 说明 别名 是否支持 AND,&Y=Y BETWEEN AND Y COALESCE return the first non-null arg Y&Y~Y^Y CASE Y DIV Y/Y=Y<=>NULL-safe equal to Y>Y>=Y GREATEST Y LEAST Y IN Y NOT IN Y INVERVAL Y IS Y IS NOT Y IS NOT NULL Y IS ...
GetGatewayServiceDetail-查询网关服务详情
gw-2837hfd91h34dbg87364g*TrafficPolicy TrafficPolicy 流量策略。GmtCreate string 创建时间 1667460287386 GmtModified string 修改时间。1667460287386 示例 正常返回示例 JSON 格式 {"RequestId":"9802C54E-5CC5-5706-927B-993DBB6DCF...
通过JDBC协议分析日志
逻辑运算 and or not 例如 a="x"and b="y"或 a="x"and not b="y。全文搜索_line_="abc"如果使用全文索引搜索，需使用特殊的key（_line_）。计算语法 支持计算操作符。更多信息，请参见 分析语法。SQL92语法 过滤语法和计算语法组合成为SQL...
运行日志
00 00 00 00 00 00 00 00 00 00 00 00 0C|.zQ.[LK-030A]<00 1C 00 61 69 6F 74 5F 63 5F 64 65 6D 6F 2F 55|.aiot_c_demo/U[LK-030A]< 54 0900 03 85 68 BF 5F 86 68 BF 5F 75 78 0B 00|T.h._.h._ux.[LK-030A]< 01 04 A5 2C 1400 04 64 00 ...
常见问题
SELECT"water_level"FROM"h2o_feet"WHERE"location"='santa_monica' AND time>='2015-08-18T00:00:00Z' AND time<='2015-08-18T00:12:00Z' name:h2o_feet time water_level-2015-08-18T00:00:00Z2.064 2015-08-18T00:06:00Z2.116 2015-08-...
时区子句
示例 返回芝加哥时区的UTC偏移量>SELECT"water_level"FROM"h2o_feet"WHERE"location"='santa_monica' AND time>='2015-08-18T00:00:00Z' AND time<= '2015-08-18T00:18:00Z' tz('America/Chicago')name:h2o_feet time water_level-2015-08-...
RecognizeBusShipTicket-客运车船票识别
[{"x":205,"y":306},{"x":205,"y":273},{"x":326,"y":276},{"x":325,"y":308}],"valueProb":100},{"key":"totalAmount","keyProb":100,"value":"56.00","valuePos":[{"x":402,"y":278},{"x":402,"y":306},{"x":366,"y":306},{"x":366,"y":...
变量
H的返回值为[0,23]，HH的返回值为[00,23]。h表示上午、下午的第N个小时，1表示0点，h的返回值为[1,12]，hh的返回值为[01,12]。K表示上午、下午的第N个小时，0表示0点，K的返回值为[0,11]，KK的返回值为[00,11]。k表示当天的第N个小时，1...
- 产品推荐
- 这些文档可能帮助您