SQLSTATE 代码

适用于:勾选“是” Databricks SQL 勾选“是” Databricks Runtime 12.2 及更高版本

Azure Databricks 返回的所有错误类都与一个 5 字符 SQLSTATE 相关联。 SQLSTATEJDBCODBC 和其他客户端 API 常用的错误条件的 SQL 标准编码。

SQLSTATE 由两个部分组成:双字符类和三字符子类。 每个字符必须是数字 '0''9',或字母 'A''Z'

虽然许多 SQLSTATE 值是由 SQL 标准规定的,但有些值在行业中很常用且特定于 Spark 或 Azure Databricks。

如有必要,Spark 和 Azure Databricks 会将 'KD' 类和 'K**' 子类范围用于自定义 SQLSTATE。 类 'XX' 用于可保证 bug 报告的内部错误。

有关错误类的已排序列表,请参阅:Azure Databricks 中的错误处理

Azure Databricks 使用以下 SQLSTATE 类:

07:动态 SQL 错误

SQLSTATE 描述和发出错误类
07001 using 子句与动态参数规范不匹配
ALL_PARAMETERS_MUST_BE_NAMED
07501 在 PREPARE 或 EXECUTE 上指定的选项无效。
INVALID_STATEMENT_FOR_EXECUTE_INTONESTED_EXECUTE_IMMEDIATE

08:连接异常

SQLSTATE 描述和发出错误类
08000 连接异常
AI_FUNCTION_HTTP_REQUEST_ERRORAI_FUNCTION_INVALID_HTTP_RESPONSECANNOT_VALIDATE_CONNECTION
08001 SQL 客户端无法建立 SQL 连接
CANNOT_ESTABLISH_CONNECTIONCANNOT_ESTABLISH_CONNECTION_SERVERLESS
08003 连接不存在
DELTA_ACTIVE_SPARK_SESSION_NOT_FOUND
08KD1 服务器忙
SERVER_IS_BUSY

0A:功能不受支持

