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, FUNCTION_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_REQUESTAI_FUNCTION_UNSUPPORTED_RETURN_TYPEAI_QUERY_RETURN_TYPE_COLUMN_TYPE_MISMATCHAI_SEARCH_EMBEDDING_COLUMN_TYPE_UNSUPPORTED_ERRORAI_SEARCH_INDEX_TYPE_UNSUPPORTED_ERRORAI_SEARCH_UNSUPPORTED_NUM_RESULTS_ERRORANALYZE_CONSTRAINTS_NOT_SUPPORTEDAVRO_DEFAULT_VALUES_UNSUPPORTEDAVRO_POSITIONAL_FIELD_MATCHING_UNSUPPORTEDCANNOT_INVOKE_IN_TRANSFORMATIONSCANNOT_SAVE_VARIANTCANNOT_UPDATE_FIELDCF_ADD_NEW_NOT_SUPPORTEDCF_EVENT_NOTIFICATION_NOT_SUPPORTEDCF_PERIODIC_BACKFILL_NOT_SUPPORTEDCF_SOURCE_UNSUPPORTEDCF_UNSUPPORTED_CLOUD_FILES_SQL_FUNCTIONCF_UNSUPPORTED_FORMAT_FOR_SCHEMA_INFERENCECF_UNSUPPORTED_LOG_VERSIONCF_UNSUPPORTED_SCHEMA_EVOLUTION_MODECLASS_UNSUPPORTED_BY_MAP_OBJECTSCLEANROOM_COMMANDS_NOT_SUPPORTEDCLUSTER_BY_AUTO_FEATURE_NOT_ENABLEDCOLUMN_MASKS_CHECK_CONSTRAINT_UNSUPPORTEDCOLUMN_MASKS_FEATURE_NOT_SUPPORTEDCOLUMN_MASKS_INCOMPATIBLE_SCHEMA_CHANGECOLUMN_MASKS_MERGE_UNSUPPORTED_SOURCECOLUMN_MASKS_MERGE_UNSUPPORTED_TARGETCOLUMN_MASKS_REQUIRE_UNITY_CATALOGCOLUMN_MASKS_TABLE_CLONE_SOURCE_NOT_SUPPORTEDCOLUMN_MASKS_TABLE_CLONE_TARGET_NOT_SUPPORTEDCOLUMN_MASKS_UNSUPPORTED_PROVIDERCOLUMN_MASKS_UNSUPPORTED_SUBQUERYCONCURRENT_QUERYCONSTRAINTS_REQUIRE_UNITY_CATALOGCOPY_INTO_CREDENTIALS_NOT_ALLOWED_ONCOPY_INTO_ENCRYPTION_NOT_ALLOWED_ONCOPY_INTO_ENCRYPTION_NOT_SUPPORTED_FOR_AZURECOPY_INTO_SOURCE_FILE_FORMAT_NOT_SUPPORTEDCOPY_INTO_UNSUPPORTED_FEATURECREATE_OR_REFRESH_MV_ST_ASYNCCREATE_PERMANENT_VIEW_WITHOUT_ALIASCSV_ENFORCE_SCHEMA_NOT_SUPPORTEDDC_UNSUPPORTED_ERRORDELTA_ADDING_DELETION_VECTORS_DISALLOWEDDELTA_ADD_CONSTRAINTSDELTA_CANNOT_WRITE_INTO_VIEWDELTA_CLUSTERING_CLONE_TABLE_NOT_SUPPORTEDDELTA_CLUSTERING_SHOW_CREATE_TABLE_WITHOUT_CLUSTERING_COLUMNSDELTA_CLUSTERING_WITH_PARTITION_PREDICATEDELTA_DOMAIN_METADATA_NOT_SUPPORTEDDELTA_DYNAMIC_PARTITION_OVERWRITE_DISABLEDDELTA_NESTED_SUBQUERY_NOT_SUPPORTEDDELTA_NOT_NULL_NESTED_FIELDDELTA_OPERATION_ON_TEMP_VIEW_WITH_GENERATED_COLS_NOT_SUPPORTEDDELTA_SOURCE_IGNORE_DELETEDELTA_SOURCE_TABLE_IGNORE_CHANGESDELTA_UNIFORM_INGRESS_NOT_SUPPORTEDDELTA_UNSUPPORTED_DEEP_CLONEDELTA_UNSUPPORTED_EXPRESSIONDELTA_UNSUPPORTED_FSCK_WITH_DELETION_VECTORSDELTA_UNSUPPORTED_GENERATE_WITH_DELETION_VECTORSDELTA_UNSUPPORTED_LIST_KEYS_WITH_PREFIXDELTA_UNSUPPORTED_MERGE_SCHEMA_EVOLUTION_WITH_CDCDELTA_UNSUPPORTED_SORT_ON_BUCKETED_TABLESDELTA_UNSUPPORTED_TRUNCATE_SAMPLE_TABLESDELTA_UNSUPPORTED_WRITE_SAMPLE_TABLESDELTA_VIOLATE_TABLE_PROPERTY_VALIDATION_FAILEDDELTA_WRITE_INTO_VIEW_NOT_SUPPORTEDDISTINCT_WINDOW_FUNCTION_UNSUPPORTEDEXTERNAL_TABLE_INVALID_SCHEMEFABRIC_REFRESH_INVALID_SCOPEFROM_JSON_INFERENCE_NOT_SUPPORTEDH3_NOT_ENABLEDINFINITE_STREAMING_TRIGGER_NOT_SUPPORTEDINVALID_PANDAS_UDF_PLACEMENTINVALID_PARTITION_COLUMN_DATA_TYPEMATERIALIZED_VIEW_OUTPUT_WITHOUT_EXPLICIT_ALIASMATERIALIZED_VIEW_UNSUPPORTED_OPERATIONMETRIC_CONSTRAINT_NOT_SUPPORTEDMULTI_UDF_INTERFACE_ERRORNAMED_PARAMETERS_NOT_SUPPORTED_FOR_SQL_UDFSNAMED_PARAMETER_SUPPORT_DISABLEDNOT_SUPPORTED_CHANGE_COLUMNNOT_SUPPORTED_COMMAND_FOR_V2_TABLENOT_SUPPORTED_COMMAND_WITHOUT_HIVE_SUPPORTNOT_SUPPORTED_IN_JDBC_CATALOGNOT_SUPPORTED_WITH_DB_SQLNOT_SUPPORTED_WITH_SERVERLESSONLY_SUPPORTED_WITH_UC_SQL_CONNECTORPROCEDURE_CREATION_EMPTY_ROUTINEPROCEDURE_NOT_SUPPORTEDPROCEDURE_NOT_SUPPORTED_WITH_HMSPROTOBUF_JAVA_CLASSES_NOT_SUPPORTEDPS_SPARK_SPECULATION_NOT_SUPPORTEDPS_UNSUPPORTED_GET_OFFSET_CALLRECIPIENT_EXPIRATION_NOT_SUPPORTEDRESTRICTED_STREAMING_OPTION_PERMISSION_ENFORCEDROW_LEVEL_SECURITY_CHECK_CONSTRAINT_UNSUPPORTEDROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTEDROW_LEVEL_SECURITY_INCOMPATIBLE_SCHEMA_CHANGEROW_LEVEL_SECURITY_MERGE_UNSUPPORTED_SOURCEROW_LEVEL_SECURITY_MERGE_UNSUPPORTED_TARGETROW_LEVEL_SECURITY_REQUIRE_UNITY_CATALOGROW_LEVEL_SECURITY_TABLE_CLONE_SOURCE_NOT_SUPPORTEDROW_LEVEL_SECURITY_TABLE_CLONE_TARGET_NOT_SUPPORTEDROW_LEVEL_SECURITY_UNSUPPORTED_PROVIDERSCALAR_SUBQUERY_IS_IN_GROUP_BY_OR_AGGREGATE_FUNCTIONSTAR_GROUP_BY_POSSTREAMING_AQE_NOT_SUPPORTED_FOR_STATEFUL_OPERATORSSTREAMING_FROM_MATERIALIZED_VIEWST_NOT_ENABLEDST_UNSUPPORTED_RETURN_TYPETABLE_VALUED_ARGUMENTS_NOT_YET_IMPLEMENTED_FOR_SQL_FUNCTIONSUC_HIVE_METASTORE_FEDERATION_NOT_ENABLEDUDF_PYSPARK_UNSUPPORTED_TYPEUDF_UNSUPPORTED_PARAMETER_DEFAULT_VALUEUDTF_PYSPARK_NOT_SUPPORTED, UNSUPPORTED_ADD_FILEUNSUPPORTED_ARROWTYPE, UNSUPPORTED_CALLUNSUPPORTED_CHAR_OR_VARCHAR_AS_STRINGUNSUPPORTED_CLAUSE_FOR_OPERATIONUNSUPPORTED_COLLATIONUNSUPPORTED_CONSTRAINT_CLAUSESUNSUPPORTED_DATASOURCE_FOR_DIRECT_QUERYUNSUPPORTED_DATATYPEUNSUPPORTED_DATA_SOURCE_SAVE_MODEUNSUPPORTED_DATA_TYPE_FOR_DATASOURCEUNSUPPORTED_DATA_TYPE_FOR_ENCODERUNSUPPORTED_DEFAULT_VALUEUNSUPPORTED_DESERIALIZERUNSUPPORTED_FEATUREUNSUPPORTED_FN_TYPEUNSUPPORTED_NESTED_ROW_OR_COLUMN_ACCESS_POLICYUNSUPPORTED_SAVE_MODEUNSUPPORTED_STREAMING_OPTIONS_FOR_VIEWUNSUPPORTED_STREAMING_OPTIONS_PERMISSION_ENFORCEDUNSUPPORTED_STREAMING_SINK_PERMISSION_ENFORCEDUNSUPPORTED_STREAMING_SOURCE_PERMISSION_ENFORCEDUNSUPPORTED_STREAM_READ_LIMIT_FOR_KINESIS_SOURCEUNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORYUNSUPPORTED_TIMESERIES_WITH_MORE_THAN_ONE_COLUMNUNSUPPORTED_TRIGGER_FOR_KINESIS_SOURCEUNSUPPORTED_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_EXPRESSION、DELTA_CANNOT_GENERATE_CODE_FOR_EXPRESSIONDELTA_CDC_NOT_ALLOWED_IN_THIS_VERSIONDELTA_CHANGE_DATA_FEED_INCOMPATIBLE_DATA_SCHEMADELTA_CHANGE_DATA_FEED_INCOMPATIBLE_SCHEMA_CHANGE、DELTA_CLONE_UNSUPPORTED_SOURCEDELTA_COLLATIONS_NOT_SUPPORTEDDELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_PARTITIONED_COLUMNDELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_TYPE、DELTA_CONVERSION_UNSUPPORTED_COLUMN_MAPPINGDELTA_CONVERT_NON_PARQUET_TABLEDELTA_CREATE_TABLE_IDENTIFIER_LOCATION_MISMATCHDELTA_DROP_COLUMN_ON_SINGLE_FIELD_SCHEMA、DELTA_INCORRECT_LOG_STORE_IMPLEMENTATION、DELTA_MISSING_PROVIDER_FOR_CONVERTDELTA_MODE_NOT_SUPPORTED、DELTA_NESTED_NOT_NULL_CONSTRAINTDELTA_NON_DETERMINISTIC_FUNCTION_NOT_SUPPORTED、DELTA_OPERATION_NOT_ALLOWEDDELTA_OPERATION_NOT_ALLOWED_DETAIL、DELTA_OPERATION_NOT_SUPPORTED_FOR_COLUMN_WITH_COLLATIONDELTA_OPERATION_NOT_SUPPORTED_FOR_EXPRESSION_WITH_COLLATIONDELTA_OPERATION_ON_VIEW_NOT_ALLOWEDDELTA_TABLE_FOR_PATH_UNSUPPORTED_HADOOP_CONFDELTA_TRUNCATE_TABLE_PARTITION_NOT_SUPPORTED、DELTA_UNIFORM_INGRESS_NOT_SUPPORTED_FORMAT、DELTA_UNIFORM_NOT_SUPPORTED、DELTA_UNSUPPORTED_ABS_PATH_ADD_FILE、DELTA_UNSUPPORTED_ALTER_TABLE_CHANGE_COL_OPDELTA_UNSUPPORTED_ALTER_TABLE_REPLACE_COL_OP、DELTA_UNSUPPORTED_CLONE_REPLACE_SAME_TABLE、DELTA_UNSUPPORTED_COLUMN_MAPPING_MODE_CHANGEDELTA_UNSUPPORTED_COLUMN_MAPPING_SCHEMA_CHANGEDELTA_UNSUPPORTED_COLUMN_MAPPING_WRITE、 DELTA_UNSUPPORTED_COLUMN_TYPE_IN_BLOOM_FILTER、DELTA_UNSUPPORTED_COMMENT_MAP_ARRAYDELTA_UNSUPPORTED_DATA_TYPES、DELTA_UNSUPPORTED_DROP_CLUSTERING_COLUMNDELTA_UNSUPPORTED_DROP_COLUMNDELTA_UNSUPPORTED_DROP_NESTED_COLUMN_FROM_NON_STRUCT_TYPEDELTA_UNSUPPORTED_DROP_PARTITION_COLUMNDELTA_UNSUPPORTED_FIELD_UPDATE_NON_STRUCT、DELTA_UNSUPPORTED_INVARIANT_NON_STRUCTDELTA_UNSUPPORTED_IN_SUBQUERYDELTA_UNSUPPORTED_MANIFEST_GENERATION_WITH_COLUMN_MAPPING、DELTA_UNSUPPORTED_MULTI_COL_IN_PREDICATEDELTA_UNSUPPORTED_NESTED_COLUMN_IN_BLOOM_FILTER、DELTA_UNSUPPORTED_NESTED_FIELD_IN_OPERATIONDELTA_UNSUPPORTED_NON_EMPTY_CLONEDELTA_UNSUPPORTED_OUTPUT_MODEDELTA_UNSUPPORTED_PARTITION_COLUMN_IN_BLOOM_FILTERDELTA_UNSUPPORTED_RENAME_COLUMN、DELTA_UNSUPPORTED_SCHEMA_DURING_READDELTA_UNSUPPORTED_SUBQUERY、DELTA_UNSUPPORTED_SUBQUERY_IN_PARTITION_PREDICATESDELTA_UNSUPPORTED_TIME_TRAVEL_VIEWSDELTA_UNSUPPORTED_TYPE_CHANGE_IN_SCHEMADELTA_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_CANNOT_DROP_CHECK_CONSTRAINT_FEATUREDELTA_CLUSTERING_PHASE_OUT_FAILEDDELTA_DATA_CHANGE_FALSEDELTA_FEATURES_PROTOCOL_METADATA_MISMATCHDELTA_FEATURES_REQUIRE_MANUAL_ENABLEMENTDELTA_FEATURE_DROP_CONFLICT_REVALIDATION_FAILDELTA_FEATURE_DROP_DEPENDENT_FEATUREDELTA_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_NESTEDCANNOT_SHALLOW_CLONE_NON_UC_MANAGED_TABLE_AS_SOURCE_OR_TARGETINVALID_SCHEMEPARTITION_METADATAUC_BUCKETED_TABLESUC_COMMAND_NOT_SUPPORTEDUC_COMMAND_NOT_SUPPORTED_IN_SHARED_ACCESS_MODEUC_CREDENTIAL_PURPOSE_NOT_SUPPORTEDUC_DATASOURCE_NOT_SUPPORTEDUC_DATASOURCE_OPTIONS_NOT_SUPPORTEDUC_FAILED_PROVISIONING_STATEUC_FILE_SCHEME_FOR_TABLE_CREATION_NOT_SUPPORTEDUC_INVALID_NAMESPACEUC_INVALID_REFERENCEUPGRADE_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 插入值列表与列列表不匹配
COPY_INTO_COLUMN_ARITY_MISMATCH, 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_OVERFLOW, BINARY_ARITHMETIC_OVERFLOW, CAST_OVERFLOW, CAST_OVERFLOW_IN_TABLE_INSERT, DECIMAL_PRECISION_EXCEEDS_MAX_PRECISION, DELTA_CANNOT_RESTORE_TABLE_VERSION, DELTA_CANNOT_RESTORE_TIMESTAMP_EARLIER, DELTA_CANNOT_RESTORE_TIMESTAMP_GREATER, DELTA_CAST_OVERFLOW_IN_TABLE_WRITE, DELTA_INVALID_CDC_RANGE, INCORRECT_RAMP_UP_RATE, INVALID_ARRAY_INDEX, INVALID_ARRAY_INDEX_IN_ELEMENT_AT, INVALID_BITMAP_POSITION, INVALID_BOUNDARY, INVALID_INDEX_OF_ZERO, INVALID_NUMERIC_LITERAL_RANGE, NUMERIC_OUT_OF_SUPPORTED_RANGE, NUMERIC_VALUE_OUT_OF_RANGE, SUM_OF_LIMIT_AND_OFFSET_EXCEEDS_MAX_INT
22004 不允许为 null 值
COMPARATOR_RETURNS_NULLNULL_QUERY_STRING_EXECUTE_IMMEDIATE
22005 分配错误
DELTA_COMPLEX_TYPE_COLUMN_CONTAINS_NULL_TYPEDELTA_FAILED_TO_MERGE_FIELDSDELTA_MERGE_UNEXPECTED_ASSIGNMENT_KEY
22006 无效的间隔格式
CANNOT_PARSE_INTERVAL, DELTA_INVALID_INTERVAL, INVALID_INTERVAL_FORMAT
22007 无效的日期/时间格式
CANNOT_PARSE_TIMESTAMP, DELTA_INVALID_TIMESTAMP_FORMAT, INVALID_DATETIME_PATTERN
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
2201E 自然对数的无效参数
STRUCT_ARRAY_LENGTH_MISMATCH
22022 指示器溢出
INVALID_CONF_VALUE
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_VALUEINVALID_VARIANT_CASTINVALID_VARIANT_FROM_PARQUETINVALID_VARIANT_GET_PATHMALFORMED_RECORD_IN_PARSINGMALFORMED_VARIANTMAX_RECORDS_PER_FETCH_INVALID_FOR_KINESIS_SOURCEMETRIC_STORE_INVALID_ARGUMENT_VALUE_ERRORRULE_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_CONSTRUCTOR_SIZE_LIMITVARIANT_DUPLICATE_KEYVARIANT_SIZE_LIMITWKB_PARSE_ERRORWKT_PARSE_ERRORXML_WILDCARD_RESCUED_DATA_CONFLICT_ERROR
22029 UCS 字符串中的非字符
INVALID_UTF8_STRING
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_ERRORAI_FUNCTION_MODEL_SCHEMA_PARSE_ERRORCANNOT_PARSE_JSON_FIELDFAILED_ROW_TO_JSONINVALID_JSON_DATA_TYPEINVALID_JSON_DATA_TYPE_FOR_COLLATIONS
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_CONCURRENT_APPEND, DELTA_CONCURRENT_DELETE_DELETE, DELTA_CONCURRENT_DELETE_READ, DELTA_CONCURRENT_TRANSACTION, DELTA_CONCURRENT_WRITE, DELTA_DELETION_VECTOR_MISSING_NUM_RECORDS, DELTA_DUPLICATE_ACTIONS_FOUND, DELTA_METADATA_CHANGED, DELTA_PROTOCOL_CHANGED
2DKD0 提交后挂钩失败。
DELTA_POST_COMMIT_HOOK_FAILED

