SQLSTATE error codes

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

All 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.

Where neccessary Spark and Databricks use the 'KD' class and 'K**' subclass ranges for custom SQLSTATEs. The class 'XX' is used for internal errors warranting a bug report.

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

Databricks uses the following SQLSTATE classes:

Class 07: dynamic SQL error

SQLSTATE

Description and issuing error classes

07001

using clause does not match dynamic parameter specifications

ALL_PARAMETERS_MUST_BE_NAMED, FUNCTION_PARAMETERS_MUST_BE_NAMED

07501

The option specified on PREPARE or EXECUTE is not valid.

INVALID_STATEMENT_FOR_EXECUTE_INTO, NESTED_EXECUTE_IMMEDIATE

Class 08: connection exception

SQLSTATE

Description and issuing error classes

08000

connection exception

AI_FUNCTION_HTTP_REQUEST_ERROR, AI_FUNCTION_INVALID_HTTP_RESPONSE, CANNOT_VALIDATE_CONNECTION

08001

SQL-client unable to establish SQL-connection

CANNOT_ESTABLISH_CONNECTION, CANNOT_ESTABLISH_CONNECTION_SERVERLESS

08003

connection does not exist

DELTA_ACTIVE_SPARK_SESSION_NOT_FOUND

08KD1

server busy

SERVER_IS_BUSY

Class 0A: feature not supported

SQLSTATE

Description and issuing error classes

0A000

feature not supported

AI_FUNCTION_UNSUPPORTED_REQUEST, AI_FUNCTION_UNSUPPORTED_RETURN_TYPE, AI_QUERY_RETURN_TYPE_COLUMN_TYPE_MISMATCH, AI_SEARCH_EMBEDDING_COLUMN_TYPE_UNSUPPORTED_ERROR, AI_SEARCH_INDEX_TYPE_UNSUPPORTED_ERROR, AI_SEARCH_UNSUPPORTED_NUM_RESULTS_ERROR, ANALYZE_CONSTRAINTS_NOT_SUPPORTED, AVRO_DEFAULT_VALUES_UNSUPPORTED, AVRO_POSITIONAL_FIELD_MATCHING_UNSUPPORTED, CANNOT_INVOKE_IN_TRANSFORMATIONS, CANNOT_SAVE_VARIANT, CANNOT_UPDATE_FIELD, CF_ADD_NEW_NOT_SUPPORTED, CF_EVENT_NOTIFICATION_NOT_SUPPORTED, CF_PERIODIC_BACKFILL_NOT_SUPPORTED, CF_SOURCE_UNSUPPORTED, CF_UNSUPPORTED_CLOUD_FILES_SQL_FUNCTION, CF_UNSUPPORTED_FORMAT_FOR_SCHEMA_INFERENCE, CF_UNSUPPORTED_LOG_VERSION, CF_UNSUPPORTED_SCHEMA_EVOLUTION_MODE, CLASS_UNSUPPORTED_BY_MAP_OBJECTS, CLEANROOM_COMMANDS_NOT_SUPPORTED, CLUSTER_BY_AUTO_FEATURE_NOT_ENABLED, COLUMN_MASKS_CHECK_CONSTRAINT_UNSUPPORTED, COLUMN_MASKS_FEATURE_NOT_SUPPORTED, COLUMN_MASKS_INCOMPATIBLE_SCHEMA_CHANGE, COLUMN_MASKS_MERGE_UNSUPPORTED_SOURCE, COLUMN_MASKS_MERGE_UNSUPPORTED_TARGET, COLUMN_MASKS_REQUIRE_UNITY_CATALOG, COLUMN_MASKS_TABLE_CLONE_SOURCE_NOT_SUPPORTED, COLUMN_MASKS_TABLE_CLONE_TARGET_NOT_SUPPORTED, COLUMN_MASKS_UNSUPPORTED_PROVIDER, COLUMN_MASKS_UNSUPPORTED_SUBQUERY, CONCURRENT_QUERY, 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, COPY_INTO_UNSUPPORTED_FEATURE, CREATE_OR_REFRESH_MV_ST_ASYNC, CREATE_PERMANENT_VIEW_WITHOUT_ALIAS, CSV_ENFORCE_SCHEMA_NOT_SUPPORTED, DC_UNSUPPORTED_ERROR, DELTA_ADDING_DELETION_VECTORS_DISALLOWED, DELTA_ADD_CONSTRAINTS, DELTA_CANNOT_WRITE_INTO_VIEW, DELTA_CLUSTERING_CLONE_TABLE_NOT_SUPPORTED, DELTA_CLUSTERING_SHOW_CREATE_TABLE_WITHOUT_CLUSTERING_COLUMNS, DELTA_CLUSTERING_WITH_PARTITION_PREDICATE, DELTA_DOMAIN_METADATA_NOT_SUPPORTED, DELTA_DYNAMIC_PARTITION_OVERWRITE_DISABLED, 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_UNIFORM_INGRESS_NOT_SUPPORTED, 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, DISTINCT_WINDOW_FUNCTION_UNSUPPORTED, EXTERNAL_TABLE_INVALID_SCHEME, FABRIC_REFRESH_INVALID_SCOPE, FROM_JSON_INFERENCE_NOT_SUPPORTED, H3_NOT_ENABLED, INFINITE_STREAMING_TRIGGER_NOT_SUPPORTED, INVALID_PANDAS_UDF_PLACEMENT, INVALID_PARTITION_COLUMN_DATA_TYPE, MATERIALIZED_VIEW_OUTPUT_WITHOUT_EXPLICIT_ALIAS, MATERIALIZED_VIEW_UNSUPPORTED_OPERATION, METRIC_CONSTRAINT_NOT_SUPPORTED, MULTI_UDF_INTERFACE_ERROR, NAMED_PARAMETERS_NOT_SUPPORTED_FOR_SQL_UDFS, NAMED_PARAMETER_SUPPORT_DISABLED, NOT_SUPPORTED_CHANGE_COLUMN, NOT_SUPPORTED_COMMAND_FOR_V2_TABLE, NOT_SUPPORTED_COMMAND_WITHOUT_HIVE_SUPPORT, NOT_SUPPORTED_IN_JDBC_CATALOG, NOT_SUPPORTED_WITH_DB_SQL, NOT_SUPPORTED_WITH_SERVERLESS, ONLY_SUPPORTED_WITH_UC_SQL_CONNECTOR, PROCEDURE_CREATION_EMPTY_ROUTINE, PROCEDURE_NOT_SUPPORTED, PROCEDURE_NOT_SUPPORTED_WITH_HMS, PROTOBUF_JAVA_CLASSES_NOT_SUPPORTED, PS_SPARK_SPECULATION_NOT_SUPPORTED, PS_UNSUPPORTED_GET_OFFSET_CALL, RECIPIENT_EXPIRATION_NOT_SUPPORTED, RESTRICTED_STREAMING_OPTION_PERMISSION_ENFORCED, ROW_LEVEL_SECURITY_CHECK_CONSTRAINT_UNSUPPORTED, ROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTED, ROW_LEVEL_SECURITY_INCOMPATIBLE_SCHEMA_CHANGE, ROW_LEVEL_SECURITY_MERGE_UNSUPPORTED_SOURCE, ROW_LEVEL_SECURITY_MERGE_UNSUPPORTED_TARGET, ROW_LEVEL_SECURITY_REQUIRE_UNITY_CATALOG, ROW_LEVEL_SECURITY_TABLE_CLONE_SOURCE_NOT_SUPPORTED, ROW_LEVEL_SECURITY_TABLE_CLONE_TARGET_NOT_SUPPORTED, ROW_LEVEL_SECURITY_UNSUPPORTED_PROVIDER, SCALAR_SUBQUERY_IS_IN_GROUP_BY_OR_AGGREGATE_FUNCTION, STAR_GROUP_BY_POS, STREAMING_AQE_NOT_SUPPORTED_FOR_STATEFUL_OPERATORS, STREAMING_FROM_MATERIALIZED_VIEW, ST_NOT_ENABLED, ST_UNSUPPORTED_RETURN_TYPE, TABLE_VALUED_ARGUMENTS_NOT_YET_IMPLEMENTED_FOR_SQL_FUNCTIONS, UC_HIVE_METASTORE_FEDERATION_NOT_ENABLED, UDF_PYSPARK_UNSUPPORTED_TYPE, UDF_UNSUPPORTED_PARAMETER_DEFAULT_VALUE, UDTF_PYSPARK_NOT_SUPPORTED, UNSUPPORTED_ADD_FILE, UNSUPPORTED_ARROWTYPE, UNSUPPORTED_CALL, UNSUPPORTED_CHAR_OR_VARCHAR_AS_STRING, UNSUPPORTED_CLAUSE_FOR_OPERATION, UNSUPPORTED_COLLATION, UNSUPPORTED_CONSTRAINT_CLAUSES, UNSUPPORTED_DATASOURCE_FOR_DIRECT_QUERY, UNSUPPORTED_DATATYPE, UNSUPPORTED_DATA_SOURCE_SAVE_MODE, UNSUPPORTED_DATA_TYPE_FOR_DATASOURCE, UNSUPPORTED_DATA_TYPE_FOR_ENCODER, UNSUPPORTED_DEFAULT_VALUE, UNSUPPORTED_DESERIALIZER, UNSUPPORTED_FEATURE, UNSUPPORTED_FN_TYPE, UNSUPPORTED_NESTED_ROW_OR_COLUMN_ACCESS_POLICY, UNSUPPORTED_SAVE_MODE, UNSUPPORTED_STREAMING_OPTIONS_FOR_VIEW, UNSUPPORTED_STREAMING_OPTIONS_PERMISSION_ENFORCED, UNSUPPORTED_STREAMING_SINK_PERMISSION_ENFORCED, UNSUPPORTED_STREAMING_SOURCE_PERMISSION_ENFORCED, UNSUPPORTED_STREAM_READ_LIMIT_FOR_KINESIS_SOURCE, UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY, UNSUPPORTED_TIMESERIES_WITH_MORE_THAN_ONE_COLUMN, 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_SCHEMA, CANNOT_SHALLOW_CLONE_ACROSS_UC_AND_HMS

