SQLSTATE 错误代码

  • 项目

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

Azure Databricks 返回的所有错误类都与一个 5 字符 SQLSTATE 相关联。 SQLSTATE 是 JDBC、ODBC 和其他客户端 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_INTO、NESTED_EXECUTE_IMMEDIATE

类 08：连接异常

SQLSTATE 描述和发出错误类
08000 连接异常
AI_FUNCTION_HTTP_REQUEST_ERROR、AI_FUNCTION_INVALID_HTTP_RESPONSE、CANNOT_VALIDATE_CONNECTION
08001 SQL 客户端无法建立 SQL 连接
CANNOT_ESTABLISH_CONNECTION、CANNOT_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_PARAMETER、ROW_LEVEL_SECURITY_UNSUPPORTED_CONSTANT_AS_PARAMETER
0AKDC 在 Delta 中不受支持
DELTA_CANNOT_EVALUATE_EXPRESSION、DELTA_CANNOT_GENERATE_CODE_FOR_EXPRESSION、DELTA_CDC_NOT_ALLOWED_IN_THIS_VERSION、DELTA_CHANGE_DATA_FEED_INCOMPATIBLE_DATA_SCHEMA、DELTA_CHANGE_DATA_FEED_INCOMPATIBLE_SCHEMA_CHANGE、DELTA_CLONE_UNSUPPORTED_SOURCE、DELTA_COLLATIONS_NOT_SUPPORTED、DELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_PARTITIONED_COLUMN、DELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_TYPE、DELTA_CONVERSION_UNSUPPORTED_COLUMN_MAPPING、DELTA_CONVERT_NON_PARQUET_TABLE、DELTA_CREATE_TABLE_IDENTIFIER_LOCATION_MISMATCH、DELTA_DROP_COLUMN_ON_SINGLE_FIELD_SCHEMA、DELTA_INCORRECT_LOG_STORE_IMPLEMENTATION、DELTA_MISSING_PROVIDER_FOR_CONVERT、DELTA_MODE_NOT_SUPPORTED、DELTA_NESTED_NOT_NULL_CONSTRAINT、DELTA_NON_DETERMINISTIC_FUNCTION_NOT_SUPPORTED、DELTA_OPERATION_NOT_ALLOWED、DELTA_OPERATION_NOT_ALLOWED_DETAIL、DELTA_OPERATION_NOT_SUPPORTED_FOR_COLUMN_WITH_COLLATION、DELTA_OPERATION_NOT_SUPPORTED_FOR_EXPRESSION_WITH_COLLATION、DELTA_OPERATION_ON_VIEW_NOT_ALLOWED、DELTA_TABLE_FOR_PATH_UNSUPPORTED_HADOOP_CONF、DELTA_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_OP、DELTA_UNSUPPORTED_ALTER_TABLE_REPLACE_COL_OP、DELTA_UNSUPPORTED_CLONE_REPLACE_SAME_TABLE、DELTA_UNSUPPORTED_COLUMN_MAPPING_MODE_CHANGE、DELTA_UNSUPPORTED_COLUMN_MAPPING_SCHEMA_CHANGE、DELTA_UNSUPPORTED_COLUMN_MAPPING_WRITE、 DELTA_UNSUPPORTED_COLUMN_TYPE_IN_BLOOM_FILTER、DELTA_UNSUPPORTED_COMMENT_MAP_ARRAY、DELTA_UNSUPPORTED_DATA_TYPES、DELTA_UNSUPPORTED_DROP_CLUSTERING_COLUMN、DELTA_UNSUPPORTED_DROP_COLUMN、DELTA_UNSUPPORTED_DROP_NESTED_COLUMN_FROM_NON_STRUCT_TYPE、DELTA_UNSUPPORTED_DROP_PARTITION_COLUMN、DELTA_UNSUPPORTED_FIELD_UPDATE_NON_STRUCT、DELTA_UNSUPPORTED_INVARIANT_NON_STRUCT、DELTA_UNSUPPORTED_IN_SUBQUERY、DELTA_UNSUPPORTED_MANIFEST_GENERATION_WITH_COLUMN_MAPPING、DELTA_UNSUPPORTED_MULTI_COL_IN_PREDICATE、DELTA_UNSUPPORTED_NESTED_COLUMN_IN_BLOOM_FILTER、DELTA_UNSUPPORTED_NESTED_FIELD_IN_OPERATION、DELTA_UNSUPPORTED_NON_EMPTY_CLONE、DELTA_UNSUPPORTED_OUTPUT_MODE、DELTA_UNSUPPORTED_PARTITION_COLUMN_IN_BLOOM_FILTER、DELTA_UNSUPPORTED_RENAME_COLUMN、DELTA_UNSUPPORTED_SCHEMA_DURING_READ、DELTA_UNSUPPORTED_SUBQUERY、DELTA_UNSUPPORTED_SUBQUERY_IN_PARTITION_PREDICATES、DELTA_UNSUPPORTED_TIME_TRAVEL_VIEWS、DELTA_UNSUPPORTED_TYPE_CHANGE_IN_SCHEMA、DELTA_UNSUPPORTED_VACUUM_SPECIFIC_PARTITION、WRONG_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_FAILED, DELTA_DATA_CHANGE_FALSE, DELTA_FEATURES_PROTOCOL_METADATA_MISMATCH, DELTA_FEATURES_REQUIRE_MANUAL_ENABLEMENT, DELTA_FEATURE_DROP_CONFLICT_REVALIDATION_FAIL, DELTA_FEATURE_DROP_DEPENDENT_FEATURE, DELTA_FEATURE_DROP_FEATURE_NOT_PRESENT, DELTA_FEATURE_DROP_HISTORICAL_VERSIONS_EXIST, DELTA_FEATURE_DROP_HISTORY_TRUNCATION_NOT_ALLOWED, DELTA_FEATURE_DROP_NONREMOVABLE_FEATURE, DELTA_FEATURE_DROP_UNSUPPORTED_CLIENT_FEATURE, DELTA_FEATURE_DROP_WAIT_FOR_RETENTION_PERIOD, DELTA_FEATURE_REQUIRES_HIGHER_READER_VERSION, DELTA_FEATURE_REQUIRES_HIGHER_WRITER_VERSION, DELTA_UNSUPPORTED_FEATURE_STATUS, WRONG_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_FAILED_PROVISIONING_STATE, UC_FILE_SCHEME_FOR_TABLE_CREATION_NOT_SUPPORTED, UC_INVALID_NAMESPACE, UC_INVALID_REFERENCE, UPGRADE_NOT_SUPPORTED
0AKUD 功能需要 Unity Catalog
FEATURE_REQUIRES_UC、OPERATION_REQUIRES_UNITY_CATALOG、SYNC_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_NULL, NULL_QUERY_STRING_EXECUTE_IMMEDIATE, TWS_VALUE_SHOULD_NOT_BE_NULL
22005 分配错误
DELTA_COMPLEX_TYPE_COLUMN_CONTAINS_NULL_TYPE、DELTA_FAILED_TO_MERGE_FIELDS、DELTA_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_ZERO、INTERVAL_DIVIDED_BY_ZERO
22015 间隔字段溢出
INTERVAL_ARITHMETIC_OVERFLOW
22018 要强制转换的字符值无效
CANNOT_PARSE_DECIMAL、CANNOT_PARSE_PROTOBUF_DESCRIPTOR、CAST_INVALID_INPUT、CONVERSION_INVALID_INPUT、DELTA_FAILED_CAST_PARTITION_VALUE、FAILED_PARSE_STRUCT_TYPE
2201B 无效的正则表达式
DELTA_REGEX_OPT_SYNTAX_ERROR
2201E 自然对数的无效参数
STRUCT_ARRAY_LENGTH_MISMATCH
22022 指示器溢出
INVALID_CONF_VALUE
22023 无效的参数值
CONFLICTING_PROVIDER, DELTA_INVALID_AUTO_COMPACT_TYPE, DELTA_INVALID_BUCKET_COUNT, DELTA_INVALID_BUCKET_INDEX, DELTA_UNSUPPORTED_STRATEGY_NAME, EMPTY_LOCAL_FILE_IN_STAGING_ACCESS_QUERY, EWKB_PARSE_ERROR, GEOJSON_PARSE_ERROR, H3_INVALID_CELL_ID, H3_INVALID_GRID_DISTANCE_VALUE, H3_INVALID_RESOLUTION_VALUE, H3_PENTAGON_ENCOUNTERED_ERROR, H3_UNDEFINED_GRID_DISTANCE, INVALID_FRACTION_OF_SECOND, INVALID_PARAMETER_MARKER_VALUE, INVALID_PARAMETER_VALUE, INVALID_VARIANT_CAST, INVALID_VARIANT_GET_PATH, MALFORMED_RECORD_IN_PARSING, MALFORMED_VARIANT, MAX_RECORDS_PER_FETCH_INVALID_FOR_KINESIS_SOURCE, METRIC_STORE_INVALID_ARGUMENT_VALUE_ERROR, RULE_ID_NOT_FOUND, SECOND_FUNCTION_ARGUMENT_NOT_INTEGER, ST_DIFFERENT_SRID_VALUES, ST_INVALID_ARGUMENT, ST_INVALID_ARGUMENT_TYPE, ST_INVALID_CRS_TRANSFORMATION_ERROR, ST_INVALID_ENDIANNESS_VALUE, ST_INVALID_GEOHASH_VALUE, ST_INVALID_PRECISION_VALUE, ST_INVALID_SRID_VALUE, TABLE_VALUED_FUNCTION_REQUIRED_METADATA_INCOMPATIBLE_WITH_CALL, TABLE_VALUED_FUNCTION_REQUIRED_METADATA_INVALID, VARIANT_CONSTRUCTOR_SIZE_LIMIT, VARIANT_DUPLICATE_KEY, VARIANT_SIZE_LIMIT, WKB_PARSE_ERROR, WKT_PARSE_ERROR, XML_WILDCARD_RESCUED_DATA_CONFLICT_ERROR
22032 无效的 JSON 文本
AI_FUNCTION_INVALID_MAX_WORDS、AI_INVALID_ARGUMENT_VALUE_ERROR、INVALID_JSON_ROOT_FIELD、INVALID_JSON_SCHEMA_MAP_TYPE、REMOTE_FUNCTION_HTTP_RESULT_PARSE_ERROR
2203G sql json 项无法强制转换为目标类型
AI_FUNCTION_HTTP_PARSE_CAST_ERROR, AI_FUNCTION_HTTP_PARSE_COLUMNS_ERROR, CANNOT_PARSE_JSON_FIELD, FAILED_ROW_TO_JSON, INVALID_JSON_DATA_TYPE, INVALID_JSON_DATA_TYPE_FOR_COLLATIONS
22525 分区键值无效。
DELTA_PARTITION_COLUMN_CAST_FAILED
22531 内置或系统提供的例程的参数导致错误。
INVALID_SECRET_LOOKUP
22546 例程参数的值无效。
CANNOT_DECODE_URL、HLL_INVALID_INPUT_SKETCH_BUFFER、HLL_INVALID_LG_K
22KD1 无效的 URI 或路径
DELTA_CANNOT_RECONSTRUCT_PATH_FROM_URI、DELTA_CANNOT_RENAME_PATH、DELTA_INVALID_CLONE_PATH、DELTA_INVALID_PARTITION_PATH
22KD2 未设置标识声明
OAUTH_CUSTOM_IDENTITY_CLAIM_NOT_PROVIDED
22KD3 无法将源类型演化为目标类型。
AVRO_INCOMPATIBLE_READ_TYPE、FROM_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_VALUE、DELTA_NOT_NULL_CONSTRAINT_VIOLATED
23505 唯一索引或唯一约束施加的约束发生冲突。
DUPLICATED_MAP_KEY、DUPLICATE_KEY
23512 无法添加检查约束，因为表包含不满足约束定义的行。
DELTA_NEW_CHECK_CONSTRAINT_VIOLATION、DELTA_NEW_NOT_NULL_VIOLATION
23K01 MERGE 基数冲突
MERGE_CARDINALITY_VIOLATION

