Error conditions in Databricks
This is a list of common, named error conditions returned by Databricks.
Databricks Runtime and Databricks SQL
ARITHMETIC_OVERFLOW
<message>.<alternative> If necessary set <config> to “false” to bypass this error.
CANNOT_COPY_STATE
Cannot copy catalog state like current database and temporary views from Unity Catalog to a legacy catalog.
CANNOT_DROP_AMBIGUOUS_CONSTRAINT
Cannot drop the constraint with the name <constraintName> shared by a CHECK constraint
and a PRIMARY KEY or FOREIGN KEY constraint. You can drop the PRIMARY KEY or
FOREIGN KEY constraint by queries:
ALTER TABLE .. DROP PRIMARY KEY or
ALTER TABLE .. DROP FOREIGN KEY ..
CANNOT_INFER_DATE
Cannot infer date in schema inference when LegacyTimeParserPolicy is “LEGACY”. Legacy Date formatter does not support strict date format matching which is required to avoid inferring timestamps and other non-date entries to date.
CANNOT_READ_SENSITIVE_KEY_FROM_SECURE_PROVIDER
Cannot read sensitive key ‘<key>’ from secure provider
CAST_INVALID_INPUT
The value <expression> of the type <sourceType> cannot be cast to <targetType> because it is malformed. Correct the value as per the syntax, or change its target type. Use try_cast to tolerate malformed input and return NULL instead. If necessary set <ansiConfig> to “false” to bypass this error.
CAST_OVERFLOW
The value <value> of the type <sourceType> cannot be cast to <targetType> due to an overflow. Use try_cast to tolerate overflow and return NULL instead. If necessary set <ansiConfig> to “false” to bypass this error.
CAST_OVERFLOW_IN_TABLE_INSERT
Fail to insert a value of <sourceType> type into the <targetType> type column <columnName> due to an overflow. Use try_cast on the input value to tolerate overflow and return NULL instead.
COLUMN_NOT_IN_GROUP_BY_CLAUSE
The expression <expression> is neither present in the group by, nor is it an aggregate function. Add to group by or wrap in first() (or first_value()) if you don’t care which value you get.
CONVERSION_INVALID_INPUT
The value <str> (<fmt>) cannot be converted to <targetType> because it is malformed. Correct the value as per the syntax, or change its format. Use <suggestion> to tolerate malformed input and return NULL instead.
COPY_INTO_CREDENTIALS_NOT_ALLOWED_ON
Invalid scheme <scheme>. COPY INTO source encryption currently only supports s3/s3n/s3a/wasbs/abfss.
COPY_INTO_DUPLICATED_FILES_COPY_NOT_ALLOWED
Duplicated files were committed in a concurrent COPY INTO operation. Please try again later.
COPY_INTO_ENCRYPTION_NOT_ALLOWED_ON
Invalid scheme <scheme>. COPY INTO source encryption currently only supports s3/s3n/s3a/abfss.
COPY_INTO_ENCRYPTION_NOT_SUPPORTED_FOR_AZURE
COPY INTO encryption only supports ADLS Gen2, or abfss:// file scheme
COPY_INTO_ENCRYPTION_REQUIRED_WITH_EXPECTED
Invalid encryption option <requiredKey>. COPY INTO source encryption must specify ‘<requiredKey>’ = ‘<keyValue>’.
COPY_INTO_NON_BLIND_APPEND_NOT_ALLOWED
COPY INTO other than appending data is not allowed to run concurrently with other transactions. Please try again later.
COPY_INTO_SOURCE_FILE_FORMAT_NOT_SUPPORTED
The format of the source files must be one of CSV, JSON, AVRO, ORC, PARQUET, TEXT, or BINARYFILE. Using COPY INTO on Delta tables as the source is not supported as duplicate data may be ingested after OPTIMIZE operations. This check can be turned off by running the SQL command set spark.databricks.delta.copyInto.formatCheck.enabled = false.
DATATYPE_MISMATCH
Cannot resolve <sqlExpr> due to data type mismatch:
For more details see DATATYPE_MISMATCH
DIVIDE_BY_ZERO
Division by zero. Use try_divide to tolerate divisor being 0 and return NULL instead. If necessary set <config> to “false” to bypass this error.
ELEMENT_AT_BY_INDEX_ZERO
The index 0 is invalid. An index shall be either < 0 or > 0 (the first element has index 1).
EXCEPT_NESTED_COLUMN_INVALID_TYPE
EXCEPT column <columnName> was resolved and expected to be StructType, but found type <dataType>.
EXCEPT_UNRESOLVED_COLUMN_IN_STRUCT_EXPANSION
The column/field name <objectName> in the EXCEPT clause cannot be resolved. Did you mean one of the following: [<objectList>]?
Note: nested columns in the EXCEPT clause may not include qualifiers (table name, parent struct column name, etc.) during a struct expansion; try removing qualifiers if they are used with nested columns.
FAILED_EXECUTE_UDF
Failed to execute user defined function (<functionName>: (<signature>) => <result>)
FOREIGN_KEY_MISMATCH
Foreign key parent columns <parentColumns> do not match primary key child columns <childColumns>.
GROUPING_COLUMN_MISMATCH
Column of grouping (<grouping>) can’t be found in grouping columns <groupingColumns>
GROUPING_ID_COLUMN_MISMATCH
Columns of grouping_id (<groupingIdColumn>) does not match grouping columns (<groupByColumns>)
GROUP_BY_POS_OUT_OF_RANGE
GROUP BY position <index> is not in select list (valid range is [1, <size>]).
GROUP_BY_POS_REFERS_AGG_EXPR
GROUP BY <index> refers to an expression <aggExpr> that contains an aggregate function. Aggregate functions are not allowed in GROUP BY.
INCOMPATIBLE_DATASOURCE_REGISTER
Detected an incompatible DataSourceRegister. Please remove the incompatible library from classpath or upgrade it. Error: <message>
INCONSISTENT_BEHAVIOR_CROSS_VERSION
You may get a different result due to the upgrading to
For more details see INCONSISTENT_BEHAVIOR_CROSS_VERSION
INCORRECT_NUMBER_OF_ARGUMENTS
<failure>, <functionName> requires at least <minArgs> arguments and at most <maxArgs> arguments.
INSUFFICIENT_PERMISSIONS_EXT_LOC
User ‘<user>’ has insufficient privileges for external location ‘<location>’.
INSUFFICIENT_PERMISSIONS_STORAGE_CRED
Storage credential ‘<credentialName>’ has insufficient privileges.
INTERVAL_DIVIDED_BY_ZERO
Division by zero. Use try_divide to tolerate divisor being 0 and return NULL instead.
INVALID_AGGREGATE_FUNCTION_USAGE_IN_SQL_FUNCTION
Invalid aggregate function usage in SQL function: <functionName>
INVALID_ARRAY_INDEX
The index <indexValue> is out of bounds. The array has <arraySize> elements. Use the SQL function get() to tolerate accessing element at invalid index and return NULL instead. If necessary set <ansiConfig> to “false” to bypass this error.
INVALID_ARRAY_INDEX_IN_ELEMENT_AT
The index <indexValue> is out of bounds. The array has <arraySize> elements. Use try_element_at to tolerate accessing element at invalid index and return NULL instead. If necessary set <ansiConfig> to “false” to bypass this error.
INVALID_CLONE_PATH
The target location for CLONE needs to be an absolute path or table name. Use an
absolute path instead of <path>.
INVALID_COLUMN_OR_FIELD_DATA_TYPE
Column or field <name> is of type <type> while it’s required to be <expectedType>.
INVALID_DEST_CATALOG
Destination catalog of the SYNC command must be within Unity Catalog. Found <catalog>.
INVALID_FRACTION_OF_SECOND
The fraction of sec must be zero. Valid range is [0, 60]. If necessary set <ansiConfig> to “false” to bypass this error.
INVALID_JSON_SCHEMA_MAP_TYPE
Input schema <jsonSchema> can only contain STRING as a key type for a MAP.
INVALID_PANDAS_UDF_PLACEMENT
The group aggregate pandas UDF <functionList> cannot be invoked together with as other, non-pandas aggregate functions.
INVALID_PARAMETER_VALUE
The value of parameter(s) ‘<parameter>’ in <functionName> is invalid: <expected>
INVALID_PROPERTY_VALUE
<value> is an invalid property value, please use quotes, e.g. SET <key>=<value>
INVALID_S3_COPY_CREDENTIALS
COPY INTO credentials must include AWS_ACCESS_KEY, AWS_SECRET_KEY, and AWS_SESSION_TOKEN.
INVALID_SOURCE_CATALOG
Source catalog must not be within Unity Catalog for the SYNC command. Found <catalog>.
INVALID_TIMESTAMP_FORMAT
The provided timestamp <timestamp> doesn’t match the expected syntax <format>.
INVALID_UPGRADE_SYNTAX
<command> <supportedOrNot> the source table is in Hive Metastore and the destination table is in Unity Catalog.
MULTIPLE_LOAD_PATH
Databricks Delta does not support multiple input paths in the load() API.
paths: <pathList>. To build a single DataFrame by loading
multiple paths from the same Delta table, please load the root path of
the Delta table with the corresponding partition filters. If the multiple paths
are from different Delta tables, please use Dataset’s union()/unionByName() APIs
to combine the DataFrames generated by separate load() API calls.
NULLABLE_ARRAY_OR_MAP_ELEMENT
Array or map at <columnPath> contains nullable element while it’s required to be non-nullable.
NULL_COMPARISON_RESULT
The comparison result is null. If you want to handle null as 0 (equal), you can set “spark.sql.legacy.allowNullComparisonResultInArraySort” to “true”.
NUMERIC_VALUE_OUT_OF_RANGE
<value> cannot be represented as Decimal(<precision>, <scale>). If necessary set <config> to “false” to bypass this error.
PARSE_CHAR_MISSING_LENGTH
DataType <type> requires a length parameter, for example <type>(10). Please specify the length.
PARTITION_METADATA
<action> is not allowed on table <tableName> since storing partition metadata is not supported in Unity Catalog.
PARTITION_SCHEMA_IN_ICEBERG_TABLES
Partition schema cannot be specified when converting Iceberg tables
PIVOT_VALUE_DATA_TYPE_MISMATCH
Invalid pivot value ‘<value>’: value data type <valueType> does not match pivot column data type <pivotType>
QUERY_RESULT_WRITE_TO_CLOUD_STORE_FAILED
An internal error occurred while uploading the result set to the cloud store.
RESERVED_CDC_COLUMNS_ON_WRITE
The write contains reserved columns <columnList> that are used
internally as metadata for Change Data Feed. To write to the table either rename/drop
these columns or disable Change Data Feed on the table by setting
<config> to false.
RESET_PERMISSION_TO_ORIGINAL
Failed to set original permission <permission> back to the created path: <path>. Exception: <message>
SECOND_FUNCTION_ARGUMENT_NOT_INTEGER
The second argument of <functionName> function needs to be an integer.
SYNC_METADATA_NOT_SUPPORTED
Repair table sync metadata command is only supported for Unity Catalog tables.
SYNC_SRC_TARGET_TBL_NOT_SAME
Source table name <srcTable> must be same as destination table name <destTable>.
UC_CATALOG_NAME_NOT_PROVIDED
For Unity Catalog, please specify the catalog name explicitly. E.g. SHOW GRANT your.address@email.com ON CATALOG main.
UC_DATASOURCE_NOT_SUPPORTED
Data source format <dataSourceFormatName> is not supported in Unity Catalog.
UDF_UNSUPPORTED_PARAMETER_DEFAULT_VALUE
Parameter default value is not supported for user-defined <functionType> function.
UNPIVOT_REQUIRES_VALUE_COLUMNS
At least one value column needs to be specified for UNPIVOT, all columns specified as ids
UNPIVOT_VALUE_DATA_TYPE_MISMATCH
Unpivot value columns must share a least common type, some types do not: [<types>]
UNRESOLVED_COLUMN
A column or function parameter with name <objectName> cannot be resolved.
For more details see UNRESOLVED_COLUMN
UNRESOLVED_FIELD
A field with name <fieldName> cannot be resolved with the struct-type column <columnPath>.
For more details see UNRESOLVED_FIELD
UNRESOLVED_MAP_KEY
Cannot resolve column <columnName> as a map key. If the key is a string literal, please add single quotes around it.
For more details see UNRESOLVED_MAP_KEY
UNSUPPORTED_CONSTRAINT_TYPE
Unsupported constraint type. Only <supportedConstraintTypes> are supported
UNSUPPORTED_DESERIALIZER
The deserializer is not supported:
For more details see UNSUPPORTED_DESERIALIZER
UNSUPPORTED_GROUPING_EXPRESSION
grouping()/grouping_id() can only be used with GroupingSets/Cube/Rollup
UNSUPPORTED_SAVE_MODE
The save mode <saveMode> is not supported for:
For more details see UNSUPPORTED_SAVE_MODE
UNTYPED_SCALA_UDF
You’re using untyped Scala UDF, which does not have the input type information. Spark may blindly pass null to the Scala closure with primitive-type argument, and the closure will see the default value of the Java type for the null argument, e.g. udf((x: Int) => x, IntegerType), the result is 0 for null input. To get rid of this error, you could:
use typed Scala UDF APIs(without return type parameter), e.g.
udf((x: Int) => x)use Java UDF APIs, e.g.
udf(new UDF1[String, Integer] { override def call(s: String): Integer = s.length() }, IntegerType), if input types are all non primitiveset “spark.sql.legacy.allowUntypedScalaUDF” to “true” and use this API with caution
UPGRADE_NOT_SUPPORTED
Table is not eligible for upgrade from Hive Metastore to Unity Catalog. Reason:
For more details see UPGRADE_NOT_SUPPORTED
USER_DEFINED_FUNCTIONS
User defined function is invalid:
For more details see USER_DEFINED_FUNCTIONS
Delta Lake
DELTA_ADD_COLUMN_AT_INDEX_LESS_THAN_ZERO
Index <columnIndex> to add column <columnName> is lower than 0
DELTA_ADD_COLUMN_PARENT_NOT_STRUCT
Cannot add <columnName> because its parent is not a StructType. Found <other>
DELTA_AGGREGATE_IN_GENERATED_COLUMN
Found <sqlExpr>. A generated column cannot use an aggregate expression
DELTA_AGGREGATION_NOT_SUPPORTED
Aggregate functions are not supported in the <operation> <predicate>.
DELTA_ALTER_TABLE_CHANGE_COL_NOT_SUPPORTED
ALTER TABLE CHANGE COLUMN is not supported for changing column <currentType> to <newType>
DELTA_ALTER_TABLE_RENAME_NOT_ALLOWED
Operation not allowed: ALTER TABLE RENAME TO is not allowed for managed Delta tables on S3, as eventual consistency on S3 may corrupt the Delta transaction log. If you insist on doing so and are sure that there has never been a Delta table with the new name <newName> before, you can enable this by setting <key> to be true.
DELTA_AMBIGUOUS_PATHS_IN_CREATE_TABLE
CREATE TABLE contains two different locations: <identifier> and <location>.
You can remove the LOCATION clause from the CREATE TABLE statement, or set
<config> to true to skip this check.
DELTA_BLOCK_COLUMN_MAPPING_AND_CDC_OPERATION
Operation “<opName>” is not allowed when the table has enabled change data feed (CDF) and has undergone schema changes using DROP COLUMN or RENAME COLUMN.
DELTA_BLOCK_COLUMN_MAPPING_SCHEMA_INCOMPATIBLE_OPERATION
<opName> is not supported on tables with column mapping schema changes (e.g. rename or drop). Read schema: <readSchema>. Incompatible schema: <incompatibleSchema>. You may force enable streaming read at your own risk by turning on <config>.
DELTA_BLOOM_FILTER_DROP_ON_NON_EXISTING_COLUMNS
Cannot drop bloom filter indices for the following non-existent column(s): <unknownColumns>
DELTA_CANNOT_CHANGE_LOCATION
Cannot change the ‘location’ of the Delta table using SET TBLPROPERTIES. Please use ALTER TABLE SET LOCATION instead.
DELTA_CANNOT_CREATE_BLOOM_FILTER_NON_EXISTING_COL
Cannot create bloom filter indices for the following non-existent column(s): <unknownCols>
DELTA_CANNOT_DROP_BLOOM_FILTER_ON_NON_INDEXED_COLUMN
Cannot drop bloom filter index on a non indexed column: <columnName>
DELTA_CANNOT_FIND_BUCKET_SPEC
Expecting a bucketing Delta table but cannot find the bucket spec in the table
DELTA_CANNOT_GENERATE_UPDATE_EXPRESSIONS
Calling without generated columns should always return a update expression for each column
DELTA_CANNOT_MODIFY_APPEND_ONLY
This table is configured to only allow appends. If you would like to permit updates or deletes, use ‘ALTER TABLE <table_name> SET TBLPROPERTIES (<config>=false)’.
DELTA_CANNOT_MODIFY_TABLE_PROPERTY
The Delta table configuration <prop> cannot be specified by the user
DELTA_CANNOT_RECONSTRUCT_PATH_FROM_URI
A uri (<uri>) which can’t be turned into a relative path was found in the transaction log.
DELTA_CANNOT_RELATIVIZE_PATH
A path (<path>) which can’t be relativized with the current input found in the
transaction log. Please re-run this as:
%%scala com.databricks.delta.Delta.fixAbsolutePathsInLog(“<userPath>”, true)
and then also run:
%%scala com.databricks.delta.Delta.fixAbsolutePathsInLog(“<path>”)
DELTA_CANNOT_REPLACE_MISSING_TABLE
Table <tableName> cannot be replaced as it does not exist. Use CREATE OR REPLACE TABLE to create the table.
DELTA_CANNOT_RESOLVE_SOURCE_COLUMN
Couldn’t resolve qualified source column <columnName> within the source query. Please contact Databricks support.
DELTA_CANNOT_RESTORE_TABLE_VERSION
Cannot restore table to version <version>. Available versions: [<startVersion>, <endVersion>].
DELTA_CANNOT_RESTORE_TIMESTAMP_GREATER
Cannot restore table to timestamp (<requestedTimestamp>) as it is after the latest version available. Please use a timestamp before (<latestTimestamp>)
DELTA_CANNOT_UPDATE_ARRAY_FIELD
Cannot update %1$s field %2$s type: update the element by updating %2$s.element
DELTA_CANNOT_UPDATE_MAP_FIELD
Cannot update %1$s field %2$s type: update a map by updating %2$s.key or %2$s.value
DELTA_CANNOT_UPDATE_STRUCT_FIELD
Cannot update <tableName> field <fieldName> type: update struct by adding, deleting, or updating its fields
DELTA_CDC_NOT_ALLOWED_IN_THIS_VERSION
Configuration delta.enableChangeDataFeed cannot be set. Change data feed from Delta is not yet available.
DELTA_CHANGE_TABLE_FEED_DISABLED
Cannot write to table with delta.enableChangeDataFeed set. Change data feed from Delta is not available.
DELTA_CHECKPOINT_NON_EXIST_TABLE
Cannot checkpoint a non-existing table <path>. Did you manually delete files in the deltalog directory?
DELTA_CLONE_AMBIGUOUS_TARGET
Two paths were provided as the CLONE target so it is ambiguous which to use. An external
location for CLONE was provided at <externalLocation> at the same time as the path
<targetIdentifier>.
DELTA_CLONE_UNSUPPORTED_SOURCE
Unsupported <mode> clone source ‘<name>’, whose format is <format>.
The supported formats are ‘delta’ (any mode) and ‘parquet’ (shallow only).
DELTA_COLUMN_NOT_FOUND_IN_MERGE
Unable to find the column ‘<targetCol>’ of the target table from the INSERT columns: <colNames>. INSERT clause must specify value for all the columns of the target table.
DELTA_COLUMN_PATH_NOT_NESTED
Expected <columnPath> to be a nested data type, but found <other>. Was looking for the
index of <column> in a nested field
DELTA_COLUMN_STRUCT_TYPE_MISMATCH
Struct column <source> cannot be inserted into a <targetType> field <targetField> in <targetTable>.
DELTA_COMPLEX_TYPE_COLUMN_CONTAINS_NULL_TYPE
Found nested NullType in column <columName> which is of <dataType>. Delta doesn’t support writing NullType in complex types.
DELTA_CONSTRAINT_ALREADY_EXISTS
Constraint ‘<constraintName>’ already exists. Please delete the old constraint first.
Old constraint:
<oldConstraint>
DELTA_CONSTRAINT_DOES_NOT_EXIST
Cannot drop nonexistent constraint <constraintName> from table <tableName>. To avoid throwing an error, provide the parameter IF EXISTS or set the SQL session configuration <config> to <confValue>.
DELTA_CONVERSION_UNSUPPORTED_COLUMN_MAPPING
The configuration ‘<config>’ cannot be set to <mode> when using CONVERT TO DELTA.
DELTA_CONVERT_NON_PARQUET_TABLE
CONVERT TO DELTA only supports parquet tables, but you are trying to convert a <sourceName> source: <tableId>
DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_SCHEMA
You are trying to create an external table <tableName>
from <path> using Delta, but the schema is not specified when the
input path is empty.
To learn more about Delta, see <docLink>
DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_TXN_LOG
You are trying to create an external table <tableName>
from %2$s using Delta, but there is no transaction log present at
%2$s/_delta_log. Check the upstream job to make sure that it is writing using
format(“delta”) and that the path is the root of the table.
To learn more about Delta, see <docLink>
DELTA_CREATE_TABLE_SCHEME_MISMATCH
The specified schema does not match the existing schema at <path>.
== Specified ==
<specifiedSchema>
== Existing ==
<existingSchema>
== Differences ==
<schemaDifferences>
If your intention is to keep the existing schema, you can omit the
schema from the create table command. Otherwise please ensure that
the schema matches.
DELTA_CREATE_TABLE_WITH_DIFFERENT_PARTITIONING
The specified partitioning does not match the existing partitioning at <path>.
== Specified ==
<specifiedColumns>
== Existing ==
<existingColumns>
DELTA_CREATE_TABLE_WITH_DIFFERENT_PROPERTY
The specified properties do not match the existing properties at <path>.
== Specified ==
<specificiedProperties>
== Existing ==
<existingProperties>
DELTA_CREATE_TABLE_WITH_NON_EMPTY_LOCATION
Cannot create table (‘<tableId>’). The associated location (‘<tableLocation>’) is not empty but it’s not a Delta table
DELTA_DATA_CHANGE_FALSE
Cannot change table metadata because the ‘dataChange’ option is set to false. Attempted operation: ‘<op>’.
DELTA_DELETION_VECTOR_CHECKSUM_MISMATCH
Could not verify deletion vector integrity, CRC checksum verification failed.
DELTA_DUPLICATE_COLUMNS_ON_UPDATE_TABLE
<message>
Please remove duplicate columns before you update your table.
DELTA_EXPRESSIONS_NOT_FOUND_IN_GENERATED_COLUMN
Cannot find the expressions in the generated column <columnName>
DELTA_EXTRACT_REFERENCES_FIELD_NOT_FOUND
Field <fieldName> could not be found when extracting references.
DELTA_FAILED_FIND_ATTRIBUTE_IN_OUTPUT_COLUMNS
Could not find <newAttributeName> among the existing target output <targetOutputColumns>
DELTA_FAILED_SCAN_WITH_HISTORICAL_VERSION
Expect a full scan of the latest version of the Delta source, but found a historical scan of version <historicalVersion>
DELTA_FAIL_RELATIVIZE_PATH
Failed to relativize the path (<path>). This can happen when absolute paths make
it into the transaction log, which start with the scheme
s3://, wasbs:// or adls://. This is a bug that has existed before DBR 5.0.
To fix this issue, please upgrade your writer jobs to DBR 5.0 and please run:
%%scala com.databricks.delta.Delta.fixAbsolutePathsInLog(“<path>”).
If this table was created with a shallow clone across file systems
(different buckets/containers) and this table is NOT USED IN PRODUCTION, you can
set the SQL configuration <config>
to true. Using this SQL configuration could lead to accidental data loss,
therefore we do not recommend the use of this flag unless
this is a shallow clone for testing purposes.
DELTA_FILE_TO_OVERWRITE_NOT_FOUND
File (<path>) to be rewritten not found among candidate files:
<pathList>
DELTA_FOUND_MAP_TYPE_COLUMN
A MapType was found. In order to access the key or value of a MapType, specify one
of:
<key> or
<value>
followed by the name of the column (only if that column is a struct type).
e.g. mymap.key.mykey
If the column is a basic type, mymap.key or mymap.value is sufficient.
DELTA_GENERATED_COLUMNS_DATA_TYPE_MISMATCH
Column <columnName> is a generated column or a column used by a generated column. The data type is <columnType>. It doesn’t accept data type <dataType>
DELTA_GENERATED_COLUMNS_EXPR_TYPE_MISMATCH
The expression type of the generated column <columnName> is <expressionType>, but the column type is <columnType>
DELTA_GENERATED_COLUMN_UPDATE_TYPE_MISMATCH
Column <currentName> is a generated column or a column used by a generated column. The data type is <currentDataType> and cannot be converted to data type <updateDataType>
DELTA_INCOMPLETE_FILE_COPY
File (<fileName>) not copied completely. Expected file size: <expectedSize>, found: <actualSize>. To continue with the operation by ignoring the file size check set spark.databricks.delta.clone.checkWrite to false.
DELTA_INCONSISTENT_BUCKET_SPEC
BucketSpec on Delta bucketed table does not match BucketSpec from metadata.Expected: <expected>. Actual: <actual>.
DELTA_INCONSISTENT_LOGSTORE_CONFS
(<setKeys>) cannot be set to different values. Please only set one of them, or set them to the same value.
DELTA_INCORRECT_ARRAY_ACCESS
Incorrectly accessing an ArrayType. Use arrayname.element.elementname position to
add to an array.
DELTA_INCORRECT_ARRAY_ACCESS_BY_NAME
An ArrayType was found. In order to access elements of an ArrayType, specify
<rightName>
Instead of <wrongName>
DELTA_INCORRECT_LOG_STORE_IMPLEMENTATION
The error typically occurs when the default LogStore implementation, that
is, HDFSLogStore, is used to write into a Delta table on a non-HDFS storage system.
In order to get the transactional ACID guarantees on table updates, you have to use the
correct implementation of LogStore that is appropriate for your storage system.
See <docLink> for details.
DELTA_INDEX_LARGER_OR_EQUAL_THAN_STRUCT
Index <position> to drop column equals to or is larger than struct length: <length>
DELTA_INDEX_LARGER_THAN_STRUCT
Index <index> to add column <columnName> is larger than struct length: <length>
DELTA_INSERT_COLUMN_ARITY_MISMATCH
Cannot write to ‘<tableName>’, <columnName>; target table has <numColumns> column(s) but the inserted data has <insertColumns> column(s)
DELTA_INVALID_BUCKET_COUNT
Invalid bucket count: <invalidBucketCount>. Bucket count should be a positive number that is power of 2 and at least 8. You can use <validBucketCount> instead.
DELTA_INVALID_CDC_RANGE
CDC range from start <start> to end <end> was invalid. End cannot be before start.
DELTA_INVALID_CHARACTERS_IN_COLUMN_NAME
Attribute name “<columnName>” contains invalid character(s) among ” ,;{}()\n\t=”. Please use alias to rename it.
DELTA_INVALID_CHARACTERS_IN_COLUMN_NAMES
Found invalid character(s) among ‘ ,;{}()nt=’ in the column names of your schema. <advice>
DELTA_INVALID_COMMITTED_VERSION
The committed version is <committedVersion> but the current version is <currentVersion>. Please contact Databricks support.
DELTA_INVALID_FORMAT
Incompatible format detected.
A transaction log for Delta was found at <deltaRootPath>/_delta_log,
but you are trying to <operation> <path> using format(“<format>”). You must use
‘format(“delta”)’ when reading and writing to a delta table.
To disable this check, SET spark.databricks.delta.formatCheck.enabled=false
To learn more about Delta, see <docLink>
DELTA_INVALID_FORMAT_FROM_SOURCE_VERSION
Unsupported format. Expected version should be smaller than or equal to <expectedVersion> but was <realVersion>. Please upgrade to newer version of Delta.
DELTA_INVALID_GENERATED_COLUMN_REFERENCES
A generated column cannot use a non-existent column or another generated column
DELTA_INVALID_LOGSTORE_CONF
(<classConfig>) and (<schemeConfig>) cannot be set at the same time. Please set only one group of them.
DELTA_INVALID_MANAGED_TABLE_SYNTAX_NO_SCHEMA
You are trying to create a managed table <tableName>
using Delta, but the schema is not specified.
To learn more about Delta, see <docLink>
DELTA_INVALID_PARTITIONING_SCHEMA
The AddFile contains partitioning schema different from the table’s partitioning schema
expected: <neededPartitioning>
actual: <specifiedPartitioning>
To disable this check set <config> to “false”
DELTA_INVALID_PARTITION_COLUMN_NAME
Found partition columns having invalid character(s) among ” ,;{}()nt=”. Please change the name to your partition columns. This check can be turned off by setting spark.conf.set(“spark.databricks.delta.partitionColumnValidity.enabled”, false) however this is not recommended as other features of Delta may not work properly.
DELTA_INVALID_PARTITION_COLUMN_TYPE
Using column <name> of type <dataType> as a partition column is not supported.
DELTA_INVALID_PARTITION_PATH
A partition path fragment should be the form like part1=foo/part2=bar. The partition path: <path>
DELTA_INVALID_PROTOCOL_DOWNGRADE
Protocol version cannot be downgraded from <oldProtocol> to <newProtocol>
DELTA_INVALID_TABLE_VALUE_FUNCTION
Function <function> is an unsupported table valued function for CDC reads.
DELTA_INVALID_TIMESTAMP_FORMAT
The provided timestamp <timestamp> does not match the expected syntax <format>.
DELTA_LOG_FILE_NOT_FOUND_FOR_STREAMING_SOURCE
If you never deleted it, it’s likely your query is lagging behind. Please delete its checkpoint to restart from scratch. To avoid this happening again, you can update your retention policy of your Delta table
DELTA_MAX_COMMIT_RETRIES_EXCEEDED
This commit has failed as it has been tried <numAttempts> times but did not succeed.
This can be caused by the Delta table being committed continuously by many concurrent
commits.
Commit started at version: <startVersion>
Commit failed at version: <failVersion>
Number of actions attempted to commit: <numActions>
Total time spent attempting this commit: <timeSpent> ms
DELTA_MERGE_INCOMPATIBLE_DECIMAL_TYPE
Failed to merge decimal types with incompatible <decimalRanges>
DELTA_MERGE_INVALID_WHEN_NOT_MATCHED_CLAUSE
<clause> clauses cannot be part of the WHEN NOT MATCHED clause in MERGE INTO.
DELTA_MERGE_UNEXPECTED_ASSIGNMENT_KEY
Unexpected assignment key: <unexpectedKeyClass> - <unexpectedKeyObject>
DELTA_METADATA_ABSENT
Couldn’t find Metadata while committing the first version of the Delta table. To disable
this check set <deltaCommitValidationEnabled> to “false”
DELTA_MISSING_CHANGE_DATA
Error getting change data for range [<startVersion> , <endVersion>] as change data was not
recorded for version [<version>]. If you’ve enabled change data feed on this table,
use DESCRIBE HISTORY to see when it was first enabled.
Otherwise, to start recording change data, use `ALTER TABLE table_name SET TBLPROPERTIES
(<key>=true)`.
DELTA_MISSING_FILES_UNEXPECTED_VERSION
The stream from your Delta table was expecting process data from version <startVersion>,
but the earliest available version in the deltalog directory is <earliestVersion>. The files
in the transaction log may have been deleted due to log cleanup. In order to avoid losing
data, we recommend that you restart your stream with a new checkpoint location and to
increase your delta.logRetentionDuration setting, if you have explicitly set it below 30
days.
If you would like to ignore the missed data and continue your stream from where it left
off, you can set the .option(“<option>”, “false”) as part
of your readStream statement.
DELTA_MISSING_NOT_NULL_COLUMN_VALUE
Column <columnName>, which has a NOT NULL constraint, is missing from the data being written into the table.
DELTA_MISSING_PROVIDER_FOR_CONVERT
CONVERT TO DELTA only supports parquet tables. Please rewrite your target as parquet.<path> if it’s a parquet directory.
DELTA_MISSING_TRANSACTION_LOG
Incompatible format detected.
You are trying to <operation> <path> using Delta, but there is no
transaction log present. Check the upstream job to make sure that it is writing
using format(“delta”) and that you are trying to %1$s the table base path.
To disable this check, SET spark.databricks.delta.formatCheck.enabled=false
To learn more about Delta, see <docLink>
DELTA_MODE_NOT_SUPPORTED
Specified mode ‘<mode>’ is not supported. Supported modes are: <supportedModes>
DELTA_MULTIPLE_CDC_BOUNDARY
Multiple <startingOrEnding> arguments provided for CDC read. Please provide one of either <startingOrEnding>Timestamp or <startingOrEnding>Version.
DELTA_MULTIPLE_CONF_FOR_SINGLE_COLUMN_IN_BLOOM_FILTER
Multiple bloom filter index configurations passed to command for column: <columnName>
DELTA_MULTIPLE_SOURCE_ROW_MATCHING_TARGET_ROW_IN_MERGE
Cannot perform Merge as multiple source rows matched and attempted to modify the same
target row in the Delta table in possibly conflicting ways. By SQL semantics of Merge,
when multiple source rows match on the same target row, the result may be ambiguous
as it is unclear which source row should be used to update or delete the matching
target row. You can preprocess the source table to eliminate the possibility of
multiple matches. Please refer to
<usageReference>
DELTA_NAME_CONFLICT_IN_BUCKETED_TABLE
The following column name(s) are reserved for Delta bucketed table internal usage only: <names>
DELTA_NESTED_FIELDS_NEED_RENAME
Nested fields need renaming to avoid data loss. Fields:
<fields>.
Original schema:
<schema>
DELTA_NESTED_NOT_NULL_CONSTRAINT
The <nestType> type of the field <parent> contains a NOT NULL constraint. Delta does not support NOT NULL constraints nested within arrays or maps. To suppress this error and silently ignore the specified constraints, set <configKey> = true.
Parsed <nestType> type:
<nestedPrettyJson>
DELTA_NEW_CHECK_CONSTRAINT_VIOLATION
<numRows> rows in <tableName> violate the new CHECK constraint (<checkConstraint>)
DELTA_NEW_NOT_NULL_VIOLATION
<numRows> rows in <tableName> violate the new NOT NULL constraint on <colName>
DELTA_NON_BOOLEAN_CHECK_CONSTRAINT
CHECK constraint ‘<name>’ (<expr>) should be a boolean expression.
DELTA_NON_DETERMINISTIC_FUNCTION_NOT_SUPPORTED
Non-deterministic functions are not supported in the <operation> <expression>
DELTA_NON_GENERATED_COLUMN_MISSING_UPDATE_EXPR
<columnName> is not a generated column but is missing its update expression
DELTA_NON_LAST_MATCHED_CLAUSE_OMIT_CONDITION
When there are more than one MATCHED clauses in a MERGE statement, only the last MATCHED clause can omit the condition.
DELTA_NON_LAST_NOT_MATCHED_CLAUSE_OMIT_CONDITION
When there are more than one NOT MATCHED clauses in a MERGE statement, only the last NOT MATCHED clause can omit the condition
DELTA_NON_PARTITION_COLUMN_ABSENT
Data written into Delta needs to contain at least one non-partitioned column.<details>
DELTA_NON_PARTITION_COLUMN_REFERENCE
Predicate references non-partition column ‘<columnName>’. Only the partition columns may be referenced: [<columnList>]
DELTA_NON_PARTITION_COLUMN_SPECIFIED
Non-partitioning column(s) <columnList> are specified where only partitioning columns are expected: <fragment>.
DELTA_NON_SINGLE_PART_NAMESPACE_FOR_CATALOG
Delta catalog requires a single-part namespace, but <identifier> is multi-part.
DELTA_NOT_A_DATABRICKS_DELTA_TABLE
<table> is not a Delta table. Please drop this table first if you would like to create it with Databricks Delta.
DELTA_NOT_A_DELTA_TABLE
<tableName> is not a Delta table. Please drop this table first if you would like to recreate it with Delta Lake.
DELTA_NOT_NULL_NESTED_FIELD
A non-nullable nested field can’t be added to a nullable parent. Please set the nullability of the parent column accordingly.
DELTA_NO_NEW_ATTRIBUTE_ID
Could not find a new attribute ID for column <columnName>. This should have been checked earlier.
DELTA_NULL_SCHEMA_IN_STREAMING_WRITE
Delta doesn’t accept NullTypes in the schema for streaming writes.
DELTA_OPERATION_NOT_ALLOWED_DETAIL
Operation not allowed: <operation> is not supported for Delta tables: <tableName>
DELTA_OPERATION_ON_TEMP_VIEW_WITH_GENERATED_COLS_NOT_SUPPORTED
<operation> command on a temp view referring to a Delta table that contains generated columns is not supported. Please run the <operation> command on the Delta table directly
DELTA_OVERWRITE_MUST_BE_TRUE
Copy option overwriteSchema cannot be specified without setting OVERWRITE = ‘true’.
DELTA_PARTITION_COLUMN_CAST_FAILED
Failed to cast value <value> to <dataType> for partition column <columnName>
DELTA_POST_COMMIT_HOOK_FAILED
Committing to the Delta table version <version> succeeded but error while executing post-commit hook <name><message>
DELTA_READ_TABLE_WITHOUT_COLUMNS
You are trying to read a table <tableName> without columns using Delta.
Write some data with option mergeSchema = true to enable subsequent read access.
DELTA_REMOVE_FILE_CDC_MISSING_EXTENDED_METADATA
RemoveFile created without extended metadata is ineligible for CDC:
<file>
DELTA_REPLACE_WHERE_IN_OVERWRITE
You can’t use replaceWhere in conjunction with an overwrite by filter
DELTA_REPLACE_WHERE_MISMATCH
Data written out does not match replaceWhere ‘<replaceWhere>’.
<message>
DELTA_REPLACE_WHERE_WITH_DYNAMIC_PARTITION_OVERWRITE
A ‘replaceWhere’ expression and ‘partitionOverwriteMode’=’dynamic’ cannot both be set in the DataFrameWriter options.
DELTA_REPLACE_WHERE_WITH_FILTER_DATA_CHANGE_UNSET
‘replaceWhere’ cannot be used with data filters when ‘dataChange’ is set to false. Filters: <dataFilters>
DELTA_SCHEMA_CHANGED
Detected schema change:
old schema: <oldSchema>
new schema: <newSchema>
Please try restarting the query. If this issue repeats across query restarts without
making progress, you have made an incompatible schema change and need to start your
query from scratch using a new checkpoint directory.
DELTA_SCHEMA_CHANGE_SINCE_ANALYSIS
The schema of your Delta table has changed in an incompatible way since your DataFrame
or DeltaTable object was created. Please redefine your DataFrame or DeltaTable object.
Changes:
<schemaDiff><legacyFlagMessage>
DELTA_SCHEMA_NOT_CONSISTENT_WITH_TARGET
The table schema <tableSchema> is not consistent with the target attributes: <targetAttrs>
DELTA_SCHEMA_NOT_PROVIDED
Table schema is not provided. Please provide the schema (column definition) of the table when using REPLACE table and an AS SELECT query is not provided.
DELTA_SCHEMA_NOT_SET
Table schema is not set. Write data into it or use CREATE TABLE to set the schema.
DELTA_SET_LOCATION_SCHEMA_MISMATCH
The schema of the new Delta location is different than the current table schema.
original schema:
<original>
destination schema:
<destination>
If this is an intended change, you may turn this check off by running:
%%sql set <config> = true
DELTA_SHOW_PARTITION_IN_NON_PARTITIONED_COLUMN
Non-partitioning column(s) <badCols> are specified for SHOW PARTITIONS
DELTA_SHOW_PARTITION_IN_NON_PARTITIONED_TABLE
SHOW PARTITIONS is not allowed on a table that is not partitioned: <tableName>
DELTA_SOURCE_IGNORE_DELETE
Detected deleted data (for example <removedFile>) from streaming source at version <version>. This is currently not supported. If you’d like to ignore deletes, set the option ‘ignoreDeletes’ to ‘true’. The source table can be found at path <dataPath>.
DELTA_SOURCE_TABLE_IGNORE_CHANGES
Detected a data update (for example <file>) in the source table at version <version>. This is currently not supported. If you’d like to ignore updates, set the option ‘ignoreChanges’ to ‘true’. If you would like the data update to be reflected, please restart this query with a fresh checkpoint directory. The source table can be found at path <dataPath>.
DELTA_STATE_RECOVER_ERROR
The <operation> of your Delta table could not be recovered while Reconstructing
version: <version>. Did you manually delete files in the deltalog directory?
Set <config> to “false”
to skip validation.
DELTA_STREAM_CHECK_COLUMN_MAPPING_NO_SNAPSHOT
Failed to obtain Delta log snapshot for the start version when checking column mapping schema changes. Please choose a different start version, or force enable streaming read at your own risk by setting ‘<config>’ to ‘true’.
DELTA_TABLE_ALREADY_CONTAINS_CDC_COLUMNS
Unable to enable Change Data Capture on the table. The table already contains
reserved columns <columnList> that will
be used internally as metadata for the table’s Change Data Feed. To enable
Change Data Feed on the table rename/drop these columns.
DELTA_TABLE_FOR_PATH_UNSUPPORTED_HADOOP_CONF
Currently DeltaTable.forPath only supports hadoop configuration keys starting with <allowedPrefixes> but got <unsupportedOptions>
DELTA_TABLE_LOCATION_MISMATCH
The location of the existing table <tableName> is <existingTableLocation>. It doesn’t match the specified location <tableLocation>.
DELTA_TABLE_NOT_FOUND_STREAMING
Delta table <tableName> doesn’t exist. Please delete your streaming query checkpoint and restart.
DELTA_TABLE_ONLY_OPERATION
<tableName> is not a Delta table. <operation> is only supported for Delta tables.
DELTA_TIMESTAMP_GREATER_THAN_COMMIT
The provided timestamp (<providedTimestamp>) is after the latest version available to this
table (<tableName>). Please use a timestamp before or at <maximumTimestamp>.
DELTA_TRUNCATED_TRANSACTION_LOG
<path>: Unable to reconstruct state at version <version> as the transaction log has been truncated due to manual deletion or the log retention policy (<logRetentionKey>=<logRetention>) and checkpoint retention policy (<checkpointRetentionKey>=<checkpointRetention>)
DELTA_TRUNCATE_TABLE_PARTITION_NOT_SUPPORTED
Operation not allowed: TRUNCATE TABLE on Delta tables does not support partition predicates; use DELETE to delete specific partitions or rows.
DELTA_TXN_LOG_FAILED_INTEGRITY
The transaction log has failed integrity checks. Failed verification at version <version> of:
<mismatchStringOpt>
DELTA_UDF_IN_GENERATED_COLUMN
Found <udfExpr>. A generated column cannot use a user-defined function
DELTA_UNEXPECTED_ACTION_IN_OPTIMIZE
Unexpected action <action> with type <actionClass>. Optimize should only have AddFiles and RemoveFiles.
DELTA_UNEXPECTED_CHANGE_FILES_FOUND
Change files found in a dataChange = false transaction. Files:
<fileList>
DELTA_UNEXPECTED_NUM_PARTITION_COLUMNS_FROM_FILE_NAME
Expecting <expectedColsSize> partition column(s): <expectedCols>, but found <parsedColsSize> partition column(s): <parsedCols> from parsing the file name: <path>
DELTA_UNEXPECTED_PARTIAL_SCAN
Expect a full scan of Delta sources, but found a partial scan. path:<path>
DELTA_UNEXPECTED_PARTITION_COLUMN_FROM_FILE_NAME
Expecting partition column <expectedCol>, but found partition column <parsedCol> from parsing the file name: <path>
DELTA_UNEXPECTED_PARTITION_SCHEMA_FROM_USER
CONVERT TO DELTA was called with a partition schema different from the partition schema inferred from the catalog, please avoid providing the schema so that the partition schema can be chosen from the catalog.
catalog partition schema:
<catalogPartitionSchema>
provided partition schema:
<userPartitionSchema>
DELTA_UNRECOGNIZED_COLUMN_CHANGE
Unrecognized column change <otherClass>. You may be running an out-of-date Delta Lake version.
DELTA_UNSET_NON_EXISTENT_PROPERTY
Attempted to unset non-existent property ‘<property>’ in table <tableName>
DELTA_UNSUPPORTED_ALTER_TABLE_REPLACE_COL_OP
Unsupported ALTER TABLE REPLACE COLUMNS operation. Reason: <details>
Failed to change schema from:
<oldSchema>
to:
<newSchema>
DELTA_UNSUPPORTED_CLONE_REPLACE_SAME_TABLE
You tried to REPLACE an existing table (<tableName>) with CLONE. This operation is
unsupported. Try a different target for CLONE or delete the table at the current target.
DELTA_UNSUPPORTED_COLUMN_MAPPING_MODE_CHANGE
Changing column mapping mode from ‘<oldMode>’ to ‘<newMode>’ is not supported.
DELTA_UNSUPPORTED_COLUMN_MAPPING_PROTOCOL
Your current table protocol version does not support changing column mapping modes
using <config>.
Required Delta protocol version for column mapping:
<requiredVersion>
Your table’s current Delta protocol version:
<currentVersion>
<advice>
DELTA_UNSUPPORTED_COLUMN_MAPPING_SCHEMA_CHANGE
Schema change is detected:
old schema:
<oldTableSchema>
new schema:
<newTableSchema>
Schema changes are not allowed during the change of column mapping mode.
DELTA_UNSUPPORTED_COLUMN_TYPE_IN_BLOOM_FILTER
Creating a bloom filter index on a column with type <dataType> is unsupported: <columnName>
DELTA_UNSUPPORTED_DATA_TYPES
Found columns using unsupported data types: <dataTypeList>. You can set ‘<config>’ to ‘false’ to disable the type check. Disabling this type check may allow users to create unsupported Delta tables and should only be used when trying to read/write legacy tables.
DELTA_UNSUPPORTED_DESCRIBE_DETAIL_VIEW
<view> is a view. DESCRIBE DETAIL is only supported for tables.
DELTA_UNSUPPORTED_DROP_NESTED_COLUMN_FROM_NON_STRUCT_TYPE
Can only drop nested columns from StructType. Found <struct>
DELTA_UNSUPPORTED_EXPRESSION
Unsupported expression type(<expType>) for <causedBy>. The supported types are [<supportedTypes>].
DELTA_UNSUPPORTED_FIELD_UPDATE_NON_STRUCT
Updating nested fields is only supported for StructType, but you are trying to update a field of <columnName>, which is of type: <dataType>.
DELTA_UNSUPPORTED_GENERATE_WITH_DELETION_VECTORS
The ‘GENERATE symlink_format_manifest’ command is not supported on table versions with deletion vectors.
In order to produce a version of the table without deletion vectors, run ‘REORG TABLE table APPLY (PURGE)’. Then re-run the ‘GENERATE’ command.
Make sure that no concurrent transactions are adding deletion vectors again between REORG and GENERATE.
If you need to generate manifests regularly, or you cannot prevent concurrent transactions, consider disabling deletion vectors on this table using ‘ALTER TABLE table SET TBLPROPERTIES (createDeletionVectors = false)’.
DELTA_UNSUPPORTED_INVARIANT_NON_STRUCT
Invariants on nested fields other than StructTypes are not supported.
DELTA_UNSUPPORTED_MANIFEST_GENERATION_WITH_COLUMN_MAPPING
Manifest generation is not supported for tables that leverage column mapping, as external readers cannot read these Delta tables. See Delta documentation for more details.
DELTA_UNSUPPORTED_MERGE_SCHEMA_EVOLUTION_WITH_CDC
MERGE INTO operations with schema evolution do not currently support writing CDC output.
DELTA_UNSUPPORTED_MULTI_COL_IN_PREDICATE
Multi-column In predicates are not supported in the <operation> condition.
DELTA_UNSUPPORTED_NESTED_COLUMN_IN_BLOOM_FILTER
Creating a bloom filer index on a nested column is currently unsupported: <columnName>
DELTA_UNSUPPORTED_NESTED_FIELD_IN_OPERATION
Nested field is not supported in the <operation> (field = <fieldName>).
DELTA_UNSUPPORTED_PARTITION_COLUMN_IN_BLOOM_FILTER
Creating a bloom filter index on a partitioning column is unsupported: <columnName>
DELTA_UNSUPPORTED_STATIC_PARTITIONS
Specifying static partitions in the partition spec is currently not supported during inserts
DELTA_UNSUPPORTED_SUBQUERY_IN_PARTITION_PREDICATES
Subquery is not supported in partition predicates.
DELTA_UNSUPPORTED_VACUUM_SPECIFIC_PARTITION
Please provide the base path (<baseDeltaPath>) when Vacuuming Delta tables. Vacuuming specific partitions is currently not supported.
DELTA_UPDATE_SCHEMA_MISMATCH_EXPRESSION
Cannot cast <fromCatalog> to <toCatalog>. All nested columns must match.
DELTA_VERSIONS_NOT_CONTIGUOUS
Versions (<versionList>) are not contiguous.
For more details see DELTA_VERSIONS_NOT_CONTIGUOUS
DELTA_VIOLATE_CONSTRAINT_WITH_VALUES
CHECK constraint <constraintName> <expression> violated by row with values:
<values>
DELTA_VIOLATE_TABLE_PROPERTY_VALIDATION_FAILED
The validation of the properties of table <table> has been violated:
For more details see DELTA_VIOLATE_TABLE_PROPERTY_VALIDATION_FAILED
Autoloader
CF_ADD_NEW_NOT_SUPPORTED
Schema evolution mode <addNewColumnsMode> is not supported when the schema is specified. To use this mode, you can provide the schema through cloudFiles.schemaHints instead.
CF_AMBIGUOUS_AUTH_OPTIONS_ERROR
Found notification-setup authentication options for the (default) directory
listing mode:
<options>
If you wish to use the file notification mode, please explicitly set:
.option("cloudFiles.\<useNotificationsKey>", "true")
Alternatively, if you want to skip the validation of your options and ignore these
authentication options, you can set:
.option("cloudFiles.ValidateOptionsKey>", "false")
CF_AMBIGUOUS_INCREMENTAL_LISTING_MODE_ERROR
Incremental listing mode (cloudFiles.<useIncrementalListingKey>)
and file notification (cloudFiles.<useNotificationsKey>)
have been enabled at the same time.
Please make sure that you select only one.
CF_BUCKET_MISMATCH
The <storeType> in the file event <fileEvent> is different from expected by the source: <source>.
CF_CANNOT_EVOLVE_SCHEMA_LOG_EMPTY
Cannot evolve schema when the schema log is empty. Schema log location: <logPath>
CF_CANNOT_RESOLVE_CONTAINER_NAME
Cannot resolve container name from path: <path>, Resolved uri: <uri>
CF_CANNOT_RUN_DIRECTORY_LISTING
Cannot run directory listing when there is an async backfill thread running
CF_CLEAN_SOURCE_ALLOW_OVERWRITES_BOTH_ON
Cannot turn on cloudFiles.cleanSource and cloudFiles.allowOverwrites at the same time.
CF_DUPLICATE_COLUMN_IN_DATA
There was an error when trying to infer the partition schema of your table. You have the same column duplicated in your data and partition paths. To ignore the partition value, please provide your partition columns explicitly by using: .option(“cloudFiles.<partitionColumnsKey>”, “{comma-separated-list}”)
CF_EMPTY_DIR_FOR_SCHEMA_INFERENCE
Cannot infer schema when the input path <path> is empty. Please try to start the stream when there are files in the input path, or specify the schema.
CF_EVENT_GRID_AUTH_ERROR
Failed to create an Event Grid subscription. Please make sure that your service
principal has <permissionType> Event Grid Subscriptions. See more details at:
<docLink>
CF_EVENT_GRID_CREATION_FAILED
Failed to create event grid subscription. Please ensure that Microsoft.EventGrid is
registered as resource provider in your subscription. See more details at:
<docLink>
CF_EVENT_GRID_NOT_FOUND_ERROR
Failed to create an Event Grid subscription. Please make sure that your storage
account (<storageAccount>) is under your resource group (<resourceGroup>) and that
the storage account is a “StorageV2 (general purpose v2)” account. See more details at:
<docLink>
CF_EVENT_NOTIFICATION_NOT_SUPPORTED
Auto Loader event notification mode is not supported for <cloudStore>.
CF_FAILED_TO_CREATED_PUBSUB_SUBSCRIPTION
Failed to create subscription: <subscriptionName>. A subscription with the same name already exists and is associated with another topic: <otherTopicName>. The desired topic is <proposedTopicName>. Either delete the existing subscription or create a subscription with a new resource suffix.
CF_FAILED_TO_CREATED_PUBSUB_TOPIC
Failed to create topic: <topicName>. A topic with the same name already exists.<reason> Remove the existing topic or try again with another resource suffix
CF_FAILED_TO_DELETE_GCP_NOTIFICATION
Failed to delete notification with id <notificationId> on bucket <bucketName> for topic <topicName>. Please retry or manually remove the notification through the GCP console.
CF_FAILED_TO_DESERIALIZE_PERSISTED_SCHEMA
Failed to deserialize persisted schema from string: ‘<jsonSchema>’
CF_FAILED_TO_INFER_SCHEMA
Failed to infer schema for format <fileFormatInput> from existing files in input path <path>. Please ensure you configured the options properly or explicitly specify the schema.
CF_FOUND_MULTIPLE_AUTOLOADER_PUBSUB_SUBSCRIPTIONS
Found multiple (<num>) subscriptions with the Auto Loader prefix for topic <topicName>:
<subscriptionList>
There should only be one subscription per topic. Please manually ensure that your topic does not have multiple subscriptions.
CF_GCP_AUTHENTICATION
Please either provide all of the following: <clientEmail>, <client>,
<privateKey>, and <privateKeyId> or provide none of them in order to use the default
GCP credential provider chain for authenticating with GCP resources.
CF_GCP_LABELS_COUNT_EXCEEDED
Received too many labels (<num>) for GCP resource. The maximum label count per resource is <maxNum>.
CF_GCP_RESOURCE_TAGS_COUNT_EXCEEDED
Received too many resource tags (<num>) for GCP resource. The maximum resource tag count per resource is <maxNum>, as resource tags are stored as GCP labels on resources, and Databricks specific tags consume some of this label quota.
CF_INCORRECT_SQL_PARAMS
The cloud_files method accepts two required string parameters: the path to load from, and the file format. File reader options must be provided in a string key-value map. e.g. cloud_files(“path”, “json”, map(“option1”, “value1”)). Received: <params>
CF_INVALID_GCP_RESOURCE_TAG_KEY
Invalid resource tag key for GCP resource: <key>. Keys must start with a lowercase letter, be within 1 to 63 characters long, and contain only lowercase letters, numbers, underscores (_), and hyphens (-).
CF_INVALID_GCP_RESOURCE_TAG_VALUE
Invalid resource tag value for GCP resource: <value>. Values must be within 0 to 63 characters long and must contain only lowercase letters, numbers, underscores (_), and hyphens (-).
CF_INVALID_SCHEMA_EVOLUTION_MODE
cloudFiles.\<schemaEvolutionModeKey> must be one of {
"<addNewColumns>"
"<failOnNewColumns>"
"<rescue>"
"<noEvolution>"}
CF_INVALID_SCHEMA_HINTS_OPTION
Schema hints can only specify a particular column once.
In this case, redefining column: <columnName>
multiple times in schemaHints:
<schemaHints>
CF_INVALID_SCHEMA_HINT_COLUMN
Schema hints can not be used to override maps’ and arrays’ nested types.
Conflicted column: <columnName>
CF_MISSING_METADATA_FILE_ERROR
The metadata file in the streaming source checkpoint directory is missing. This metadata
file contains important default options for the stream, so the stream cannot be restarted
right now. Please contact Databricks support for assistance.
CF_MISSING_PARTITION_COLUMN_ERROR
Partition column <columnName> does not exist in the provided schema:
<schema>
CF_MISSING_SCHEMA_IN_PATHLESS_MODE
Please specify a schema using .schema() if a path is not provided to the CloudFiles source while using file notification mode. Alternatively, to have Auto Loader to infer the schema please provide a base path in .load().
CF_MULTIPLE_PUBSUB_NOTIFICATIONS_FOR_TOPIC
Found existing notifications for topic <topicName> on bucket <bucketName>:
notification,id
<notificationList>
To avoid polluting the subscriber with unintended events, please delete the above notifications and retry.
CF_NEW_PARTITION_ERROR
New partition columns were inferred from your files: [<filesList>]. Please provide all partition columns in your schema or provide a list of partition columns which you would like to extract values for by using: .option(“cloudFiles.partitionColumns”, “{comma-separated-list|empty-string}”)
CF_PARTITON_INFERENCE_ERROR
There was an error when trying to infer the partition schema of the current batch of files. Please provide your partition columns explicitly by using: .option(“cloudFiles.<partitionColumnOption>”, “{comma-separated-list}”)
CF_PERIODIC_BACKFILL_NOT_SUPPORTED
Periodic backfill is not supported if asynchronous backfill is disabled. You can enable asynchronous backfill/directory listing by setting spark.databricks.cloudFiles.asyncDirListing to true
CF_PROTOCOL_MISMATCH
<message>
If you don’t need to make any other changes to your code, then please set the SQL
configuration: ‘<sourceProtocolVersionKey> = <value>’
to resume your stream. Please refer to:
<docLink>
for more details.
CF_REGION_NOT_FOUND_ERROR
Could not get default AWS Region. Please specify a region using the cloudFiles.region option.
CF_RESOURCE_SUFFIX_EMPTY
Failed to create notification services: the resource suffix cannot be empty.
CF_RESOURCE_SUFFIX_INVALID_CHAR_AWS
Failed to create notification services: the resource suffix can only have alphanumeric characters, hyphens (-) and underscores (_).
CF_RESOURCE_SUFFIX_INVALID_CHAR_AZURE
Failed to create notification services: the resource suffix can only have lowercase letter, number, and dash (-).
CF_RESOURCE_SUFFIX_INVALID_CHAR_GCP
Failed to create notification services: the resource suffix can only have alphanumeric characters, hyphens (-), underscores (_), periods (.), tildes (~) plus signs (+), and percent signs (<percentSign>).
CF_RESOURCE_SUFFIX_LIMIT
Failed to create notification services: the resource suffix cannot have more than <limit> characters.
CF_RESOURCE_SUFFIX_LIMIT_GCP
Failed to create notification services: the resource suffix must be between <lowerLimit> and <upperLimit> characters.
CF_RESTRICTED_GCP_RESOURCE_TAG_KEY
Found restricted GCP resource tag key (<key>). The following GCP resource tag keys are restricted for Auto Loader: [<restrictedKeys>]
CF_RETENTION_GREATER_THAN_MAX_FILE_AGE
cloudFiles.cleanSource.retentionDuration cannot be greater than cloudFiles.maxFileAge.
CF_SAME_PUB_SUB_TOPIC_NEW_KEY_PREFIX
Failed to create notification for topic: <topic> with prefix: <prefix>. There is already a topic with the same name with another prefix: <oldPrefix>. Try using a different resource suffix for setup or delete the existing setup.
CF_SOURCE_UNSUPPORTED
The cloud files source only supports S3, Azure Blob Storage (wasb/wasbs) and Azure Data Lake Gen1 (adl) and Gen2 (abfs/abfss) paths right now. path: ‘<path>’, resolved uri: ‘<uri>’
CF_UNABLE_TO_DERIVE_STREAM_CHECKPOINT_LOCATION
Unable to derive the stream checkpoint location from the source checkpoint location: <checkPointLocation>
CF_UNABLE_TO_EXTRACT_BUCKET_INFO
Unable to extract bucket information. Path: ‘<path>’, resolved uri: ‘<uri>’.
CF_UNABLE_TO_EXTRACT_KEY_INFO
Unable to extract key information. Path: ‘<path>’, resolved uri: ‘<uri>’.
CF_UNABLE_TO_EXTRACT_STORAGE_ACCOUNT_INFO
Unable to extract storage account information; path: ‘<path>’, resolved uri: ‘<uri>’
CF_UNABLE_TO_LIST_EFFICIENTLY
Received a directory rename event for the path <path>, but we are unable to list this directory efficiently. In order for the stream to continue, set the option ‘cloudFiles.ignoreDirRenames’ to true, and consider enabling regular backfills with cloudFiles.backfillInterval for this data to be processed.
CF_UNKNOWN_OPTION_KEYS_ERROR
Found unknown option keys:
<optionList>
Please make sure that all provided option keys are correct. If you want to skip the
validation of your options and ignore these unknown options, you can set:
.option("cloudFiles.\<validateOptions>", "false")
CF_UNSUPPORTED_FORMAT_FOR_SCHEMA_INFERENCE
Schema inference is not supported for format: <format>. Please specify the schema.
CF_UNSUPPORTED_LOG_VERSION
UnsupportedLogVersion: maximum supported log version is v<maxVersion>, but encountered v<version>. The log file was produced by a newer version of DBR and cannot be read by this version. Please upgrade.
Geospatial
GEOJSON_PARSE_ERROR
Error parsing GeoJSON: <parseError> at position <pos>
H3_INVALID_CELL_ID
<h3Cell> is not a valid H3 cell ID
H3_INVALID_GRID_DISTANCE_VALUE
H3 grid distance <k> must be non-negative
H3_INVALID_RESOLUTION_VALUE
H3 resolution <r> must be between <minR> and <maxR>, inclusive
H3_NOT_ENABLED
<h3Expression> is disabled or unsupported. Consider enabling Photon or switch to a tier that supports H3 expressions
H3_PENTAGON_ENCOUNTERED_ERROR
A pentagon was encountered while computing the hex ring of <h3Cell> with grid distance <k>
WKB_PARSE_ERROR
Error parsing WKB: <parseError> at position <pos>