SQLSTATE 描述和发出错误类
0A000 功能不受支持
AI_FUNCTION_UNSUPPORTED_REQUEST, AI_FUNCTION_UNSUPPORTED_RETURN_TYPE, AVRO_DEFAULT_VALUES_UNSUPPORTED, AVRO_POSITIONAL_FIELD_MATCHING_UNSUPPORTED, CANNOT_INVOKE_IN_TRANSFORMATIONS, CANNOT_SAVE_VARIANT, CANNOT_UPDATE_FIELD, CF_ADD_NEW_NOT_SUPPORTED, CF_EVENT_NOTIFICATION_NOT_SUPPORTED, CF_PERIODIC_BACKFILL_NOT_SUPPORTED, CF_SOURCE_UNSUPPORTED, CF_STATEFUL_STREAMING_SCHEMA_EVOLUTION, CF_UNSUPPORTED_CLOUD_FILES_SQL_FUNCTION, CF_UNSUPPORTED_FORMAT_FOR_SCHEMA_INFERENCE, CF_UNSUPPORTED_LOG_VERSION, CF_UNSUPPORTED_SCHEMA_EVOLUTION_MODE, CLASS_UNSUPPORTED_BY_MAP_OBJECTS, CLEANROOM_COMMANDS_NOT_SUPPORTED, COLUMN_MASKS_CHECK_CONSTRAINT_UNSUPPORTED, COLUMN_MASKS_FEATURE_NOT_SUPPORTED, COLUMN_MASKS_INCOMPATIBLE_SCHEMA_CHANGE, COLUMN_MASKS_MERGE_UNSUPPORTED_SOURCE, COLUMN_MASKS_MERGE_UNSUPPORTED_TARGET, COLUMN_MASKS_REQUIRE_UNITY_CATALOG, COLUMN_MASKS_TABLE_CLONE_SOURCE_NOT_SUPPORTED, COLUMN_MASKS_TABLE_CLONE_TARGET_NOT_SUPPORTED, COLUMN_MASKS_UNSUPPORTED_PROVIDER, COLUMN_MASKS_UNSUPPORTED_SUBQUERY, CONCURRENT_QUERY, CONSTRAINTS_REQUIRE_UNITY_CATALOG, COPY_INTO_CREDENTIALS_NOT_ALLOWED_ON, COPY_INTO_ENCRYPTION_NOT_ALLOWED_ON, COPY_INTO_ENCRYPTION_NOT_SUPPORTED_FOR_AZURE, COPY_INTO_SOURCE_FILE_FORMAT_NOT_SUPPORTED, CREATE_OR_REFRESH_MV_ST_ASYNC, CREATE_PERMANENT_VIEW_WITHOUT_ALIAS, CSV_ENFORCE_SCHEMA_NOT_SUPPORTED, DC_FEATURE_NOT_ENABLED, DC_UNSUPPORTED_ERROR, DELTA_ADDING_DELETION_VECTORS_DISALLOWED, DELTA_ADD_CONSTRAINTS, DELTA_CANNOT_WRITE_INTO_VIEW, DELTA_CLUSTERING_CLONE_TABLE_NOT_SUPPORTED, DELTA_CLUSTERING_SHOW_CREATE_TABLE_WITHOUT_CLUSTERING_COLUMNS, DELTA_CLUSTERING_WITH_PARTITION_PREDICATE, DELTA_DOMAIN_METADATA_NOT_SUPPORTED, DELTA_DYNAMIC_PARTITION_OVERWRITE_DISABLED, DELTA_NESTED_SUBQUERY_NOT_SUPPORTED, DELTA_NOT_NULL_NESTED_FIELD, DELTA_OPERATION_ON_TEMP_VIEW_WITH_GENERATED_COLS_NOT_SUPPORTED, DELTA_SOURCE_IGNORE_DELETE, DELTA_SOURCE_TABLE_IGNORE_CHANGES, DELTA_UNSUPPORTED_DEEP_CLONE, DELTA_UNSUPPORTED_EXPRESSION, DELTA_UNSUPPORTED_FSCK_WITH_DELETION_VECTORS, DELTA_UNSUPPORTED_GENERATE_WITH_DELETION_VECTORS, DELTA_UNSUPPORTED_LIST_KEYS_WITH_PREFIX, DELTA_UNSUPPORTED_MERGE_SCHEMA_EVOLUTION_WITH_CDC, DELTA_UNSUPPORTED_SORT_ON_BUCKETED_TABLES, DELTA_UNSUPPORTED_TRUNCATE_SAMPLE_TABLES, DELTA_UNSUPPORTED_WRITE_SAMPLE_TABLES, DELTA_VIOLATE_TABLE_PROPERTY_VALIDATION_FAILED, DELTA_WRITE_INTO_VIEW_NOT_SUPPORTED, DISTINCT_WINDOW_FUNCTION_UNSUPPORTED, EXTERNAL_TABLE_INVALID_SCHEME, FABRIC_REFRESH_INVALID_SCOPE, FROM_JSON_INFERENCE_NOT_SUPPORTED, H3_NOT_ENABLED, INFINITE_STREAMING_TRIGGER_NOT_SUPPORTED, INVALID_PANDAS_UDF_PLACEMENT, MATERIALIZED_VIEW_OUTPUT_WITHOUT_EXPLICIT_ALIAS, MATERIALIZED_VIEW_UNSUPPORTED_OPERATION, MULTI_UDF_INTERFACE_ERROR, NAMED_PARAMETERS_NOT_SUPPORTED_FOR_SQL_UDFS, NAMED_PARAMETER_SUPPORT_DISABLED, NOT_SUPPORTED_CHANGE_COLUMN, NOT_SUPPORTED_COMMAND_FOR_V2_TABLE, NOT_SUPPORTED_COMMAND_WITHOUT_HIVE_SUPPORT, NOT_SUPPORTED_IN_JDBC_CATALOG, NOT_SUPPORTED_WITH_DB_SQL, PROTOBUF_JAVA_CLASSES_NOT_SUPPORTED, PS_SPARK_SPECULATION_NOT_SUPPORTED, PS_UNSUPPORTED_GET_OFFSET_CALL, RESTRICTED_STREAMING_OPTION_PERMISSION_ENFORCED, ROW_LEVEL_SECURITY_CHECK_CONSTRAINT_UNSUPPORTED, ROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTED, ROW_LEVEL_SECURITY_INCOMPATIBLE_SCHEMA_CHANGE, ROW_LEVEL_SECURITY_MERGE_UNSUPPORTED_SOURCE, ROW_LEVEL_SECURITY_MERGE_UNSUPPORTED_TARGET, ROW_LEVEL_SECURITY_REQUIRE_UNITY_CATALOG, ROW_LEVEL_SECURITY_TABLE_CLONE_SOURCE_NOT_SUPPORTED, ROW_LEVEL_SECURITY_TABLE_CLONE_TARGET_NOT_SUPPORTED, ROW_LEVEL_SECURITY_UNSUPPORTED_PROVIDER, SCALAR_SUBQUERY_IS_IN_GROUP_BY_OR_AGGREGATE_FUNCTION, STAR_GROUP_BY_POS, STORED_PROCEDURE_NOT_SUPPORTED, STREAMING_AQE_NOT_SUPPORTED_FOR_STATEFUL_OPERATORS, STREAMING_FROM_MATERIALIZED_VIEW, ST_NOT_ENABLED, ST_UNSUPPORTED_RETURN_TYPE, TABLE_VALUED_ARGUMENTS_NOT_YET_IMPLEMENTED_FOR_SQL_FUNCTIONS, UC_HIVE_METASTORE_FEDERATION_NOT_ENABLED, UDF_PYSPARK_UNSUPPORTED_TYPE, UDF_UNSUPPORTED_PARAMETER_DEFAULT_VALUE, UDTF_PYSPARK_NOT_SUPPORTED, UNSUPPORTED_ADD_FILE, UNSUPPORTED_ARROWTYPE, UNSUPPORTED_CHAR_OR_VARCHAR_AS_STRING, UNSUPPORTED_CLAUSE_FOR_OPERATION, UNSUPPORTED_CONSTRAINT_CLAUSES, UNSUPPORTED_DATASOURCE_FOR_DIRECT_QUERY, UNSUPPORTED_DATATYPE, UNSUPPORTED_DATA_SOURCE_SAVE_MODE, UNSUPPORTED_DATA_TYPE_FOR_DATASOURCE, UNSUPPORTED_DEFAULT_VALUE, UNSUPPORTED_DESERIALIZER, UNSUPPORTED_FEATURE, UNSUPPORTED_FN_TYPE, UNSUPPORTED_NESTED_ROW_OR_COLUMN_ACCESS_POLICY, UNSUPPORTED_SAVE_MODE, UNSUPPORTED_STREAMING_OPTIONS_FOR_VIEW, UNSUPPORTED_STREAMING_OPTIONS_PERMISSION_ENFORCED, UNSUPPORTED_STREAMING_SINK_PERMISSION_ENFORCED, UNSUPPORTED_STREAMING_SOURCE_PERMISSION_ENFORCED, UNSUPPORTED_STREAM_READ_LIMIT_FOR_KINESIS_SOURCE, UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY, UNSUPPORTED_TIMESERIES_WITH_MORE_THAN_ONE_COLUMN, UNSUPPORTED_TRIGGER_FOR_KINESIS_SOURCE, UNSUPPORTED_TYPED_LITERAL
0AKD0 不支持跨目录或架构操作
CANNOT_COPY_STATE, CANNOT_REFERENCE_UC_IN_HMS, CANNOT_RENAME_ACROSS_CATALOG, CANNOT_RENAME_ACROSS_SCHEMA, CANNOT_SHALLOW_CLONE_ACROSS_UC_AND_HMS
0AKD1 不支持安全功能
COLUMN_MASKS_UNSUPPORTED_CONSTANT_AS_PARAMETERROW_LEVEL_SECURITY_UNSUPPORTED_CONSTANT_AS_PARAMETER
0AKDC 在 Delta 中不受支持
DELTA_CANNOT_EVALUATE_EXPRESSIONDELTA_CANNOT_GENERATE_CODE_FOR_EXPRESSIONDELTA_CDC_NOT_ALLOWED_IN_THIS_VERSIONDELTA_CHANGE_DATA_FEED_INCOMPATIBLE_DATA_SCHEMADELTA_CHANGE_DATA_FEED_INCOMPATIBLE_SCHEMA_CHANGEDELTA_CLONE_UNSUPPORTED_SOURCEDELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_PARTITIONED_COLUMNDELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_TYPEDELTA_CONVERSION_UNSUPPORTED_COLUMN_MAPPINGDELTA_CONVERT_NON_PARQUET_TABLEDELTA_INCORRECT_LOG_STORE_IMPLEMENTATIONDELTA_MISSING_PROVIDER_FOR_CONVERTDELTA_MODE_NOT_SUPPORTEDDELTA_NESTED_NOT_NULL_CONSTRAINTDELTA_NON_DETERMINISTIC_FUNCTION_NOT_SUPPORTEDDELTA_OPERATION_NOT_ALLOWEDDELTA_OPERATION_NOT_ALLOWED_DETAILDELTA_TABLE_FOR_PATH_UNSUPPORTED_HADOOP_CONFDELTA_TRUNCATE_TABLE_PARTITION_NOT_SUPPORTEDDELTA_UNIFORM_NOT_SUPPORTEDDELTA_UNSUPPORTED_ABS_PATH_ADD_FILEDELTA_UNSUPPORTED_ALTER_TABLE_CHANGE_COL_OPDELTA_UNSUPPORTED_ALTER_TABLE_REPLACE_COL_OPDELTA_UNSUPPORTED_CLONE_REPLACE_SAME_TABLEDELTA_UNSUPPORTED_COLUMN_MAPPING_MODE_CHANGEDELTA_UNSUPPORTED_COLUMN_MAPPING_SCHEMA_CHANGEDELTA_UNSUPPORTED_COLUMN_MAPPING_WRITEDELTA_UNSUPPORTED_COLUMN_TYPE_IN_BLOOM_FILTERDELTA_UNSUPPORTED_COMMENT_MAP_ARRAYDELTA_UNSUPPORTED_DATA_TYPESDELTA_UNSUPPORTED_DROP_CLUSTERING_COLUMNDELTA_UNSUPPORTED_DROP_COLUMNDELTA_UNSUPPORTED_DROP_NESTED_COLUMN_FROM_NON_STRUCT_TYPEDELTA_UNSUPPORTED_DROP_PARTITION_COLUMNDELTA_UNSUPPORTED_FIELD_UPDATE_NON_STRUCTDELTA_UNSUPPORTED_INVARIANT_NON_STRUCTDELTA_UNSUPPORTED_IN_SUBQUERYDELTA_UNSUPPORTED_MANIFEST_GENERATION_WITH_COLUMN_MAPPINGDELTA_UNSUPPORTED_MULTI_COL_IN_PREDICATEDELTA_UNSUPPORTED_NESTED_COLUMN_IN_BLOOM_FILTERDELTA_UNSUPPORTED_NESTED_FIELD_IN_OPERATIONDELTA_UNSUPPORTED_NON_EMPTY_CLONEDELTA_UNSUPPORTED_OUTPUT_MODEDELTA_UNSUPPORTED_PARTITION_COLUMN_IN_BLOOM_FILTERDELTA_UNSUPPORTED_RENAME_COLUMNDELTA_UNSUPPORTED_SCHEMA_DURING_READDELTA_UNSUPPORTED_SUBQUERYDELTA_UNSUPPORTED_SUBQUERY_IN_PARTITION_PREDICATESDELTA_UNSUPPORTED_TIME_TRAVEL_VIEWSDELTA_UNSUPPORTED_VACUUM_SPECIFIC_PARTITIONWRONG_COLUMN_DEFAULTS_FOR_DELTA_ALTER_TABLE_ADD_COLUMN_NOT_SUPPORTED
0AKDD 功能需要 Delta
DELTA_COPY_INTO_TARGET_FORMAT, DELTA_NOT_A_DELTA_TABLE, DELTA_ONLY_OPERATION, DELTA_TABLE_ONLY_OPERATION, DELTA_UNSUPPORTED_SOURCE, DELTA_UNSUPPORTED_STATIC_PARTITIONS, SYNC_METADATA_DELTA_ONLY, UNSUPPORTED_MANAGED_TABLE_CREATION
0AKDE 未为此 Delta 表启用功能
DELTA_CLUSTERING_PHASE_OUT_FAILEDDELTA_DATA_CHANGE_FALSEDELTA_FEATURES_PROTOCOL_METADATA_MISMATCHDELTA_FEATURES_REQUIRE_MANUAL_ENABLEMENTDELTA_FEATURE_DROP_CONFLICT_REVALIDATION_FAILDELTA_FEATURE_DROP_FEATURE_NOT_PRESENTDELTA_FEATURE_DROP_HISTORICAL_VERSIONS_EXISTDELTA_FEATURE_DROP_HISTORY_TRUNCATION_NOT_ALLOWEDDELTA_FEATURE_DROP_NONREMOVABLE_FEATUREDELTA_FEATURE_DROP_UNSUPPORTED_CLIENT_FEATUREDELTA_FEATURE_DROP_WAIT_FOR_RETENTION_PERIODDELTA_FEATURE_REQUIRES_HIGHER_READER_VERSIONDELTA_FEATURE_REQUIRES_HIGHER_WRITER_VERSIONDELTA_UNSUPPORTED_FEATURE_STATUSWRONG_COLUMN_DEFAULTS_FOR_DELTA_FEATURE_NOT_ENABLED
0AKUC 在 Unity Catalog 中不受支持
CANNOT_SHALLOW_CLONE_NESTED, CANNOT_SHALLOW_CLONE_NON_UC_MANAGED_TABLE_AS_SOURCE_OR_TARGET, INVALID_SCHEME, PARTITION_METADATA, UC_BUCKETED_TABLES, UC_COMMAND_NOT_SUPPORTED, UC_DATASOURCE_NOT_SUPPORTED, UC_DATASOURCE_OPTIONS_NOT_SUPPORTED, UC_FILE_SCHEME_FOR_TABLE_CREATION_NOT_SUPPORTED, UC_INVALID_NAMESPACE, UC_INVALID_REFERENCE, UPGRADE_NOT_SUPPORTED
0AKUD 功能需要 Unity Catalog
FEATURE_REQUIRES_UCOPERATION_REQUIRES_UNITY_CATALOGSYNC_METADATA_NOT_SUPPORTED

0B:无效的事务启动

SQLSTATE 描述和发出错误类
0B000 无效的事务启动
DELTA_ACTIVE_TRANSACTION_ALREADY_SET

0N:SQL/XML 映射错误

SQLSTATE 描述和发出错误类
0N000 SQL/XML 映射错误
XML_UNSUPPORTED_NESTED_TYPES

21:基数冲突

SQLSTATE 描述和发出错误类
21000 基数冲突
ROW_SUBQUERY_TOO_MANY_ROWS, SCALAR_SUBQUERY_TOO_MANY_ROWS
21506 表的同一行不能是多个更新、删除或插入操作的目标。
DELTA_MULTIPLE_SOURCE_ROW_MATCHING_TARGET_ROW_IN_MERGE
21S01 插入值列表与列列表不匹配
CREATE_VIEW_COLUMN_ARITY_MISMATCH, INSERT_COLUMN_ARITY_MISMATCH, INSERT_PARTITION_COLUMN_ARITY_MISMATCH

22:数据异常