0AKD1

Security feature not supported

COLUMN_MASKS_UNSUPPORTED_CONSTANT_AS_PARAMETER, ROW_LEVEL_SECURITY_UNSUPPORTED_CONSTANT_AS_PARAMETER

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_COLLATIONS_NOT_SUPPORTED, DELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_PARTITIONED_COLUMN, DELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_TYPE, DELTA_CONVERSION_UNSUPPORTED_COLUMN_MAPPING, DELTA_CONVERT_NON_PARQUET_TABLE, DELTA_CREATE_TABLE_IDENTIFIER_LOCATION_MISMATCH, DELTA_DROP_COLUMN_ON_SINGLE_FIELD_SCHEMA, 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_OPERATION_NOT_SUPPORTED_FOR_COLUMN_WITH_COLLATION, DELTA_OPERATION_NOT_SUPPORTED_FOR_EXPRESSION_WITH_COLLATION, DELTA_OPERATION_ON_VIEW_NOT_ALLOWED, DELTA_TABLE_FOR_PATH_UNSUPPORTED_HADOOP_CONF, DELTA_TRUNCATE_TABLE_PARTITION_NOT_SUPPORTED, DELTA_UNIFORM_INGRESS_NOT_SUPPORTED_FORMAT, DELTA_UNIFORM_NOT_SUPPORTED, DELTA_UNSUPPORTED_ABS_PATH_ADD_FILE, DELTA_UNSUPPORTED_ALTER_TABLE_CHANGE_COL_OP, 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_COMMENT_MAP_ARRAY, DELTA_UNSUPPORTED_DATA_TYPES, DELTA_UNSUPPORTED_DROP_CLUSTERING_COLUMN, 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_TYPE_CHANGE_IN_SCHEMA, DELTA_UNSUPPORTED_VACUUM_SPECIFIC_PARTITION, WRONG_COLUMN_DEFAULTS_FOR_DELTA_ALTER_TABLE_ADD_COLUMN_NOT_SUPPORTED

0AKDD

Feature requires Delta

DELTA_COPY_INTO_TARGET_FORMAT, DELTA_NOT_A_DELTA_TABLE, DELTA_ONLY_OPERATION, DELTA_TABLE_ONLY_OPERATION, DELTA_UNSUPPORTED_SOURCE, DELTA_UNSUPPORTED_STATIC_PARTITIONS, SYNC_METADATA_DELTA_ONLY, UNSUPPORTED_MANAGED_TABLE_CREATION

0AKDE

Feature non enabled for this Delta table

DELTA_CANNOT_DROP_CHECK_CONSTRAINT_FEATURE, DELTA_CLUSTERING_PHASE_OUT_FAILED, DELTA_DATA_CHANGE_FALSE, DELTA_FEATURES_PROTOCOL_METADATA_MISMATCH, DELTA_FEATURES_REQUIRE_MANUAL_ENABLEMENT, DELTA_FEATURE_DROP_CONFLICT_REVALIDATION_FAIL, DELTA_FEATURE_DROP_DEPENDENT_FEATURE, DELTA_FEATURE_DROP_FEATURE_NOT_PRESENT, DELTA_FEATURE_DROP_HISTORICAL_VERSIONS_EXIST, DELTA_FEATURE_DROP_HISTORY_TRUNCATION_NOT_ALLOWED, DELTA_FEATURE_DROP_NONREMOVABLE_FEATURE, DELTA_FEATURE_DROP_UNSUPPORTED_CLIENT_FEATURE, DELTA_FEATURE_DROP_WAIT_FOR_RETENTION_PERIOD, 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_COMMAND_NOT_SUPPORTED_IN_SHARED_ACCESS_MODE, UC_CREDENTIAL_PURPOSE_NOT_SUPPORTED, UC_DATASOURCE_NOT_SUPPORTED, UC_DATASOURCE_OPTIONS_NOT_SUPPORTED, UC_FAILED_PROVISIONING_STATE, UC_FILE_SCHEME_FOR_TABLE_CREATION_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 0N: SQL/XML mapping error

SQLSTATE

Description and issuing error classes

0N000

SQL/XML mapping error

XML_UNSUPPORTED_NESTED_TYPES

Class 21: cardinality violation

SQLSTATE

Description and issuing error classes

21000

cardinality violation

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

21S01

Insert value list does not match column list

COPY_INTO_COLUMN_ARITY_MISMATCH, CREATE_VIEW_COLUMN_ARITY_MISMATCH, INSERT_COLUMN_ARITY_MISMATCH, INSERT_PARTITION_COLUMN_ARITY_MISMATCH

Class 22: data exception

SQLSTATE

Description and issuing error classes

22000

data exception