类 25：无效的事务状态

SQLSTATE 描述和发出错误类
25000 无效的事务状态
COPY_INTO_DUPLICATED_FILES_COPY_NOT_ALLOWED、COPY_INTO_NON_BLIND_APPEND_NOT_ALLOWED、COPY_INTO_ROCKSDB_MAX_RETRY_EXCEEDED、DATA_LINEAGE_SECURE_VIEW_LEAF_NODE_HAS_NO_RELATION、DELTA_INVALID_ISOLATION_LEVEL、DELTA_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_UDF、FOREACH_BATCH_USER_FUNCTION_ERROR、UDF_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_PROVIDER、CF_CLEAN_SOURCE_UNAUTHORIZED_WRITE_PERMISSION、INSUFFICIENT_PERMISSIONS、INSUFFICIENT_PERMISSIONS_EXT_LOC、INSUFFICIENT_PERMISSIONS_NO_OWNER、INSUFFICIENT_PERMISSIONS_OWNERSHIP_SECURABLE、INSUFFICIENT_PERMISSIONS_SECURABLE、INSUFFICIENT_PERMISSIONS_SECURABLE_PARENT_OWNER、INSUFFICIENT_PERMISSIONS_STORAGE_CRED、INSUFFICIENT_PERMISSIONS_UNDERLYING_SECURABLES、INSUFFICIENT_PERMISSIONS_UNDERLYING_SECURABLES_VERBOSE、INVALID_S3_COPY_CREDENTIALS、UNAUTHORIZED_ACCESS
42601 字符、标记或子句无效或缺失。
COLUMN_ALIASES_NOT_ALLOWED、COMMA_PRECEDING_CONSTRAINT_ERROR、COPY_INTO_CREDENTIALS_REQUIRED、COPY_INTO_ENCRYPTION_REQUIRED、COPY_INTO_ENCRYPTION_REQUIRED_WITH_EXPECTED、COPY_INTO_SYNTAX_ERROR、CREDENTIAL_MISSING、DATA_SOURCE_OPTION_IS_REQUIRED、DELTA_CANNOT_CHANGE_LOCATION、DELTA_COLUMN_MISSING_DATA_TYPE、DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_SCHEMA、DELTA_CREATE_TABLE_MISSING_TABLE_NAME_OR_LOCATION、DELTA_CREATE_TABLE_WITH_NON_EMPTY_LOCATION、DELTA_DUPLICATE_DOMAIN_METADATA_INTERNAL_ERROR、DELTA_FAILED_RECOGNIZE_PREDICATE、DELTA_ILLEGAL_USAGE、DELTA_MERGE_MISSING_WHEN、DELTA_MERGE_RESOLVED_ATTRIBUTE_MISSING_FROM_INPUT、DELTA_MERGE_UNRESOLVED_EXPRESSION、DELTA_NON_LAST_MATCHED_CLAUSE_OMIT_CONDITION、DELTA_NON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITION、DELTA_NON_LAST_NOT_MATCHED_CLAUSE_OMIT_CONDITION、DELTA_NON_PARSABLE_TAG、DELTA_NO_START_FOR_CDC_READ、DELTA_ONEOF_IN_TIMETRAVEL、DELTA_OPERATION_MISSING_PATH、DELTA_UNEXPECTED_ACTION_EXPRESSION、DELTA_UNKNOWN_PRIVILEGE、DELTA_UNKNOWN_READ_LIMIT、DELTA_UNRECOGNIZED_COLUMN_CHANGE、EVENT_LOG_REQUIRES_SHARED_COMPUTE、FROM_JSON_CONFLICTING_SCHEMA_UPDATES、FROM_JSON_CORRUPT_RECORD_COLUMN_IN_SCHEMA、FROM_JSON_CORRUPT_SCHEMA、FROM_JSON_INFERENCE_FAILED、FROM_JSON_INVALID_CONFIGURATION、GET_WARMUP_TRACING_FAILED、GET_WARMUP_TRACING_FUNCTION_NOT_ALLOWED、IDENTIFIER_TOO_MANY_NAME_PARTS、ILLEGAL_STATE_STORE_VALUE、INVALID_BUCKET_COLUMN_DATA_TYPE、INVALID_EXTRACT_FIELD、INVALID_FORMAT、INVALID_PARTITION_OPERATION、INVALID_SHARED_ALIAS_NAME、INVALID_STATEMENT_OR_CLAUSE、INVALID_WINDOW_SPEC_FOR_AGGREGATION_FUNC、LOCAL_MUST_WITH_SCHEMA_FILE、MV_ST_ALTER_QUERY_INCORRECT_BACKING_TYPE、NOT_ALLOWED_IN_FROM、NOT_A_CONSTANT_ STRING、NOT_UNRESOLVED_ENCODER、PARSE_SYNTAX_ERROR、PROCEDURE_CREATION_PARAMETER_OUT_INOUT_WITH_DEFAULT、REF_DEFAULT_VALUE_IS_NOT_ALLOWED_IN_PARTITION、SORT_BY_WITHOUT_BUCKETING、SPECIFY_BUCKETING_IS_NOT_ALLOWED、SPECIFY_PARTITION_IS_NOT_ALLOWED、STDS_REQUIRED_OPTION_UNSPECIFIED、STREAMING_TABLE_OPERATION_NOT_ALLOWED、 SYNTAX_DISCONTINUED、UC_EXTERNAL_VOLUME_MISSING_LOCATION、UC_LOCATION_FOR_MANAGED_VOLUME_NOT_SUPPORTED、UNCLOSED_BRACKETED_COMMENT、USER_DEFINED_FUNCTIONS、WINDOW_FUNCTION_WITHOUT_OVER_CLAUSE、WITH_CREDENTIAL、WRITE_STREAM_NOT_ALLOWED
42602 已检测到名称中无效的字符。
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_JOIN、DELTA_TIME_TRAVEL_INVALID_BEGIN_VALUE、EMPTY_JSON_FIELD_VALUE、INVALID_ESC、INVALID_ESCAPE_CHAR、INVALID_PIPELINE_ID、INVALID_STAGING_PATH_IN_STAGING_ACCESS_QUERY、INVALID_TYPED_LITERAL、INVALID_UUID
42605 为标量函数指定的参数数目无效。
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 列、自变量、参数或全局变量定义无效。
DELTA_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_BOUNDARY、DELTA_MULTIPLE_CONF_FOR_SINGLE_COLUMN_IN_BLOOM_FILTER、DUPLICATE_CLAUSES、REPEATED_CLAUSE
42616 指定的选项无效
BIGQUERY_OPTIONS_ARE_MUTUALLY_EXCLUSIVE、DELTA_ILLEGAL_OPTION、DELTA_INVALID_IDEMPOTENT_WRITES_OPTIONS、DELTA_UNSET_NON_EXISTENT_PROPERTY、STDS_INVALID_OPTION_VALUE、UNSUPPORTED_COMMON_ANCESTOR_LOC_FOR_FILE_STREAM_SOURCE、UNSUPPORTED_INITIAL_POSITION_AND_TRIGGER_PAIR_FOR_KINESIS_SOURCE
42617 语句字符串为空。
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_VALUE、INVALID_DEFAULT_VALUE
42701 在同一 SQL 语句中多次指定同一目标进行赋值。
DELTA_CONFLICT_SET_COLUMN、DELTA_DUPLICATE_COLUMNS_ON_INSERT、DELTA_DUPLICATE_COLUMNS_ON_UPDATE_TABLE、DELTA_DUPLICATE_DATA_SKIPPING_COLUMNS、DUPLICATE_ASSIGNMENTS、EXEC_IMMEDIATE_DUPLICATE_ARGUMENT_ALIASES
42702 由于名称重复，列引用不明确。
AMBIGUOUS_COLUMN_OR_FIELD、AMBIGUOUS_COLUMN_REFERENCE、AMBIGUOUS_LATERAL_COLUMN_ALIAS、DELTA_AMBIGUOUS_PARTITION_COLUMN、EXCEPT_OVERLAPPING_COLUMNS
42703 检测到未定义的列或参数名称。
COLUMN_NOT_DEFINED_IN_TABLE、COLUMN_NOT_FOUND、DELTA_BLOOM_FILTER_DROP_ON_NON_EXISTING_COLUMNS、DELTA_CANNOT_CREATE_BLOOM_FILTER_NON_EXISTING_COL、DELTA_CANNOT_DROP_BLOOM_FILTER_ON_NON_INDEXED_COLUMN、DELTA_CANNOT_RESOLVE_COLUMN、DELTA_COLUMN_MAPPING_MAX_COLUMN_ID_NOT_SET、DELTA_COLUMN_MAPPING_MAX_COLUMN_ID_NOT_SET_CORRECTLY、DELTA_COLUMN_NOT_FOUND、DELTA_COLUMN_NOT_FOUND_IN_MERGE、DELTA_COLUMN_NOT_FOUND_IN_SCHEMA、DELTA_FAILED_FIND_ATTRIBUTE_IN_OUTPUT_COLUMNS、DELTA_MISSING_COLUMN、DELTA_MISSING_SET_COLUMN、DELTA_PARTITION_COLUMN_NOT_FOUND、DELTA_ZORDERING_COLUMN_DOES_NOT_EXIST、EXCEPT_RESOLVED_COLUMNS_WITHOUT_MATCH、EXCEPT_UNRESOLVED_COLUMN_IN_STRUCT_EXPANSION、UNRESOLVED_COLUMN、UNRESOLVED_FIELD、UNRESOLVED_MAP_KEY、UNRESOLVED_USING_COLUMN_FOR_JOIN、ZORDERBY_COLUMN_DOES_NOT_EXIST
42704 检测到未定义的对象或限制名称。
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_EXISTS、DELTA_DUPLICATE_COLUMNS_FOUND、DELTA_TABLE_ALREADY_CONTAINS_CDC_COLUMNS、DUPLICATE_ROUTINE_RETURNS_COLUMNS
42713 在列表中检测到重复对象或与现有对象相同。
DUPLICATED_FIELD_NAME_IN_ARROW_STRUCT、STATIC_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_MISMATCH、GROUPING_ID_COLUMN_MISMATCH、MISSING_AGGREGATION、MISSING_GROUP_BY、UNRESOLVED_ALL_IN_GROUP_BY
42805 ORDER BY 子句中的整数未标识结果表的列。
GROUP_BY_POS_OUT_OF_RANGE、ORDER_BY_POS_OUT_OF_RANGE
42806 无法为变量赋值，因为数据类型不兼容。
DELTA_MERGE_INCOMPATIBLE_DECIMAL_TYPE
42807 此对象不允许使用数据更改语句。
DELTA_CHANGE_TABLE_FEED_DISABLED、DELTA_UNSUPPORTED_WRITES_STAGED_TABLE
42809 标识的对象不是该语句适用的对象类型。
DELTA_CANNOT_DESCRIBE_VIEW_HISTORY、DELTA_CANNOT_MODIFY_APPEND_ONLY、DELTA_SHOW_PARTITION_IN_NON_PARTITIONED_TABLE、DELTA_TABLE_NOT_SUPPORTED_IN_OP、DELTA_UNSUPPORTED_DESCRIBE_DETAIL_VIEW、EXPECT_PERMANENT_VIEW_NOT_TEMP、EXPECT_TABLE_NOT_VIEW、EXPECT_VIEW_NOT_TABLE、FORBIDDEN_OPERATION、INVALID_DEST_CATALOG、INVALID_SOURCE_CATALOG、INVALID_UPGRADE_SYNTAX、NOT_A_PARTITIONED_TABLE、UNSUPPORTED_INSERT、WRONG_COMMAND_FOR_OBJECT_TYPE
42816 表达式中的日期/时间值或持续时间无效。
DELTA_TIMESTAMP_GREATER_THAN_COMMIT、DELTA_TIMESTAMP_INVALID
42818 运算符或函数的操作数不兼容或不可比较。
INCOMPARABLE_PIVOT_COLUMN
42822 ORDER BY 子句或 GROUP BY 子句中的表达式无效。
EXPRESSION_TYPE_IS_NOT_ORDERABLE、GROUP_EXPRESSION_TYPE_IS_NOT_ORDERABLE
42823 从只允许一个列的子查询返回了多个列。
INVALID_SUBQUERY_EXPRESSION
42825 UNION、INTERSECT、EXCEPT 或 VALUES 的行没有兼容的列。
CANNOT_MERGE_INCOMPATIBLE_DATA_TYPE、INCOMPATIBLE_COLUMN_TYPE
42826 UNION、INTERSECT、EXCEPT 或 VALUES 的行没有相同的列数。
NUM_COLUMNS_MISMATCH、NUM_TABLE_VALUE_ALIASES_MISMATCH
42830 外键不符合父键的描述。
FOREIGN_KEY_MISMATCH
42832 不允许对系统对象执行该操作。
BUILT_IN_CATALOG、CANNOT_DELETE_SYSTEM_OWNED、EVENT_LOG_UNSUPPORTED_TABLE_TYPE、MODIFY_BUILTIN_CATALOG、SAMPLE_TABLE_PERMISSIONS
42837 无法更改该列，因为它的属性与当前列属性不兼容。
DELTA_ALTER_TABLE_CHANGE_COL_NOT_SUPPORTED
42845 检测到 NOT DETERMINISTIC 或 EXTERNAL ACTION 函数的无效用法。
AGGREGATE_FUNCTION_WITH_NONDETERMINISTIC_EXPRESSION
42846 不支持从源类型强制转换为目标类型。
CANNOT_CAST_DATATYPE、CANNOT_CONVERT_PROTOBUF_FIELD_TYPE_TO_SQL_TYPE、CANNOT_CONVERT_PROTOBUF_MESSAGE_TYPE_TO_SQL_TYPE、CANNOT_CONVERT_SQL_TYPE_TO_PROTOBUF_FIELD_TYPE、CANNOT_CONVERT_SQL_VALUE_TO_PROTOBUF_ENUM_TYPE、CANNOT_UP_CAST_DATATYPE、DELTA_UPDATE_SCHEMA_MISMATCH_EXPRESSION、EXPRESSION_DECODING_FAILED、EXPRESSION_ENCODING_FAILED、UNEXPECTED_SERIALIZER_FOR_CLASS
42852 GRANT 或 REVOKE 中指定的特权无效或不一致。 （例如，对视图运行 GRANT ALTER。）
INVALID_PRIVILEGE
42883 找不到具有匹配签名的例程。
ROUTINE_NOT_FOUND、UNRESOLVABLE_TABLE_VALUED_FUNCTION、UNRESOLVED_ROUTINE、UNRESOLVED_VARIABLE、VARIABLE_NOT_FOUND
42887 函数或表引用在其上下文中无效。
CYCLIC_FUNCTION_REFERENCE、DELTA_SHARING_INVALID_OP_IN_EXTERNAL_SHARED_VIEW、INVALID_CURRENT_RECIPIENT_USAGE、NOT_A_SCALAR_FUNCTION、NOT_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_PARTITION、PARTITIONS_ALREADY_EXIST、PARTITIONS_NOT_FOUND
428GU 表必须至少包含一个未隐式隐藏的列。
DELTA_EMPTY_DATA、DELTA_READ_TABLE_WITHOUT_COLUMNS、DELTA_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_PROVIDED、DELTA_SCHEMA_NOT_PROVIDED、SPECIFY_CLUSTER_BY_WITH_BUCKETING_IS_NOT_ALLOWED、SPECIFY_CLUSTER_BY_WITH_PARTITIONED_BY_IS_NOT_ALLOWED
42939 不能使用该名称，因为指定的标识符保留给系统使用。
DELTA_CANNOT_CHANGE_PROVIDER、DELTA_CANNOT_MODIFY_TABLE_PROPERTY、RESERVED_CDC_COLUMNS_ON_WRITE、ROUTINE_USES_SYSTEM_RESERVED_CLASS_NAME
42996 不能在分区键中使用指定的列。
DELTA_INVALID_PARTITION_COLUMN、DELTA_INVALID_PARTITION_COLUMN_NAME、DELTA_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_SIZE、INCOMPLETE_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_EXISTS、DELTA_LOG_ALREADY_EXISTS、DELTA_PATH_EXISTS、FAILED_RENAME_PATH、FILE_IN_STAGING_PATH_ALREADY_EXISTS、KINESIS_FETCHED_SHARD_LESS_THAN_TRACKED_SHARD、PARTITION_LOCATION_ALREADY_EXISTS、PATH_ALREADY_EXISTS
42K05 名称无效
CLEANROOM_INVALID_SHARED_DATA_OBJECT_NAME、COLUMN_MASKS_MULTI_PART_TARGET_COLUMN_NAME、COLUMN_MASKS_MULTI_PART_USING_COLUMN_NAME、DELTA_INVALID_CHARACTERS_IN_COLUMN_NAME、DELTA_INVALID_CHARACTERS_IN_COLUMN_NAMES、DELTA_INVALID_COLUMN_NAMES_WHEN_REMOVING_COLUMN_MAPPING、DELTA_NESTED_FIELDS_NEED_RENAME、DELTA_NON_SINGLE_PART_NAMESPACE_FOR_CATALOG、INVALID_EMPTY_LOCATION、REQUIRES_SINGLE_PART_NAMESPACE、ROW_LEVEL_SECURITY_MULTI_PART_COLUMN_NAME
42K06 选项的类型无效
DELTA_PROTOCOL_PROPERTY_NOT_INT、INVALID_OPTIONS
42K07 不是有效的架构文本
INVALID_SCHEMA
42K08 不是常数
ARGUMENT_NOT_CONSTANT、INVALID_SQL_ARG、NON_FOLDABLE_ARGUMENT、NON_LITERAL_PIVOT_VALUES、SEED_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_ATTRIBUTES、UNPIVOT_REQUIRES_VALUE_COLUMNS
42K0B 已阻止旧功能
INCONSISTENT_BEHAVIOR_CROSS_VERSION
42K0C 对约束的引用不明确
AMBIGUOUS_CONSTRAINT、CANNOT_DROP_AMBIGUOUS_CONSTRAINT
42K0D lambda 函数无效
INVALID_LAMBDA_FUNCTION_CALL
42K0E 表达式在使用它的上下文中无效
INVALID_LIMIT_LIKE_EXPRESSION、INVALID_NON_DETERMINISTIC_EXPRESSIONS、INVALID_OBSERVED_METRICS、INVALID_TIME_TRAVEL_SPEC、INVALID_TIME_TRAVEL_TIMESTAMP_EXPR、JOIN_CONDITION_IS_NOT_BOOLEAN_TYPE、MULTIPLE_TIME_TRAVEL_SPEC、MULTI_SOURCES_UNSUPPORTED_FOR_EXPRESSION、NO_MERGE_ACTION_SPECIFIED、ONLY_SECRET_FUNCTION_SUPPORTED_HERE、SECRET_FUNCTION_INVALID_LOCATION、UNSUPPORTED_EXPR_FOR_OPERATOR、UNSUPPORTED_EXPR_FOR_PARAMETER、UNSUPPORTED_GENERATOR、UNSUPPORTED_GROUPING_EXPRESSION、UNSUPPORTED_MERGE_CONDITION、UNTYPED_SCALA_UDF、WINDOW_FUNCTION_AND_FRAME_MISMATCH
42K0F 持久化对象不能引用临时对象。
INVALID_TEMP_OBJ_REFERENCE
42K0G protobuf 无效
PROTOBUF_DEPENDENCY_NOT_FOUND、PROTOBUF_DESCRIPTOR_FILE_NOT_FOUND、PROTOBUF_FIELD_MISSING、PROTOBUF_FIELD_MISSING_IN_SQL_SCHEMA、PROTOBUF_FIELD_TYPE_MISMATCH、PROTOBUF_MESSAGE_NOT_FOUND、PROTOBUF_TYPE_NOT_SUPPORT、RECURSIVE_PROTOBUF_SCHEMA、SCHEMA_REGISTRY_CONFIGURATION_ERROR、UNABLE_TO_CONVERT_TO_PROTOBUF_MESSAGE_TYPE、UNKNOWN_PROTOBUF_MESSAGE_TYPE
42K0H 检测到循环调用。
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_ZERO、DELTA_ADD_COLUMN_PARENT_NOT_STRUCT、DELTA_ADD_COLUMN_STRUCT_NOT_FOUND
42KD4 操作不受支持，因为表架构已更改。
DELTA_BLOCK_COLUMN_MAPPING_AND_CDC_OPERATION、DELTA_STREAMING_INCOMPATIBLE_SCHEMA_CHANGE、DELTA_STREAMING_INCOMPATIBLE_SCHEMA_CHANGE_USE_SCHEMA_LOG
42KD5 无法创建文件或路径。
DELTA_CANNOT_CREATE_LOG_PATH、PARTITION_LOCATION_IS_NOT_UNDER_TABLE_DIRECTORY
42KD6 找不到分区信息。
DELTA_CONVERSION_NO_PARTITION_FOUND、DELTA_MISSING_PARTITION_COLUMN、DELTA_MISSING_PART_FILES
42KD7 表签名不匹配。
DELTA_CREATE_TABLE_SCHEME_MISMATCH、DELTA_CREATE_TABLE_WITH_DIFFERENT_CLUSTERING、DELTA_CREATE_TABLE_WITH_DIFFERENT_PARTITIONING、DELTA_CREATE_TABLE_WITH_DIFFERENT_PROPERTY、DELTA_SET_LOCATION_SCHEMA_MISMATCH
42KD8 列位置超出范围。
DELTA_DROP_COLUMN_AT_INDEX_LESS_THAN_ZERO、DELTA_INDEX_LARGER_OR_EQUAL_THAN_STRUCT、DELTA_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_LIMIT、DELTA_ARCHIVED_FILES_IN_SCAN
42KDD 流式处理视图中不支持的操作。
UNEXPECTED_OPERATOR_IN_STREAMING_VIEW
42KDE 流式处理数据集上不支持的操作。
CALL_ON_STREAMING_DATASET_UNSUPPORTED、CANNOT_CREATE_DATA_SOURCE_TABLE、INVALID_WRITER_COMMIT_MESSAGE、NON_TIME_WINDOW_NOT_SUPPORTED_IN_STREAMING
42KDF 必需的例程参数缺少参数。
MISSING_PARAMETER_FOR_KAFKA、MISSING_PARAMETER_FOR_ROUTINE、XML_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_EXISTS、TABLE_OR_VIEW_ALREADY_EXISTS、TEMP_TABLE_OR_VIEW_ALREADY_EXISTS、VIEW_ALREADY_EXISTS
42P08 不明确的参数
CATALOG_NOT_FOUND
42P10 列引用无效
DELTA_CLUSTERING_COLUMNS_MISMATCH、DELTA_NON_PARTITION_COLUMN_REFERENCE、DELTA_NON_PARTITION_COLUMN_SPECIFIED、DELTA_SHOW_PARTITION_IN_NON_PARTITIONED_COLUMN、DELTA_ZORDERING_ON_PARTITION_COLUMN
42P18 数据类型不确定
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_OOM、UNABLE_TO_ACQUIRE_MEMORY

