SQLSTATE codes

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 12.2 and above

Most error classes returned by Databricks 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, or Databricks.

For an ordered list of error classes see: Error conditions in Databricks

Databricks uses the following SQLSTATE classes:

Class 08: connection exception

SQLSTATE

Description and issuing error classes

08003

connection does not exist

DELTA_ACTIVE_SPARK_SESSION_NOT_FOUND

Class 0A: feature not supported

SQLSTATE

Description and issuing error classes

0A000

feature not supported

CF_ADD_NEW_NOT_SUPPORTED, CF_EVENT_NOTIFICATION_NOT_SUPPORTED, CF_PERIODIC_BACKFILL_NOT_SUPPORTED, CF_SOURCE_UNSUPPORTED, CF_UNSUPPORTED_FORMAT_FOR_SCHEMA_INFERENCE, CF_UNSUPPORTED_LOG_VERSION, CF_UNSUPPORTED_SCHEMA_EVOLUTION_MODE, CONSTRAINTS_REQUIRE_UNITY_CATALOG, COPY_INTO_CREDENTIALS_NOT_ALLOWED_ON, COPY_INTO_ENCRYPTION_NOT_ALLOWED_ON, COPY_INTO_ENCRYPTION_NOT_SUPPORTED_FOR_AZURE, COPY_INTO_SOURCE_FILE_FORMAT_NOT_SUPPORTED, DELTA_ADDING_DELETION_VECTORS_DISALLOWED, DELTA_ADD_CONSTRAINTS, DELTA_CANNOT_WRITE_INTO_VIEW, DELTA_NESTED_SUBQUERY_NOT_SUPPORTED, DELTA_NOT_NULL_NESTED_FIELD, DELTA_OPERATION_ON_TEMP_VIEW_WITH_GENERATED_COLS_NOT_SUPPORTED, DELTA_SOURCE_IGNORE_DELETE, DELTA_SOURCE_TABLE_IGNORE_CHANGES, DELTA_UNSUPPORTED_DEEP_CLONE, DELTA_UNSUPPORTED_EXPRESSION, DELTA_UNSUPPORTED_FSCK_WITH_DELETION_VECTORS, DELTA_UNSUPPORTED_GENERATE_WITH_DELETION_VECTORS, DELTA_UNSUPPORTED_LIST_KEYS_WITH_PREFIX, DELTA_UNSUPPORTED_MERGE_SCHEMA_EVOLUTION_WITH_CDC, DELTA_UNSUPPORTED_SORT_ON_BUCKETED_TABLES, DELTA_UNSUPPORTED_TRUNCATE_SAMPLE_TABLES, DELTA_UNSUPPORTED_WRITE_SAMPLE_TABLES, DELTA_VIOLATE_TABLE_PROPERTY_VALIDATION_FAILED, DELTA_WRITE_INTO_VIEW_NOT_SUPPORTED, EXTERNAL_TABLE_INVALID_SCHEME, INVALID_PANDAS_UDF_PLACEMENT, NOT_SUPPORTED_WITH_DB_SQL, STAR_GROUP_BY_POS, UDF_PYSPARK_UNSUPPORTED_TYPE, UDF_UNSUPPORTED_PARAMETER_DEFAULT_VALUE, UNSUPPORTED_ARROWTYPE, UNSUPPORTED_CONSTRAINT_CLAUSES, UNSUPPORTED_DATATYPE, UNSUPPORTED_DESERIALIZER, UNSUPPORTED_FEATURE, UNSUPPORTED_FN_TYPE, UNSUPPORTED_GENERATOR, UNSUPPORTED_STREAM_READ_LIMIT_FOR_KINESIS_SOURCE, UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY, UNSUPPORTED_TRIGGER_FOR_KINESIS_SOURCE, UNSUPPORTED_TYPED_LITERAL

0AKD0

Cross catalog or schema operation not supported

CANNOT_COPY_STATE, CANNOT_REFERENCE_UC_IN_HMS, CANNOT_RENAME_ACROSS_CATALOG, CANNOT_RENAME_ACROSS_METASTORE, CANNOT_RENAME_ACROSS_SCHEMA, CANNOT_SHALLOW_CLONE_ACROSS_UC_AND_HMS

0AKDC

Not supported in Delta

DELTA_CANNOT_EVALUATE_EXPRESSION, DELTA_CANNOT_GENERATE_CODE_FOR_EXPRESSION, DELTA_CDC_NOT_ALLOWED_IN_THIS_VERSION, DELTA_CHANGE_DATA_FEED_INCOMPATIBLE_DATA_SCHEMA, DELTA_CHANGE_DATA_FEED_INCOMPATIBLE_SCHEMA_CHANGE, DELTA_CLONE_UNSUPPORTED_SOURCE, DELTA_CONVERSION_UNSUPPORTED_COLUMN_MAPPING, DELTA_CONVERT_NON_PARQUET_TABLE, DELTA_INCORRECT_LOG_STORE_IMPLEMENTATION, DELTA_MISSING_PROVIDER_FOR_CONVERT, DELTA_MODE_NOT_SUPPORTED, DELTA_NESTED_NOT_NULL_CONSTRAINT, DELTA_NON_DETERMINISTIC_FUNCTION_NOT_SUPPORTED, DELTA_OPERATION_NOT_ALLOWED, DELTA_OPERATION_NOT_ALLOWED_DETAIL, DELTA_TABLE_FOR_PATH_UNSUPPORTED_HADOOP_CONF, DELTA_TRUNCATE_TABLE_PARTITION_NOT_SUPPORTED, DELTA_UNSUPPORTED_ABS_PATH_ADD_FILE, DELTA_UNSUPPORTED_ALTER_TABLE_REPLACE_COL_OP, DELTA_UNSUPPORTED_CLONE_REPLACE_SAME_TABLE, DELTA_UNSUPPORTED_COLUMN_MAPPING_MODE_CHANGE, DELTA_UNSUPPORTED_COLUMN_MAPPING_SCHEMA_CHANGE, DELTA_UNSUPPORTED_COLUMN_MAPPING_WRITE, DELTA_UNSUPPORTED_COLUMN_TYPE_IN_BLOOM_FILTER, DELTA_UNSUPPORTED_DATA_TYPES, DELTA_UNSUPPORTED_DROP_COLUMN, DELTA_UNSUPPORTED_DROP_NESTED_COLUMN_FROM_NON_STRUCT_TYPE, DELTA_UNSUPPORTED_DROP_PARTITION_COLUMN, DELTA_UNSUPPORTED_FIELD_UPDATE_NON_STRUCT, DELTA_UNSUPPORTED_INVARIANT_NON_STRUCT, DELTA_UNSUPPORTED_IN_SUBQUERY, DELTA_UNSUPPORTED_MANIFEST_GENERATION_WITH_COLUMN_MAPPING, DELTA_UNSUPPORTED_MULTI_COL_IN_PREDICATE, DELTA_UNSUPPORTED_NESTED_COLUMN_IN_BLOOM_FILTER, DELTA_UNSUPPORTED_NESTED_FIELD_IN_OPERATION, DELTA_UNSUPPORTED_NON_EMPTY_CLONE, DELTA_UNSUPPORTED_OUTPUT_MODE, DELTA_UNSUPPORTED_PARTITION_COLUMN_IN_BLOOM_FILTER, DELTA_UNSUPPORTED_RENAME_COLUMN, DELTA_UNSUPPORTED_SCHEMA_DURING_READ, DELTA_UNSUPPORTED_SUBQUERY, DELTA_UNSUPPORTED_SUBQUERY_IN_PARTITION_PREDICATES, DELTA_UNSUPPORTED_TIME_TRAVEL_VIEWS, DELTA_UNSUPPORTED_VACUUM_SPECIFIC_PARTITION, WRONG_COLUMN_DEFAULTS_FOR_DELTA_ALTER_TABLE_ADD_COLUMN_NOT_SUPPORTED