AI_FUNCTION_JSON_PARSE_ERROR, CF_BUCKET_MISMATCH, CF_CANNOT_EVOLVE_SCHEMA_LOG_EMPTY, CF_CANNOT_PARSE_QUEUE_MESSAGE, 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_INVALID_MANAGED_FILE_EVENTS_RESPONSE, CF_LATEST_OFFSET_READ_LIMIT_REQUIRED, CF_LOG_FILE_MALFORMED, CF_MANAGED_FILE_EVENTS_BACKFILL_IN_PROGRESS, 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_UNEXPECTED_READ_LIMIT, CF_UNKNOWN_READ_LIMIT, DELTA_CANNOT_FIND_BUCKET_SPEC, DELTA_CLUSTERING_COLUMN_MISSING_STATS, DELTA_CLUSTERING_CREATE_EXTERNAL_NON_LIQUID_TABLE_FROM_LIQUID_TABLE, DELTA_COMPACTION_VALIDATION_FAILED, DELTA_CONVERT_TO_DELTA_ROW_TRACKING_WITHOUT_STATS, DELTA_DV_HISTOGRAM_DESERIALIZATON, DELTA_INVALID_FORMAT, DELTA_INVALID_TABLE_VALUE_FUNCTION, DELTA_MATERIALIZED_ROW_TRACKING_COLUMN_NAME_MISSING, DELTA_ROW_ID_ASSIGNMENT_WITHOUT_STATS, DELTA_STREAMING_METADATA_EVOLUTION, DELTA_STREAMING_SCHEMA_EVOLUTION_UNSUPPORTED_ROW_FILTER_COLUMN_MASKS, 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_METADATA, DELTA_STREAMING_SCHEMA_LOG_PARSE_SCHEMA_FAILED, DELTA_VACUUM_COPY_INTO_STATE_FAILED, HLL_UNION_DIFFERENT_LG_K, INVALID_TIMESTAMP_FORMAT, KAFKA_DATA_LOSS, KINESIS_COULD_NOT_READ_SHARD_UNTIL_END_OFFSET, KINESIS_RECORD_SEQ_NUMBER_ORDER_VIOLATION, PS_FETCH_RETRY_EXCEPTION, PS_INVALID_KEY_TYPE, PS_INVALID_UNSAFE_ROW_CONVERSION_FROM_PROTO, PS_MOVING_CHECKPOINT_FAILURE, PS_MULTIPLE_FAILED_EPOCHS, PS_OPTION_NOT_IN_BOUNDS, PS_UNABLE_TO_PARSE_PROTO, 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_EARLIER, DELTA_CANNOT_RESTORE_TIMESTAMP_GREATER, DELTA_CAST_OVERFLOW_IN_TABLE_WRITE, DELTA_INVALID_CDC_RANGE, INCORRECT_RAMP_UP_RATE, INVALID_ARRAY_INDEX, INVALID_ARRAY_INDEX_IN_ELEMENT_AT, INVALID_BITMAP_POSITION, INVALID_BOUNDARY, INVALID_INDEX_OF_ZERO, INVALID_NUMERIC_LITERAL_RANGE, NUMERIC_OUT_OF_SUPPORTED_RANGE, NUMERIC_VALUE_OUT_OF_RANGE, SUM_OF_LIMIT_AND_OFFSET_EXCEEDS_MAX_INT

22004

null value not allowed

COMPARATOR_RETURNS_NULL, NULL_QUERY_STRING_EXECUTE_IMMEDIATE

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

CANNOT_PARSE_INTERVAL, DELTA_INVALID_INTERVAL, INVALID_INTERVAL_FORMAT

22007

invalid datetime format

CANNOT_PARSE_TIMESTAMP, DELTA_INVALID_TIMESTAMP_FORMAT, INVALID_DATETIME_PATTERN

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, CANNOT_PARSE_PROTOBUF_DESCRIPTOR, CAST_INVALID_INPUT, CONVERSION_INVALID_INPUT, DELTA_FAILED_CAST_PARTITION_VALUE, FAILED_PARSE_STRUCT_TYPE

2201B

invalid regular expression

DELTA_REGEX_OPT_SYNTAX_ERROR

2201E

invalid argument for natural logarithm

STRUCT_ARRAY_LENGTH_MISMATCH

22022

indicator overflow

INVALID_CONF_VALUE

22023

invalid parameter value

CONFLICTING_PROVIDER, DELTA_INVALID_AUTO_COMPACT_TYPE, DELTA_INVALID_BUCKET_COUNT, DELTA_INVALID_BUCKET_INDEX, DELTA_UNSUPPORTED_STRATEGY_NAME, EMPTY_LOCAL_FILE_IN_STAGING_ACCESS_QUERY, EWKB_PARSE_ERROR, 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_MARKER_VALUE, INVALID_PARAMETER_VALUE, INVALID_VARIANT_CAST, INVALID_VARIANT_FROM_PARQUET, INVALID_VARIANT_GET_PATH, MALFORMED_RECORD_IN_PARSING, MALFORMED_VARIANT, MAX_RECORDS_PER_FETCH_INVALID_FOR_KINESIS_SOURCE, METRIC_STORE_INVALID_ARGUMENT_VALUE_ERROR, RULE_ID_NOT_FOUND, SECOND_FUNCTION_ARGUMENT_NOT_INTEGER, ST_DIFFERENT_SRID_VALUES, ST_INVALID_ARGUMENT, ST_INVALID_ARGUMENT_TYPE, ST_INVALID_CRS_TRANSFORMATION_ERROR, ST_INVALID_ENDIANNESS_VALUE, ST_INVALID_GEOHASH_VALUE, ST_INVALID_PRECISION_VALUE, ST_INVALID_SRID_VALUE, TABLE_VALUED_FUNCTION_REQUIRED_METADATA_INCOMPATIBLE_WITH_CALL, TABLE_VALUED_FUNCTION_REQUIRED_METADATA_INVALID, VARIANT_CONSTRUCTOR_SIZE_LIMIT, VARIANT_DUPLICATE_KEY, VARIANT_SIZE_LIMIT, WKB_PARSE_ERROR, WKT_PARSE_ERROR, XML_WILDCARD_RESCUED_DATA_CONFLICT_ERROR

22029

noncharacter in UCS string

INVALID_UTF8_STRING

22032

invalid JSON text

AI_FUNCTION_INVALID_MAX_WORDS, AI_INVALID_ARGUMENT_VALUE_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

AI_FUNCTION_HTTP_PARSE_CAST_ERROR, AI_FUNCTION_HTTP_PARSE_COLUMNS_ERROR, AI_FUNCTION_MODEL_SCHEMA_PARSE_ERROR, CANNOT_PARSE_JSON_FIELD, FAILED_ROW_TO_JSON, INVALID_JSON_DATA_TYPE, INVALID_JSON_DATA_TYPE_FOR_COLLATIONS

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, HLL_INVALID_INPUT_SKETCH_BUFFER, HLL_INVALID_LG_K

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

22KD3

Cannot evolve source type to target type.

AVRO_INCOMPATIBLE_READ_TYPE, FROM_JSON_SCHEMA_EVOLUTION_FAILED

22P02

invalid text representation

INVALID_URL

22P03

invalid binary representation

INVALID_BYTE_STRING

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

23K01

MERGE cardinality violation

MERGE_CARDINALITY_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_CONCURRENT_APPEND, DELTA_CONCURRENT_DELETE_DELETE, DELTA_CONCURRENT_DELETE_READ, DELTA_CONCURRENT_TRANSACTION, DELTA_CONCURRENT_WRITE, DELTA_DELETION_VECTOR_MISSING_NUM_RECORDS, DELTA_DUPLICATE_ACTIONS_FOUND, DELTA_METADATA_CHANGED, DELTA_PROTOCOL_CHANGED

2DKD0

Post commit hook failed.

DELTA_POST_COMMIT_HOOK_FAILED

Class 39: external routine invocation exception

SQLSTATE

Description and issuing error classes

39000

external routine invocation exception

FAILED_EXECUTE_UDF, FOREACH_BATCH_USER_FUNCTION_ERROR, 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