类 54：超出程序限制

SQLSTATE 描述和发出错误类
54000 超出程序限制
COLLECTION_SIZE_LIMIT_EXCEEDED、DELTA_CLUSTER_BY_INVALID_NUM_COLUMNS、GROUPING_SIZE_LIMIT_EXCEEDED、RELATION_LARGER_THAN_8G
54001 语句太长或太复杂。
FAILED_TO_PARSE_TOO_COMPLEX
54006 结果字符串太长。
EXCEED_LIMIT_LENGTH、KRYO_BUFFER_OVERFLOW
54023 参数太多
TABLE_VALUED_FUNCTION_TOO_MANY_TABLE_ARGUMENTS
54K00 已超出嵌套视图的最大深度。
VIEW_EXCEED_MAX_NESTED_DEPTH
54KD0 超出了查询计划中的最大 UDF 计数。
UDF_LIMITS、UDF_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_ERROR, ANSI_CONFIG_CANNOT_BE_DISABLED, CF_MANAGED_FILE_EVENTS_ONLY_ON_SERVERLESS, CLUSTER_BY_AUTO_REQUIRES_CLUSTERING_FEATURE_ENABLED, CLUSTER_BY_AUTO_REQUIRES_PREDICTIVE_OPTIMIZATION, CLUSTER_BY_AUTO_UNSUPPORTED_TABLE_TYPE_ERROR, CODEC_NOT_AVAILABLE, COLUMN_MASKS_NOT_ENABLED, DATABRICKS_DELTA_NOT_ENABLED, DELTA_MISSING_ICEBERG_CLASS, DELTA_UNRECOGNIZED_INVARIANT, DELTA_UNSUPPORTED_FEATURES_FOR_READ, DELTA_UNSUPPORTED_FEATURES_FOR_WRITE, DELTA_UNSUPPORTED_FEATURES_IN_CONFIG, DLT_EXPECTATIONS_NOT_SUPPORTED, DLT_VIEW_CLUSTER_BY_NOT_SUPPORTED, DLT_VIEW_LOCATION_NOT_SUPPORTED, DLT_VIEW_SCHEMA_WITH_TYPE_NOT_SUPPORTED, DLT_VIEW_TABLE_CONSTRAINTS_NOT_SUPPORTED, FEATURE_NOT_ENABLED, FEATURE_NOT_ON_CLASSIC_WAREHOUSE, FEATURE_UNAVAILABLE, GET_TABLES_BY_TYPE_UNSUPPORTED_BY_HIVE_VERSION, INCOMPATIBLE_DATASOURCE_REGISTER, MATERIALIZED_VIEW_OPERATION_NOT_ALLOWED, METRIC_STORE_UNSUPPORTED_ERROR, NATIVE_XML_DATA_SOURCE_NOT_ENABLED, STREAMING_TABLE_NOT_SUPPORTED, UC_LAKEHOUSE_FEDERATION_WRITES_NOT_ALLOWED, UC_NOT_ENABLED, UC_QUERY_FEDERATION_NOT_ENABLED, UC_VOLUMES_NOT_ENABLED, UC_VOLUMES_SHARING_NOT_ENABLED, UNSUPPORTED_TIMESERIES_COLUMNS
56098 在隐式重新绑定、重新编译或重新验证期间出错。
UC_INVALID_DEPENDENCIES
56K00 Spark Connect 错误
CONNECT

