全部产品
分析型数据库

附录三 常见错误码表

更新时间:2017-06-07 13:26:11   分享:   

类别 错误码 SQL状态码 错误信息 处理方法
DML异常 -1(65535) HY000 Reject execution of sql with #key#, statement: #sql# SQL包含被过滤的关键字,联系阿里云团队确认
DML异常 1047 08S01 No database selected 修改语句,指定database schema,修改后重新执行
DDL异常 1064 HY000 ShowSyntaxException: You have an error in your SQL syntax 检查SHOW语句语法
权限异常 1142 42000 DenyAccessException:User[#user#] does not have[#action#] access to resource[#resource#] 确认用户的执行权限
权限异常 1142 42000 NotAllowAcessException:User[#user#] does not have[#action#] access to resource[#resource#] 确认用户的执行权限
权限异常 1142 42000 AclException:User[#user#] does not have[#action#] access to resource[#resource#] 确认用户的执行权限
DML异常 1149 42000 SQL parsing failed(SQL syntax error): #Parse error message# 检查SQL语法,修改后重新执行
DML异常 1149 42000 SQL parsing unknown error: #Parse error message# 检查SQL语法,修改后重新执行
DML异常 1235 42000 SQL dump data selecting columns count exceed limit: #dump_column_count_limit# DUMP列超过系统允许的最大值
DML异常 1235 42000 SQL selecting columns count exceed limit: #select_column_count_limit# 确认需要select的列数超过系统允许的最大值
DML异常 1235 42000 SQL feature NOT supported yet: SELECT or SELECT #tb#. 修改SQL,重新执行
DML异常 1236 42000 SQL feature NOT supported yet: SELECT agg_func() ... UNION/UNION ALL/INTERSECT SELECT agg_func() ... 修改SQL,采用子查询方式,重新执行
DML异常 1236 42000 SQL feature NOT supported yet: SELECT ... ORDER BY ... UNION/UNION ALL/INTERSECT SELECT ... ORDER BY ... 修改SQL,目前分布式查询模式下,UNION分支中ORDER BY无意义,考虑修改查询逻辑
DML异常 1236 42000 SQL feature NOT supported yet: SELECT ... LIMIT X UNION/UNION ALL/INTERSECT SELECT ... LIMIT X 修改SQL,目前分布式查询模式下,UNION分支中LIMIT无意义,考虑修改查询逻辑
DDL异常 3080 HY000 AcquireLockException:lockName = #schema_table# 提交重新执行
DDL异常 3081 HY000 IllegalParameterException: paramaterName=#parameter name# 检查DDL语句参数
DDL异常 3081 HY000 IllegalParameterException: paramaterName=Column type is invalid: #data_type# 检查DDL列的数据类型
DDL异常 3082 HY000 IllegalParameterValueException: [DDL-N3000]: groupName should be provided for DIMENSION tb. 检查DDL语句参数,为维度表指定groupName
DDL异常 3082 HY000 IllegalParameterValueException: [DDL-N3001]: PARTITION NUM should = 1 for DIMENSION tb. 检查DDL语句参数,维度表分区数必须为1
DDL异常 3082 HY000 IllegalParameterValueException: [DDL-N3002]: hashPartitionNum should be provided and set value to 1 for DIMENSION tb. 检查DDL语句参数,为维度表指定hashPartitionNum,值必须为1
DDL异常 3082 HY000 IllegalParameterValueException: [DDL-N3003]: target tb group is not for DIMENSION tb: #tb group# 检查DDL语句参数,目标表组为分区表表组,不能创建维度表
DDL异常 3082 HY000 IllegalParameterValueException: [DDL-N3004]: target tb group is only for DIMENSION tb: #tb group# 检查DDL语句参数,目标表组为维度表组,不能创建分区表
DDL异常 3082 HY000 IllegalParameterValueException: [DDL-N3005]: can not use DIMENSION_GROUP as target tb group, which is reserved for virtual dimension tb group. 检查DDL语句参数,不能使用DIMENSION_GROUP作为目标表组,为内部虚拟维度表组预留
DDL异常 3082 HY000 IllegalParameterValueException: [DDL-N4000]: PARTITION NUM should # 0 for HASH partition. 检查DDL语句参数,分区表的分区数必须大于0
DDL异常 3082 HY000 IllegalParameterValueException: [DDL-N5000]: originalTableName should not be null. 检查DDL语句参数,指定originalTableName
DDL异常 3082 HY000 IllegalParameterValueException: [DDL-NFFFF] Unexpected exception: #exception message# 检查DDL语句参数
DDL异常 3082 HY000 IllegalParameterValueException: parameterName=#parameterName#, parameterValue=#parameterValue#, correct type is #type# 检查DDL语句参数
DDL异常 3082 HY000 IllegalParameterValueException: #name# is exceed the valid range, reasonable range:[#min#, #max#] 检查并修改DDL语句参数值范围
DDL异常 3082 HY000 IllegalParameterValueException:loader.originalTableName is not null 检查DDL语句参数,指定originalTableName
DDL异常 3082 HY000 IllegalParameterValueException:loader.originalTableName conflict 检查DDL语句参数,目标originalTableName已存在,修改originalTableName
DDL异常 3082 HY000 IllegalParameterValueException:valueType must is lllegal 检查DDL语句参数valueType
DDL异常 3082 HY000 IllegalParameterValueException:valueType is not null 检查DDL语句参数valueType
DDL异常 3084 HY000 DropTableOperationFailedException:#error message# 联系阿里云技术支持
DDL异常 3086 HY000 CreateTableOperationFailed:Table '#schema#.#tableName#' already exists 目标表已经存在,无需执行
DDL异常 3086 HY000 CreateTableOperationFailed:put tableInfo failed, sql:#DDL statement# 联系阿里云技术支持
DDL异常 3086 HY000 CreateTableOperationFailed:put onlineGroupInfo failed, sql:#DDL statement# 联系阿里云技术支持
DDL异常 3087 HY000 CreateTableRollBackException:#error message# 联系阿里云技术支持
DDL异常 3088 HY000 AlterTableIsNotExist:alter tb is not exist! tablePath:#tb path# 目标表不存在,确认表的正确性
DDL异常 3000 HY000 AlterRepeatException:indexName:#indexName# repeat 目标index已存在
DDL异常 3092 HY000 DescTableSqlFormatExcpetion: check sql 检查并修正SHOW语法,重新执行
DDL异常 3094 HY000 DropSyntaxException:#DDL statement# 检查并修正DROP DDL语法,重新执行
DDL异常 3096 HY000 AlterSyntaxException:#DDL statement# 检查并修正ALTER DDL语法,重新执行
DDL异常 3099 HY000 ExceedMaxTableNumException: maxTableNumInDB=#maximun tb number allowed in this database# 目标数据库已到达允许的表数上限,请删除无用表
DML异常 31000 HY000 SQL planning partition routing error: #error message# 系统错误,联系阿里云技术支持,若消息中含有DATA_NOT_FOUND,亦有可能是离线导入的表还没第一次导入数据,无法查询
DML异常 32000 HY000 SQL planning partition routing error: ZERO_ROUTE 系统错误,联系阿里云技术支持
DML异常 51000 HY000 Partitions query error: all failed; #error message# 系统错误,联系阿里云技术支持
DML异常 55000 HY000 Partition merging error: #error message# 系统错误,联系阿里云技术支持
DML异常 55001 HY000 Partitions query error: partitions miss: #missed part count# 系统错误,联系阿里云技术支持
导入异常 1066 HY000 unable to extract param#sourcePath# 语法检查失败,检查语句中参数,重新load data
导入异常 1066 HY000 job does not exist: 确认job是否成功提交
导入异常 1066 HY000 check signature exception: 系统错误,联系阿里云技术支持
导入异常 1066 HY000 target table not exist: 确认load data中的分析型数据库表存在后再发送load data
导入异常 1066 HY000 target database not found: 确认load data中的分析型数据库存在后再发送load data
导入异常 1066 HY000 table DB.TABLE hash partition num:XXX more than limit XXX 分析型数据库离线导入表表HASH分区数限制为不超过256,需调整分区数
导入异常 1066 HY000 table size exceed limit 暂未使用
导入异常 1066 HY000 source table has no records 确认odps源表中有数据后再发送load data
导入异常 1066 HY000 source table column mapping with dest table error 确定分析型数据库表中的列全部在源表中找得到对应的列
导入异常 1066 HY000 get odps table error 确认是否授权garuda_build@aliyun.com对源表/视图的DESC权限
导入异常 1066 HY000 no permission to select source table 确认是否授权garuda_build@aliyun.com对原表/视图的SELECT权限
本文导读目录
本文导读目录
以上内容是否对您有帮助?