SQLSTATE 描述和发出错误类
22000 数据异常
AI_FUNCTION_JSON_PARSE_ERROR, CF_BUCKET_MISMATCH, CF_CANNOT_EVOLVE_SCHEMA_LOG_EMPTY, CF_CANNOT_PARSE_QUEUE_MESSAGE, CF_CANNOT_RESOLVE_CONTAINER_NAME, CF_CANNOT_RUN_DIRECTORY_LISTING, CF_DUPLICATE_COLUMN_IN_DATA, CF_EVENT_GRID_AUTH_ERROR, CF_EVENT_GRID_CREATION_FAILED, CF_EVENT_GRID_NOT_FOUND_ERROR, CF_FAILED_TO_CHECK_STREAM_NEW, CF_FAILED_TO_CREATED_PUBSUB_SUBSCRIPTION, CF_FAILED_TO_CREATED_PUBSUB_TOPIC, CF_FAILED_TO_DELETE_GCP_NOTIFICATION, CF_FAILED_TO_DESERIALIZE_PERSISTED_SCHEMA, CF_FAILED_TO_EVOLVE_SCHEMA, CF_FAILED_TO_INFER_SCHEMA, CF_FAILED_TO_WRITE_TO_SCHEMA_LOG, CF_FOUND_MULTIPLE_AUTOLOADER_PUBSUB_SUBSCRIPTIONS, CF_GCP_LABELS_COUNT_EXCEEDED, CF_GCP_RESOURCE_TAGS_COUNT_EXCEEDED, CF_INCOMPLETE_LOG_FILE_IN_SCHEMA_LOG, CF_INCOMPLETE_METADATA_FILE_IN_CHECKPOINT, CF_INVALID_MANAGED_FILE_EVENTS_RESPONSE, CF_LATEST_OFFSET_READ_LIMIT_REQUIRED, CF_LOG_FILE_MALFORMED, CF_MANAGED_FILE_EVENTS_BACKFILL_IN_PROGRESS, CF_METADATA_FILE_CONCURRENTLY_USED, CF_MULTIPLE_PUBSUB_NOTIFICATIONS_FOR_TOPIC, CF_NEW_PARTITION_ERROR, CF_PARTITON_INFERENCE_ERROR, CF_PREFIX_MISMATCH, CF_PROTOCOL_MISMATCH, CF_RESTRICTED_GCP_RESOURCE_TAG_KEY, CF_SAME_PUB_SUB_TOPIC_NEW_KEY_PREFIX, CF_THREAD_IS_DEAD, CF_UNABLE_TO_LIST_EFFICIENTLY, CF_UNEXPECTED_READ_LIMIT, CF_UNKNOWN_READ_LIMIT, DELTA_CANNOT_FIND_BUCKET_SPEC, DELTA_CLUSTERING_COLUMN_MISSING_STATS, DELTA_CLUSTERING_CREATE_EXTERNAL_NON_LIQUID_TABLE_FROM_LIQUID_TABLE, DELTA_COMPACTION_VALIDATION_FAILED, DELTA_CONVERT_TO_DELTA_ROW_TRACKING_WITHOUT_STATS, DELTA_DV_HISTOGRAM_DESERIALIZATON, DELTA_INVALID_FORMAT, DELTA_INVALID_TABLE_VALUE_FUNCTION, DELTA_MATERIALIZED_ROW_TRACKING_COLUMN_NAME_MISSING, DELTA_ROW_ID_ASSIGNMENT_WITHOUT_STATS, DELTA_STREAMING_METADATA_EVOLUTION, DELTA_STREAMING_SCHEMA_EVOLUTION_UNSUPPORTED_ROW_FILTER_COLUMN_MASKS, DELTA_STREAMING_SCHEMA_LOCATION_CONFLICT, DELTA_STREAMING_SCHEMA_LOCATION_NOT_UNDER_CHECKPOINT, DELTA_STREAMING_SCHEMA_LOG_DESERIALIZE_FAILED, DELTA_STREAMING_SCHEMA_LOG_INCOMPATIBLE_DELTA_TABLE_ID, DELTA_STREAMING_SCHEMA_LOG_INCOMPATIBLE_PARTITION_SCHEMA, DELTA_STREAMING_SCHEMA_LOG_INIT_FAILED_INCOMPATIBLE_METADATA, DELTA_STREAMING_SCHEMA_LOG_PARSE_SCHEMA_FAILED, HLL_UNION_DIFFERENT_LG_K, INVALID_TIMESTAMP_FORMAT, KAFKA_DATA_LOSS, KINESIS_COULD_NOT_READ_SHARD_UNTIL_END_OFFSET, PS_FETCH_RETRY_EXCEPTION, PS_INVALID_KEY_TYPE, PS_INVALID_UNSAFE_ROW_CONVERSION_FROM_PROTO, PS_MOVING_CHECKPOINT_FAILURE, PS_MULTIPLE_FAILED_EPOCHS, PS_OPTION_NOT_IN_BOUNDS, PS_UNABLE_TO_PARSE_PROTO, STAGING_PATH_CURRENTLY_INACCESSIBLE
22001 字符串数据,右截断
DELTA_EXCEED_CHAR_VARCHAR_LIMIT
22003 数值超出范围
ARITHMETIC_OVERFLOWBINARY_ARITHMETIC_OVERFLOWCAST_OVERFLOWCAST_OVERFLOW_IN_TABLE_INSERTDECIMAL_PRECISION_EXCEEDS_MAX_PRECISIONDELTA_CANNOT_RESTORE_TABLE_VERSIONDELTA_CANNOT_RESTORE_TIMESTAMP_GREATERDELTA_CAST_OVERFLOW_IN_TABLE_WRITEDELTA_INVALID_CDC_RANGEINCORRECT_RAMP_UP_RATEINVALID_ARRAY_INDEXINVALID_ARRAY_INDEX_IN_ELEMENT_ATINVALID_BITMAP_POSITIONINVALID_BOUNDARYINVALID_INDEX_OF_ZEROINVALID_NUMERIC_LITERAL_RANGENUMERIC_OUT_OF_SUPPORTED_RANGENUMERIC_VALUE_OUT_OF_RANGESUM_OF_LIMIT_AND_OFFSET_EXCEEDS_MAX_INT
22004 不允许为 null 值
COMPARATOR_RETURNS_NULLTWS_VALUE_SHOULD_NOT_BE_NULL
22005 分配错误
DELTA_COMPLEX_TYPE_COLUMN_CONTAINS_NULL_TYPEDELTA_FAILED_TO_MERGE_FIELDSDELTA_MERGE_UNEXPECTED_ASSIGNMENT_KEY
22006 无效的间隔格式
CANNOT_PARSE_INTERVALDELTA_INVALID_INTERVAL
22007 无效的日期/时间格式
CANNOT_PARSE_TIMESTAMPDELTA_INVALID_TIMESTAMP_FORMAT
22008 日期/时间字段溢出
DATETIME_OVERFLOW
2200E 数组目标中包含 null 值
NULL_MAP_KEY
2200G 最具体类型不匹配
DELTA_COLUMN_STRUCT_TYPE_MISMATCH
2200P 间隔值超出范围
DELTA_INVALID_CALENDAR_INTERVAL_EMPTY
22012 被零除
DIVIDE_BY_ZEROINTERVAL_DIVIDED_BY_ZERO
22015 间隔字段溢出
INTERVAL_ARITHMETIC_OVERFLOW
22018 要强制转换的字符值无效
CANNOT_PARSE_DECIMALCANNOT_PARSE_PROTOBUF_DESCRIPTORCAST_INVALID_INPUTCONVERSION_INVALID_INPUTDELTA_FAILED_CAST_PARTITION_VALUEFAILED_PARSE_STRUCT_TYPE
2201B 无效的正则表达式
DELTA_REGEX_OPT_SYNTAX_ERROR
22023 无效的参数值
CONFLICTING_PROVIDERDELTA_INVALID_AUTO_COMPACT_TYPEDELTA_INVALID_BUCKET_COUNTDELTA_INVALID_BUCKET_INDEXDELTA_UNSUPPORTED_STRATEGY_NAMEEMPTY_LOCAL_FILE_IN_STAGING_ACCESS_QUERYEWKB_PARSE_ERRORGEOJSON_PARSE_ERRORH3_INVALID_CELL_IDH3_INVALID_GRID_DISTANCE_VALUEH3_INVALID_RESOLUTION_VALUEH3_PENTAGON_ENCOUNTERED_ERRORH3_UNDEFINED_GRID_DISTANCEINVALID_FRACTION_OF_SECONDINVALID_PARAMETER_MARKER_VALUEINVALID_PARAMETER_VALUEMALFORMED_RECORD_IN_PARSINGMALFORMED_VARIANTMAX_RECORDS_PER_FETCH_INVALID_FOR_KINESIS_SOURCERULE_ID_NOT_FOUNDSECOND_FUNCTION_ARGUMENT_NOT_INTEGERST_DIFFERENT_SRID_VALUESST_INVALID_ARGUMENTST_INVALID_ARGUMENT_TYPEST_INVALID_CRS_TRANSFORMATION_ERRORST_INVALID_ENDIANNESS_VALUEST_INVALID_GEOHASH_VALUEST_INVALID_PRECISION_VALUEST_INVALID_SRID_VALUETABLE_VALUED_FUNCTION_REQUIRED_METADATA_INCOMPATIBLE_WITH_CALLTABLE_VALUED_FUNCTION_REQUIRED_METADATA_INVALIDVARIANT_SIZE_LIMITWKB_PARSE_ERRORWKT_PARSE_ERRORXML_WILDCARD_RESCUED_DATA_CONFLICT_ERROR
22032 无效的 JSON 文本
AI_FUNCTION_INVALID_MAX_WORDSAI_INVALID_ARGUMENT_VALUE_ERRORINVALID_JSON_ROOT_FIELDINVALID_JSON_SCHEMA_MAP_TYPEREMOTE_FUNCTION_HTTP_RESULT_PARSE_ERROR
2203G sql json 项无法强制转换为目标类型
AI_FUNCTION_HTTP_PARSE_CAST_ERRORAI_FUNCTION_HTTP_PARSE_COLUMNS_ERRORCANNOT_PARSE_JSON_FIELD
22525 分区键值无效。
DELTA_PARTITION_COLUMN_CAST_FAILED
22531 内置或系统提供的例程的参数导致错误。
INVALID_SECRET_LOOKUP
22546 例程参数的值无效。
CANNOT_DECODE_URLHLL_INVALID_INPUT_SKETCH_BUFFERHLL_INVALID_LG_K
22KD1 无效的 URI 或路径
DELTA_CANNOT_RECONSTRUCT_PATH_FROM_URIDELTA_CANNOT_RENAME_PATHDELTA_INVALID_CLONE_PATHDELTA_INVALID_PARTITION_PATH
22KD2 未设置标识声明
OAUTH_CUSTOM_IDENTITY_CLAIM_NOT_PROVIDED
22KD3 无法将源类型演化为目标类型。
AVRO_INCOMPATIBLE_READ_TYPEFROM_JSON_SCHEMA_EVOLUTION_FAILED
22P02 文本表示形式无效
INVALID_URL
22P03 二进制表示形式无效
INVALID_BYTE_STRING