0AKDD

Feature requires Delta

DELTA_NOT_A_DELTA_TABLE, DELTA_ONLY_OPERATION, DELTA_TABLE_ONLY_OPERATION, DELTA_UNSUPPORTED_SOURCE, DELTA_UNSUPPORTED_STATIC_PARTITIONS, SYNC_METADATA_DELTA_ONLY

0AKDE

Feature non enabled for this Delta table

DELTA_DATA_CHANGE_FALSE, DELTA_FEATURES_PROTOCOL_METADATA_MISMATCH, DELTA_FEATURES_REQUIRE_MANUAL_ENABLEMENT, DELTA_FEATURE_REQUIRES_HIGHER_READER_VERSION, DELTA_FEATURE_REQUIRES_HIGHER_WRITER_VERSION, DELTA_UNSUPPORTED_FEATURE_STATUS, WRONG_COLUMN_DEFAULTS_FOR_DELTA_FEATURE_NOT_ENABLED

0AKUC

Not supported in Unity Catalog

CANNOT_SHALLOW_CLONE_NESTED, CANNOT_SHALLOW_CLONE_NON_UC_MANAGED_TABLE_AS_SOURCE_OR_TARGET, INVALID_SCHEME, PARTITION_METADATA, UC_BUCKETED_TABLES, UC_COMMAND_NOT_SUPPORTED, UC_DATASOURCE_NOT_SUPPORTED, UC_DATASOURCE_OPTIONS_NOT_SUPPORTED, UC_INVALID_NAMESPACE, UC_INVALID_REFERENCE, UPGRADE_NOT_SUPPORTED

0AKUD

Feature requires Unity Catalog

FEATURE_REQUIRES_UC, OPERATION_REQUIRES_UNITY_CATALOG, SYNC_METADATA_NOT_SUPPORTED

Class 0B: invalid transaction initiation

SQLSTATE

Description and issuing error classes

0B000

invalid transaction initiation

DELTA_ACTIVE_TRANSACTION_ALREADY_SET

Class 21: cardinality violation

SQLSTATE

Description and issuing error classes

21000

cardinality violation

SCALAR_SUBQUERY_TOO_MANY_ROWS

21506

The same row of a table cannot be the target for more than one of an update, delete or insert operation.

DELTA_MULTIPLE_SOURCE_ROW_MATCHING_TARGET_ROW_IN_MERGE

Class 22: data exception

SQLSTATE

Description and issuing error classes

22000

data exception

CF_BUCKET_MISMATCH, CF_CANNOT_EVOLVE_SCHEMA_LOG_EMPTY, CF_CANNOT_RESOLVE_CONTAINER_NAME, CF_CANNOT_RUN_DIRECTORY_LISTING, CF_DUPLICATE_COLUMN_IN_DATA, CF_EVENT_GRID_AUTH_ERROR, CF_EVENT_GRID_CREATION_FAILED, CF_EVENT_GRID_NOT_FOUND_ERROR, CF_FAILED_TO_CHECK_STREAM_NEW, CF_FAILED_TO_CREATED_PUBSUB_SUBSCRIPTION, CF_FAILED_TO_CREATED_PUBSUB_TOPIC, CF_FAILED_TO_DELETE_GCP_NOTIFICATION, CF_FAILED_TO_DESERIALIZE_PERSISTED_SCHEMA, CF_FAILED_TO_EVOLVE_SCHEMA, CF_FAILED_TO_INFER_SCHEMA, CF_FAILED_TO_WRITE_TO_SCHEMA_LOG, CF_FOUND_MULTIPLE_AUTOLOADER_PUBSUB_SUBSCRIPTIONS, CF_GCP_LABELS_COUNT_EXCEEDED, CF_GCP_RESOURCE_TAGS_COUNT_EXCEEDED, CF_INCOMPLETE_LOG_FILE_IN_SCHEMA_LOG, CF_INCOMPLETE_METADATA_FILE_IN_CHECKPOINT, CF_LATEST_OFFSET_READ_LIMIT_REQUIRED, CF_LOG_FILE_MALFORMED, CF_METADATA_FILE_CONCURRENTLY_USED, CF_MULTIPLE_PUBSUB_NOTIFICATIONS_FOR_TOPIC, CF_NEW_PARTITION_ERROR, CF_PARTITON_INFERENCE_ERROR, CF_PREFIX_MISMATCH, CF_PROTOCOL_MISMATCH, CF_RESTRICTED_GCP_RESOURCE_TAG_KEY, CF_SAME_PUB_SUB_TOPIC_NEW_KEY_PREFIX, CF_THREAD_IS_DEAD, CF_UNABLE_TO_LIST_EFFICIENTLY, CF_UNABLE_TO_USE_INCREMENTAL_LISTING_WITH_COLON_IN_FILENAME, CF_UNEXPECTED_READ_LIMIT, CF_UNKNOWN_READ_LIMIT, DELTA_CANNOT_FIND_BUCKET_SPEC, DELTA_COMPACTION_VALIDATION_FAILED, DELTA_DV_HISTOGRAM_DESERIALIZATON, DELTA_INVALID_FORMAT, DELTA_INVALID_TABLE_VALUE_FUNCTION, DELTA_MULTIPLE_ROW_ID_HIGH_WATERMARKS_FOUND, DELTA_PHYSICAL_ROW_ID_COLUMN_NAME_MISSING, DELTA_STREAMING_SCHEMA_EVOLUTION, DELTA_STREAMING_SCHEMA_LOCATION_CONFLICT, DELTA_STREAMING_SCHEMA_LOCATION_NOT_UNDER_CHECKPOINT, DELTA_STREAMING_SCHEMA_LOG_DESERIALIZE_FAILED, DELTA_STREAMING_SCHEMA_LOG_INCOMPATIBLE_DELTA_TABLE_ID, DELTA_STREAMING_SCHEMA_LOG_INCOMPATIBLE_PARTITION_SCHEMA, DELTA_STREAMING_SCHEMA_LOG_INIT_FAILED_INCOMPATIBLE_SCHEMA, DELTA_STREAMING_SCHEMA_LOG_PARSE_SCHEMA_FAILED, INVALID_TIMESTAMP_FORMAT, STAGING_PATH_CURRENTLY_INACCESSIBLE