CONCURRENT_STREAM_LOG_UPDATE, 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_INTERNAL_ERROR, CF_INVALID_ARN, CF_INVALID_AZURE_CERTIFICATE, CF_INVALID_AZURE_CERT_PRIVATE_KEY, CF_INVALID_CHECKPOINT, CF_INVALID_CLEAN_SOURCE_MODE, CF_INVALID_GCP_RESOURCE_TAG_KEY, CF_INVALID_GCP_RESOURCE_TAG_VALUE, CF_INVALID_MANAGED_FILE_EVENTS_OPTION_KEYS, CF_INVALID_SCHEMA_EVOLUTION_MODE, CF_INVALID_SCHEMA_HINTS_OPTION, CF_INVALID_SCHEMA_HINT_COLUMN, CF_MANAGED_FILE_EVENTS_ENDPOINT_NOT_FOUND, CF_MANAGED_FILE_EVENTS_ENDPOINT_PERMISSION_DENIED, 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_READ_FILES, 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_STATE_INCORRECT_SQL_PARAMS, CF_STATE_INVALID_CHECKPOINT_PATH, CF_STATE_INVALID_VERSION, 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, COMMENT_ON_CONNECTION_NOT_IMPLEMENTED_YET, CONNECTION_ALREADY_EXISTS, CONNECTION_NAME_CANNOT_BE_EMPTY, CONNECTION_NOT_FOUND, CONNECTION_OPTION_NOT_SUPPORTED, CONNECTION_TYPE_NOT_SUPPORTED, CREATE_FOREIGN_SCHEMA_NOT_IMPLEMENTED_YET, CREATE_FOREIGN_TABLE_NOT_IMPLEMENTED_YET, DELTA_ADDING_COLUMN_WITH_INTERNAL_NAME_FAILED, DELTA_ADDING_DELETION_VECTORS_WITH_TIGHT_BOUNDS_DISALLOWED, DELTA_ALTER_TABLE_CLUSTER_BY_NOT_ALLOWED, DELTA_ALTER_TABLE_CLUSTER_BY_ON_PARTITIONED_TABLE_NOT_ALLOWED, DELTA_ALTER_TABLE_RENAME_NOT_ALLOWED, DELTA_ALTER_TABLE_SET_CLUSTERING_TABLE_FEATURE_NOT_ALLOWED, DELTA_CANNOT_RELATIVIZE_PATH, DELTA_CLONE_INCOMPLETE_FILE_COPY, DELTA_CLUSTERING_NOT_SUPPORTED, DELTA_CLUSTERING_REPLACE_TABLE_WITH_PARTITIONED_TABLE, DELTA_CLUSTERING_WITH_DYNAMIC_PARTITION_OVERWRITE, DELTA_CREATE_TABLE_SET_CLUSTERING_TABLE_FEATURE_NOT_ALLOWED, DELTA_INCONSISTENT_BUCKET_SPEC, DELTA_INCORRECT_GET_CONF, DELTA_INVALID_INVENTORY_SCHEMA, 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_INLINE_TABLE, INVALID_SAVE_MODE, INVALID_SET_SYNTAX, INVALID_SQL_SYNTAX, INVALID_USAGE_OF_STAR_OR_REGEX, INVALID_WRITE_DISTRIBUTION, MATERIALIZED_VIEW_OVER_STREAMING_QUERY_INVALID, 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_ASSERT_VIOLATION, NOT_NULL_CONSTRAINT_VIOLATION, NO_HANDLER_FOR_UDAF, NULLABLE_COLUMN_OR_FIELD, NULLABLE_ROW_ID_ATTRIBUTES, PS_INVALID_EMPTY_OPTION, PS_INVALID_OPTION, PS_INVALID_OPTION_TYPE, PS_INVALID_READ_LIMIT, PS_MISSING_AUTH_INFO, PS_MISSING_REQUIRED_OPTION, PS_PROVIDE_CREDENTIALS_WITH_OPTION, PS_UNABLE_TO_CREATE_SUBSCRIPTION, ROUTINE_PARAMETER_NOT_FOUND, STREAMING_TABLE_QUERY_INVALID, UNSUPPORTED_BATCH_TABLE_VALUED_FUNCTION, UNSUPPORTED_CONSTRAINT_TYPE, UNSUPPORTED_STREAMING_TABLE_VALUED_FUNCTION, VOLUME_ALREADY_EXISTS

42001

Invalid encoder error

INVALID_EXPRESSION_ENCODER

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

42601

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

COLUMN_ALIASES_NOT_ALLOWED, COMMA_PRECEDING_CONSTRAINT_ERROR, COPY_INTO_CREDENTIALS_REQUIRED, COPY_INTO_ENCRYPTION_REQUIRED, COPY_INTO_ENCRYPTION_REQUIRED_WITH_EXPECTED, COPY_INTO_SYNTAX_ERROR, CREDENTIAL_MISSING, DATA_SOURCE_OPTION_IS_REQUIRED, DELTA_CANNOT_CHANGE_LOCATION, DELTA_COLUMN_MISSING_DATA_TYPE, DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_SCHEMA, DELTA_CREATE_TABLE_MISSING_TABLE_NAME_OR_LOCATION, DELTA_CREATE_TABLE_WITH_NON_EMPTY_LOCATION, DELTA_DUPLICATE_DOMAIN_METADATA_INTERNAL_ERROR, DELTA_FAILED_RECOGNIZE_PREDICATE, DELTA_ILLEGAL_USAGE, DELTA_MERGE_MISSING_WHEN, DELTA_MERGE_RESOLVED_ATTRIBUTE_MISSING_FROM_INPUT, DELTA_MERGE_UNRESOLVED_EXPRESSION, 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, FROM_JSON_CONFLICTING_SCHEMA_UPDATES, FROM_JSON_CORRUPT_RECORD_COLUMN_IN_SCHEMA, FROM_JSON_CORRUPT_SCHEMA, FROM_JSON_INFERENCE_FAILED, FROM_JSON_INVALID_CONFIGURATION, GET_WARMUP_TRACING_FAILED, GET_WARMUP_TRACING_FUNCTION_NOT_ALLOWED, IDENTIFIER_TOO_MANY_NAME_PARTS, ILLEGAL_STATE_STORE_VALUE, INVALID_BUCKET_COLUMN_DATA_TYPE, INVALID_EXTRACT_FIELD, INVALID_FORMAT, INVALID_PARTITION_OPERATION, INVALID_SHARED_ALIAS_NAME, INVALID_STATEMENT_OR_CLAUSE, INVALID_WINDOW_SPEC_FOR_AGGREGATION_FUNC, LOCAL_MUST_WITH_SCHEMA_FILE, MV_ST_ALTER_QUERY_INCORRECT_BACKING_TYPE, NOT_ALLOWED_IN_FROM, NOT_A_CONSTANT_STRING, NOT_UNRESOLVED_ENCODER, PARSE_SYNTAX_ERROR, PROCEDURE_CREATION_PARAMETER_OUT_INOUT_WITH_DEFAULT, REF_DEFAULT_VALUE_IS_NOT_ALLOWED_IN_PARTITION, SORT_BY_WITHOUT_BUCKETING, SPECIFY_BUCKETING_IS_NOT_ALLOWED, SPECIFY_PARTITION_IS_NOT_ALLOWED, STDS_REQUIRED_OPTION_UNSPECIFIED, STREAMING_TABLE_OPERATION_NOT_ALLOWED, SYNTAX_DISCONTINUED, UC_EXTERNAL_VOLUME_MISSING_LOCATION, UC_LOCATION_FOR_MANAGED_VOLUME_NOT_SUPPORTED, UNCLOSED_BRACKETED_COMMENT, USER_DEFINED_FUNCTIONS, WINDOW_FUNCTION_WITHOUT_OVER_CLAUSE, WITH_CREDENTIAL, WRITE_STREAM_NOT_ALLOWED

42602

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

DATA_SOURCE_OPTION_CONTAINS_INVALID_CHARACTERS, INVALID_DELIMITER_VALUE, INVALID_IDENTIFIER, INVALID_PROPERTY_KEY, INVALID_PROPERTY_VALUE, INVALID_SCHEMA_OR_RELATION_NAME

42604

An invalid numeric or string constant has been detected.

AS_OF_JOIN, DELTA_TIME_TRAVEL_INVALID_BEGIN_VALUE, EMPTY_JSON_FIELD_VALUE, INVALID_ESC, INVALID_ESCAPE_CHAR, 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, PROCEDURE_ARGUMENT_NUMBER_MISMATCH, WRONG_NUM_ARGS

42607

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

NESTED_AGGREGATE_FUNCTION

42608

The use of NULL or DEFAULT in VALUES or an assignment statement is invalid.

DEFAULT_PLACEMENT_INVALID, NO_DEFAULT_COLUMN_VALUE_AVAILABLE

42611

The column, argument, parameter, or global variable definition is invalid.

CANNOT_ASSIGN_EVENT_TIME_COLUMN_WITHOUT_WATERMARK, DELTA_IDENTITY_COLUMNS_ILLEGAL_STEP

42613

Clauses are mutually exclusive.

COPY_INTO_FEATURE_INCOMPATIBLE_SETTING, DELTA_AMBIGUOUS_PATHS_IN_CREATE_TABLE, DELTA_CANNOT_SET_LOCATION_ON_PATH_IDENTIFIER, DELTA_CLONE_AMBIGUOUS_TARGET, DELTA_CLUSTERING_WITH_ZORDER_BY, DELTA_CLUSTER_BY_WITH_BUCKETING, DELTA_CLUSTER_BY_WITH_PARTITIONED_BY, DELTA_FILE_LIST_AND_PATTERN_STRING_CONFLICT, DELTA_IDENTITY_COLUMNS_WITH_GENERATED_EXPRESSION, DELTA_OVERWRITE_SCHEMA_WITH_DYNAMIC_PARTITION_OVERWRITE, 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, INVALID_QUERY_MIXED_QUERY_PARAMETERS, INVALID_SINGLE_VARIANT_COLUMN, MANAGED_TABLE_WITH_CRED, MUTUALLY_EXCLUSIVE_CLAUSES, NON_LAST_MATCHED_CLAUSE_OMIT_CONDITION, NON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITION, NON_LAST_NOT_MATCHED_BY_TARGET_CLAUSE_OMIT_CONDITION, STDS_CONFLICT_OPTIONS

42614

A duplicate keyword or clause is invalid.

DELTA_MULTIPLE_CDC_BOUNDARY, DELTA_MULTIPLE_CONF_FOR_SINGLE_COLUMN_IN_BLOOM_FILTER, DUPLICATE_CLAUSES, REPEATED_CLAUSE

42616

Invalid options specified

BIGQUERY_OPTIONS_ARE_MUTUALLY_EXCLUSIVE, DELTA_CANNOT_SET_MANAGED_STATS_COLUMNS_PROPERTY, DELTA_ILLEGAL_OPTION, DELTA_INVALID_IDEMPOTENT_WRITES_OPTIONS, DELTA_UNSET_NON_EXISTENT_PROPERTY, STDS_INVALID_OPTION_VALUE, UNSUPPORTED_COMMON_ANCESTOR_LOC_FOR_FILE_STREAM_SOURCE, 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_NON_DETERMINISTIC_EXPRESSION_IN_GENERATED_COLUMN, DELTA_UDF_IN_GENERATED_COLUMN, DELTA_UNSUPPORTED_DATA_TYPE_IN_GENERATED_COLUMN, DELTA_UNSUPPORTED_EXPRESSION_GENERATED_COLUMN, UNSUPPORTED_EXPRESSION_GENERATED_COLUMN

42623

A DEFAULT clause cannot be specified.

GENERATED_COLUMN_WITH_DEFAULT_VALUE, INVALID_DEFAULT_VALUE

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, DELTA_DUPLICATE_DATA_SKIPPING_COLUMNS, DUPLICATE_ASSIGNMENTS, EXEC_IMMEDIATE_DUPLICATE_ARGUMENT_ALIASES

42702

A column reference is ambiguous, because of duplicate names.

AMBIGUOUS_COLUMN_OR_FIELD, AMBIGUOUS_COLUMN_REFERENCE, AMBIGUOUS_LATERAL_COLUMN_ALIAS, DELTA_AMBIGUOUS_PARTITION_COLUMN, EXCEPT_OVERLAPPING_COLUMNS

42703

An undefined column or parameter name was detected.

COLUMN_NOT_DEFINED_IN_TABLE, 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, CANNOT_RESOLVE_DATAFRAME_COLUMN, CANNOT_RESOLVE_STAR_EXPAND, CODEC_SHORT_NAME_NOT_FOUND, COLLATION_INVALID_NAME, COLLATION_INVALID_PROVIDER, DATA_SOURCE_NOT_EXIST, DEFAULT_DATABASE_NOT_EXISTS, DELTA_COLUMN_PATH_NOT_NESTED, DELTA_CONSTRAINT_DOES_NOT_EXIST, DELTA_SHARING_CURRENT_RECIPIENT_PROPERTY_UNDEFINED, ENCODER_NOT_FOUND, 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, DATA_SOURCE_ALREADY_EXISTS, DELTA_CONSTRAINT_ALREADY_EXISTS, DUPLICATED_METRICS_NAME, FIELDS_ALREADY_EXISTS, FOUND_MULTIPLE_DATA_SOURCES, INDEX_ALREADY_EXISTS, LOCATION_ALREADY_EXISTS, MULTIPLE_XML_DATA_SOURCE, STATEFUL_PROCESSOR_CANNOT_REINITIALIZE_STATE_ON_KEY

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

42713

A duplicate object was detected in a list or is the same as an existing object.

DUPLICATED_FIELD_NAME_IN_ARROW_STRUCT, STATIC_PARTITION_COLUMN_IN_INSERT_COLUMN_LIST

42723

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

ROUTINE_ALREADY_EXISTS, VARIABLE_ALREADY_EXISTS

42734

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

COLUMN_MASKS_DUPLICATE_USING_COLUMN_NAME, COLUMN_MASKS_USING_COLUMN_NAME_SAME_AS_TARGET_COLUMN, DUPLICATE_ROUTINE_PARAMETER_NAMES, ROW_LEVEL_SECURITY_DUPLICATE_COLUMN_NAME

4274K

Invalid use of a named argument when invoking a routine.

DUPLICATE_ROUTINE_PARAMETER_ASSIGNMENT, NAMED_PARAMETERS_NOT_SUPPORTED, READ_FILES_AMBIGUOUS_ROUTINE_PARAMETERS, READ_TVF_UNEXPECTED_REQUIRED_PARAMETER, REQUIRED_PARAMETER_ALREADY_PROVIDED_POSITIONALLY, REQUIRED_PARAMETER_NOT_FOUND, UNEXPECTED_POSITIONAL_ARGUMENT, UNKNOWN_POSITIONAL_ARGUMENT, UNRECOGNIZED_PARAMETER_NAME

42802

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