23:完整性约束冲突

SQLSTATE 描述和发出错误类
23001 限制冲突
DELTA_VIOLATE_CONSTRAINT_WITH_VALUES
23502 插入或更新值为 null,但列不能包含 null 值。
DELTA_MISSING_NOT_NULL_COLUMN_VALUEDELTA_NOT_NULL_CONSTRAINT_VIOLATED
23505 唯一索引或唯一约束施加的约束发生冲突。
DUPLICATED_MAP_KEYDUPLICATE_KEY
23512 无法添加检查约束,因为表包含不满足约束定义的行。
DELTA_NEW_CHECK_CONSTRAINT_VIOLATIONDELTA_NEW_NOT_NULL_VIOLATION
23K01 MERGE 基数冲突
MERGE_CARDINALITY_VIOLATION

25:无效的事务状态

SQLSTATE 描述和发出错误类
25000 无效的事务状态
COPY_INTO_DUPLICATED_FILES_COPY_NOT_ALLOWEDCOPY_INTO_NON_BLIND_APPEND_NOT_ALLOWEDCOPY_INTO_ROCKSDB_MAX_RETRY_EXCEEDEDDATA_LINEAGE_SECURE_VIEW_LEAF_NODE_HAS_NO_RELATIONDELTA_INVALID_ISOLATION_LEVELDELTA_MERGE_MATERIALIZE_SOURCE_FAILED_REPEATEDLY

2B:依赖特权描述符仍然存在

SQLSTATE 描述和发出错误类
2BP01 依赖对象仍然存在
SCHEMA_NOT_EMPTY

2D:无效的事务终止

SQLSTATE 描述和发出错误类
2D521 SQL COMMIT 或 ROLLBACK 在当前操作环境中无效。
DELTA_DELETION_VECTOR_MISSING_NUM_RECORDSDELTA_DUPLICATE_ACTIONS_FOUND
2DKD0 提交后挂钩失败。
DELTA_POST_COMMIT_HOOK_FAILED

38:外部例程异常

SQLSTATE 描述和发出错误类
38000 外部例程异常
FAILED_FUNCTION_CALLINVALID_UDF_IMPLEMENTATIONNO_UDF_INTERFACEPYTHON_DATA_SOURCE_ERRORTABLE_VALUED_FUNCTION_FAILED_TO_ANALYZE_IN_PYTHON

39:外部例程调用异常

SQLSTATE 描述和发出错误类
39000 外部例程调用异常
FAILED_EXECUTE_UDFFOREACH_BATCH_USER_FUNCTION_ERRORUDF_USER_CODE_ERROR

3D:无效的目录名称

SQLSTATE 描述和发出错误类
3D000 无效的目录名称
UC_CATALOG_NAME_NOT_PROVIDED

40:事务回滚

SQLSTATE 描述和发出错误类
40000 事务回滚 (transaction rollback)
CONCURRENT_STREAM_LOG_UPDATE, DELTA_MAX_COMMIT_RETRIES_EXCEEDED

42:语法错误或访问规则冲突