38:外部例程异常

SQLSTATE 描述和发出错误类
38000 外部例程异常
CLASS_NOT_OVERRIDE_EXPECTED_METHOD, FAILED_FUNCTION_CALL, INVALID_UDF_IMPLEMENTATION, NO_UDF_INTERFACE, PYTHON_DATA_SOURCE_ERROR, PYTHON_STREAMING_DATA_SOURCE_RUNTIME_ERROR, TABLE_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_FIELDSCF_AMBIGUOUS_AUTH_OPTIONS_ERRORCF_AMBIGUOUS_INCREMENTAL_LISTING_MODE_ERRORCF_AZURE_STORAGE_SUFFIXES_REQUIREDCF_CLEAN_SOURCE_ALLOW_OVERWRITES_BOTH_ONCF_EMPTY_DIR_FOR_SCHEMA_INFERENCECF_FAILED_TO_FIND_PROVIDERCF_FILE_FORMAT_REQUIREDCF_GCP_AUTHENTICATIONCF_INCORRECT_SQL_PARAMSCF_INTERNAL_ERRORCF_INVALID_ARNCF_INVALID_AZURE_CERTIFICATECF_INVALID_AZURE_CERT_PRIVATE_KEYCF_INVALID_CHECKPOINTCF_INVALID_CLEAN_SOURCE_MODECF_INVALID_GCP_RESOURCE_TAG_KEYCF_INVALID_GCP_RESOURCE_TAG_VALUECF_INVALID_MANAGED_FILE_EVENTS_OPTION_KEYSCF_INVALID_SCHEMA_EVOLUTION_MODECF_INVALID_SCHEMA_HINTS_OPTIONCF_INVALID_SCHEMA_HINT_COLUMNCF_MANAGED_FILE_EVENTS_ENDPOINT_NOT_FOUNDCF_MANAGED_FILE_EVENTS_ENDPOINT_PERMISSION_DENIEDCF_MAX_MUST_BE_POSITIVECF_MISSING_METADATA_FILE_ERRORCF_MISSING_PARTITION_COLUMN_ERRORCF_MISSING_SCHEMA_IN_PATHLESS_MODECF_PATH_DOES_NOT_EXIST_FOR_READ_FILESCF_REGION_NOT_FOUND_ERRORCF_RESOURCE_SUFFIX_EMPTYCF_RESOURCE_SUFFIX_INVALID_CHAR_AWSCF_RESOURCE_SUFFIX_INVALID_CHAR_AZURECF_RESOURCE_SUFFIX_INVALID_CHAR_GCPCF_RESOURCE_SUFFIX_LIMITCF_RESOURCE_SUFFIX_LIMIT_GCPCF_RETENTION_GREATER_THAN_MAX_FILE_AGECF_SOURCE_DIRECTORY_PATH_REQUIREDCF_STATE_INCORRECT_SQL_PARAMSCF_STATE_INVALID_CHECKPOINT_PATHCF_STATE_INVALID_VERSIONCF_UNABLE_TO_DERIVE_STREAM_CHECKPOINT_LOCATIONCF_UNABLE_TO_DETECT_FILE_FORMATCF_UNABLE_TO_EXTRACT_BUCKET_INFOCF_UNABLE_TO_EXTRACT_KEY_INFOCF_UNABLE_TO_EXTRACT_STORAGE_ACCOUNT_INFOCF_UNKNOWN_OPTION_KEYS_ERRORCF_USE_DELTA_FORMATCOMMENT_ON_CONNECTION_NOT_IMPLEMENTED_YETCONNECTION_ALREADY_EXISTSCONNECTION_NAME_CANNOT_BE_EMPTYCONNECTION_NOT_FOUNDCONNECTION_OPTION_NOT_SUPPORTEDCONNECTION_TYPE_NOT_SUPPORTEDCREATE_FOREIGN_SCHEMA_NOT_IMPLEMENTED_YETCREATE_FOREIGN_TABLE_NOT_IMPLEMENTED_YETDELTA_ADDING_COLUMN_WITH_INTERNAL_NAME_FAILEDDELTA_ADDING_DELETION_VECTORS_WITH_TIGHT_BOUNDS_DISALLOWEDDELTA_ALTER_TABLE_CLUSTER_BY_NOT_ALLOWEDDELTA_ALTER_TABLE_CLUSTER_BY_ON_PARTITIONED_TABLE_NOT_ALLOWEDDELTA_ALTER_TABLE_RENAME_NOT_ALLOWEDDELTA_ALTER_TABLE_SET_CLUSTERING_TABLE_FEATURE_NOT_ALLOWEDDELTA_CANNOT_RELATIVIZE_PATHDELTA_CLONE_INCOMPLETE_FILE_COPYDELTA_CLUSTERING_NOT_SUPPORTEDDELTA_CLUSTERING_REPLACE_TABLE_WITH_PARTITIONED_TABLEDELTA_CLUSTERING_WITH_DYNAMIC_PARTITION_OVERWRITEDELTA_CREATE_TABLE_SET_CLUSTERING_TABLE_FEATURE_NOT_ALLOWEDDELTA_INCONSISTENT_BUCKET_SPECDELTA_INCORRECT_GET_CONFDELTA_INVALID_INVENTORY_SCHEMADELTA_INVALID_MANAGED_TABLE_SYNTAX_NO_SCHEMADELTA_MAX_ARRAY_SIZE_EXCEEDEDDELTA_MAX_LIST_FILE_EXCEEDEDDELTA_MISSING_TRANSACTION_LOGDELTA_NAME_CONFLICT_IN_BUCKETED_TABLEDELTA_NOT_A_DATABRICKS_DELTA_TABLEDELTA_OVERWRITE_MUST_BE_TRUEDELTA_STATS_COLLECTION_COLUMN_NOT_FOUNDFOREIGN_OBJECT_NAME_CANNOT_BE_EMPTYINVALID_COLUMN_OR_FIELD_DATA_TYPEINVALID_EXTRACT_BASE_FIELD_TYPEINVALID_EXTRACT_FIELD_TYPEINVALID_FIELD_NAMEINVALID_INLINE_TABLEINVALID_SAVE_MODEINVALID_SET_SYNTAXINVALID_SQL_SYNTAXINVALID_USAGE_OF_STAR_OR_REGEXINVALID_WRITE_DISTRIBUTIONMATERIALIZED_VIEW_OVER_STREAMING_QUERY_INVALIDMISSING_CONNECTION_OPTIONMISSING_NAME_FOR_CHECK_CONSTRAINTMULTIPLE_LOAD_PATHNAMESPACE_ALREADY_EXISTSNAMESPACE_NOT_EMPTYNAMESPACE_NOT_FOUNDNON_PARTITION_COLUMNNOT_NULL_ASSERT_VIOLATIONNOT_NULL_CONSTRAINT_VIOLATIONNO_HANDLER_FOR_UDAFNULLABLE_COLUMN_OR_FIELDNULLABLE_ROW_ID_ATTRIBUTESPS_INVALID_EMPTY_OPTIONPS_INVALID_OPTIONPS_INVALID_OPTION_TYPEPS_INVALID_READ_LIMITPS_MISSING_AUTH_INFOPS_MISSING_REQUIRED_OPTIONPS_PROVIDE_CREDENTIALS_WITH_OPTIONPS_UNABLE_TO_CREATE_SUBSCRIPTIONROUTINE_PARAMETER_NOT_FOUNDSTREAMING_TABLE_QUERY_INVALIDUNSUPPORTED_BATCH_TABLE_VALUED_FUNCTIONUNSUPPORTED_CONSTRAINT_TYPEUNSUPPORTED_STREAMING_TABLE_VALUED_FUNCTIONVOLUME_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_ALLOWED、COMMA_PRECEDING_CONSTRAINT_ERRORCOPY_INTO_CREDENTIALS_REQUIRED、COPY_INTO_ENCRYPTION_REQUIREDCOPY_INTO_ENCRYPTION_REQUIRED_WITH_EXPECTED、COPY_INTO_SYNTAX_ERROR、CREDENTIAL_MISSINGDATA_SOURCE_OPTION_IS_REQUIRED、DELTA_CANNOT_CHANGE_LOCATION、DELTA_COLUMN_MISSING_DATA_TYPE、DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_SCHEMADELTA_CREATE_TABLE_MISSING_TABLE_NAME_OR_LOCATIONDELTA_CREATE_TABLE_WITH_NON_EMPTY_LOCATION、DELTA_DUPLICATE_DOMAIN_METADATA_INTERNAL_ERRORDELTA_FAILED_RECOGNIZE_PREDICATEDELTA_ILLEGAL_USAGEDELTA_MERGE_MISSING_WHENDELTA_MERGE_RESOLVED_ATTRIBUTE_MISSING_FROM_INPUTDELTA_MERGE_UNRESOLVED_EXPRESSION、DELTA_NON_LAST_MATCHED_CLAUSE_OMIT_CONDITION、DELTA_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_PATH、DELTA_UNEXPECTED_ACTION_EXPRESSION、DELTA_UNKNOWN_PRIVILEGEDELTA_UNKNOWN_READ_LIMIT、DELTA_UNRECOGNIZED_COLUMN_CHANGE、EVENT_LOG_REQUIRES_SHARED_COMPUTEFROM_JSON_CONFLICTING_SCHEMA_UPDATESFROM_JSON_CORRUPT_RECORD_COLUMN_IN_SCHEMAFROM_JSON_CORRUPT_SCHEMA、FROM_JSON_INFERENCE_FAILEDFROM_JSON_INVALID_CONFIGURATION、GET_WARMUP_TRACING_FAILED、GET_WARMUP_TRACING_FUNCTION_NOT_ALLOWEDIDENTIFIER_TOO_MANY_NAME_PARTS、ILLEGAL_STATE_STORE_VALUE、INVALID_BUCKET_COLUMN_DATA_TYPEINVALID_EXTRACT_FIELD、INVALID_FORMAT、INVALID_PARTITION_OPERATIONINVALID_SHARED_ALIAS_NAME、INVALID_STATEMENT_OR_CLAUSE、INVALID_WINDOW_SPEC_FOR_AGGREGATION_FUNC、LOCAL_MUST_WITH_SCHEMA_FILE、MV_ST_ALTER_QUERY_INCORRECT_BACKING_TYPENOT_ALLOWED_IN_FROM、NOT_A_CONSTANT_ STRINGNOT_UNRESOLVED_ENCODERPARSE_SYNTAX_ERROR、PROCEDURE_CREATION_PARAMETER_OUT_INOUT_WITH_DEFAULTREF_DEFAULT_VALUE_IS_NOT_ALLOWED_IN_PARTITIONSORT_BY_WITHOUT_BUCKETINGSPECIFY_BUCKETING_IS_NOT_ALLOWEDSPECIFY_PARTITION_IS_NOT_ALLOWED、STDS_REQUIRED_OPTION_UNSPECIFIEDSTREAMING_TABLE_OPERATION_NOT_ALLOWEDSYNTAX_DISCONTINUEDUC_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_CHARACTERS, INVALID_DELIMITER_VALUE, INVALID_IDENTIFIER, INVALID_PROPERTY_KEY, INVALID_PROPERTY_VALUE, INVALID_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_ARGUMENTS, PROCEDURE_ARGUMENT_NUMBER_MISMATCH, WRONG_NUM_ARGS
42607 聚合函数或 CONCAT 运算符的操作数无效。
NESTED_AGGREGATE_FUNCTION
42608 在 VALUES 或赋值语句中使用 NULL 或 DEFAULT 无效。
DEFAULT_PLACEMENT_INVALID, NO_DEFAULT_COLUMN_VALUE_AVAILABLE
42611 列、自变量、参数或全局变量定义无效。
CANNOT_ASSIGN_EVENT_TIME_COLUMN_WITHOUT_WATERMARKDELTA_IDENTITY_COLUMNS_ILLEGAL_STEP
42613 子句互斥。
COPY_INTO_FEATURE_INCOMPATIBLE_SETTING, DELTA_AMBIGUOUS_PATHS_IN_CREATE_TABLE, DELTA_CANNOT_SET_LOCATION_ON_PATH_IDENTIFIER, DELTA_CLONE_AMBIGUOUS_TARGET, DELTA_CLUSTERING_WITH_ZORDER_BY, DELTA_CLUSTER_BY_WITH_BUCKETING, DELTA_CLUSTER_BY_WITH_PARTITIONED_BY, DELTA_FILE_LIST_AND_PATTERN_STRING_CONFLICT, DELTA_IDENTITY_COLUMNS_WITH_GENERATED_EXPRESSION, DELTA_OVERWRITE_SCHEMA_WITH_DYNAMIC_PARTITION_OVERWRITE, DELTA_PARTITION_SCHEMA_IN_ICEBERG_TABLES, DELTA_REPLACE_WHERE_IN_OVERWRITE, DELTA_REPLACE_WHERE_WITH_DYNAMIC_PARTITION_OVERWRITE, DELTA_REPLACE_WHERE_WITH_FILTER_DATA_CHANGE_UNSET, DELTA_STARTING_VERSION_AND_TIMESTAMP_BOTH_SET, DELTA_TABLE_LOCATION_MISMATCH, DELTA_UNSUPPORTED_TIME_TRAVEL_MULTIPLE_FORMATS, INCOMPATIBLE_JOIN_TYPES, INVALID_LATERAL_JOIN_TYPE, INVALID_QUERY_MIXED_QUERY_PARAMETERS, INVALID_SINGLE_VARIANT_COLUMN, MANAGED_TABLE_WITH_CRED, MUTUALLY_EXCLUSIVE_CLAUSES, NON_LAST_MATCHED_CLAUSE_OMIT_CONDITION, NON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITION, NON_LAST_NOT_MATCHED_BY_TARGET_CLAUSE_OMIT_CONDITION, STDS_CONFLICT_OPTIONS
42614 重复的关键字或子句无效。
DELTA_MULTIPLE_CDC_BOUNDARYDELTA_MULTIPLE_CONF_FOR_SINGLE_COLUMN_IN_BLOOM_FILTERDUPLICATE_CLAUSESREPEATED_CLAUSE
42616 指定的选项无效
BIGQUERY_OPTIONS_ARE_MUTUALLY_EXCLUSIVEDELTA_CANNOT_SET_MANAGED_STATS_COLUMNS_PROPERTYDELTA_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_COLUMN, DELTA_INVALID_GENERATED_COLUMN_REFERENCES, DELTA_NON_BOOLEAN_CHECK_CONSTRAINT, DELTA_NON_DETERMINISTIC_EXPRESSION_IN_GENERATED_COLUMN, DELTA_UDF_IN_GENERATED_COLUMN, DELTA_UNSUPPORTED_DATA_TYPE_IN_GENERATED_COLUMN, DELTA_UNSUPPORTED_EXPRESSION_GENERATED_COLUMN, UNSUPPORTED_EXPRESSION_GENERATED_COLUMN
42623 不能指定 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_REFERENCE, CANNOT_RESOLVE_DATAFRAME_COLUMN, CANNOT_RESOLVE_STAR_EXPAND, CODEC_SHORT_NAME_NOT_FOUND, COLLATION_INVALID_NAME, COLLATION_INVALID_PROVIDER, DATA_SOURCE_NOT_EXIST, DEFAULT_DATABASE_NOT_EXISTS, DELTA_COLUMN_PATH_NOT_NESTED, DELTA_CONSTRAINT_DOES_NOT_EXIST, DELTA_SHARING_CURRENT_RECIPIENT_PROPERTY_UNDEFINED, ENCODER_NOT_FOUND, FIELD_NOT_FOUND, INDEX_NOT_FOUND, SCHEMA_NOT_FOUND, UC_VOLUME_NOT_FOUND, UNRECOGNIZED_SQL_TYPE
42710 检测到重复的对象或约束名称。
ALTER_TABLE_COLUMN_DESCRIPTOR_DUPLICATE, CREATE_TABLE_COLUMN_DESCRIPTOR_DUPLICATE, DATA_SOURCE_ALREADY_EXISTS, DELTA_CONSTRAINT_ALREADY_EXISTS, DUPLICATED_METRICS_NAME, FIELDS_ALREADY_EXISTS, FOUND_MULTIPLE_DATA_SOURCES, INDEX_ALREADY_EXISTS, LOCATION_ALREADY_EXISTS, MULTIPLE_XML_DATA_SOURCE, STATEFUL_PROCESSOR_CANNOT_REINITIALIZE_STATE_ON_KEY
42711 在对象定义或 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_ALREADY_PROVIDED_POSITIONALLY, REQUIRED_PARAMETER_NOT_FOUND, UNEXPECTED_POSITIONAL_ARGUMENT, UNKNOWN_POSITIONAL_ARGUMENT, UNRECOGNIZED_PARAMETER_NAME
42802 目标值的数目与源值的数目不同。
ASSIGNMENT_ARITY_MISMATCH, DELTA_INSERT_COLUMN_ARITY_MISMATCH, DELTA_INSERT_COLUMN_MISMATCH, STATEFUL_PROCESSOR_CANNOT_PERFORM_OPERATION_WITH_INVALID_HANDLE_STATE, STATEFUL_PROCESSOR_CANNOT_PERFORM_OPERATION_WITH_INVALID_TIME_MODE, STATEFUL_PROCESSOR_INCORRECT_TIME_MODE_TO_ASSIGN_TTL, STATEFUL_PROCESSOR_TTL_DURATION_MUST_BE_POSITIVE, STATE_STORE_CANNOT_CREATE_COLUMN_FAMILY_WITH_RESERVED_CHARS, STATE_STORE_CANNOT_USE_COLUMN_FAMILY_WITH_INVALID_NAME, STATE_STORE_HANDLE_NOT_INITIALIZED, STATE_STORE_INCORRECT_NUM_ORDERING_COLS_FOR_RANGE_SCAN, STATE_STORE_INCORRECT_NUM_PREFIX_COLS_FOR_PREFIX_SCAN, STATE_STORE_NULL_TYPE_ORDERING_COLS_NOT_SUPPORTED, STATE_STORE_UNSUPPORTED_OPERATION_ON_MISSING_COLUMN_FAMILY, STATE_STORE_VARIABLE_SIZE_ORDERING_COLS_NOT_SUPPORTED, UDTF_ALIAS_NUMBER_MISMATCH, UDTF_INVALID_ALIAS_IN_REQUESTED_ORDERING_STRING_FROM_ANALYZE_METHOD, UDTF_INVALID_REQUESTED_SELECTED_EXPRESSION_FROM_ANALYZE_METHOD_REQUIRES_ALIAS
42803 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
42815 数据类型、长度、刻度、值或 CCSID 无效。
EMITTING_ROWS_OLDER_THAN_WATERMARK_NOT_ALLOWED
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_COLLATION_BUCKET_COLUMNCANNOT_ALTER_PARTITION_COLUMNDELTA_ALTER_COLLATION_NOT_SUPPORTED_BLOOM_FILTERDELTA_ALTER_COLLATION_NOT_SUPPORTED_CLUSTER_BY
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 数据类型在其使用上下文中不受支持。
DELTA_IDENTITY_COLUMNS_UNSUPPORTED_DATA_TYPE, 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_SUPPORTED, GROUP_BY_AGGREGATE, GROUP_BY_POS_AGGREGATE, INVALID_AGGREGATE_FILTER, INVALID_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_FOUND, CANNOT_LOAD_PROTOBUF_CLASS, CLOUD_FILE_SOURCE_FILE_NOT_FOUND, DATA_SOURCE_TABLE_SCHEMA_MISMATCH, DEFAULT_FILE_NOT_FOUND, DELTA_CHANGE_DATA_FILE_NOT_FOUND, DELTA_CHECKPOINT_NON_EXIST_TABLE, DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_TXN_LOG, DELTA_DELETED_PARQUET_FILE_NOT_FOUND, DELTA_EMPTY_DIRECTORY, DELTA_FILE_NOT_FOUND, DELTA_FILE_NOT_FOUND_DETAILED, DELTA_FILE_OR_DIR_NOT_FOUND, DELTA_FILE_TO_OVERWRITE_NOT_FOUND, DELTA_LOG_FILE_NOT_FOUND_FOR_STREAMING_SOURCE, DELTA_PATH_DOES_NOT_EXIST, DELTA_SHALLOW_CLONE_FILE_NOT_FOUND, DELTA_TRUNCATED_TRANSACTION_LOG, LOAD_DATA_PATH_NOT_EXISTS, PATH_NOT_FOUND, READ_CURRENT_FILE_NOT_FOUND, RENAME_SRC_PATH_NOT_FOUND, STDS_FAILED_TO_READ_STATE_SCHEMA, STREAMING_STATEFUL_OPERATOR_NOT_MATCH_IN_STATE_METADATA
42K04 重复文件
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_OPTIONSSTATE_STORE_INVALID_PROVIDERSTATE_STORE_PROVIDER_DOES_NOT_SUPPORT_FINE_GRAINED_STATE_REPLAY
42K07 不是有效的架构文本
INVALID_SCHEMA
42K08 不是常数
ARGUMENT_NOT_CONSTANTINVALID_SQL_ARGNON_FOLDABLE_ARGUMENTNON_LITERAL_PIVOT_VALUESSEED_EXPRESSION_IS_UNFOLDABLE
42K09 数据类型不匹配
COMPLEX_EXPRESSION_UNSUPPORTED_INPUT, DATATYPE_MISMATCH, DELTA_CONSTRAINT_DATA_TYPE_MISMATCH, DELTA_CONSTRAINT_DEPENDENT_COLUMN_CHANGE, DELTA_GENERATED_COLUMNS_DATA_TYPE_MISMATCH, DELTA_GENERATED_COLUMNS_DEPENDENT_COLUMN_CHANGE, DELTA_GENERATED_COLUMNS_EXPR_TYPE_MISMATCH, DELTA_GENERATED_COLUMN_UPDATE_TYPE_MISMATCH, DELTA_MERGE_ADD_VOID_COLUMN, DELTA_MERGE_INCOMPATIBLE_DATATYPE, DELTA_NOT_NULL_COLUMN_NOT_FOUND_IN_STRUCT, EVENT_TIME_IS_NOT_ON_TIMESTAMP_TYPE, INVALID_VARIABLE_TYPE_FOR_QUERY_EXECUTE_IMMEDIATE, PIVOT_VALUE_DATA_TYPE_MISMATCH, UNEXPECTED_INPUT_TYPE, UNPIVOT_VALUE_DATA_TYPE_MISMATCH
42K0A 无效的 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 配置。
CONFIG_NOT_AVAILABLESQL_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
42P08 不明确的参数
CATALOG_NOT_FOUND
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
42P21 排序规则不匹配
COLLATION_MISMATCH
42P22 不确定的排序规则
INDETERMINATE_COLLATION
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
54001 语句太长或太复杂。
FAILED_TO_PARSE_TOO_COMPLEX
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 该对象处于无效状态,不可用于操作。
CANNOT_QUERY_TABLE_DURING_INITIALIZATION, COPY_INTO_STATE_INTERNAL_ERROR, DIFFERENT_DELTA_TABLE_READ_BY_STREAMING_SOURCE, EVENT_LOG_UNAVAILABLE, MATERIALIZED_VIEW_MESA_REFRESH_WITHOUT_PIPELINE_ID, STREAMING_TABLE_NEEDS_REFRESH

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_SERVERLESSCLUSTER_BY_AUTO_REQUIRES_CLUSTERING_FEATURE_ENABLEDCLUSTER_BY_AUTO_REQUIRES_PREDICTIVE_OPTIMIZATIONCLUSTER_BY_AUTO_UNSUPPORTED_TABLE_TYPE_ERRORCODEC_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_ENABLEDFEATURE_NOT_ON_CLASSIC_WAREHOUSEFEATURE_UNAVAILABLEGET_TABLES_BY_TYPE_UNSUPPORTED_BY_HIVE_VERSIONINCOMPATIBLE_DATASOURCE_REGISTERMATERIALIZED_VIEW_OPERATION_NOT_ALLOWEDMETRIC_STORE_UNSUPPORTED_ERRORNATIVE_XML_DATA_SOURCE_NOT_ENABLEDSTREAMING_TABLE_NOT_SUPPORTEDUC_LAKEHOUSE_FEDERATION_WRITES_NOT_ALLOWEDUC_NOT_ENABLEDUC_QUERY_FEDERATION_NOT_ENABLEDUC_SERVICE_CREDENTIALS_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 描述和发出错误类
58000 系统错误
CLOUD_PROVIDER_ERROR
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
HV091 无效的描述符字段标识符
NONEXISTENT_FIELD_NAME_IN_LIST