22001

string data, right truncation

DELTA_EXCEED_CHAR_VARCHAR_LIMIT

22003

numeric value out of range

ARITHMETIC_OVERFLOW, BINARY_ARITHMETIC_OVERFLOW, CAST_OVERFLOW, CAST_OVERFLOW_IN_TABLE_INSERT, DECIMAL_PRECISION_EXCEEDS_MAX_PRECISION, DELTA_CANNOT_RESTORE_TABLE_VERSION, DELTA_CANNOT_RESTORE_TIMESTAMP_GREATER, DELTA_INVALID_CDC_RANGE, INCORRECT_END_OFFSET, INCORRECT_RAMP_UP_RATE, INVALID_ARRAY_INDEX, INVALID_ARRAY_INDEX_IN_ELEMENT_AT, INVALID_INDEX_OF_ZERO, NUMERIC_OUT_OF_SUPPORTED_RANGE, NUMERIC_VALUE_OUT_OF_RANGE

22005

error in assignment

DELTA_COMPLEX_TYPE_COLUMN_CONTAINS_NULL_TYPE, DELTA_FAILED_TO_MERGE_FIELDS, DELTA_MERGE_UNEXPECTED_ASSIGNMENT_KEY

22006

invalid interval format

DELTA_INVALID_INTERVAL

22007

invalid datetime format

CANNOT_PARSE_TIMESTAMP, DELTA_INVALID_TIMESTAMP_FORMAT

22008

datetime field overflow

DATETIME_OVERFLOW

2200E

null value in array target

NULL_MAP_KEY

2200G

most specific type mismatch

DELTA_COLUMN_STRUCT_TYPE_MISMATCH

2200P

interval value out of range

DELTA_INVALID_CALENDAR_INTERVAL_EMPTY

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, DELTA_FAILED_CAST_PARTITION_VALUE

2201B

invalid regular expression

DELTA_REGEX_OPT_SYNTAX_ERROR

22023

invalid parameter value

DELTA_INVALID_BUCKET_COUNT, DELTA_INVALID_BUCKET_INDEX, DELTA_UNSUPPORTED_STRATEGY_NAME, EMPTY_LOCAL_FILE_IN_STAGING_ACCESS_QUERY, GEOJSON_PARSE_ERROR, H3_INVALID_CELL_ID, H3_INVALID_GRID_DISTANCE_VALUE, H3_INVALID_RESOLUTION_VALUE, H3_PENTAGON_ENCOUNTERED_ERROR, H3_UNDEFINED_GRID_DISTANCE, INVALID_FRACTION_OF_SECOND, INVALID_PARAMETER_VALUE, SECOND_FUNCTION_ARGUMENT_NOT_INTEGER, ST_INVALID_PRECISION_VALUE, ST_INVALID_SRID_VALUE, WKB_PARSE_ERROR, WKT_PARSE_ERROR

22032

invalid JSON text

AI_INVALID_MODEL_ERROR, INVALID_JSON_ROOT_FIELD, INVALID_JSON_SCHEMA_MAP_TYPE, REMOTE_FUNCTION_HTTP_RESULT_PARSE_ERROR

2203G

SQL/JSON item cannot be cast to target type

CANNOT_PARSE_JSON_FIELD

22525

Partitioning key value is not valid.

DELTA_PARTITION_COLUMN_CAST_FAILED

22531

The argument of a built-in or system provided routine resulted in an error.

INVALID_SECRET_LOOKUP

22546

The value for a routine argument is not valid.

CANNOT_DECODE_URL

22KD1

Invalid URI or PATH

DELTA_CANNOT_RECONSTRUCT_PATH_FROM_URI, DELTA_CANNOT_RENAME_PATH, DELTA_INVALID_CLONE_PATH, DELTA_INVALID_PARTITION_PATH

22KD2

Identity claim is unset

OAUTH_CUSTOM_IDENTITY_CLAIM_NOT_PROVIDED

Class 23: integrity constraint violation

SQLSTATE

Description and issuing error classes

23001

restrict violation

DELTA_VIOLATE_CONSTRAINT_WITH_VALUES

23502

An insert or update value is null, but the column cannot contain null values.

DELTA_MISSING_NOT_NULL_COLUMN_VALUE, DELTA_NOT_NULL_CONSTRAINT_VIOLATED

23505

A violation of the constraint imposed by a unique index or a unique constraint occurred.

DUPLICATED_MAP_KEY, DUPLICATE_KEY

23512

The check constraint cannot be added, because the table contains rows that do not satisfy the constraint definition.

DELTA_NEW_CHECK_CONSTRAINT_VIOLATION, DELTA_NEW_NOT_NULL_VIOLATION

Class 2B: dependent privilege descriptors still exist

SQLSTATE

Description and issuing error classes

2BP01

dependent_objects_still_exist

SCHEMA_NOT_EMPTY

Class 2D: invalid transaction termination

SQLSTATE

Description and issuing error classes

2D521

SQL COMMIT or ROLLBACK are invalid in the current operating environment.

DELTA_DELETION_VECTOR_MISSING_NUM_RECORDS, DELTA_DUPLICATE_ACTIONS_FOUND

2DKD0

Post commit hook failed

DELTA_POST_COMMIT_HOOK_FAILED

Class 38: external routine exception

SQLSTATE

Description and issuing error classes

38000

external routine exception

FAILED_FUNCTION_CALL

Class 39: external routine invocation exception

SQLSTATE

Description and issuing error classes

39000

external routine invocation exception

FAILED_EXECUTE_UDF, UDF_USER_CODE_ERROR

Class 3D: invalid catalog name

SQLSTATE

Description and issuing error classes

3D000

invalid catalog name

UC_CATALOG_NAME_NOT_PROVIDED

Class 40: transaction rollback

SQLSTATE

Description and issuing error classes

40000

transaction rollback

DELTA_MAX_COMMIT_RETRIES_EXCEEDED

Class 42: syntax error or access rule violation

SQLSTATE

Description and issuing error classes

42000

syntax error or access rule violation

