SQLSTATE Codes |
您所在的位置：网站首页 › sqlstate=42704 › SQLSTATE Codes |
|
SQLSTATE Codes
Most error classes returned by Spark SQL are associated with a 5 character SQLSTATE. A SQLSTATE is a SQL standard encoding for error conditions commonly used by JDBC, ODBC, and other client APIs. A SQLSTATE consists of two portions: A two character class, and a three character subclass. Each character must be a digit '0' to '9' or 'A' to 'Z'. While many SQLSTATE values are prescribed by the SQL standard, others are common in the industry, specific to Spark. For an ordered list of error classes see: Error Conditions in Spark SQL Spark SQL uses the following SQLSTATE classes: Class 0A: feature not supported SQLSTATEDescription and issuing error classes 0A000 feature not supported INVALID_PANDAS_UDF_PLACEMENT, STAR_GROUP_BY_POS, UNSUPPORTED_ARROWTYPE, UNSUPPORTED_DATATYPE, UNSUPPORTED_DESERIALIZER, UNSUPPORTED_FEATURE, UNSUPPORTED_GENERATOR, UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY, UNSUPPORTED_TYPED_LITERAL Class 21: cardinality violation SQLSTATEDescription and issuing error classes 21000 cardinality violation SCALAR_SUBQUERY_TOO_MANY_ROWS Class 22: data exception SQLSTATEDescription and issuing error classes 22003 numeric value out of range ARITHMETIC_OVERFLOW, CAST_OVERFLOW, CAST_OVERFLOW_IN_TABLE_INSERT, DECIMAL_PRECISION_EXCEEDS_MAX_PRECISION, INVALID_INDEX_OF_ZERO, INCORRECT_END_OFFSET, INCORRECT_RAMP_UP_RATE, INVALID_ARRAY_INDEX, INVALID_ARRAY_INDEX_IN_ELEMENT_AT, NUMERIC_OUT_OF_SUPPORTED_RANGE, NUMERIC_VALUE_OUT_OF_RANGE 22007 invalid datetime format CANNOT_PARSE_TIMESTAMP 22008 datetime field overflow DATETIME_OVERFLOW 2200E null value in array target NULL_MAP_KEY 22012 division by zero DIVIDE_BY_ZERO, INTERVAL_DIVIDED_BY_ZERO 22015 interval field overflow INTERVAL_ARITHMETIC_OVERFLOW 22018 invalid character value for cast CANNOT_PARSE_DECIMAL, CAST_INVALID_INPUT, CONVERSION_INVALID_INPUT 22023 invalid parameter value INVALID_FRACTION_OF_SECOND, INVALID_PARAMETER_VALUE, SECOND_FUNCTION_ARGUMENT_NOT_INTEGER 22032 invalid JSON text INVALID_JSON_ROOT_FIELD, INVALID_JSON_SCHEMA_MAP_TYPE 2203G sql_json_item_cannot_be_cast_to_target_type CANNOT_PARSE_JSON_FIELD 22546 The value for a routine argument is not valid. CANNOT_DECODE_URL Class 23: integrity constraint violation SQLSTATEDescription and issuing error classes 23505 A violation of the constraint imposed by a unique index or a unique constraint occurred. DUPLICATED_MAP_KEY, DUPLICATE_KEY Class 2B: dependent privilege descriptors still exist SQLSTATEDescription and issuing error classes 2BP01 dependent_objects_still_exist SCHEMA_NOT_EMPTY Class 38: external routine exception SQLSTATEDescription and issuing error classes 38000 external routine exception FAILED_FUNCTION_CALL Class 39: external routine invocation exception SQLSTATEDescription and issuing error classes 39000 external routine invocation exception FAILED_EXECUTE_UDF Class 42: syntax error or access rule violation SQLSTATEDescription and issuing error classes 42000 syntax error or access rule violation AMBIGUOUS_REFERENCE_TO_FIELDS, INVALID_COLUMN_OR_FIELD_DATA_TYPE, INVALID_EXTRACT_BASE_FIELD_TYPE, INVALID_EXTRACT_FIELD_TYPE, INVALID_FIELD_NAME, INVALID_SET_SYNTAX, INVALID_SQL_SYNTAX, NON_PARTITION_COLUMN, NOT_NULL_CONSTRAINT_VIOLATION, NULLABLE_COLUMN_OR_FIELD, NULLABLE_ROW_ID_ATTRIBUTES 42601 A character, token, or clause is invalid or missing. IDENTIFIER_TOO_MANY_NAME_PARTS, INVALID_EXTRACT_FIELD, INVALID_FORMAT, PARSE_SYNTAX_ERROR, UNCLOSED_BRACKETED_COMMENT 42602 A character that is invalid in a name has been detected. INVALID_IDENTIFIER, INVALID_PROPERTY_KEY, INVALID_PROPERTY_VALUE 42604 An invalid numeric or string constant has been detected. EMPTY_JSON_FIELD_VALUE, INVALID_TYPED_LITERAL 42605 The number of arguments specified for a scalar function is invalid. WRONG_NUM_ARGS 42607 An operand of an aggregate function or CONCAT operator is invalid. NESTED_AGGREGATE_FUNCTION 42613 Clauses are mutually exclusive. INCOMPATIBLE_JOIN_TYPES, INVALID_LATERAL_JOIN_TYPE, NON_LAST_MATCHED_CLAUSE_OMIT_CONDITION, NON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITION, NON_LAST_NOT_MATCHED_BY_TARGET_CLAUSE_OMIT_CONDITION 42614 A duplicate keyword or clause is invalid. REPEATED_CLAUSE 42617 The statement string is blank or empty. PARSE_EMPTY_STATEMENT 42702 A column reference is ambiguous, because of duplicate names. AMBIGUOUS_COLUMN_OR_FIELD, AMBIGUOUS_LATERAL_COLUMN_ALIAS 42703 An undefined column or parameter name was detected. COLUMN_NOT_FOUND, UNRESOLVED_COLUMN, UNRESOLVED_FIELD, UNRESOLVED_MAP_KEY, UNRESOLVED_USING_COLUMN_FOR_JOIN 42704 An undefined object or constraint name was detected. AMBIGUOUS_REFERENCE, DEFAULT_DATABASE_NOT_EXISTS, FIELD_NOT_FOUND, INDEX_NOT_FOUND, SCHEMA_NOT_FOUND, UNRECOGNIZED_SQL_TYPE 42710 A duplicate object or constraint name was detected. CREATE_TABLE_COLUMN_OPTION_DUPLICATE, INDEX_ALREADY_EXISTS, LOCATION_ALREADY_EXISTS 42711 A duplicate column name was detected in the object definition or ALTER TABLE statement. COLUMN_ALREADY_EXISTS 42723 A routine with the same signature already exists in the schema, module, or compound block where it is defined. ROUTINE_ALREADY_EXISTS 42803 A column reference in the SELECT or HAVING clause is invalid, because it is not a grouping column; or a column reference in the GROUP BY clause is invalid. GROUPING_COLUMN_MISMATCH, GROUPING_ID_COLUMN_MISMATCH, MISSING_AGGREGATION, MISSING_GROUP_BY, UNRESOLVED_ALL_IN_GROUP_BY 42805 An integer in the ORDER BY clause does not identify a column of the result table. GROUP_BY_POS_OUT_OF_RANGE, ORDER_BY_POS_OUT_OF_RANGE 42809 The identified object is not the type of object to which the statement applies. FORBIDDEN_OPERATION 42818 The operands of an operator or function are not compatible or comparable. INCOMPARABLE_PIVOT_COLUMN 42823 Multiple columns are returned from a subquery that only allows one column. INVALID_SUBQUERY_EXPRESSION 42825 The rows of UNION, INTERSECT, EXCEPT, or VALUES do not have compatible columns. CANNOT_MERGE_INCOMPATIBLE_DATA_TYPE, INCOMPATIBLE_COLUMN_TYPE 42826 The rows of UNION, INTERSECT, EXCEPT, or VALUES do not have the same number of columns. NUM_COLUMNS_MISMATCH 42846 Cast from source type to target type is not supported. CANNOT_CAST_DATATYPE 42883 No routine was found with a matching signature. ROUTINE_NOT_FOUND, UNRESOLVED_ROUTINE 428C4 The number of elements on each side of the predicate operator is not the same. UNPIVOT_VALUE_SIZE_MISMATCH 428EK The schema qualifier is not valid. TEMP_VIEW_NAME_TOO_MANY_NAME_PARTS 428FT The partitioning clause specified on CREATE or ALTER is not valid. PARTITIONS_ALREADY_EXIST, PARTITIONS_NOT_FOUND 42903 Invalid use of an aggregate function or OLAP function. GROUP_BY_AGGREGATE, GROUP_BY_POS_AGGREGATE, INVALID_WHERE_CONDITION 429BB The data type of a column, parameter, or SQL variable is not supported. CANNOT_RECOGNIZE_HIVE_TYPE 42K01 data type not fully specified DATATYPE_MISSING_SIZE, INCOMPLETE_TYPE_DEFINITION 42K02 data source not found DATA_SOURCE_NOT_FOUND 42K03 File not found PATH_NOT_FOUND, RENAME_SRC_PATH_NOT_FOUND 42K04 Duplicate file FAILED_RENAME_PATH, PATH_ALREADY_EXISTS 42K05 Name is not valid INVALID_EMPTY_LOCATION, REQUIRES_SINGLE_PART_NAMESPACE 42K06 Invalid type for options INVALID_OPTIONS 42K07 Not a valid schema literal INVALID_SCHEMA 42K08 Not a constant NON_LITERAL_PIVOT_VALUES 42K09 Data type mismatch DATATYPE_MISMATCH, PIVOT_VALUE_DATA_TYPE_MISMATCH, UNEXPECTED_INPUT_TYPE, UNPIVOT_VALUE_DATA_TYPE_MISMATCH 42K0A Invalid UNPIVOT clause UNPIVOT_REQUIRES_ATTRIBUTES, UNPIVOT_REQUIRES_VALUE_COLUMNS 42K0B Legacy feature blocked INCONSISTENT_BEHAVIOR_CROSS_VERSION 42KD9 Cannot infer table schema. UNABLE_TO_INFER_SCHEMA 42P01 undefined_table TABLE_OR_VIEW_NOT_FOUND, VIEW_NOT_FOUND 42P02 undefined_parameter UNBOUND_SQL_PARAMETER 42P06 duplicate_schema SCHEMA_ALREADY_EXISTS 42P07 duplicate_table TABLE_OR_VIEW_ALREADY_EXISTS, TEMP_TABLE_OR_VIEW_ALREADY_EXISTS, VIEW_ALREADY_EXISTS 42P20 windowing_error UNSUPPORTED_EXPR_FOR_WINDOW Class 46: java ddl 1 SQLSTATEDescription and issuing error classes 46110 unsupported feature CANNOT_MODIFY_CONFIG 46121 invalid column name INVALID_COLUMN_NAME_AS_PATH Class 53: insufficient resources SQLSTATEDescription and issuing error classes 53200 out_of_memory UNABLE_TO_ACQUIRE_MEMORY Class 54: program limit exceeded SQLSTATEDescription and issuing error classes 54000 program limit exceeded GROUPING_SIZE_LIMIT_EXCEEDED, TOO_MANY_ARRAY_ELEMENTS Class XX: internal error SQLSTATEDescription and issuing error classes XX000 internal error INTERNAL_ERROR |
| CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |