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 |
Databricks SQL