SQLSTATE 描述和发出错误类
42000 语法错误或访问规则冲突
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_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, 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_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_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, 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, 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_EXPRESSION_ENCODER
42501 授权 ID 无权对标识的对象执行指定的操作。
CANNOT_READ_SENSITIVE_KEY_FROM_SECURE_PROVIDERCF_CLEAN_SOURCE_UNAUTHORIZED_WRITE_PERMISSIONINSUFFICIENT_PERMISSIONSINSUFFICIENT_PERMISSIONS_EXT_LOCINSUFFICIENT_PERMISSIONS_NO_OWNERINSUFFICIENT_PERMISSIONS_OWNERSHIP_SECURABLEINSUFFICIENT_PERMISSIONS_SECURABLEINSUFFICIENT_PERMISSIONS_SECURABLE_PARENT_OWNERINSUFFICIENT_PERMISSIONS_STORAGE_CREDINSUFFICIENT_PERMISSIONS_UNDERLYING_SECURABLESINSUFFICIENT_PERMISSIONS_UNDERLYING_SECURABLES_VERBOSEINVALID_S3_COPY_CREDENTIALSUNAUTHORIZED_ACCESS
42601 字符、标记或子句无效或缺失。
COLUMN_ALIASES_NOT_ALLOWEDCOMMA_PRECEDING_CONSTRAINT_ERRORCOPY_INTO_CREDENTIALS_REQUIREDCOPY_INTO_ENCRYPTION_REQUIREDCOPY_INTO_ENCRYPTION_REQUIRED_WITH_EXPECTEDCOPY_INTO_SYNTAX_ERRORCREDENTIAL_MISSINGDATA_SOURCE_OPTION_IS_REQUIREDDELTA_CANNOT_CHANGE_LOCATIONDELTA_CREATE_EXTERNAL_TABLE_WITHOUT_SCHEMADELTA_CREATE_TABLE_WITH_NON_EMPTY_LOCATIONDELTA_DUPLICATE_DOMAIN_METADATA_INTERNAL_ERRORDELTA_FAILED_RECOGNIZE_PREDICATEDELTA_ILLEGAL_USAGEDELTA_MERGE_MISSING_WHENDELTA_MERGE_RESOLVED_ATTRIBUTE_MISSING_FROM_INPUTDELTA_MERGE_UNRESOLVED_EXPRESSIONDELTA_NON_LAST_MATCHED_CLAUSE_OMIT_CONDITIONDELTA_NON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITIONDELTA_NON_LAST_NOT_MATCHED_CLAUSE_OMIT_CONDITIONDELTA_NON_PARSABLE_TAGDELTA_NO_START_FOR_CDC_READDELTA_ONEOF_IN_TIMETRAVELDELTA_OPERATION_MISSING_PATHDELTA_UNEXPECTED_ACTION_EXPRESSIONDELTA_UNKNOWN_PRIVILEGEDELTA_UNKNOWN_READ_LIMITDELTA_UNRECOGNIZED_COLUMN_CHANGEEVENT_LOG_REQUIRES_SHARED_COMPUTEFROM_JSON_CONFLICTING_SCHEMA_UPDATESFROM_JSON_CORRUPT_RECORD_COLUMN_IN_SCHEMAFROM_JSON_CORRUPT_SCHEMAFROM_JSON_INFERENCE_FAILEDFROM_JSON_INVALID_CONFIGURATIONIDENTIFIER_TOO_MANY_NAME_PARTSINVALID_EXTRACT_FIELDINVALID_FORMATINVALID_PARTITION_OPERATIONINVALID_SHARED_ALIAS_NAMEINVALID_WINDOW_SPEC_FOR_AGGREGATION_FUNCLOCAL_MUST_WITH_SCHEMA_FILEMV_ST_ALTER_QUERY_INCORRECT_BACKING_TYPENOT_ALLOWED_IN_FROMNOT_A_CONSTANT_STRINGPARSE_SYNTAX_ERRORREF_DEFAULT_VALUE_IS_NOT_ALLOWED_IN_PARTITIONSORT_BY_WITHOUT_BUCKETINGSPECIFY_BUCKETING_IS_NOT_ALLOWEDSPECIFY_PARTITION_IS_NOT_ALLOWEDSTDS_REQUIRED_OPTION_UNSPECIFIEDSTREAMING_TABLE_OPERATION_NOT_ALLOWEDUC_EXTERNAL_VOLUME_MISSING_LOCATIONUC_LOCATION_FOR_MANAGED_VOLUME_NOT_SUPPORTEDUNCLOSED_BRACKETED_COMMENTUSER_DEFINED_FUNCTIONSWINDOW_FUNCTION_WITHOUT_OVER_CLAUSEWITH_CREDENTIALWRITE_STREAM_NOT_ALLOWED
42602 已检测到名称中无效的字符。
DATA_SOURCE_OPTION_CONTAINS_INVALID_CHARACTERSINVALID_IDENTIFIERINVALID_PROPERTY_KEYINVALID_PROPERTY_VALUEINVALID_SCHEMA_OR_RELATION_NAME
42604 检测到无效的数字或字符串常数。
AS_OF_JOINDELTA_TIME_TRAVEL_INVALID_BEGIN_VALUEEMPTY_JSON_FIELD_VALUEINVALID_ESCINVALID_ESCAPE_CHARINVALID_PIPELINE_IDINVALID_STAGING_PATH_IN_STAGING_ACCESS_QUERYINVALID_TYPED_LITERALINVALID_UUID
42605 为标量函数指定的参数数目无效。
INCORRECT_NUMBER_OF_ARGUMENTSWRONG_NUM_ARGS
42607 聚合函数或 CONCAT 运算符的操作数无效。
NESTED_AGGREGATE_FUNCTION
42608 在 VALUES 或赋值语句中使用 NULL 或 DEFAULT 无效。
DEFAULT_PLACEMENT_INVALID, NO_DEFAULT_COLUMN_VALUE_AVAILABLE
42613 子句互斥。
DELTA_AMBIGUOUS_PATHS_IN_CREATE_TABLEDELTA_CANNOT_SET_LOCATION_ON_PATH_IDENTIFIERDELTA_CLONE_AMBIGUOUS_TARGETDELTA_CLUSTERING_WITH_ZORDER_BYDELTA_CLUSTER_BY_WITH_BUCKETINGDELTA_CLUSTER_BY_WITH_PARTITIONED_BYDELTA_FILE_LIST_AND_PATTERN_STRING_CONFLICTDELTA_OVERWRITE_SCHEMA_WITH_DYNAMIC_PARTITION_OVERWRITEDELTA_PARTITION_SCHEMA_IN_ICEBERG_TABLESDELTA_REPLACE_WHERE_IN_OVERWRITEDELTA_REPLACE_WHERE_WITH_DYNAMIC_PARTITION_OVERWRITEDELTA_REPLACE_WHERE_WITH_FILTER_DATA_CHANGE_UNSETDELTA_STARTING_VERSION_AND_TIMESTAMP_BOTH_SETDELTA_TABLE_LOCATION_MISMATCHDELTA_UNSUPPORTED_TIME_TRAVEL_MULTIPLE_FORMATSINCOMPATIBLE_JOIN_TYPESINVALID_LATERAL_JOIN_TYPEINVALID_QUERY_MIXED_QUERY_PARAMETERSINVALID_SINGLE_VARIANT_COLUMNMANAGED_TABLE_WITH_CREDMUTUALLY_EXCLUSIVE_CLAUSESNON_LAST_MATCHED_CLAUSE_OMIT_CONDITIONNON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITIONNON_LAST_NOT_MATCHED_BY_TARGET_CLAUSE_OMIT_CONDITIONSTDS_CONFLICT_OPTIONS
42614 重复的关键字或子句无效。
DELTA_MULTIPLE_CDC_BOUNDARYDELTA_MULTIPLE_CONF_FOR_SINGLE_COLUMN_IN_BLOOM_FILTERDUPLICATE_CLAUSESREPEATED_CLAUSE
42616 指定的选项无效
BIGQUERY_OPTIONS_ARE_MUTUALLY_EXCLUSIVEDELTA_ILLEGAL_OPTIONDELTA_INVALID_IDEMPOTENT_WRITES_OPTIONSDELTA_UNSET_NON_EXISTENT_PROPERTYSTDS_INVALID_OPTION_VALUEUNSUPPORTED_COMMON_ANCESTOR_LOC_FOR_FILE_STREAM_SOURCEUNSUPPORTED_INITIAL_POSITION_AND_TRIGGER_PAIR_FOR_KINESIS_SOURCE
42617 语句字符串为空。
PARSE_EMPTY_STATEMENT
42621 检查约束或生成的列表达式无效。
DELTA_AGGREGATE_IN_GENERATED_COLUMNDELTA_INVALID_GENERATED_COLUMN_REFERENCESDELTA_NON_BOOLEAN_CHECK_CONSTRAINTDELTA_UDF_IN_GENERATED_COLUMNDELTA_UNSUPPORTED_EXPRESSION_GENERATED_COLUMNUNSUPPORTED_EXPRESSION_GENERATED_COLUMN
42623 不能指定 DEFAULT 子句。
GENERATED_COLUMN_WITH_DEFAULT_VALUEINVALID_DEFAULT_VALUE
42701 在同一 SQL 语句中多次指定同一目标进行赋值。
DELTA_CONFLICT_SET_COLUMNDELTA_DUPLICATE_COLUMNS_ON_INSERTDELTA_DUPLICATE_COLUMNS_ON_UPDATE_TABLEDELTA_DUPLICATE_DATA_SKIPPING_COLUMNSDUPLICATE_ASSIGNMENTSEXEC_IMMEDIATE_DUPLICATE_ARGUMENT_ALIASES
42702 由于名称重复,列引用不明确。
AMBIGUOUS_COLUMN_OR_FIELDAMBIGUOUS_COLUMN_REFERENCEAMBIGUOUS_LATERAL_COLUMN_ALIASDELTA_AMBIGUOUS_PARTITION_COLUMNEXCEPT_OVERLAPPING_COLUMNS
42703 检测到未定义的列或参数名称。
COLUMN_NOT_DEFINED_IN_TABLECOLUMN_NOT_FOUNDDELTA_BLOOM_FILTER_DROP_ON_NON_EXISTING_COLUMNSDELTA_CANNOT_CREATE_BLOOM_FILTER_NON_EXISTING_COLDELTA_CANNOT_DROP_BLOOM_FILTER_ON_NON_INDEXED_COLUMNDELTA_CANNOT_RESOLVE_COLUMNDELTA_COLUMN_MAPPING_MAX_COLUMN_ID_NOT_SETDELTA_COLUMN_MAPPING_MAX_COLUMN_ID_NOT_SET_CORRECTLYDELTA_COLUMN_NOT_FOUNDDELTA_COLUMN_NOT_FOUND_IN_MERGEDELTA_COLUMN_NOT_FOUND_IN_SCHEMADELTA_FAILED_FIND_ATTRIBUTE_IN_OUTPUT_COLUMNSDELTA_MISSING_COLUMNDELTA_MISSING_SET_COLUMNDELTA_PARTITION_COLUMN_NOT_FOUNDDELTA_ZORDERING_COLUMN_DOES_NOT_EXISTEXCEPT_RESOLVED_COLUMNS_WITHOUT_MATCHEXCEPT_UNRESOLVED_COLUMN_IN_STRUCT_EXPANSIONUNRESOLVED_COLUMNUNRESOLVED_FIELDUNRESOLVED_MAP_KEYUNRESOLVED_USING_COLUMN_FOR_JOINZORDERBY_COLUMN_DOES_NOT_EXIST
42704 检测到未定义的对象或限制名称。
AMBIGUOUS_REFERENCECANNOT_RESOLVE_DATAFRAME_COLUMNCANNOT_RESOLVE_STAR_EXPANDCODEC_SHORT_NAME_NOT_FOUNDCOLLATION_INVALID_NAMEDATA_SOURCE_NOT_EXISTDEFAULT_DATABASE_NOT_EXISTSDELTA_COLUMN_PATH_NOT_NESTEDDELTA_CONSTRAINT_DOES_NOT_EXISTDELTA_SHARING_CURRENT_RECIPIENT_PROPERTY_UNDEFINEDENCODER_NOT_FOUNDFIELD_NOT_FOUNDINDEX_NOT_FOUNDSCHEMA_NOT_FOUNDUC_VOLUME_NOT_FOUNDUNRECOGNIZED_SQL_TYPE
42710 检测到重复的对象或约束名称。
ALTER_TABLE_COLUMN_DESCRIPTOR_DUPLICATECREATE_TABLE_COLUMN_DESCRIPTOR_DUPLICATEDATA_SOURCE_ALREADY_EXISTSDELTA_CONSTRAINT_ALREADY_EXISTSDUPLICATED_METRICS_NAMEFIELDS_ALREADY_EXISTSFOUND_MULTIPLE_DATA_SOURCESINDEX_ALREADY_EXISTSLOCATION_ALREADY_EXISTSMULTIPLE_XML_DATA_SOURCE
42711 在对象定义或 ALTER TABLE 语句中检测到重复的列名。
COLUMN_ALREADY_EXISTSDELTA_DUPLICATE_COLUMNS_FOUNDDELTA_TABLE_ALREADY_CONTAINS_CDC_COLUMNSDUPLICATE_ROUTINE_RETURNS_COLUMNS
42713 在列表中检测到重复对象或与现有对象相同。
DUPLICATED_FIELD_NAME_IN_ARROW_STRUCTSTATIC_PARTITION_COLUMN_IN_INSERT_COLUMN_LIST
42723 具有相同签名的例程已存在于定义该例程的架构、模块或复合块中。
ROUTINE_ALREADY_EXISTS, VARIABLE_ALREADY_EXISTS
42734 检测到重复的参数名称、SQL 变量名、标签或条件名称。
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 调用例程时使用的命名参数无效。
DUPLICATE_ROUTINE_PARAMETER_ASSIGNMENT, NAMED_PARAMETERS_NOT_SUPPORTED, READ_FILES_AMBIGUOUS_ROUTINE_PARAMETERS, READ_TVF_UNEXPECTED_REQUIRED_PARAMETER, REQUIRED_PARAMETER_NOT_FOUND, UNEXPECTED_POSITIONAL_ARGUMENT, UNKNOWN_POSITIONAL_ARGUMENT, UNRECOGNIZED_PARAMETER_NAME
42802 目标值的数目与源值的数目不同。
ASSIGNMENT_ARITY_MISMATCHDELTA_INSERT_COLUMN_ARITY_MISMATCHDELTA_INSERT_COLUMN_MISMATCHSTATE_STORE_CANNOT_REMOVE_DEFAULT_COLUMN_FAMILYSTATE_STORE_MULTIPLE_VALUES_PER_KEYUDTF_ALIAS_NUMBER_MISMATCHUDTF_INVALID_ALIAS_IN_REQUESTED_ORDERING_STRING_FROM_ANALYZE_METHODUDTF_INVALID_REQUESTED_SELECTED_EXPRESSION_FROM_ANALYZE_METHOD_REQUIRES_ALIAS
42803 SELECT 或 HAVING 子句中的列引用无效,因为它不是分组列;或者 GROUP BY 子句中的列引用无效。
GROUPING_COLUMN_MISMATCHGROUPING_ID_COLUMN_MISMATCHMISSING_AGGREGATIONMISSING_GROUP_BYUNRESOLVED_ALL_IN_GROUP_BY
42805 ORDER BY 子句中的整数未标识结果表的列。
GROUP_BY_POS_OUT_OF_RANGEORDER_BY_POS_OUT_OF_RANGE
42806 无法为变量赋值,因为数据类型不兼容。
DELTA_MERGE_INCOMPATIBLE_DECIMAL_TYPE
42807 此对象不允许使用数据更改语句。
DELTA_CHANGE_TABLE_FEED_DISABLEDDELTA_UNSUPPORTED_WRITES_STAGED_TABLE
42809 标识的对象不是该语句适用的对象类型。
DELTA_CANNOT_DESCRIBE_VIEW_HISTORYDELTA_CANNOT_MODIFY_APPEND_ONLYDELTA_SHOW_PARTITION_IN_NON_PARTITIONED_TABLEDELTA_TABLE_NOT_SUPPORTED_IN_OPDELTA_UNSUPPORTED_DESCRIBE_DETAIL_VIEWEXPECT_PERMANENT_VIEW_NOT_TEMPEXPECT_TABLE_NOT_VIEWEXPECT_VIEW_NOT_TABLEFORBIDDEN_OPERATIONINVALID_DEST_CATALOGINVALID_SOURCE_CATALOGINVALID_UPGRADE_SYNTAXNOT_A_PARTITIONED_TABLEUNSUPPORTED_INSERTWRONG_COMMAND_FOR_OBJECT_TYPE
42816 表达式中的日期/时间值或持续时间无效。
DELTA_TIMESTAMP_GREATER_THAN_COMMITDELTA_TIMESTAMP_INVALID
42818 运算符或函数的操作数不兼容或不可比较。
INCOMPARABLE_PIVOT_COLUMN
42822 ORDER BY 子句或 GROUP BY 子句中的表达式无效。
EXPRESSION_TYPE_IS_NOT_ORDERABLEGROUP_EXPRESSION_TYPE_IS_NOT_ORDERABLE
42823 从只允许一个列的子查询返回了多个列。
INVALID_SUBQUERY_EXPRESSION
42825 UNION、INTERSECT、EXCEPT 或 VALUES 的行没有兼容的列。
CANNOT_MERGE_INCOMPATIBLE_DATA_TYPEINCOMPATIBLE_COLUMN_TYPE
42826 UNION、INTERSECT、EXCEPT 或 VALUES 的行没有相同的列数。
NUM_COLUMNS_MISMATCHNUM_TABLE_VALUE_ALIASES_MISMATCH
42830 外键不符合父键的描述。
FOREIGN_KEY_MISMATCH
42832 不允许对系统对象执行该操作。
BUILT_IN_CATALOGCANNOT_DELETE_SYSTEM_OWNEDEVENT_LOG_UNSUPPORTED_TABLE_TYPEMODIFY_BUILTIN_CATALOGSAMPLE_TABLE_PERMISSIONS
42837 无法更改该列,因为它的属性与当前列属性不兼容。
DELTA_ALTER_TABLE_CHANGE_COL_NOT_SUPPORTED
42845 检测到 NOT DETERMINISTIC 或 EXTERNAL ACTION 函数的无效用法。
AGGREGATE_FUNCTION_WITH_NONDETERMINISTIC_EXPRESSION
42846 不支持从源类型强制转换为目标类型。
CANNOT_CAST_DATATYPECANNOT_CONVERT_PROTOBUF_FIELD_TYPE_TO_SQL_TYPECANNOT_CONVERT_PROTOBUF_MESSAGE_TYPE_TO_SQL_TYPECANNOT_CONVERT_SQL_TYPE_TO_PROTOBUF_FIELD_TYPECANNOT_CONVERT_SQL_VALUE_TO_PROTOBUF_ENUM_TYPECANNOT_UP_CAST_DATATYPEDELTA_UPDATE_SCHEMA_MISMATCH_EXPRESSIONEXPRESSION_DECODING_FAILEDEXPRESSION_ENCODING_FAILEDUNEXPECTED_SERIALIZER_FOR_CLASS
42852 GRANT 或 REVOKE 中指定的特权无效或不一致。 (例如,对视图运行 GRANT ALTER。)
INVALID_PRIVILEGE
42883 找不到具有匹配签名的例程。
ROUTINE_NOT_FOUNDUNRESOLVABLE_TABLE_VALUED_FUNCTIONUNRESOLVED_ROUTINEUNRESOLVED_VARIABLEVARIABLE_NOT_FOUND
42887 函数或表引用在其上下文中无效。
CYCLIC_FUNCTION_REFERENCEDELTA_SHARING_INVALID_OP_IN_EXTERNAL_SHARED_VIEWINVALID_CURRENT_RECIPIENT_USAGENOT_A_SCALAR_FUNCTIONNOT_A_TABLE_FUNCTION
42891 已存在重复约束。
MULTIPLE_MATCHING_CONSTRAINTS
428C4 谓词运算符两边的元素数目不同。
UNPIVOT_VALUE_SIZE_MISMATCH
428EK 架构限定符无效。
TEMP_VIEW_NAME_TOO_MANY_NAME_PARTS
428FR 无法按指定更改列。
CANNOT_ALTER_PARTITION_COLUMN
428FT 在 CREATE 或 ALTER 中指定的分区子句无效。
DELTA_CANNOT_USE_ALL_COLUMNS_FOR_PARTITIONPARTITIONS_ALREADY_EXISTPARTITIONS_NOT_FOUND
428GU 表必须至少包含一个未隐式隐藏的列。
DELTA_EMPTY_DATADELTA_READ_TABLE_WITHOUT_COLUMNSDELTA_TARGET_TABLE_FINAL_SCHEMA_EMPTY
428H2 数据类型在其使用上下文中不受支持。
EXCEPT_NESTED_COLUMN_INVALID_TYPE
428HD 无法处理语句,因为无法应用列掩码,或者掩码的定义与语句冲突。
QUERIED_TABLE_INCOMPATIBLE_WITH_COLUMN_MASK_POLICY, QUERIED_TABLE_INCOMPATIBLE_WITH_ROW_LEVEL_SECURITY_POLICY
42902 FROM 子句中还标识了 INSERT、UPDATE 或 DELETE 的对象(可能通过视图隐式标识)。
UNSUPPORTED_OVERWRITE
42903 聚合函数或 OLAP 函数的用法无效。
DELTA_AGGREGATION_NOT_SUPPORTEDGROUP_BY_AGGREGATEGROUP_BY_POS_AGGREGATEINVALID_WHERE_CONDITION
42908 语句不包含必需的列列表。
DELTA_CLUSTER_BY_SCHEMA_NOT_PROVIDEDDELTA_SCHEMA_NOT_PROVIDEDSPECIFY_CLUSTER_BY_WITH_BUCKETING_IS_NOT_ALLOWEDSPECIFY_CLUSTER_BY_WITH_PARTITIONED_BY_IS_NOT_ALLOWED
42939 不能使用该名称,因为指定的标识符保留给系统使用。
DELTA_CANNOT_CHANGE_PROVIDERDELTA_CANNOT_MODIFY_TABLE_PROPERTYRESERVED_CDC_COLUMNS_ON_WRITEROUTINE_USES_SYSTEM_RESERVED_CLASS_NAME
42996 不能在分区键中使用指定的列。
DELTA_INVALID_PARTITION_COLUMNDELTA_INVALID_PARTITION_COLUMN_NAMEDELTA_INVALID_PARTITION_COLUMN_TYPE
429BB 不支持列、参数或 SQL 变量的数据类型。
CANNOT_RECOGNIZE_HIVE_TYPE
429BQ 不允许指定的数据类型或属性更改。
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 未完全指定数据类型
DATATYPE_MISSING_SIZEINCOMPLETE_TYPE_DEFINITION
42K02 找不到数据源
DATA_SOURCE_NOT_FOUND, STREAM_NOT_FOUND_FOR_KINESIS_SOURCE
42K03 找不到文件
BATCH_METADATA_NOT_FOUNDCANNOT_LOAD_PROTOBUF_CLASSCLOUD_FILE_SOURCE_FILE_NOT_FOUNDDATA_SOURCE_TABLE_SCHEMA_MISMATCHDEFAULT_FILE_NOT_FOUNDDELTA_CHANGE_DATA_FILE_NOT_FOUNDDELTA_CHECKPOINT_NON_EXIST_TABLEDELTA_CREATE_EXTERNAL_TABLE_WITHOUT_TXN_LOGDELTA_DELETED_PARQUET_FILE_NOT_FOUNDDELTA_EMPTY_DIRECTORYDELTA_FILE_NOT_FOUNDDELTA_FILE_NOT_FOUND_DETAILEDDELTA_FILE_OR_DIR_NOT_FOUNDDELTA_FILE_TO_OVERWRITE_NOT_FOUNDDELTA_LOG_FILE_NOT_FOUND_FOR_STREAMING_SOURCEDELTA_PATH_DOES_NOT_EXISTDELTA_SHALLOW_CLONE_FILE_NOT_FOUNDDELTA_TRUNCATED_TRANSACTION_LOGLOAD_DATA_PATH_NOT_EXISTSPATH_NOT_FOUNDRENAME_SRC_PATH_NOT_FOUNDSTDS_FAILED_TO_READ_STATE_SCHEMASTREAMING_STATEFUL_OPERATOR_NOT_MATCH_IN_STATE_METADATA
42K04 重复文件
DELTA_FILE_ALREADY_EXISTSDELTA_LOG_ALREADY_EXISTSDELTA_PATH_EXISTSFAILED_RENAME_PATHFILE_IN_STAGING_PATH_ALREADY_EXISTSKINESIS_FETCHED_SHARD_LESS_THAN_TRACKED_SHARDPARTITION_LOCATION_ALREADY_EXISTSPATH_ALREADY_EXISTS
42K05 名称无效
CLEANROOM_INVALID_SHARED_DATA_OBJECT_NAMECOLUMN_MASKS_MULTI_PART_TARGET_COLUMN_NAMECOLUMN_MASKS_MULTI_PART_USING_COLUMN_NAMEDELTA_INVALID_CHARACTERS_IN_COLUMN_NAMEDELTA_INVALID_CHARACTERS_IN_COLUMN_NAMESDELTA_INVALID_COLUMN_NAMES_WHEN_REMOVING_COLUMN_MAPPINGDELTA_NESTED_FIELDS_NEED_RENAMEDELTA_NON_SINGLE_PART_NAMESPACE_FOR_CATALOGINVALID_EMPTY_LOCATIONREQUIRES_SINGLE_PART_NAMESPACEROW_LEVEL_SECURITY_MULTI_PART_COLUMN_NAME
42K06 选项的类型无效
DELTA_PROTOCOL_PROPERTY_NOT_INTINVALID_OPTIONS
42K07 不是有效的架构文本
INVALID_SCHEMA
42K08 不是常数
ARGUMENT_NOT_CONSTANTINVALID_SQL_ARGNON_FOLDABLE_ARGUMENTNON_LITERAL_PIVOT_VALUESSEED_EXPRESSION_IS_UNFOLDABLE
42K09 数据类型不匹配
DATATYPE_MISMATCHDELTA_GENERATED_COLUMNS_DATA_TYPE_MISMATCHDELTA_GENERATED_COLUMNS_EXPR_TYPE_MISMATCHDELTA_GENERATED_COLUMN_UPDATE_TYPE_MISMATCHDELTA_MERGE_INCOMPATIBLE_DATATYPEDELTA_NOT_NULL_COLUMN_NOT_FOUND_IN_STRUCTEVENT_TIME_IS_NOT_ON_TIMESTAMP_TYPEINVALID_VARIABLE_TYPE_FOR_QUERY_EXECUTE_IMMEDIATEPIVOT_VALUE_DATA_TYPE_MISMATCHUNEXPECTED_INPUT_TYPEUNPIVOT_VALUE_DATA_TYPE_MISMATCH
42K0A 无效的 UNPIVOT 子句
UNPIVOT_REQUIRES_ATTRIBUTESUNPIVOT_REQUIRES_VALUE_COLUMNS
42K0B 已阻止旧功能
INCONSISTENT_BEHAVIOR_CROSS_VERSION
42K0C 对约束的引用不明确
AMBIGUOUS_CONSTRAINTCANNOT_DROP_AMBIGUOUS_CONSTRAINT
42K0D lambda 函数无效
INVALID_LAMBDA_FUNCTION_CALL
42K0E 表达式在使用的上下文中无效
INVALID_LIMIT_LIKE_EXPRESSIONINVALID_NON_DETERMINISTIC_EXPRESSIONSINVALID_OBSERVED_METRICSINVALID_TIME_TRAVEL_SPECINVALID_TIME_TRAVEL_TIMESTAMP_EXPRJOIN_CONDITION_IS_NOT_BOOLEAN_TYPEMULTIPLE_TIME_TRAVEL_SPECMULTI_SOURCES_UNSUPPORTED_FOR_EXPRESSIONNO_MERGE_ACTION_SPECIFIEDONLY_SECRET_FUNCTION_SUPPORTED_HERESECRET_FUNCTION_INVALID_LOCATIONUNSUPPORTED_EXPR_FOR_OPERATORUNSUPPORTED_EXPR_FOR_PARAMETERUNSUPPORTED_GENERATORUNSUPPORTED_GROUPING_EXPRESSIONUNSUPPORTED_MERGE_CONDITIONUNTYPED_SCALA_UDFWINDOW_FUNCTION_AND_FRAME_MISMATCH
42K0F 持久化对象不能引用临时对象。
INVALID_TEMP_OBJ_REFERENCE
42K0G protobuf 无效
PROTOBUF_DEPENDENCY_NOT_FOUNDPROTOBUF_DESCRIPTOR_FILE_NOT_FOUNDPROTOBUF_FIELD_MISSINGPROTOBUF_FIELD_MISSING_IN_SQL_SCHEMAPROTOBUF_FIELD_TYPE_MISMATCHPROTOBUF_MESSAGE_NOT_FOUNDPROTOBUF_TYPE_NOT_SUPPORTRECURSIVE_PROTOBUF_SCHEMASCHEMA_REGISTRY_CONFIGURATION_ERRORUNABLE_TO_CONVERT_TO_PROTOBUF_MESSAGE_TYPEUNKNOWN_PROTOBUF_MESSAGE_TYPE
42K0H 检测到循环调用。
RECURSIVE_VIEW
42K0I 找不到 SQL 配置。
SQL_CONF_NOT_FOUND
42K0J 找不到属性。
UNSET_NONEXISTENT_PROPERTIES
42K0K 逆分布函数无效
INVALID_INVERSE_DISTRIBUTION_FUNCTION
42KD0 名称引用不明确。
AMBIGUOUS_ALIAS_IN_NESTED_CTE
42KD1 操作在 READ ONLY 会话模式下不受支持。
OP_NOT_SUPPORTED_READ_ONLY
42KD2 SYNC 操作的源表和目标表名称必须相同。
SYNC_SRC_TARGET_TBL_NOT_SAME
42KD3 无法根据指定添加列。
DELTA_ADD_COLUMN_AT_INDEX_LESS_THAN_ZERODELTA_ADD_COLUMN_PARENT_NOT_STRUCTDELTA_ADD_COLUMN_STRUCT_NOT_FOUND
42KD4 操作不受支持,因为表架构已更改。
DELTA_BLOCK_COLUMN_MAPPING_AND_CDC_OPERATIONDELTA_STREAMING_INCOMPATIBLE_SCHEMA_CHANGEDELTA_STREAMING_INCOMPATIBLE_SCHEMA_CHANGE_USE_SCHEMA_LOG
42KD5 无法创建文件或路径。
DELTA_CANNOT_CREATE_LOG_PATHPARTITION_LOCATION_IS_NOT_UNDER_TABLE_DIRECTORY
42KD6 找不到分区信息。
DELTA_CONVERSION_NO_PARTITION_FOUNDDELTA_MISSING_PARTITION_COLUMNDELTA_MISSING_PART_FILES
42KD7 表签名不匹配。
DELTA_CREATE_TABLE_SCHEME_MISMATCHDELTA_CREATE_TABLE_WITH_DIFFERENT_CLUSTERINGDELTA_CREATE_TABLE_WITH_DIFFERENT_PARTITIONINGDELTA_CREATE_TABLE_WITH_DIFFERENT_PROPERTYDELTA_SET_LOCATION_SCHEMA_MISMATCH
42KD8 列位置超出范围。
DELTA_DROP_COLUMN_AT_INDEX_LESS_THAN_ZERODELTA_INDEX_LARGER_OR_EQUAL_THAN_STRUCTDELTA_INDEX_LARGER_THAN_STRUCT
42KD9 无法推理表架构。
CANNOT_MERGE_SCHEMAS, COPY_INTO_SOURCE_SCHEMA_INFERENCE_FAILED, DELTA_FAILED_INFER_SCHEMA, UNABLE_TO_INFER_SCHEMA
42KDA 无法将文件合并到表架构中。
DELTA_FAILED_MERGE_SCHEMA_FILE
42KDB 无效的 URL
DATA_SOURCE_URL_NOT_ALLOWED
42KDC 存档文件引用。
DELTA_ARCHIVED_FILES_IN_LIMITDELTA_ARCHIVED_FILES_IN_SCAN
42KDD 流式处理视图中不支持的操作。
UNEXPECTED_OPERATOR_IN_STREAMING_VIEW
42KDE 流式处理数据集上不支持的操作。
CALL_ON_STREAMING_DATASET_UNSUPPORTEDCANNOT_CREATE_DATA_SOURCE_TABLEINVALID_WRITER_COMMIT_MESSAGENON_TIME_WINDOW_NOT_SUPPORTED_IN_STREAMING
42KDF 必需的例程参数缺少参数。
MISSING_PARAMETER_FOR_KAFKAMISSING_PARAMETER_FOR_ROUTINEXML_ROW_TAG_MISSING
42KDG 目标架构与引入的数据不兼容。
COPY_INTO_SCHEMA_MISMATCH_WITH_TARGET_TABLE
42P01 表未定义
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 参数未定义
UNBOUND_SQL_PARAMETER
42P06 架构重复
SCHEMA_ALREADY_EXISTS
42P07 表重复
DELTA_TABLE_ALREADY_EXISTSTABLE_OR_VIEW_ALREADY_EXISTSTEMP_TABLE_OR_VIEW_ALREADY_EXISTSVIEW_ALREADY_EXISTS
42P10 列引用无效
DELTA_CLUSTERING_COLUMNS_MISMATCHDELTA_NON_PARTITION_COLUMN_REFERENCEDELTA_NON_PARTITION_COLUMN_SPECIFIEDDELTA_SHOW_PARTITION_IN_NON_PARTITIONED_COLUMNDELTA_ZORDERING_ON_PARTITION_COLUMN
42P18 数据类型不确定
DELTA_NULL_SCHEMA_IN_STREAMING_WRITE
42P20 窗口化错误
UNSUPPORTED_EXPR_FOR_WINDOW
42S22 找不到列
NO_SQL_TYPE_IN_PROTOBUF_SCHEMA