AMBIGUOUS_REFERENCE_TO_FIELDS, CF_AMBIGUOUS_AUTH_OPTIONS_ERROR, CF_AMBIGUOUS_INCREMENTAL_LISTING_MODE_ERROR, CF_AZURE_STORAGE_SUFFIXES_REQUIRED, CF_CLEAN_SOURCE_ALLOW_OVERWRITES_BOTH_ON, CF_EMPTY_DIR_FOR_SCHEMA_INFERENCE, CF_FAILED_TO_FIND_PROVIDER, CF_FILE_FORMAT_REQUIRED, CF_GCP_AUTHENTICATION, CF_INCORRECT_SQL_PARAMS, CF_INVALID_ARN, CF_INVALID_CHECKPOINT, CF_INVALID_CLEAN_SOURCE_MODE, CF_INVALID_GCP_RESOURCE_TAG_KEY, CF_INVALID_GCP_RESOURCE_TAG_VALUE, CF_INVALID_SCHEMA_EVOLUTION_MODE, CF_INVALID_SCHEMA_HINTS_OPTION, CF_INVALID_SCHEMA_HINT_COLUMN, CF_MAX_MUST_BE_POSITIVE, CF_MISSING_METADATA_FILE_ERROR, CF_MISSING_PARTITION_COLUMN_ERROR, CF_MISSING_SCHEMA_IN_PATHLESS_MODE, CF_PATH_DOES_NOT_EXIST_FOR_SCHEMA_INFERENCE, CF_REGION_NOT_FOUND_ERROR, CF_RESOURCE_SUFFIX_EMPTY, CF_RESOURCE_SUFFIX_INVALID_CHAR_AWS, CF_RESOURCE_SUFFIX_INVALID_CHAR_AZURE, CF_RESOURCE_SUFFIX_INVALID_CHAR_GCP, CF_RESOURCE_SUFFIX_LIMIT, CF_RESOURCE_SUFFIX_LIMIT_GCP, CF_RETENTION_GREATER_THAN_MAX_FILE_AGE, CF_SOURCE_DIRECTORY_PATH_REQUIRED, CF_UNABLE_TO_DERIVE_STREAM_CHECKPOINT_LOCATION, CF_UNABLE_TO_DETECT_FILE_FORMAT, CF_UNABLE_TO_EXTRACT_BUCKET_INFO, CF_UNABLE_TO_EXTRACT_KEY_INFO, CF_UNABLE_TO_EXTRACT_STORAGE_ACCOUNT_INFO, CF_UNKNOWN_OPTION_KEYS_ERROR, CF_USE_DELTA_FORMAT, CONNECTION_ALREADY_EXISTS, CONNECTION_NAME_CANNOT_BE_EMPTY, CONNECTION_NOT_FOUND, CONNECTION_OPTION_NOT_SUPPORTED, CONNECTION_TYPE_NOT_SUPPORTED, DELTA_ADDING_COLUMN_WITH_INTERNAL_NAME_FAILED, DELTA_ADDING_DELETION_VECTORS_WITH_TIGHT_BOUNDS_DISALLOWED, DELTA_ALTER_TABLE_RENAME_NOT_ALLOWED, DELTA_CANNOT_RELATIVIZE_PATH, DELTA_CLONE_INCOMPLETE_FILE_COPY, DELTA_INCONSISTENT_BUCKET_SPEC, DELTA_INCORRECT_GET_CONF, DELTA_INVALID_MANAGED_TABLE_SYNTAX_NO_SCHEMA, DELTA_MAX_ARRAY_SIZE_EXCEEDED, DELTA_MAX_LIST_FILE_EXCEEDED, DELTA_MISSING_TRANSACTION_LOG, DELTA_NAME_CONFLICT_IN_BUCKETED_TABLE, DELTA_NOT_A_DATABRICKS_DELTA_TABLE, DELTA_OVERWRITE_MUST_BE_TRUE, DELTA_STATS_COLLECTION_COLUMN_NOT_FOUND, FOREIGN_OBJECT_NAME_CANNOT_BE_EMPTY, INVALID_COLUMN_OR_FIELD_DATA_TYPE, INVALID_EXTRACT_BASE_FIELD_TYPE, INVALID_EXTRACT_FIELD_TYPE, INVALID_FIELD_NAME, INVALID_SET_SYNTAX, INVALID_SQL_SYNTAX, MISSING_CONNECTION_OPTION, MISSING_NAME_FOR_CHECK_CONSTRAINT, MULTIPLE_LOAD_PATH, NAMESPACE_ALREADY_EXISTS, NAMESPACE_NOT_EMPTY, NAMESPACE_NOT_FOUND, NON_PARTITION_COLUMN, NOT_NULL_CONSTRAINT_VIOLATION, NULLABLE_COLUMN_OR_FIELD, NULLABLE_ROW_ID_ATTRIBUTES, ROUTINE_PARAMETER_NOT_FOUND, STREAMING_TABLE_QUERY_INVALID, UNSUPPORTED_CONSTRAINT_TYPE, UNSUPPORTED_STREAMING_TABLE_VALUED_FUNCTION, VOLUME_ALREADY_EXISTS

42501

The authorization ID does not have the privilege to perform the specified operation on the identified object.

CANNOT_READ_SENSITIVE_KEY_FROM_SECURE_PROVIDER, CF_CLEAN_SOURCE_UNAUTHORIZED_WRITE_PERMISSION, INSUFFICIENT_PERMISSIONS, INSUFFICIENT_PERMISSIONS_EXT_LOC, INSUFFICIENT_PERMISSIONS_NO_OWNER, INSUFFICIENT_PERMISSIONS_OWNERSHIP_SECURABLE, INSUFFICIENT_PERMISSIONS_SECURABLE, INSUFFICIENT_PERMISSIONS_SECURABLE_PARENT_OWNER, INSUFFICIENT_PERMISSIONS_STORAGE_CRED, INSUFFICIENT_PERMISSIONS_UNDERLYING_SECURABLES, INSUFFICIENT_PERMISSIONS_UNDERLYING_SECURABLES_VERBOSE, INVALID_S3_COPY_CREDENTIALS

42601

A character, token, or clause is invalid or missing.

