HY00-HY00文档介绍内容-阿里云

MySQL提示：ERROR 202(HY000):Too many nested sub-...

MySQL提示：ERROR 202(<em>HY</em>000):Too many nested sub-...

问题现象在RDS MySQL实例中执行命令进行查询时，提示如下错误：ERROR 202(HY000):Too many nested sub-expressions in a full-text search 可能原因 MySQL 5.7.32在修复一个bug时，将full-text search中的嵌套子查询数限制到了31个，超过...

MySQL提示：ERROR 202(HY000):Too many nested sub-...

问题现象在RDS MySQL实例中执行命令进行查询时，提示如下错误：ERROR 202(HY000):Too many nested sub-expressions in a full-text search 可能原因 MySQL 5.7.32在修复一个bug时，将full-text search中的嵌套子查询数限制到了31个，超过...

Dataphin集成任务报错“ERROR 1105(HY000):other ...

问题描述用户在使用集成任务，从TiDB同步数据到其他数据库时，报错“ERROR 1105(HY000):other error:[src/coprocessor/dag/[mod.rs:143](http://mod.rs:143/)]:IoError(Custom { kind:Other,error:"given slice is too small to serialize...

提示“ERROR 2003(HY000):Can't connect to MySQL ...

本文介绍远程连接Linux系统的ECS实例中的MySQL失败，提示“ERROR 2003(HY000):Can't connect to MySQL server on '39.106.*.*'(110)”错误的解决方案。问题现象用户远程连接Linux系统的ECS实例中的MySQL时失败，提示“ERROR 2003(HY000):...

ModifyTenantResource-修改租户资源

EE205C00-30E4-*-*-87E3A8A2AA0C 示例正常返回示例 JSON 格式 {"TenantId":"t33h8y08k*","RequestId":"EE205C00-30E4-*-*-87E3A8A2AA0C"} 错误码 HTTP status code 错误码错误信息描述 500 InternalError The request processing has ...

ModifyTenantUserStatus-锁定或解锁指定的数据库账号

t33h8y08k*示例正常返回示例 JSON 格式 {"RequestId":"EE205C00-30E4-XXXX-XXXX-87E3A8A2AA0C","TenantUser":[{"UserStatus":"LOCKED","UserName":"pay_test","TenantId":"t33h8y08k*"}]} 错误码 HTTP status code 错误码错误信息描述 ...

ModifyDatabaseUserRoles-修改数据库用户角色

EE205C00-30E4-XXXX-XXXX-87E3A8A2AA0C 示例正常返回示例 JSON 格式 {"TenantUser":{"DatabaseName":"sms_pre","Users":[{"Role":"ReadOnly","UserName":"user_pay_ro"}],"TenantId":"t33h8y08k*"},"RequestId":"EE205C00-30E4-XXXX-XXXX-...

格式符（2.0版）

1-9 digits for parsing:0.999999999)%H Hour(00.23)%h Hour(01.12)%I Hour(01.12)%i Minutes,numeric(00.59)%j Day of year(001.366)%k Hour(0.23)%l Hour(1.12)%M Month name(January.December)%m Month,numeric(00.12)%p AM or PM%r ...

CreateTenant-创建租户

EE205C00-30E4-XXXX-XXXX-87E3A8A2AA0C 示例正常返回示例 JSON 格式 {"TenantId":"t33h8y08k*","RequestId":"EE205C00-30E4-XXXX-XXXX-87E3A8A2AA0C"} 错误码 HTTP status code 错误码错误信息描述 500 InternalError The request ...

时间解析

d-%b-%y%H:%M:%S RFC850 Mon,02 Jan 2006 15:04:05 MST%A,%d%b%Y%H:%M:%S RFC1123 2006-01-02T15:04:05Z07:00%Y-%m-%dT%H:%M:%S RFC3339 2006-01-02T15:04:05.999999999Z07:00%Y-%m-%dT%H:%M:%S RFC3339Nano 1637843406%s 自定义 ...

时间格式

M RFC822Z Monday,02-Jan-06 15:04:05 MST%A,%d-%b-%y%H:%M:%S RFC850 Mon,02 Jan 2006 15:04:05 MST%A,%d%b%Y%H:%M:%S RFC1123 2006-01-02T15:04:05Z07:00%Y-%m-%dT%H:%M:%S RFC3339 2006-01-02T15:04:05.999999999Z07:00%Y-%m-%dT%H:%M:...

散点图（v3.x版本）

[{"x":"2010/02/01 00:00:00","y":"175","s":"1"},{"x":"2010/02/10 00:00:00","y":"200","s":"1"},{"x":"2010/03/01 00:00:00","y":"125","s":"1"},{"x":"2010/03/20 00:00:00","y":"190","s":"1"},{"x":"2010/04/01 00:00:00","y":"190",...

散点图（v3.0以下版本）

[{"x":"2010/02/01 00:00:00","y":"175","s":"1"},{"x":"2010/02/10 00:00:00","y":"200","s":"1"},{"x":"2010/03/01 00:00:00","y":"125","s":"1"},{"x":"2010/03/20 00:00:00","y":"190","s":"1"},{"x":"2010/04/01 00:00:00","y":"190",...

配置自定义区域右下角组件数据

{"x":"2010/01/01 00:00:00","y":500,"s":"新增确诊"},{"x":"2010/01/01 00:00:00","y":180,"s":"新增疑似"},{"x":"2010/02/01 00:00:00","y":600,"s":"新增确诊"},{"x":"2010/02/01 00:00:00","y":700,"s":"新增疑似"} 在设置数据源页面...

气泡图（v3.x版本）

2010/05/01 00:00:00","y":"170","r":"20","s":"1"},{"x":"2010/01/15 00:00:00","y":"180","r":"16","s":"2"},{"x":"2010/02/15 00:00:00","y":"390","r":"10","s":"2"},{"x":"2010/03/15 00:00:00","y":"355","r":"15","s":"2"},{"x":...

配置自定义区域右下角组件数据

{"x":"2010/01/01 00:00:00","y":500,"s":"新增确诊"},{"x":"2010/01/01 00:00:00","y":180,"s":"新增疑似"},{"x":"2010/02/01 00:00:00","y":600,"s":"新增确诊"},{"x":"2010/02/01 00:00:00","y":700,"s":"新增疑似"} 在设置数据源页面...

区域翻牌器（v3.0以下版本）

[{"x":"2010/01/01 00:00:00","y":375,"s":"1"},{"x":"2010/01/01 00:00:00","y":180,"s":"2"},{"x":"2010/02/01 00:00:00","y":200,"s":"1"},{"x":"2010/02/01 00:00:00","y":100,"s":"2"},{"x":"2010/03/01 00:00:00","y":25,"s":"1"},{...

基本折线图（v3.0以下版本）

[{"x":"2010/01/01 00:00:00","y":375,"s":"1"},{"x":"2010/01/01 00:00:00","y":180,"s":"2"},{"x":"2010/02/01 00:00:00","y":200,"s":"1"},{"x":"2010/02/01 00:00:00","y":100,"s":"2"},{"x":"2010/03/01 00:00:00","y":25,"s":"1"},{...

气泡图（v4.x版本）

[{"x":"2010/01/01 00:00:00","y":"360","r":"10","s":"系列1"},{"x":"2010/02/01 00:00:00","y":"230","r":"20","s":"系列1"},{"x":"2010/03/01 00:00:00","y":"325","r":"25","s":"系列1"},{"x":"2010/04/01 00:00:00","y":"500","r":"8...

日期和时间函数

1-9 digits for parsing:0.999999999)%H Hour(00.23)%h Hour(01.12)%I Hour(01.12)%i Minutes,numeric(00.59)%j Day of year(001.366)%k Hour(0.23)%l Hour(1.12)%M Month name(January.December)%m Month,numeric(00.12)%p AM or PM%r ...

基本折线图（v4.0及以上版本）

[{"x":"2010/01/01 00:00:00","y":500,"s":"系列1"},{"x":"2010/01/01 00:00:00","y":180,"s":"系列2"},{"x":"2010/02/01 00:00:00","y":250,"s":"系列1"},{"x":"2010/02/01 00:00:00","y":100,"s":"系列2"},{"x":"2010/03/01 00:00:00","y...

常见问题

示例3：使用聚合函数并且指定时间范围和使用 GROUP BY time()子句>SELECT SUM("water_level")FROM"h2o_feet"WHERE time>='2015-08-18T00:00:00Z' AND time<='2015-08-18T00:18:00Z' GROUP BY time(12m)name:h2o_feet time sum-2015-08-18T...

出租车发票识别

90</Angle><Size><W>91</W><H>519</H></Size></ItemRoi><Text>129.00元</Text></Items...H></Size></ItemRoi><Text>0.00元</Text></Items><Items><ItemRoi><Center><X>1953</X><Y>3368</Y></Center><Angle>0</Angle><Size><W>166</W><H>78</H>...

日期时间格式化指令

00，01，.，99 解析时%d、%m、%H、%I、%M、%S、%J、%U、%W、%V、%y 不要求开头0补齐。Y 十进制数表示的带世纪的年份。0001，0002，.，2013，2014，.，9998，9999 解析年时，范围是[1，9999]，如果年小于1000，必须用0填充为4位数。例如0180...

聚合函数

示例1：列出指定field key对应的不同的field value SELECT DISTINCT("level description")FROM"h2o_feet"name:h2o_feet time distinct-1970-01-01T00:00:00Z between 6 and 9 feet 1970-01-01T00:00:00Z below 3 feet 1970-01-01T00:00:00Z...

SAP系统高可用环境维护指南

双轴折线图（v3.0以下版本）

[{"x":"2010/01/01 00:00:00","y":375,"z":22 },{"x":"2010/02/01 00:00:00","y":200,"z":59 },{"x":"2010/03/01 00:00:00","y":25,"z":51 },{"x":"2010/04/01 00:00:00","y":190,"z":18 },{"x":"2010/05/01 00:00:00","y":70,"z":100 }]x...

区域图（v4.0以下版本）

[{"x":"2010/01/01 00:00:00","y":375 },{"x":"2010/02/01 00:00:00","y":200 },{"x":"2010/03/01 00:00:00","y":0 },{"x":"2010/04/01 00:00:00","y":190 },{"x":"2010/05/01 00:00:00","y":90 },{"x":"2010/06/01 00:00:00","y":233 }]...

日期数据类型

自定义日期格式规则符号含义示例 y 年份 yyyy：2008 yy：08 M 月份 M：7 MM：07 d 月分中的第几天 d：8 dd：08 a 上午（AM）或者下午（PM）标记 a：AM a：PM K AM或者PM中的小时，取值范围为0~11 K：0 KK：00 H 一天中的小时，取值范围...

转换函数

需要注意的重要事项是，所有的field value都在 ACOS()函数的可计算范围里（-1到1）：SELECT"of_capacity"FROM"park_occupancy"WHERE time>='2017-05-01T00:00:00Z' AND time<='2017-05-09T00:00:00Z' name:park_occupancy time capacity-...

示例数据

name average_temperature h2o_feet h2o_pH h2o_quality h2o_temperature 统计在measurement h2o_feet 中，非 null 的 water_level 的值的数量：>SELECT COUNT("water_level")FROM h2o_feet name:h2o_feet-time count 1970-01-01T00:00:00Z...

时间语法

用类似RFC3339格式的日期-时间字符串指定一个时间范围>SELECT"water_level"FROM"h2o_feet"WHERE"location"='santa_monica' AND time>='2015-08-18' AND time<= '2015-08-1800:12:00' name:h2o_feet time water_level-2015-08-18T00:00:00Z 2...

正则表达式

h2o_feet time distinct_level description distinct_water_level-2015-08-18T00:00:00Z below 3 feet 2.064 2015-08-18T00:00:00Z 2.116 2015-08-18T00:00:00Z 2.028 该查询使用了一个InfluxQL函数，返回每个包含 level 的field key所对应...

GROUP BY子句

示例原始数据：SELECT"water_level"FROM"h2o_feet"WHERE"location"='coyote_creek' AND time>='2015-08-18T00:00:00Z' AND time<='2015-08-18T00:18:00Z' name:h2o_feet-time water_level 2015-08-18T00:00:00Z8.12 2015-08-18T00:06:00Z8...

云数据库RDS SQL Server版阻塞问题处理方法

sql_handle)AS h1 CROSS APPLY sys.dm_exec_sql_text(ec2.most_recent_sql_handle)AS h2 waitfor delay '00:00:01' End 系统显示类似如下。说明 DBName：数据库名称。request_session_id：当前请求的session ID，即被阻塞的session。...

richtext

备注 br 换行<p>To break lines in a paragraph, use the br tag.</p>-span 用来组合文档中的行内元素<p><span>some text.</span>some other text.</p>-div 把文档分割为独立的、不同的部分<div style="color:#00FF00"><h3>...

服务指标

service_method,1,12,Y,F,GZ00B 样例日志格式如下：•日志打印时间•fromApp•toApp（即 currentApp）•服务名•方法名•本段时间内的被调用次数•本段时间内的请求处理总耗时•结果（Y/N）•全链路压测标志（T/F）•调用者 Zone sal 调用...

公众人物识别

本文介绍人脸人体（facebody）类目下的公众人物识别...0006272</Id><Rate>98.35</Rate></Faces><H>153</H><Y>153</Y><X>182</X></SubResults><Rate>98.35</Rate></Results></Elements></Data></RecognizePublicFaceResponse>JSON 格式 ...

选择函数

SELECT BOTTOM("water_level",2)FROM"h2o_feet"WHERE time>='2015-08-18T00:00:00Z' AND time<='2015-08-18T00:30:00Z' AND"location"='santa_monica' GROUP BY time(18m)name:h2o_feet time bottom-_2015-08-18T00:00:00Z2.064|2015-08-18...

分区连接

y2023q4 a_3(cost=0.00.15.20 rows=520 width=128)(25 rows)可以看到，当开启分区连接后，分布连接优化的效果很明显：sales_y2023q2 只需要和 measurement_y2023q2 连接，sales_y2023q3 只需要和 measurement_y2023q3 连接，sales_y2023q4 ...

HY00

新品推荐