ASSIGNMENT_ARITY_MISMATCH, DELTA_INSERT_COLUMN_ARITY_MISMATCH, DELTA_INSERT_COLUMN_MISMATCH, STATEFUL_PROCESSOR_CANNOT_PERFORM_OPERATION_WITH_INVALID_HANDLE_STATE, STATEFUL_PROCESSOR_CANNOT_PERFORM_OPERATION_WITH_INVALID_TIME_MODE, STATEFUL_PROCESSOR_INCORRECT_TIME_MODE_TO_ASSIGN_TTL, STATEFUL_PROCESSOR_TTL_DURATION_MUST_BE_POSITIVE, STATE_STORE_CANNOT_CREATE_COLUMN_FAMILY_WITH_RESERVED_CHARS, STATE_STORE_CANNOT_USE_COLUMN_FAMILY_WITH_INVALID_NAME, STATE_STORE_HANDLE_NOT_INITIALIZED, STATE_STORE_INCORRECT_NUM_ORDERING_COLS_FOR_RANGE_SCAN, STATE_STORE_INCORRECT_NUM_PREFIX_COLS_FOR_PREFIX_SCAN, STATE_STORE_NULL_TYPE_ORDERING_COLS_NOT_SUPPORTED, STATE_STORE_UNSUPPORTED_OPERATION_ON_MISSING_COLUMN_FAMILY, STATE_STORE_VARIABLE_SIZE_ORDERING_COLS_NOT_SUPPORTED, UDTF_ALIAS_NUMBER_MISMATCH, UDTF_INVALID_ALIAS_IN_REQUESTED_ORDERING_STRING_FROM_ANALYZE_METHOD, UDTF_INVALID_REQUESTED_SELECTED_EXPRESSION_FROM_ANALYZE_METHOD_REQUIRES_ALIAS

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, EXPECT_PERMANENT_VIEW_NOT_TEMP, EXPECT_TABLE_NOT_VIEW, EXPECT_VIEW_NOT_TABLE, FORBIDDEN_OPERATION, INVALID_DEST_CATALOG, INVALID_SOURCE_CATALOG, INVALID_UPGRADE_SYNTAX, NOT_A_PARTITIONED_TABLE, UNSUPPORTED_INSERT, WRONG_COMMAND_FOR_OBJECT_TYPE

42815

The data type, length, scale, value, or CCSID is invalid.

EMITTING_ROWS_OLDER_THAN_WATERMARK_NOT_ALLOWED

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

42822

An expression in the ORDER BY clause or GROUP BY clause is not valid.

EXPRESSION_TYPE_IS_NOT_ORDERABLE, GROUP_EXPRESSION_TYPE_IS_NOT_ORDERABLE

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

42845

An invalid use of a NOT DETERMINISTIC or EXTERNAL ACTION function was detected.

AGGREGATE_FUNCTION_WITH_NONDETERMINISTIC_EXPRESSION

42846

Cast from source type to target type is not supported.

CANNOT_CAST_DATATYPE, CANNOT_CONVERT_PROTOBUF_FIELD_TYPE_TO_SQL_TYPE, CANNOT_CONVERT_PROTOBUF_MESSAGE_TYPE_TO_SQL_TYPE, CANNOT_CONVERT_SQL_TYPE_TO_PROTOBUF_FIELD_TYPE, CANNOT_CONVERT_SQL_VALUE_TO_PROTOBUF_ENUM_TYPE, CANNOT_UP_CAST_DATATYPE, DELTA_UPDATE_SCHEMA_MISMATCH_EXPRESSION, EXPRESSION_DECODING_FAILED, EXPRESSION_ENCODING_FAILED, UNEXPECTED_SERIALIZER_FOR_CLASS

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, UNRESOLVABLE_TABLE_VALUED_FUNCTION, UNRESOLVED_ROUTINE, UNRESOLVED_VARIABLE, VARIABLE_NOT_FOUND

42887

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

CYCLIC_FUNCTION_REFERENCE, DELTA_SHARING_INVALID_OP_IN_EXTERNAL_SHARED_VIEW, INVALID_CURRENT_RECIPIENT_USAGE, 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

428FR

A column cannot be altered as specified.

CANNOT_ALTER_COLLATION_BUCKET_COLUMN, CANNOT_ALTER_PARTITION_COLUMN, DELTA_ALTER_COLLATION_NOT_SUPPORTED_BLOOM_FILTER, DELTA_ALTER_COLLATION_NOT_SUPPORTED_CLUSTER_BY

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.

DELTA_IDENTITY_COLUMNS_UNSUPPORTED_DATA_TYPE, EXCEPT_NESTED_COLUMN_INVALID_TYPE

428HD

The statement cannot be processed because a column mask cannot be applied or the definition of the mask conflicts with the statement.

QUERIED_TABLE_INCOMPATIBLE_WITH_COLUMN_MASK_POLICY, QUERIED_TABLE_INCOMPATIBLE_WITH_ROW_LEVEL_SECURITY_POLICY

42902

The object of the INSERT, UPDATE, or DELETE is also identified (possibly implicitly through a view) in a FROM clause.

UNSUPPORTED_OVERWRITE

42903

Invalid use of an aggregate function or OLAP function.

DELTA_AGGREGATION_NOT_SUPPORTED, GROUP_BY_AGGREGATE, GROUP_BY_POS_AGGREGATE, INVALID_AGGREGATE_FILTER, INVALID_WHERE_CONDITION

42908

The statement does not include a required column list.

DELTA_CLUSTER_BY_SCHEMA_NOT_PROVIDED, DELTA_SCHEMA_NOT_PROVIDED, SPECIFY_CLUSTER_BY_WITH_BUCKETING_IS_NOT_ALLOWED, SPECIFY_CLUSTER_BY_WITH_PARTITIONED_BY_IS_NOT_ALLOWED

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_AMBIGUOUS_DATA_TYPE_CHANGE, 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, STREAM_NOT_FOUND_FOR_KINESIS_SOURCE

42K03

File not found

BATCH_METADATA_NOT_FOUND, CANNOT_LOAD_PROTOBUF_CLASS, CLOUD_FILE_SOURCE_FILE_NOT_FOUND, DATA_SOURCE_TABLE_SCHEMA_MISMATCH, DEFAULT_FILE_NOT_FOUND, DELTA_CHANGE_DATA_FILE_NOT_FOUND, DELTA_CHECKPOINT_NON_EXIST_TABLE, DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_TXN_LOG, DELTA_DELETED_PARQUET_FILE_NOT_FOUND, 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, LOAD_DATA_PATH_NOT_EXISTS, PATH_NOT_FOUND, READ_CURRENT_FILE_NOT_FOUND, RENAME_SRC_PATH_NOT_FOUND, STDS_FAILED_TO_READ_STATE_SCHEMA, STREAMING_STATEFUL_OPERATOR_NOT_MATCH_IN_STATE_METADATA

42K04

Duplicate file

DELTA_FILE_ALREADY_EXISTS, DELTA_LOG_ALREADY_EXISTS, DELTA_PATH_EXISTS, FAILED_RENAME_PATH, FILE_IN_STAGING_PATH_ALREADY_EXISTS, KINESIS_FETCHED_SHARD_LESS_THAN_TRACKED_SHARD, PARTITION_LOCATION_ALREADY_EXISTS, PATH_ALREADY_EXISTS

42K05

Name is not valid

CLEANROOM_INVALID_SHARED_DATA_OBJECT_NAME, COLUMN_MASKS_MULTI_PART_TARGET_COLUMN_NAME, COLUMN_MASKS_MULTI_PART_USING_COLUMN_NAME, DELTA_INVALID_CHARACTERS_IN_COLUMN_NAME, DELTA_INVALID_CHARACTERS_IN_COLUMN_NAMES, DELTA_INVALID_COLUMN_NAMES_WHEN_REMOVING_COLUMN_MAPPING, DELTA_NESTED_FIELDS_NEED_RENAME, DELTA_NON_SINGLE_PART_NAMESPACE_FOR_CATALOG, INVALID_EMPTY_LOCATION, REQUIRES_SINGLE_PART_NAMESPACE, ROW_LEVEL_SECURITY_MULTI_PART_COLUMN_NAME

42K06

Invalid type for options