类 57：操作员干预

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

类 58：系统错误

SQLSTATE 描述和发出错误类
58000 系统错误
CLOUD_PROVIDER_ERROR
58030 I/O 错误
CANNOT_LOAD_STATE_STORE、CANNOT_RESTORE_PERMISSIONS_FOR_PATH、CANNOT_WRITE_STATE_STORE、FAILED_RENAME_TEMP_FILE、INVALID_BUCKET_FILE、TASK_WRITE_FAILED、UNABLE_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_VERSION、DELTA_MISSING_CHANGE_DATA、DELTA_STREAMING_CANNOT_CONTINUE_PROCESSING_POST_SCHEMA_EVOLUTION、DELTA_STREAMING_CHECK_COLUMN_MAPPING_NO_SNAPSHOT
KD003 数据类型的访问权限不正确
CANNOT_READ_ARCHIVED_FILE、CANNOT_READ_FILE、DELTA_FOUND_MAP_TYPE_COLUMN、DELTA_INCORRECT_ARRAY_ACCESS、DELTA_INCORRECT_ARRAY_ACCESS_BY_NAME、UNKNOWN_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_ALLOWED、DELTA_NON_PARTITION_COLUMN_ABSENT
KD006 在日志路径中找不到提交
DELTA_NO_COMMITS_FOUND、DELTA_NO_RECREATABLE_HISTORY_FOUND、STDS_COMMITTED_BATCH_UNAVAILABLE、STDS_NO_PARTITION_DISCOVERED_IN_STATE_STORE、STDS_OFFSET_LOG_UNAVAILABLE、STDS_OFFSET_METADATA_LOG_UNAVAILABLE
KD007 表签名已更改
DELTA_SCHEMA_CHANGED、DELTA_SCHEMA_CHANGED_WITH_STARTING_OPTIONS、DELTA_SCHEMA_CHANGED_WITH_VERSION、DELTA_SCHEMA_CHANGE_SINCE_ANALYSIS、DELTA_TABLE_ID_MISMATCH
KD008 表签名未设置
DELTA_SCHEMA_NOT_SET
KD009 分区不匹配
DELTA_UNEXPECTED_NUM_PARTITION_COLUMNS_FROM_FILE_NAME、DELTA_UNEXPECTED_PARTITION_COLUMN_FROM_FILE_NAME、DELTA_UNEXPECTED_PARTITION_SCHEMA_FROM_USER
KD00A 意外的部分扫描
DELTA_UNEXPECTED_PARTIAL_SCAN
KD00B 无法识别的文件
DELTA_UNRECOGNIZED_LOGFILE、ERROR_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_EXCEPTION、USER_RAISED_EXCEPTION_PARAMETER_MISMATCH、USER_RAISED_EXCEPTION_UNKNOWN_ERROR_CLASS