44:发生检查选项冲突

SQLSTATE 描述和发出错误类
44000 发生检查选项冲突
DELTA_REPLACE_WHERE_MISMATCH

46:Java DDL 1

SQLSTATE 描述和发出错误类
46103 未解析的类名
CANNOT_LOAD_FUNCTION_CLASS
46110 不支持的功能
CANNOT_MODIFY_CONFIG
46121 列名称无效
INVALID_COLUMN_NAME_AS_PATH

51:应用程序状态无效

SQLSTATE 描述和发出错误类
51024 不能使用对象,因为它已被标记为无效。
INCOMPATIBLE_VIEW_SCHEMA_CHANGE

53:资源不足

SQLSTATE 描述和发出错误类
53200 内存不足
EXECUTOR_BROADCAST_JOIN_OOMUNABLE_TO_ACQUIRE_MEMORY

54:超出程序限制

SQLSTATE 描述和发出错误类
54000 超出程序限制
COLLECTION_SIZE_LIMIT_EXCEEDEDDELTA_CLUSTER_BY_INVALID_NUM_COLUMNSGROUPING_SIZE_LIMIT_EXCEEDEDRELATION_LARGER_THAN_8G
54006 结果字符串太长。
EXCEED_LIMIT_LENGTHKRYO_BUFFER_OVERFLOW
54023 参数太多
TABLE_VALUED_FUNCTION_TOO_MANY_TABLE_ARGUMENTS
54K00 已超出嵌套视图的最大深度。
VIEW_EXCEED_MAX_NESTED_DEPTH
54KD0 超出了查询计划中的最大 UDF 计数。
UDF_LIMITSUDF_MAX_COUNT_EXCEEDED
54KD1 超过会话中的最大对象数。
MAX_NUMBER_VARIABLES_IN_SESSION_EXCEEDED