DELTA_PROTOCOL_PROPERTY_NOT_INT, INVALID_OPTIONS, STATE_STORE_INVALID_PROVIDER, STATE_STORE_PROVIDER_DOES_NOT_SUPPORT_FINE_GRAINED_STATE_REPLAY

42K07

Not a valid schema literal

INVALID_SCHEMA

42K08

Not a constant

ARGUMENT_NOT_CONSTANT, INVALID_SQL_ARG, NON_FOLDABLE_ARGUMENT, NON_LITERAL_PIVOT_VALUES, SEED_EXPRESSION_IS_UNFOLDABLE

42K09

Data type mismatch

COMPLEX_EXPRESSION_UNSUPPORTED_INPUT, DATATYPE_MISMATCH, DELTA_CONSTRAINT_DATA_TYPE_MISMATCH, DELTA_CONSTRAINT_DEPENDENT_COLUMN_CHANGE, DELTA_GENERATED_COLUMNS_DATA_TYPE_MISMATCH, DELTA_GENERATED_COLUMNS_DEPENDENT_COLUMN_CHANGE, DELTA_GENERATED_COLUMNS_EXPR_TYPE_MISMATCH, DELTA_GENERATED_COLUMN_UPDATE_TYPE_MISMATCH, DELTA_MERGE_ADD_VOID_COLUMN, DELTA_MERGE_INCOMPATIBLE_DATATYPE, DELTA_NOT_NULL_COLUMN_NOT_FOUND_IN_STRUCT, EVENT_TIME_IS_NOT_ON_TIMESTAMP_TYPE, INVALID_VARIABLE_TYPE_FOR_QUERY_EXECUTE_IMMEDIATE, 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

42K0D

Invalid lambda function

INVALID_LAMBDA_FUNCTION_CALL

42K0E

An expression is not valid in the context it is used

INVALID_LIMIT_LIKE_EXPRESSION, INVALID_NON_DETERMINISTIC_EXPRESSIONS, INVALID_OBSERVED_METRICS, INVALID_TIME_TRAVEL_SPEC, INVALID_TIME_TRAVEL_TIMESTAMP_EXPR, JOIN_CONDITION_IS_NOT_BOOLEAN_TYPE, MULTIPLE_TIME_TRAVEL_SPEC, MULTI_SOURCES_UNSUPPORTED_FOR_EXPRESSION, NO_MERGE_ACTION_SPECIFIED, ONLY_SECRET_FUNCTION_SUPPORTED_HERE, SECRET_FUNCTION_INVALID_LOCATION, UNSUPPORTED_EXPR_FOR_OPERATOR, UNSUPPORTED_EXPR_FOR_PARAMETER, UNSUPPORTED_GENERATOR, UNSUPPORTED_GROUPING_EXPRESSION, UNSUPPORTED_MERGE_CONDITION, UNTYPED_SCALA_UDF, WINDOW_FUNCTION_AND_FRAME_MISMATCH

42K0F

A persisted object cannot reference a temporary object.

INVALID_TEMP_OBJ_REFERENCE

42K0G

A protobuf is invalid

PROTOBUF_DEPENDENCY_NOT_FOUND, PROTOBUF_DESCRIPTOR_FILE_NOT_FOUND, PROTOBUF_FIELD_MISSING, PROTOBUF_FIELD_MISSING_IN_SQL_SCHEMA, PROTOBUF_FIELD_TYPE_MISMATCH, PROTOBUF_MESSAGE_NOT_FOUND, PROTOBUF_TYPE_NOT_SUPPORT, RECURSIVE_PROTOBUF_SCHEMA, SCHEMA_REGISTRY_CONFIGURATION_ERROR, UNABLE_TO_CONVERT_TO_PROTOBUF_MESSAGE_TYPE, UNKNOWN_PROTOBUF_MESSAGE_TYPE

42K0H

A cyclic invocation has been detected.

RECURSIVE_VIEW

42K0I

SQL Config not found.

CONFIG_NOT_AVAILABLE, SQL_CONF_NOT_FOUND

42K0J

Property not found.

UNSET_NONEXISTENT_PROPERTIES

42K0K

Invalid inverse distribution function

INVALID_INVERSE_DISTRIBUTION_FUNCTION

42KD0

Ambiguous name reference.

AMBIGUOUS_ALIAS_IN_NESTED_CTE

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

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_CLUSTERING, 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.

CANNOT_MERGE_SCHEMAS, COPY_INTO_SOURCE_SCHEMA_INFERENCE_FAILED, DELTA_FAILED_INFER_SCHEMA, UNABLE_TO_INFER_SCHEMA

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

42KDD

Unsupported operation in streaming view.

UNEXPECTED_OPERATOR_IN_STREAMING_VIEW

42KDE

Unsupported operation on streaming dataset.

CALL_ON_STREAMING_DATASET_UNSUPPORTED, CANNOT_CREATE_DATA_SOURCE_TABLE, INVALID_WRITER_COMMIT_MESSAGE, NON_TIME_WINDOW_NOT_SUPPORTED_IN_STREAMING

42KDF

A required routine parameter is missing an argument.

MISSING_PARAMETER_FOR_KAFKA, MISSING_PARAMETER_FOR_ROUTINE, XML_ROW_TAG_MISSING

42KDG

The target schema is not compatible with the ingested data.

COPY_INTO_SCHEMA_MISMATCH_WITH_TARGET_TABLE

42P01

undefined table

DELTA_CANNOT_REPLACE_MISSING_TABLE, DELTA_MISSING_DELTA_TABLE, DELTA_MISSING_DELTA_TABLE_COPY_INTO, DELTA_NO_RELATION_TABLE, DELTA_TABLE_NOT_FOUND, 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

42P08

ambiguous parameter

CATALOG_NOT_FOUND

42P10

invalid column reference

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

42P21

collation mismatch

COLLATION_MISMATCH

42P22

indeterminate collation

INDETERMINATE_COLLATION

42S22

Column not found

NO_SQL_TYPE_IN_PROTOBUF_SCHEMA

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

46103

unresolved class name

CANNOT_LOAD_FUNCTION_CLASS

46110

unsupported feature

CANNOT_MODIFY_CONFIG

46121

invalid column name

INVALID_COLUMN_NAME_AS_PATH

Class 51: Invalid Application State

SQLSTATE

Description and issuing error classes

51024

An object cannot be used, because it has been marked inoperative.

INCOMPATIBLE_VIEW_SCHEMA_CHANGE

Class 53: insufficient resources

SQLSTATE

Description and issuing error classes

53200

out of memory

EXECUTOR_BROADCAST_JOIN_OOM, UNABLE_TO_ACQUIRE_MEMORY

Class 54: program limit exceeded

SQLSTATE

Description and issuing error classes

54000

program limit exceeded

COLLECTION_SIZE_LIMIT_EXCEEDED, DELTA_CLUSTER_BY_INVALID_NUM_COLUMNS, GROUPING_SIZE_LIMIT_EXCEEDED, RELATION_LARGER_THAN_8G

54001

The statement is too long or too complex.

FAILED_TO_PARSE_TOO_COMPLEX

54006

The result string is too long.

EXCEED_LIMIT_LENGTH, KRYO_BUFFER_OVERFLOW

54023

too many arguments

TABLE_VALUED_FUNCTION_TOO_MANY_TABLE_ARGUMENTS

54K00

Maximum depth of nested views was exceeded.

VIEW_EXCEED_MAX_NESTED_DEPTH

54KD0

Maximum UDF count in query plan exceeded.

UDF_LIMITS, UDF_MAX_COUNT_EXCEEDED

54KD1

Maximum object count in session exceeded.

MAX_NUMBER_VARIABLES_IN_SESSION_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.