COPY_INTO_CREDENTIALS_REQUIRED, COPY_INTO_ENCRYPTION_REQUIRED, COPY_INTO_ENCRYPTION_REQUIRED_WITH_EXPECTED, CREDENTIAL_MISSING, DATA_SOURCE_OPTION_IS_REQUIRED, DELTA_CANNOT_CHANGE_LOCATION, DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_SCHEMA, DELTA_CREATE_TABLE_WITH_NON_EMPTY_LOCATION, DELTA_FAILED_RECOGNIZE_PREDICATE, DELTA_ILLEGAL_USAGE, DELTA_MERGE_MISSING_WHEN, DELTA_NON_LAST_MATCHED_CLAUSE_OMIT_CONDITION, DELTA_NON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITION, DELTA_NON_LAST_NOT_MATCHED_CLAUSE_OMIT_CONDITION, DELTA_NON_PARSABLE_TAG, DELTA_NO_START_FOR_CDC_READ, DELTA_ONEOF_IN_TIMETRAVEL, DELTA_OPERATION_MISSING_PATH, DELTA_UNEXPECTED_ACTION_EXPRESSION, DELTA_UNKNOWN_PRIVILEGE, DELTA_UNKNOWN_READ_LIMIT, DELTA_UNRECOGNIZED_COLUMN_CHANGE, EVENT_LOG_REQUIRES_SHARED_COMPUTE, IDENTIFIER_TOO_MANY_NAME_PARTS, INVALID_EXTRACT_FIELD, INVALID_FORMAT, PARSE_SYNTAX_ERROR, STREAMING_TABLE_OPERATION_NOT_ALLOWED, UNCLOSED_BRACKETED_COMMENT, USER_DEFINED_FUNCTIONS, WITH_CREDENTIAL

42602

A character that is invalid in a name has been detected.

DATA_SOURCE_OPTION_CONTAINS_INVALID_CHARACTERS, INVALID_IDENTIFIER, INVALID_PROPERTY_KEY, INVALID_PROPERTY_VALUE

42604

An invalid numeric or string constant has been detected.

DELTA_TIME_TRAVEL_INVALID_BEGIN_VALUE, EMPTY_JSON_FIELD_VALUE, INVALID_PIPELINE_ID, INVALID_STAGING_PATH_IN_STAGING_ACCESS_QUERY, INVALID_TYPED_LITERAL, INVALID_UUID

42605

The number of arguments specified for a scalar function is invalid.

INCORRECT_NUMBER_OF_ARGUMENTS, WRONG_NUM_ARGS

42607

An operand of an aggregate function or CONCAT operator is invalid.

NESTED_AGGREGATE_FUNCTION

42613

Clauses are mutually exclusive.

DELTA_AMBIGUOUS_PATHS_IN_CREATE_TABLE, DELTA_CANNOT_SET_LOCATION_ON_PATH_IDENTIFIER, DELTA_CLONE_AMBIGUOUS_TARGET, DELTA_FILE_LIST_AND_PATTERN_STRING_CONFLICT, DELTA_PARTITION_SCHEMA_IN_ICEBERG_TABLES, DELTA_REPLACE_WHERE_IN_OVERWRITE, DELTA_REPLACE_WHERE_WITH_DYNAMIC_PARTITION_OVERWRITE, DELTA_REPLACE_WHERE_WITH_FILTER_DATA_CHANGE_UNSET, DELTA_STARTING_VERSION_AND_TIMESTAMP_BOTH_SET, DELTA_TABLE_LOCATION_MISMATCH, DELTA_UNSUPPORTED_TIME_TRAVEL_MULTIPLE_FORMATS, INCOMPATIBLE_JOIN_TYPES, INVALID_LATERAL_JOIN_TYPE, MANAGED_TABLE_WITH_CRED, NON_LAST_MATCHED_CLAUSE_OMIT_CONDITION, NON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITION, NON_LAST_NOT_MATCHED_CLAUSE_OMIT_CONDITION

42614

A duplicate keyword or clause is invalid.

DELTA_MULTIPLE_CDC_BOUNDARY, DELTA_MULTIPLE_CONF_FOR_SINGLE_COLUMN_IN_BLOOM_FILTER, REPEATED_CLAUSE

42616

Invalid options specified

DELTA_ILLEGAL_OPTION, DELTA_INVALID_IDEMPOTENT_WRITES_OPTIONS, DELTA_UNSET_NON_EXISTENT_PROPERTY, UNSUPPORTED_INITIAL_POSITION_AND_TRIGGER_PAIR_FOR_KINESIS_SOURCE

42617

The statement string is blank or empty.

PARSE_EMPTY_STATEMENT

42621

The check constraint or generated column expression is invalid.

DELTA_AGGREGATE_IN_GENERATED_COLUMN, DELTA_INVALID_GENERATED_COLUMN_REFERENCES, DELTA_NON_BOOLEAN_CHECK_CONSTRAINT, DELTA_UDF_IN_GENERATED_COLUMN, DELTA_UNSUPPORTED_EXPRESSION_GENERATED_COLUMN

42701

The same target is specified more than once for assignment in the same SQL statement.

DELTA_CONFLICT_SET_COLUMN, DELTA_DUPLICATE_COLUMNS_ON_INSERT, DELTA_DUPLICATE_COLUMNS_ON_UPDATE_TABLE

42702

A column reference is ambiguous, because of duplicate names.

AMBIGUOUS_COLUMN_OR_FIELD, AMBIGUOUS_LATERAL_COLUMN_ALIAS, DELTA_AMBIGUOUS_PARTITION_COLUMN, EXCEPT_OVERLAPPING_COLUMNS

42703

An undefined column or parameter name was detected.

COLUMN_NOT_FOUND, DELTA_BLOOM_FILTER_DROP_ON_NON_EXISTING_COLUMNS, DELTA_CANNOT_CREATE_BLOOM_FILTER_NON_EXISTING_COL, DELTA_CANNOT_DROP_BLOOM_FILTER_ON_NON_INDEXED_COLUMN, DELTA_CANNOT_RESOLVE_COLUMN, DELTA_COLUMN_MAPPING_MAX_COLUMN_ID_NOT_SET, DELTA_COLUMN_MAPPING_MAX_COLUMN_ID_NOT_SET_CORRECTLY, DELTA_COLUMN_NOT_FOUND, DELTA_COLUMN_NOT_FOUND_IN_MERGE, DELTA_COLUMN_NOT_FOUND_IN_SCHEMA, DELTA_FAILED_FIND_ATTRIBUTE_IN_OUTPUT_COLUMNS, DELTA_MISSING_COLUMN, DELTA_MISSING_SET_COLUMN, DELTA_PARTITION_COLUMN_NOT_FOUND, DELTA_ZORDERING_COLUMN_DOES_NOT_EXIST, EXCEPT_RESOLVED_COLUMNS_WITHOUT_MATCH, EXCEPT_UNRESOLVED_COLUMN_IN_STRUCT_EXPANSION, UNRESOLVED_COLUMN, UNRESOLVED_FIELD, UNRESOLVED_MAP_KEY, UNRESOLVED_USING_COLUMN_FOR_JOIN, ZORDERBY_COLUMN_DOES_NOT_EXIST

42704

An undefined object or constraint name was detected.

