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 |