CANNOT_QUERY_TABLE_DURING_INITIALIZATION, COPY_INTO_STATE_INTERNAL_ERROR, DIFFERENT_DELTA_TABLE_READ_BY_STREAMING_SOURCE, EVENT_LOG_UNAVAILABLE, MATERIALIZED_VIEW_MESA_REFRESH_WITHOUT_PIPELINE_ID, STREAMING_TABLE_NEEDS_REFRESH

Class 56: Miscellaneous SQL or Product Error

SQLSTATE

Description and issuing error classes

56000

Miscellaneous SQL or Product Error

CHECKPOINT_RDD_BLOCK_ID_NOT_FOUND

56038

The requested feature is not supported in this environment.

AI_FUNCTION_UNSUPPORTED_ERROR, ANSI_CONFIG_CANNOT_BE_DISABLED, CF_MANAGED_FILE_EVENTS_ONLY_ON_SERVERLESS, CLUSTER_BY_AUTO_REQUIRES_CLUSTERING_FEATURE_ENABLED, CLUSTER_BY_AUTO_REQUIRES_PREDICTIVE_OPTIMIZATION, CLUSTER_BY_AUTO_UNSUPPORTED_TABLE_TYPE_ERROR, CODEC_NOT_AVAILABLE, COLUMN_MASKS_NOT_ENABLED, DATABRICKS_DELTA_NOT_ENABLED, DELTA_MISSING_ICEBERG_CLASS, DELTA_UNRECOGNIZED_INVARIANT, DELTA_UNSUPPORTED_FEATURES_FOR_READ, DELTA_UNSUPPORTED_FEATURES_FOR_WRITE, DELTA_UNSUPPORTED_FEATURES_IN_CONFIG, DLT_EXPECTATIONS_NOT_SUPPORTED, DLT_VIEW_CLUSTER_BY_NOT_SUPPORTED, DLT_VIEW_LOCATION_NOT_SUPPORTED, DLT_VIEW_SCHEMA_WITH_TYPE_NOT_SUPPORTED, DLT_VIEW_TABLE_CONSTRAINTS_NOT_SUPPORTED, FEATURE_NOT_ENABLED, FEATURE_NOT_ON_CLASSIC_WAREHOUSE, FEATURE_UNAVAILABLE, GET_TABLES_BY_TYPE_UNSUPPORTED_BY_HIVE_VERSION, INCOMPATIBLE_DATASOURCE_REGISTER, MATERIALIZED_VIEW_OPERATION_NOT_ALLOWED, METRIC_STORE_UNSUPPORTED_ERROR, NATIVE_XML_DATA_SOURCE_NOT_ENABLED, STREAMING_TABLE_NOT_SUPPORTED, UC_LAKEHOUSE_FEDERATION_WRITES_NOT_ALLOWED, UC_NOT_ENABLED, UC_QUERY_FEDERATION_NOT_ENABLED, UC_SERVICE_CREDENTIALS_NOT_ENABLED, UC_VOLUMES_NOT_ENABLED, UC_VOLUMES_SHARING_NOT_ENABLED, UNSUPPORTED_TIMESERIES_COLUMNS

56098

An error occurred during implicit rebind, recompile, or revalidation.

UC_INVALID_DEPENDENCIES

56K00

Spark Connect error

CONNECT

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_RESULT_UNEXPECTED_ERROR, REMOTE_FUNCTION_HTTP_RETRY_TIMEOUT, REMOTE_FUNCTION_MISSING_REQUIREMENTS_ERROR

Class 82: out of memory

SQLSTATE

Description and issuing error classes

82100

out of memory (could not allocate)

DELTA_BLOOM_FILTER_OOM_ON_WRITE

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, INVALID_DRIVER_MEMORY, INVALID_EXECUTOR_MEMORY, INVALID_KRYO_SERIALIZER_BUFFER_SIZE

Class HV: FDW-specific condition

SQLSTATE

Description and issuing error classes

HV000

FDW-specific condition

FAILED_JDBC

HV091

invalid descriptor field identifier

NONEXISTENT_FIELD_NAME_IN_LIST

Class HY: CLI-specific condition

SQLSTATE

Description and issuing error classes

HY000

CLI-specific condition

INVALID_HANDLE

HY008

operation canceled

OPERATION_CANCELED

HY109

invalid cursor position

INVALID_CURSOR

Class KD: datasource specific errors

SQLSTATE

Description and issuing error classes

KD000

datasource specific errors

DC_API_QUOTA_EXCEEDED, DC_CONNECTION_ERROR, DC_DYNAMICS_API_ERROR, DC_NETSUITE_ERROR, DC_SERVICENOW_API_ERROR, DC_SFDC_BULK_QUERY_JOB_INCOMPLETE, DC_SHAREPOINT_API_ERROR, DC_SOURCE_API_ERROR, DC_WORKDAY_RAAS_API_ERROR, END_OFFSET_HAS_GREATER_OFFSET_FOR_TOPIC_PARTITION_THAN_LATEST_WITH_TRIGGER_AVAILABLENOW, END_OFFSET_HAS_GREATER_OFFSET_FOR_TOPIC_PARTITION_THAN_PREFETCHED, FAILED_REGISTER_CLASS_WITH_KRYO, GRAPHITE_SINK_INVALID_PROTOCOL, GRAPHITE_SINK_PROPERTY_MISSING, INCOMPATIBLE_DATA_FOR_TABLE, LOST_TOPIC_PARTITIONS_IN_END_OFFSET_WITH_TRIGGER_AVAILABLENOW, MALFORMED_AVRO_MESSAGE, MALFORMED_CSV_RECORD, MISMATCHED_TOPIC_PARTITIONS_BETWEEN_END_OFFSET_AND_PREFETCHED

KD001

Cannot read file footer

DELTA_FAILED_READ_FILE_FOOTER, FAILED_READ_FILE

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_MISSING_COMMIT_INFO, DELTA_MISSING_COMMIT_TIMESTAMP, DELTA_READ_FEATURE_PROTOCOL_REQUIRES_WRITE, DELTA_UNSUPPORTED_COLUMN_MAPPING_PROTOCOL

KD005

Table must include at least one non partition column

ALL_PARTITION_COLUMNS_NOT_ALLOWED, DELTA_NON_PARTITION_COLUMN_ABSENT

KD006

No commits found at log path

DELTA_NO_COMMITS_FOUND, DELTA_NO_RECREATABLE_HISTORY_FOUND, STDS_COMMITTED_BATCH_UNAVAILABLE, STDS_NO_PARTITION_DISCOVERED_IN_STATE_STORE, STDS_OFFSET_LOG_UNAVAILABLE, STDS_OFFSET_METADATA_LOG_UNAVAILABLE

KD007

Table signature changed

DELTA_SCHEMA_CHANGED, DELTA_SCHEMA_CHANGED_WITH_STARTING_OPTIONS, DELTA_SCHEMA_CHANGED_WITH_VERSION, DELTA_SCHEMA_CHANGE_SINCE_ANALYSIS, DELTA_TABLE_ID_MISMATCH

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

KD00C

Versioning not contiguous

DELTA_VERSIONS_NOT_CONTIGUOUS

KD00D

Stats required

DELTA_ZORDERING_ON_COLUMN_WITHOUT_STATS

KD00E

table feature validation failure

DELTA_ICEBERG_COMPAT_VIOLATION, DELTA_UNIFORM_ICEBERG_INGRESS_VIOLATION, DELTA_UNIVERSAL_FORMAT_CONVERSION_FAILED, DELTA_UNIVERSAL_FORMAT_VIOLATION

Class P0: procedural logic error

SQLSTATE

Description and issuing error classes

P0001

raise exception

USER_RAISED_EXCEPTION, USER_RAISED_EXCEPTION_PARAMETER_MISMATCH, USER_RAISED_EXCEPTION_UNKNOWN_ERROR_CLASS