AMBIGUOUS_REFERENCE, DEFAULT_DATABASE_NOT_EXISTS, DELTA_COLUMN_PATH_NOT_NESTED, DELTA_CONSTRAINT_DOES_NOT_EXIST, FIELD_NOT_FOUND, INDEX_NOT_FOUND, SCHEMA_NOT_FOUND, UC_VOLUME_NOT_FOUND, UNRECOGNIZED_SQL_TYPE

42710

A duplicate object or constraint name was detected.

ALTER_TABLE_COLUMN_DESCRIPTOR_DUPLICATE, CREATE_TABLE_COLUMN_DESCRIPTOR_DUPLICATE, DELTA_CONSTRAINT_ALREADY_EXISTS, INDEX_ALREADY_EXISTS, LOCATION_ALREADY_EXISTS

42711

A duplicate column name was detected in the object definition or ALTER TABLE statement.

COLUMN_ALREADY_EXISTS, DELTA_DUPLICATE_COLUMNS_FOUND, DELTA_TABLE_ALREADY_CONTAINS_CDC_COLUMNS, DUPLICATE_ROUTINE_RETURNS_COLUMNS

42723

A routine with the same signature already exists in the schema, module, or compound block where it is defined.

ROUTINE_ALREADY_EXISTS

42734

A duplicate parameter-name, SQL variable name, label, or condition-name was detected.

DUPLICATE_ROUTINE_PARAMETER_NAMES

4274K

Invalid use of a named argument when invoking a routine.

DUPLICATE_ROUTINE_PARAMETER_ASSIGNMENT, READ_FILES_AMBIGUOUS_ROUTINE_PARAMETERS, READ_TVF_UNEXPECTED_REQUIRED_PARAMETER, REQUIRED_PARAMETER_NOT_FOUND, UNEXPECTED_POSITIONAL_ARGUMENT, UNKNOWN_POSITIONAL_ARGUMENT

42802

The number of target values is not the same as the number of source values.

DELTA_INSERT_COLUMN_ARITY_MISMATCH, DELTA_INSERT_COLUMN_MISMATCH

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

42806

A value cannot be assigned to a variable, because the data types are not compatible.

DELTA_MERGE_INCOMPATIBLE_DECIMAL_TYPE

42807

The data-change statement is not permitted on this object.

DELTA_CHANGE_TABLE_FEED_DISABLED, DELTA_UNSUPPORTED_WRITES_STAGED_TABLE

42809

The identified object is not the type of object to which the statement applies.

DELTA_CANNOT_DESCRIBE_VIEW_HISTORY, DELTA_CANNOT_MODIFY_APPEND_ONLY, DELTA_SHOW_PARTITION_IN_NON_PARTITIONED_TABLE, DELTA_TABLE_NOT_SUPPORTED_IN_OP, DELTA_UNSUPPORTED_DESCRIBE_DETAIL_VIEW, FORBIDDEN_OPERATION, INVALID_DEST_CATALOG, INVALID_SOURCE_CATALOG, INVALID_UPGRADE_SYNTAX

42816

A datetime value or duration in an expression is invalid.

DELTA_TIMESTAMP_GREATER_THAN_COMMIT, DELTA_TIMESTAMP_INVALID

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

42830

The foreign key does not conform to the description of the parent key.

FOREIGN_KEY_MISMATCH

42832

The operation is not allowed on system objects.

BUILT_IN_CATALOG, CANNOT_DELETE_SYSTEM_OWNED, EVENT_LOG_UNSUPPORTED_TABLE_TYPE, MODIFY_BUILTIN_CATALOG, SAMPLE_TABLE_PERMISSIONS

42837

The column cannot be altered, because its attributes are not compatible with the current column attributes.

DELTA_ALTER_TABLE_CHANGE_COL_NOT_SUPPORTED

42846

Cast from source type to target type is not supported.

CANNOT_CAST_DATATYPE, DELTA_UPDATE_SCHEMA_MISMATCH_EXPRESSION

42852

The privileges specified in GRANT or REVOKE are invalid or inconsistent. (For example, GRANT ALTER on a view.)

INVALID_PRIVILEGE

42883

No routine was found with a matching signature.

ROUTINE_NOT_FOUND, UNRESOLVED_ROUTINE

42887

The function or table-reference is not valid in the context where it occurs.

CYCLIC_FUNCTION_REFERENCE, NOT_A_SCALAR_FUNCTION, NOT_A_TABLE_FUNCTION

42891

A duplicate constraint already exists.

MULTIPLE_MATCHING_CONSTRAINTS

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.

DELTA_CANNOT_USE_ALL_COLUMNS_FOR_PARTITION, PARTITIONS_ALREADY_EXIST, PARTITIONS_NOT_FOUND

428GU

A table must include at least one column that is not implicitly hidden.

DELTA_EMPTY_DATA, DELTA_READ_TABLE_WITHOUT_COLUMNS, DELTA_TARGET_TABLE_FINAL_SCHEMA_EMPTY

428H2

Data type is not supported in the context where it is being used.

EXCEPT_NESTED_COLUMN_INVALID_TYPE

42903

Invalid use of an aggregate function or OLAP function.

DELTA_AGGREGATION_NOT_SUPPORTED, GROUP_BY_AGGREGATE, GROUP_BY_POS_AGGREGATE, INVALID_WHERE_CONDITION

42908

The statement does not include a required column list.

DELTA_SCHEMA_NOT_PROVIDED

42939

The name cannot be used, because the specified identifier is reserved for system use.

DELTA_CANNOT_CHANGE_PROVIDER, DELTA_CANNOT_MODIFY_TABLE_PROPERTY, RESERVED_CDC_COLUMNS_ON_WRITE, ROUTINE_USES_SYSTEM_RESERVED_CLASS_NAME

42996

A specified column may not be used in a partition key.

DELTA_INVALID_PARTITION_COLUMN, DELTA_INVALID_PARTITION_COLUMN_NAME, DELTA_INVALID_PARTITION_COLUMN_TYPE

429BB

The data type of a column, parameter, or SQL variable is not supported.

CANNOT_RECOGNIZE_HIVE_TYPE

429BQ

The specified alter of the data type or attribute is not allowed.

DELTA_CANNOT_CHANGE_DATA_TYPE, DELTA_CANNOT_UPDATE_ARRAY_FIELD, DELTA_CANNOT_UPDATE_MAP_FIELD, DELTA_CANNOT_UPDATE_OTHER_FIELD, DELTA_CANNOT_UPDATE_STRUCT_FIELD

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