55:对象不处于先决条件状态

SQLSTATE 描述和发出错误类
55019 该对象处于无效状态,不可用于操作。
DIFFERENT_DELTA_TABLE_READ_BY_STREAMING_SOURCE, EVENT_LOG_UNAVAILABLE, MATERIALIZED_VIEW_MESA_REFRESH_WITHOUT_PIPELINE_ID, STREAMING_TABLE_NEEDS_REFRESH

56:其他 SQL 或产品错误

SQLSTATE 描述和发出错误类
56000 其他 SQL 或产品错误
CHECKPOINT_RDD_BLOCK_ID_NOT_FOUND
56038 此环境不支持请求的功能。
AI_FUNCTION_UNSUPPORTED_ERRORANSI_CONFIG_CANNOT_BE_DISABLEDCF_MANAGED_FILE_EVENTS_ONLY_ON_SERVERLESSCODEC_NOT_AVAILABLECOLUMN_MASKS_NOT_ENABLEDDATABRICKS_DELTA_NOT_ENABLEDDELTA_MISSING_ICEBERG_CLASSDELTA_UNRECOGNIZED_INVARIANTDELTA_UNSUPPORTED_FEATURES_FOR_READDELTA_UNSUPPORTED_FEATURES_FOR_WRITEDELTA_UNSUPPORTED_FEATURES_IN_CONFIGDLT_EXPECTATIONS_NOT_SUPPORTEDDLT_VIEW_CLUSTER_BY_NOT_SUPPORTEDDLT_VIEW_LOCATION_NOT_SUPPORTEDDLT_VIEW_SCHEMA_WITH_TYPE_NOT_SUPPORTEDDLT_VIEW_TABLE_CONSTRAINTS_NOT_SUPPORTEDFEATURE_NOT_ON_CLASSIC_WAREHOUSEFEATURE_UNAVAILABLEGET_TABLES_BY_TYPE_UNSUPPORTED_BY_HIVE_VERSIONINCOMPATIBLE_DATASOURCE_REGISTERMATERIALIZED_VIEW_OPERATION_NOT_ALLOWEDNATIVE_XML_DATA_SOURCE_NOT_ENABLEDSTREAMING_TABLE_NOT_SUPPORTEDUC_LAKEHOUSE_FEDERATION_WRITES_NOT_ALLOWEDUC_NOT_ENABLEDUC_QUERY_FEDERATION_NOT_ENABLEDUC_VOLUMES_NOT_ENABLEDUC_VOLUMES_SHARING_NOT_ENABLEDUNSUPPORTED_TIMESERIES_COLUMNS
56098 在隐式重新绑定、重新编译或重新验证期间出错。
UC_INVALID_DEPENDENCIES
56K00 Spark Connect 错误
CONNECT