HY:特定于 CLI 的条件

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

KD:特定于数据源的错误

SQLSTATE 描述和发出错误类
KD000 特定于数据源的错误
DC_API_QUOTA_EXCEEDED, DC_CONNECTION_ERROR, DC_DYNAMICS_API_ERROR, DC_NETSUITE_ERROR, DC_SERVICENOW_API_ERROR, DC_SFDC_BULK_QUERY_JOB_INCOMPLETE, DC_SHAREPOINT_API_ERROR, DC_SOURCE_API_ERROR, DC_WORKDAY_RAAS_API_ERROR, END_OFFSET_HAS_GREATER_OFFSET_FOR_TOPIC_PARTITION_THAN_LATEST_WITH_TRIGGER_AVAILABLENOW, END_OFFSET_HAS_GREATER_OFFSET_FOR_TOPIC_PARTITION_THAN_PREFETCHED, FAILED_REGISTER_CLASS_WITH_KRYO, GRAPHITE_SINK_INVALID_PROTOCOL, GRAPHITE_SINK_PROPERTY_MISSING, INCOMPATIBLE_DATA_FOR_TABLE, LOST_TOPIC_PARTITIONS_IN_END_OFFSET_WITH_TRIGGER_AVAILABLENOW, MALFORMED_AVRO_MESSAGE, MALFORMED_CSV_RECORD, MISMATCHED_TOPIC_PARTITIONS_BETWEEN_END_OFFSET_AND_PREFETCHED
KD001 无法读取文件页脚
DELTA_FAILED_READ_FILE_FOOTER, FAILED_READ_FILE
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_DOWNGRADE, DELTA_INVALID_PROTOCOL_VERSION, DELTA_MISSING_COMMIT_INFO, DELTA_MISSING_COMMIT_TIMESTAMP, DELTA_READ_FEATURE_PROTOCOL_REQUIRES_WRITE, DELTA_UNSUPPORTED_COLUMN_MAPPING_PROTOCOL
KD005 表必须至少包含一个非分区列
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_VIOLATION, DELTA_UNIFORM_ICEBERG_INGRESS_VIOLATION, DELTA_UNIVERSAL_FORMAT_CONVERSION_FAILED, DELTA_UNIVERSAL_FORMAT_VIOLATION

P0:过程逻辑错误

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