CLOUD_FILE_SOURCE_FILE_NOT_FOUND, DEFAULT_FILE_NOT_FOUND, DELTA_CHANGE_DATA_FILE_NOT_FOUND, DELTA_CHECKPOINT_NON_EXIST_TABLE, DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_TXN_LOG, DELTA_EMPTY_DIRECTORY, DELTA_FILE_NOT_FOUND, DELTA_FILE_NOT_FOUND_DETAILED, DELTA_FILE_OR_DIR_NOT_FOUND, DELTA_FILE_TO_OVERWRITE_NOT_FOUND, DELTA_LOG_FILE_NOT_FOUND_FOR_STREAMING_SOURCE, DELTA_PATH_DOES_NOT_EXIST, DELTA_SHALLOW_CLONE_FILE_NOT_FOUND, DELTA_TRUNCATED_TRANSACTION_LOG, PATH_NOT_FOUND, RENAME_SRC_PATH_NOT_FOUND

42K04

Duplicate file

DELTA_FILE_ALREADY_EXISTS, DELTA_LOG_ALREADY_EXISTS, DELTA_PATH_EXISTS, FAILED_RENAME_PATH, FILE_IN_STAGING_PATH_ALREADY_EXISTS, PATH_ALREADY_EXISTS

42K05

Name is not valid

DELTA_INVALID_CHARACTERS_IN_COLUMN_NAME, DELTA_INVALID_CHARACTERS_IN_COLUMN_NAMES, DELTA_NESTED_FIELDS_NEED_RENAME, DELTA_NON_SINGLE_PART_NAMESPACE_FOR_CATALOG, INVALID_EMPTY_LOCATION, REQUIRES_SINGLE_PART_NAMESPACE

42K06

Invalid type for options

DELTA_PROTOCOL_PROPERTY_NOT_INT, INVALID_OPTIONS

42K07

Not a valid schema literal

INVALID_SCHEMA

42K08

Not a constant

ARGUMENT_NOT_CONSTANT, NON_LITERAL_PIVOT_VALUES

42K09

Data type mismatch

DATATYPE_MISMATCH, DELTA_GENERATED_COLUMNS_DATA_TYPE_MISMATCH, DELTA_GENERATED_COLUMNS_EXPR_TYPE_MISMATCH, DELTA_GENERATED_COLUMN_UPDATE_TYPE_MISMATCH, DELTA_NOT_NULL_COLUMN_NOT_FOUND_IN_STRUCT, 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

42K0C

Ambiguous reference to constraint

AMBIGUOUS_CONSTRAINT, CANNOT_DROP_AMBIGUOUS_CONSTRAINT

42KD1

Operation not supported in READ ONLY session mode

OP_NOT_SUPPORTED_READ_ONLY

42KD2

The source and target table names of a SYNC operaton must be the same.

SYNC_SRC_TARGET_TBL_NOT_SAME

42KD3

A column can not be added as specified

DELTA_ADD_COLUMN_AT_INDEX_LESS_THAN_ZERO, DELTA_ADD_COLUMN_PARENT_NOT_STRUCT, DELTA_ADD_COLUMN_STRUCT_NOT_FOUND

42KD4

Operation not supported because table schema has changed

DELTA_BLOCK_COLUMN_MAPPING_AND_CDC_OPERATION, DELTA_STREAMING_INCOMPATIBLE_SCHEMA_CHANGE, DELTA_STREAMING_INCOMPATIBLE_SCHEMA_CHANGE_USE_SCHEMA_LOG

42KD5

Cannot create file or path

DELTA_CANNOT_CREATE_LOG_PATH

42KD6

No partition information found

DELTA_CONVERSION_NO_PARTITION_FOUND, DELTA_MISSING_PARTITION_COLUMN, DELTA_MISSING_PART_FILES

42KD7

Table signature mismatch

DELTA_CREATE_TABLE_SCHEME_MISMATCH, DELTA_CREATE_TABLE_WITH_DIFFERENT_PARTITIONING, DELTA_CREATE_TABLE_WITH_DIFFERENT_PROPERTY, DELTA_SET_LOCATION_SCHEMA_MISMATCH

42KD8

Column position out of range

DELTA_DROP_COLUMN_AT_INDEX_LESS_THAN_ZERO, DELTA_INDEX_LARGER_OR_EQUAL_THAN_STRUCT, DELTA_INDEX_LARGER_THAN_STRUCT

42KD9

Cannot infer table schema

COPY_INTO_SOURCE_SCHEMA_INFERENCE_FAILED, DELTA_FAILED_INFER_SCHEMA, UNABLE_TO_INFER_SCHEMA, UNABLE_TO_INFER_SCHEMA_WITH_COLON_IN_FILENAME

42KDA

Failed to merge file into table schema

DELTA_FAILED_MERGE_SCHEMA_FILE

42KDB

Invalid URL

DATA_SOURCE_URL_NOT_ALLOWED

42KDC

Archived file reference

DELTA_ARCHIVED_FILES_IN_LIMIT, DELTA_ARCHIVED_FILES_IN_SCAN

42P01

undefined_table

DELTA_CANNOT_REPLACE_MISSING_TABLE, DELTA_MISSING_DELTA_TABLE, DELTA_NO_RELATION_TABLE, DELTA_TABLE_NOT_FOUND, DELTA_TABLE_NOT_FOUND_STREAMING, TABLE_OR_VIEW_NOT_FOUND, TABLE_WITH_ID_NOT_FOUND, VIEW_NOT_FOUND

42P02

undefined_parameter

UNBOUND_SQL_PARAMETER

42P06

duplicate_schema

SCHEMA_ALREADY_EXISTS

42P07

duplicate_table

DELTA_TABLE_ALREADY_EXISTS, TABLE_OR_VIEW_ALREADY_EXISTS, TEMP_TABLE_OR_VIEW_ALREADY_EXISTS, VIEW_ALREADY_EXISTS

42P10

invalid_column_reference

DELTA_NON_PARTITION_COLUMN_REFERENCE, DELTA_NON_PARTITION_COLUMN_SPECIFIED, DELTA_SHOW_PARTITION_IN_NON_PARTITIONED_COLUMN, DELTA_ZORDERING_ON_PARTITION_COLUMN

42P18

indeterminate_datatype

DELTA_NULL_SCHEMA_IN_STREAMING_WRITE

42P20

windowing_error

UNSUPPORTED_EXPR_FOR_WINDOW

Class 44: with check option violation

SQLSTATE

Description and issuing error classes

44000

with check option violation

DELTA_REPLACE_WHERE_MISMATCH

Class 46: java ddl 1

SQLSTATE

Description and issuing error classes

46110

unsupported feature

CANNOT_MODIFY_CONFIG

46121

invalid column name

INVALID_COLUMN_NAME_AS_PATH

Class 53: insufficient resources

SQLSTATE

Description and issuing error classes

53200

out_of_memory

UNABLE_TO_ACQUIRE_MEMORY

Class 54: program limit exceeded

SQLSTATE

Description and issuing error classes

54000

program limit exceeded

GROUPING_SIZE_LIMIT_EXCEEDED, TOO_MANY_ARRAY_ELEMENTS

54KD0

Maximum UDF count in query plan exceeded.