57:操作员干预

SQLSTATE 描述和发出错误类
57012 非数据库资源不可用。 这不会影响后续语句的成功执行。
REMOTE_FUNCTION_HTTP_FAILED_ERRORREMOTE_FUNCTION_HTTP_RESULT_UNEXPECTED_ERRORREMOTE_FUNCTION_HTTP_RETRY_TIMEOUTREMOTE_FUNCTION_MISSING_REQUIREMENTS_ERROR

58:系统错误

SQLSTATE 描述和发出错误类
58030 I/O 错误
CANNOT_LOAD_STATE_STORECANNOT_RESTORE_PERMISSIONS_FOR_PATHCANNOT_WRITE_STATE_STOREFAILED_RENAME_TEMP_FILEINVALID_BUCKET_FILETASK_WRITE_FAILEDUNABLE_TO_FETCH_HIVE_TABLES

82:内存不足

SQLSTATE 描述和发出错误类
82100 内存不足(无法分配)
DELTA_BLOOM_FILTER_OOM_ON_WRITE

F0:配置文件错误

SQLSTATE 描述和发出错误类
F0000 配置文件错误
DELTA_INCONSISTENT_LOGSTORE_CONFS, DELTA_INVALID_LOGSTORE_CONF, DELTA_UNKNOWN_CONFIGURATION, INVALID_DRIVER_MEMORY, INVALID_EXECUTOR_MEMORY, INVALID_KRYO_SERIALIZER_BUFFER_SIZE

HV:特定于 FDW 的条件

SQLSTATE 描述和发出错误类
HV000 特定于 FDW 的条件
FAILED_JDBC

HY:特定于 CLI 的条件

SQLSTATE 描述和发出错误类
HY000 特定于 CLI 的条件
INVALID_HANDLE
HY008 操作已取消
OPERATION_CANCELED
HY109 无效的游标位置
INVALID_CURSOR

KD:特定于数据源的错误

SQLSTATE 描述和发出错误类
KD000 特定于数据源的错误
DC_CONNECTION_ERRORDC_CONNECTOR_ERRORDC_FILE_BACKUP_NOT_FOUNDDC_GA4_RAW_DATA_ERRORDC_INVALID_OFFSETDC_SFDC_API_DAILY_QUOTA_THRESHOLD_EXCEEDEDDC_SFDC_API_ERRORDC_SQLSERVER_ERRORDC_WORKDAY_RAAS_API_ERROREND_OFFSET_HAS_GREATER_OFFSET_FOR_TOPIC_PARTITION_THAN_LATEST_WITH_TRIGGER_AVAILABLENOWEND_OFFSET_HAS_GREATER_OFFSET_FOR_TOPIC_PARTITION_THAN_PREFETCHEDFAILED_REGISTER_CLASS_WITH_KRYOGRAPHITE_SINK_INVALID_PROTOCOLGRAPHITE_SINK_PROPERTY_MISSINGINCOMPATIBLE_DATA_FOR_TABLELOST_TOPIC_PARTITIONS_IN_END_OFFSET_WITH_TRIGGER_AVAILABLENOWMALFORMED_AVRO_MESSAGEMALFORMED_CSV_RECORDMISMATCHED_TOPIC_PARTITIONS_BETWEEN_END_OFFSET_AND_PREFETCHED
KD001 无法读取文件页脚
CANNOT_READ_FILE_FOOTERDELTA_FAILED_READ_FILE_FOOTER
KD002 意外的版本
DELTA_FAILED_SCAN_WITH_HISTORICAL_VERSIONDELTA_MISSING_CHANGE_DATADELTA_STREAMING_CANNOT_CONTINUE_PROCESSING_POST_SCHEMA_EVOLUTIONDELTA_STREAMING_CHECK_COLUMN_MAPPING_NO_SNAPSHOT
KD003 数据类型的访问权限不正确
CANNOT_READ_ARCHIVED_FILECANNOT_READ_FILEDELTA_FOUND_MAP_TYPE_COLUMNDELTA_INCORRECT_ARRAY_ACCESSDELTA_INCORRECT_ARRAY_ACCESS_BY_NAMEUNKNOWN_FIELD_EXCEPTION
KD004 Delta 协议版本错误
DELTA_INVALID_PROTOCOL_DOWNGRADEDELTA_INVALID_PROTOCOL_VERSIONDELTA_READ_FEATURE_PROTOCOL_REQUIRES_WRITEDELTA_UNSUPPORTED_COLUMN_MAPPING_PROTOCOL
KD005 表必须至少包含一个非分区列
ALL_PARTITION_COLUMNS_NOT_ALLOWEDDELTA_NON_PARTITION_COLUMN_ABSENT
KD006 在日志路径中找不到提交
DELTA_NO_COMMITS_FOUNDDELTA_NO_RECREATABLE_HISTORY_FOUNDSTDS_COMMITTED_BATCH_UNAVAILABLESTDS_NO_PARTITION_DISCOVERED_IN_STATE_STORESTDS_OFFSET_LOG_UNAVAILABLESTDS_OFFSET_METADATA_LOG_UNAVAILABLE
KD007 表签名已更改
DELTA_SCHEMA_CHANGEDDELTA_SCHEMA_CHANGED_WITH_STARTING_OPTIONSDELTA_SCHEMA_CHANGED_WITH_VERSIONDELTA_SCHEMA_CHANGE_SINCE_ANALYSISDELTA_TABLE_ID_MISMATCH
KD008 表签名未设置
DELTA_SCHEMA_NOT_SET
KD009 分区不匹配
DELTA_UNEXPECTED_NUM_PARTITION_COLUMNS_FROM_FILE_NAMEDELTA_UNEXPECTED_PARTITION_COLUMN_FROM_FILE_NAMEDELTA_UNEXPECTED_PARTITION_SCHEMA_FROM_USER
KD00A 意外的部分扫描
DELTA_UNEXPECTED_PARTIAL_SCAN
KD00B 无法识别的文件
DELTA_UNRECOGNIZED_LOGFILEERROR_READING_AVRO_UNKNOWN_FINGERPRINT
KD00C 版本不连续
DELTA_VERSIONS_NOT_CONTIGUOUS
KD00D 需要统计信息
DELTA_ZORDERING_ON_COLUMN_WITHOUT_STATS
KD00E 表功能验证失败
DELTA_ICEBERG_COMPAT_VIOLATIONDELTA_UNIVERSAL_FORMAT_VIOLATION

P0:过程逻辑错误

SQLSTATE 描述和发出错误类
P0001 引发异常
USER_RAISED_EXCEPTIONUSER_RAISED_EXCEPTION_PARAMETER_MISMATCHUSER_RAISED_EXCEPTION_UNKNOWN_ERROR_CLASS