UDF_MAX_COUNT_EXCEEDED

Class 55: object not in prerequisite state

SQLSTATE

Description and issuing error classes

55019

The object is in an invalid state for the operation.

EVENT_LOG_UNAVAILABLE, MATERIALIZED_VIEW_MESA_REFRESH_WITHOUT_PIPELINE_ID, STREAMING_TABLE_NEEDS_REFRESH

Class 57: operator intervention

SQLSTATE

Description and issuing error classes

57012

A non-database resource is not available. This will not affect the successful execution of subsequent statements.

REMOTE_FUNCTION_HTTP_FAILED_ERROR, REMOTE_FUNCTION_HTTP_RETRY_TIMEOUT

Class F0: configuration file error

SQLSTATE

Description and issuing error classes

F0000

configuration file error

DELTA_INCONSISTENT_LOGSTORE_CONFS, DELTA_INVALID_LOGSTORE_CONF, DELTA_UNKNOWN_CONFIGURATION

Class KD: datasource specific errors

SQLSTATE

Description and issuing error classes

KD001

Cannot read file footer

DELTA_FAILED_READ_FILE_FOOTER

KD002

Unexpected version

DELTA_FAILED_SCAN_WITH_HISTORICAL_VERSION, DELTA_MISSING_CHANGE_DATA, DELTA_STREAMING_CANNOT_CONTINUE_PROCESSING_POST_SCHEMA_EVOLUTION, DELTA_STREAMING_CHECK_COLUMN_MAPPING_NO_SNAPSHOT

KD003

Incorrect access to data type

CANNOT_READ_ARCHIVED_FILE, CANNOT_READ_FILE, DELTA_FOUND_MAP_TYPE_COLUMN, DELTA_INCORRECT_ARRAY_ACCESS, DELTA_INCORRECT_ARRAY_ACCESS_BY_NAME, UNKNOWN_FIELD_EXCEPTION

KD004

Delta protocol version error

DELTA_INVALID_PROTOCOL_DOWNGRADE, DELTA_INVALID_PROTOCOL_VERSION, DELTA_READ_FEATURE_PROTOCOL_REQUIRES_WRITE, DELTA_UNSUPPORTED_COLUMN_MAPPING_PROTOCOL

KD005

Table must include at least one non partition column

DELTA_NON_PARTITION_COLUMN_ABSENT

KD006

No commits found at log path

DELTA_NO_COMMITS_FOUND, DELTA_NO_RECREATABLE_HISTORY_FOUND

KD007

Table signature changed

DELTA_SCHEMA_CHANGED, DELTA_SCHEMA_CHANGED_WITH_STARTING_OPTIONS, DELTA_SCHEMA_CHANGED_WITH_VERSION, DELTA_SCHEMA_CHANGE_SINCE_ANALYSIS

KD008

Table signature not set

DELTA_SCHEMA_NOT_SET

KD009

Partitions do not match

DELTA_UNEXPECTED_NUM_PARTITION_COLUMNS_FROM_FILE_NAME, DELTA_UNEXPECTED_PARTITION_COLUMN_FROM_FILE_NAME, DELTA_UNEXPECTED_PARTITION_SCHEMA_FROM_USER

KD00A

Unexpected partial scan

DELTA_UNEXPECTED_PARTIAL_SCAN

KD00B

Unrecognised file

DELTA_UNRECOGNIZED_LOGFILE

KD00C

Versioning not contiguous

DELTA_VERSIONS_NOT_CONTIGUOUS

KD00D

Stats required

DELTA_ZORDERING_ON_COLUMN_WITHOUT_STATS

Class XX: internal error

SQLSTATE

Description and issuing error classes

XX000

internal error

INTERNAL_ERROR, QUERY_RESULT_PARSE_AS_ARROW_FAILED, QUERY_RESULT_READ_FROM_CLOUD_STORE_FAILED, QUERY_RESULT_WRITE_TO_CLOUD_STORE_FAILED, STREAMING_TABLE_OPERATION_INTERNAL_ERROR

XXKD0

Analysis - Bad plan

INVALID_SQL_FUNCTION_PLAN_STRUCTURE

XXKDS

Delta Storage

DELTA_CANNOT_CONVERT_TO_FILEFORMAT, DELTA_CANNOT_FIND_VERSION, DELTA_CANNOT_GENERATE_UPDATE_EXPRESSIONS, DELTA_CANNOT_RESOLVE_SOURCE_COLUMN, DELTA_CANNOT_SET_LOCATION_MULTIPLE_TIMES, DELTA_CHECKPOINT_SNAPSHOT_MISMATCH, DELTA_DELETION_VECTOR_CHECKSUM_MISMATCH, DELTA_DELETION_VECTOR_INVALID_ROW_INDEX, DELTA_DELETION_VECTOR_SIZE_MISMATCH, DELTA_EXPRESSIONS_NOT_FOUND_IN_GENERATED_COLUMN, DELTA_EXTRACT_REFERENCES_FIELD_NOT_FOUND, DELTA_FAILED_FIND_PARTITION_COLUMN_IN_OUTPUT_PLAN, DELTA_FAIL_RELATIVIZE_PATH, DELTA_ILLEGAL_FILE_FOUND, DELTA_INVALID_COMMITTED_VERSION, DELTA_INVALID_FORMAT_FROM_SOURCE_VERSION, DELTA_INVALID_PARTITIONING_SCHEMA, DELTA_INVALID_SOURCE_VERSION, DELTA_INVALID_V1_TABLE_CALL, DELTA_ITERATOR_ALREADY_CLOSED, DELTA_METADATA_ABSENT, DELTA_MISSING_FILES_UNEXPECTED_VERSION, DELTA_NON_GENERATED_COLUMN_MISSING_UPDATE_EXPR, DELTA_NO_NEW_ATTRIBUTE_ID, DELTA_REMOVE_FILE_CDC_MISSING_EXTENDED_METADATA, DELTA_SCHEMA_NOT_CONSISTENT_WITH_TARGET, DELTA_SPARK_SESSION_NOT_SET, DELTA_SPARK_THREAD_NOT_FOUND, DELTA_STATE_RECOVER_ERROR, DELTA_TABLE_FOUND_IN_EXECUTOR, DELTA_TXN_LOG_FAILED_INTEGRITY, DELTA_UNEXPECTED_ACTION_IN_OPTIMIZE, DELTA_UNEXPECTED_ALIAS, DELTA_UNEXPECTED_ATTRIBUTE_REFERENCE, DELTA_UNEXPECTED_CHANGE_FILES_FOUND, DELTA_UNEXPECTED_PROJECT, DELTA_UNRECOGNIZED_FILE_ACTION

XXKUC

Catalog Service (Unity Catalog)

UNKNOWN_TABLE_TYPE