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_INVALID_RESPONSE_FORMAT_TYPE, AI_FUNCTION_UNSUPPORTED_REQUEST, AI_FUNCTION_UNSUPPORTED_RESPONSE_FORMAT, AI_FUNCTION_UNSUPPORTED_RETURN_TYPE, AI_QUERY_ENDPOINT_NOT_SUPPORT_STRUCTURED_OUTPUT, AI_QUERY_RETURN_TYPE_COLUMN_TYPE_MISMATCH, AI_SEARCH_CONFLICTING_QUERY_PARAM_SUPPLY_ERROR, AI_SEARCH_EMBEDDING_COLUMN_TYPE_UNSUPPORTED_ERROR, AI_SEARCH_EMPTY_QUERY_PARAM_ERROR, AI_SEARCH_HYBRID_QUERY_PARAM_DEPRECATION_ERROR, AI_SEARCH_HYBRID_TEXT_NOT_FOUND_ERROR, AI_SEARCH_INDEX_TYPE_UNSUPPORTED_ERROR, AI_SEARCH_MISSING_EMBEDDING_INPUT_ERROR, AI_SEARCH_QUERY_TYPE_CONVERT_ENCODE_ERROR, AI_SEARCH_QUERY_TYPE_UNSUPPORTED_ERROR, AI_SEARCH_UNSUPPORTED_NUM_RESULTS_ERROR, ANALYZE_CONSTRAINTS_NOT_SUPPORTED, AVRO_DEFAULT_VALUES_UNSUPPORTED, AVRO_POSITIONAL_FIELD_MATCHING_UNSUPPORTED, CANNOT_INVOKE_IN_TRANSFORMATIONS, CANNOT_UPDATE_FIELD, CF_ADD_NEW_NOT_SUPPORTED, CF_EVENT_NOTIFICATION_NOT_SUPPORTED, CF_PERIODIC_BACKFILL_NOT_SUPPORTED, CF_SFTP_NOT_ENABLED, CF_SFTP_REQUIRE_UC_CLUSTER, CF_SOURCE_UNSUPPORTED, 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, CLUSTER_BY_AUTO_FEATURE_NOT_ENABLED, COLUMN_ARRAY_ELEMENT_TYPE_MISMATCH, COLUMN_MASKS_ABAC_MISMATCH, 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_SHOW_PARTITIONS_UNSUPPORTED, 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, COPY_INTO_UNSUPPORTED_FEATURE, CREATE_OR_REFRESH_MV_ST_ASYNC, CREATE_PERMANENT_VIEW_WITHOUT_ALIAS, CSV_ENFORCE_SCHEMA_NOT_SUPPORTED, DC_UNSUPPORTED_ERROR, DELTA_ADDING_DELETION_VECTORS_DISALLOWED, DELTA_ADD_CONSTRAINTS, DELTA_CANNOT_WRITE_INTO_VIEW, DELTA_CLUSTERING_CLONE_TABLE_NOT_SUPPORTED, DELTA_CLUSTERING_COLUMNS_DATATYPE_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_UNIFORM_INGRESS_NOT_SUPPORTED, 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, DESCRIBE_JSON_NOT_EXTENDED, DISTINCT_WINDOW_FUNCTION_UNSUPPORTED, EMPTY_SCHEMA_NOT_SUPPORTED_FOR_DATASOURCE, EXTERNAL_TABLE_INVALID_SCHEME, FABRIC_REFRESH_INVALID_SCOPE, FORBIDDEN_DATASOURCE_IN_SERVERLESS, FROM_JSON_INFERENCE_NOT_SUPPORTED, H3_NOT_ENABLED, HYBRID_ANALYZER_EXCEPTION, INFINITE_STREAMING_TRIGGER_NOT_SUPPORTED, INVALID_PANDAS_UDF_PLACEMENT, INVALID_PARTITION_COLUMN_DATA_TYPE, KINESIS_POLLING_MODE_UNSUPPORTED, MATERIALIZED_VIEW_OUTPUT_WITHOUT_EXPLICIT_ALIAS, MATERIALIZED_VIEW_UNSUPPORTED_OPERATION, METRIC_CONSTRAINT_NOT_SUPPORTED, MOVE_TABLE_BETWEEN_PIPELINES_FEATURE_DISABLED, 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, NOT_SUPPORTED_WITH_SERVERLESS, ONLY_SUPPORTED_WITH_UC_SQL_CONNECTOR, PIPE_OPERATOR_AGGREGATE_EXPRESSION_CONTAINS_NO_AGGREGATE_FUNCTION, PIPE_OPERATOR_CONTAINS_AGGREGATE_FUNCTION, PROCEDURE_CREATION_EMPTY_ROUTINE, PROCEDURE_NOT_SUPPORTED, PROCEDURE_NOT_SUPPORTED_WITH_HMS, PROTOBUF_JAVA_CLASSES_NOT_SUPPORTED, PS_SPARK_SPECULATION_NOT_SUPPORTED, PS_UNSUPPORTED_GET_OFFSET_CALL, RECIPIENT_EXPIRATION_NOT_SUPPORTED, RESTRICTED_STREAMING_OPTION_PERMISSION_ENFORCED, ROW_LEVEL_SECURITY_ABAC_MISMATCH, 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_SHOW_PARTITIONS_UNSUPPORTED, ROW_LEVEL_SECURITY_TABLE_CLONE_SOURCE_NOT_SUPPORTED, ROW_LEVEL_SECURITY_TABLE_CLONE_TARGET_NOT_SUPPORTED, ROW_LEVEL_SECURITY_UNSUPPORTED_PROVIDER, SAAS_CONNECTOR_UNSUPPORTED_ERROR, SCALAR_SUBQUERY_IS_IN_GROUP_BY_OR_AGGREGATE_FUNCTION, SET_TBLPROPERTIES_NOT_ALLOWED_FOR_DLT_DATASET, STAR_GROUP_BY_POS, STREAMING_AQE_NOT_SUPPORTED_FOR_STATEFUL_OPERATORS, STREAMING_FROM_MATERIALIZED_VIEW, STREAMING_REAL_TIME_MODE, ST_NOT_ENABLED, ST_UNSUPPORTED_RETURN_TYPE, TABLE_VALUED_ARGUMENTS_NOT_YET_IMPLEMENTED_FOR_SQL_FUNCTIONS, TRIGGER_SOURCE_TYPE_NOT_SUPPORTED, UC_HIVE_METASTORE_FEDERATION_NOT_ENABLED, UDF_PYSPARK_UNSUPPORTED_TYPE, UDF_UNSUPPORTED_PARAMETER_DEFAULT_VALUE, UNSTRUCTURED_DATA_PROCESSING_UNSUPPORTED_FILE_FORMAT, UNSTRUCTURED_DATA_PROCESSING_UNSUPPORTED_MODEL, UNSUPPORTED_ADD_FILE, UNSUPPORTED_ALTER_COLUMN_PARAMETER, UNSUPPORTED_ARROWTYPE, UNSUPPORTED_CALL, UNSUPPORTED_CHAR_OR_VARCHAR_AS_STRING, UNSUPPORTED_CLAUSE_FOR_OPERATION, UNSUPPORTED_COLLATION, UNSUPPORTED_CONSTRAINT_CLAUSES, UNSUPPORTED_DATASOURCE_FOR_DIRECT_QUERY, UNSUPPORTED_DATATYPE, UNSUPPORTED_DATA_SOURCE_SAVE_MODE, UNSUPPORTED_DATA_TYPE_FOR_DATASOURCE, UNSUPPORTED_DATA_TYPE_FOR_ENCODER, UNSUPPORTED_DEFAULT_VALUE, UNSUPPORTED_DESERIALIZER, UNSUPPORTED_FEATURE, UNSUPPORTED_FEATURE_FOR_WORKSPACE, UNSUPPORTED_FN_TYPE, UNSUPPORTED_JOIN_TYPE, UNSUPPORTED_LANGUAGE, UNSUPPORTED_NESTED_ROW_OR_COLUMN_ACCESS_POLICY, UNSUPPORTED_PARTITION_TRANSFORM, UNSUPPORTED_SAVE_MODE, UNSUPPORTED_SHOW_CREATE_TABLE, UNSUPPORTED_SINGLE_PASS_ANALYZER_FEATURE, UNSUPPORTED_STREAMING_OPERATOR_WITHOUT_WATERMARK, 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, UNSUPPORTED_UDF_FEATURE, UNSUPPORTED_UDF_TYPES_IN_SAME_PLACE
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_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_MERGE_ON_READ_NOT_SUPPORTED, DELTA_CONVERSION_UNSUPPORTED_COLLATED_PARTITION_COLUMN, DELTA_CONVERSION_UNSUPPORTED_COLUMN_MAPPING, DELTA_CONVERSION_UNSUPPORTED_SCHEMA_CHANGE, DELTA_CONVERT_NON_PARQUET_TABLE, DELTA_CREATE_TABLE_IDENTIFIER_LOCATION_MISMATCH, DELTA_DROP_COLUMN_ON_SINGLE_FIELD_SCHEMA, DELTA_GEOSPATIAL_NOT_SUPPORTED, 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_COMPATIBILITY_LOCATION_CANNOT_BE_CHANGED, DELTA_UNIFORM_INGRESS_NOT_SUPPORTED_FORMAT, DELTA_UNIFORM_NOT_SUPPORTED, DELTA_UNIFORM_REFRESH_NOT_SUPPORTED, DELTA_UNIFORM_REFRESH_NOT_SUPPORTED_FOR_MANAGED_ICEBERG_TABLE_WITH_METADATA_PATH, 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_OPERATIONS_ON_COLUMNS_WITH_BLOOM_FILTER_INDEX, 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_TYPE_CHANGE_ON_COLUMNS_WITH_BLOOM_FILTER_INDEX, DELTA_UNSUPPORTED_VACUUM_SPECIFIC_PARTITION, DELTA_UNSUPPORTED_WRITES_WITHOUT_COORDINATOR, WRONG_COLUMN_DEFAULTS_FOR_DELTA_ALTER_TABLE_ADD_COLUMN_NOT_SUPPORTED
0AKDD 功能需要 Delta
DELTA_COPY_INTO_TARGET_FORMATDELTA_IDENTITY_COLUMNS_ALTER_NON_DELTA_FORMATDELTA_IDENTITY_COLUMNS_NON_DELTA_FORMATDELTA_NOT_A_DELTA_TABLEDELTA_ONLY_OPERATIONDELTA_TABLE_ONLY_OPERATIONDELTA_UNSUPPORTED_SOURCEDELTA_UNSUPPORTED_STATIC_PARTITIONSSYNC_METADATA_DELTA_ONLYUNSUPPORTED_MANAGED_TABLE_CREATION
0AKDE 未为此 Delta 表启用功能
DELTA_CANNOT_DROP_CHECK_CONSTRAINT_FEATUREDELTA_CANNOT_DROP_COLLATIONS_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_SERVERLESSUC_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_CATALOG

0B:无效的事务启动

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

0N:SQL/XML 映射错误

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

21:基数冲突

SQLSTATE 描述和发出错误类
21000 基数冲突
BOOLEAN_STATEMENT_WITH_EMPTY_ROWROW_SUBQUERY_TOO_MANY_ROWSSCALAR_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, DELTA_VACUUM_COPY_INTO_STATE_FAILED, HLL_UNION_DIFFERENT_LG_K, INVALID_TIMESTAMP_FORMAT, KAFKA_DATA_LOSS, KINESIS_COULD_NOT_READ_SHARD_UNTIL_END_OFFSET, KINESIS_RECORD_SEQ_NUMBER_ORDER_VIOLATION, MALFORMED_CHARACTER_CODING, PS_FETCH_RETRY_EXCEPTION, PS_INVALID_KEY_TYPE, PS_INVALID_UNSAFE_ROW_CONVERSION_FROM_PROTO, PS_MOVING_CHECKPOINT_FAILURE, PS_MULTIPLE_FAILED_EPOCHS, PS_OPTION_NOT_IN_BOUNDS, PS_UNABLE_TO_PARSE_PROTO, STAGING_PATH_CURRENTLY_INACCESSIBLE
22001 字符串数据,右截断
DELTA_EXCEED_CHAR_VARCHAR_LIMIT
22003 数值超出范围
ARITHMETIC_OVERFLOWBINARY_ARITHMETIC_OVERFLOWCAST_OVERFLOWCAST_OVERFLOW_IN_TABLE_INSERTCOLUMN_ORDINAL_OUT_OF_BOUNDSDECIMAL_PRECISION_EXCEEDS_MAX_PRECISIONDELTA_CANNOT_RESTORE_TABLE_VERSIONDELTA_CANNOT_RESTORE_TIMESTAMP_EARLIERDELTA_CANNOT_RESTORE_TIMESTAMP_GREATERDELTA_CAST_OVERFLOW_IN_TABLE_WRITEDELTA_INVALID_CDC_RANGEINCORRECT_RAMP_UP_RATEINVALID_ARRAY_INDEXINVALID_ARRAY_INDEX_IN_ELEMENT_ATINVALID_BITMAP_POSITIONINVALID_BOUNDARYINVALID_INDEX_OF_ZEROINVALID_NUMERIC_LITERAL_RANGENEGATIVE_VALUES_IN_FREQUENCY_EXPRESSIONNUMERIC_OUT_OF_SUPPORTED_RANGENUMERIC_VALUE_OUT_OF_RANGESCHEDULE_PERIOD_INVALIDSUM_OF_LIMIT_AND_OFFSET_EXCEEDS_MAX_INTTRIGGER_INTERVAL_INVALIDTRIGGER_INTERVAL_VALUE_INVALID
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_INTERVALDELTA_INVALID_INTERVALINVALID_INTERVAL_FORMATINVALID_INTERVAL_WITH_MICROSECONDS_ADDITION
22007 无效的日期/时间格式
CANNOT_PARSE_TIMESTAMP, DELTA_INVALID_TIMESTAMP_FORMAT, INVALID_DATETIME_PATTERN
22008 日期/时间字段溢出
DATETIME_OVERFLOW
22009 无效时区置换值
ILLEGAL_DAY_OF_WEEKINVALID_TIMEZONE
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 无效的参数值
AI_FUNCTION_INVALID_MODEL_PARAMETERSCONFLICTING_PROVIDERDATETIME_FIELD_OUT_OF_BOUNDSDELTA_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_HTTP_REQUEST_METHODINVALID_HTTP_REQUEST_PATHINVALID_JSON_RECORD_TYPEINVALID_PARAMETER_MARKER_VALUEINVALID_PARAMETER_VALUEINVALID_REGEXP_REPLACEINVALID_VARIANT_CASTINVALID_VARIANT_FROM_PARQUETINVALID_VARIANT_GET_PATHINVALID_VARIANT_SHREDDING_SCHEMAKINESIS_SOURCE_REGISTERED_CONSUMER_ID_COUNT_MISMATCHKINESIS_SOURCE_REGISTERED_CONSUMER_NOT_FOUNDKINESIS_SOURCE_REGISTERED_CONSUMER_TYPE_INVALIDMALFORMED_RECORD_IN_PARSINGMALFORMED_VARIANTMAX_RECORDS_PER_FETCH_INVALID_FOR_KINESIS_SOURCEMETRIC_STORE_INVALID_ARGUMENT_VALUE_ERRORROW_VALUE_IS_NULLRULE_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_INDEX_VALUEST_INVALID_PRECISION_VALUEST_INVALID_SRID_VALUETABLE_VALUED_FUNCTION_REQUIRED_METADATA_INCOMPATIBLE_WITH_CALLTABLE_VALUED_FUNCTION_REQUIRED_METADATA_INVALIDUNKNOWN_PRIMITIVE_TYPE_IN_VARIANTVARIANT_CONSTRUCTOR_SIZE_LIMITVARIANT_DUPLICATE_KEYVARIANT_SIZE_LIMITWKB_PARSE_ERRORWKT_PARSE_ERRORXML_WILDCARD_RESCUED_DATA_CONFLICT_ERROR
22024 未终止的 C 字符串
NULL_DATA_SOURCE_OPTION
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_KINVALID_BOOLEAN_STATEMENT
22KD0 暂时性错误
DELTA_FEATURE_DROP_CHECKPOINT_FAILEDDELTA_FEATURE_DROP_CHECKPOINT_PROTECTION_WAIT_FOR_RETENTION_PERIOD
22KD1 无效的 URI 或路径
DELTA_CANNOT_RECONSTRUCT_PATH_FROM_URIDELTA_CANNOT_RENAME_PATHDELTA_INVALID_CLONE_PATHDELTA_INVALID_PARTITION_PATHINVALID_NON_ABSOLUTE_PATH
22KD2 未设置标识声明
OAUTH_CUSTOM_IDENTITY_CLAIM_NOT_PROVIDED
22KD3 无法将源类型演化为目标类型。
AVRO_INCOMPATIBLE_READ_TYPECANNOT_USE_KRYOFROM_JSON_SCHEMA_EVOLUTION_FAILEDPROTOBUF_NOT_LOADED_SQL_FUNCTIONS_UNUSABLE
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

28:授权规范无效

SQLSTATE 描述和发出错误类
28000 授权规范无效
DELTA_SHARING_INVALID_PROVIDER_AUTHDELTA_SHARING_INVALID_RECIPIENT_AUTH

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_METHODFAILED_FUNCTION_CALLFAILED_TO_LOAD_ROUTINEINVALID_UDF_IMPLEMENTATIONNO_UDF_INTERFACEPYTHON_DATA_SOURCE_ERRORPYTHON_STREAMING_DATA_SOURCE_RUNTIME_ERRORTABLE_VALUED_FUNCTION_FAILED_TO_ANALYZE_IN_PYTHON

39:外部例程调用异常

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

3D:无效的目录名称

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

3F:架构名称无效

SQLSTATE 描述和发出错误类
3F000 无效的架构名称
MISSING_DATABASE_FOR_V1_SESSION_CATALOG

40:事务回滚

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

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

SQLSTATE 描述和发出错误类
42000 语法错误或访问规则冲突
AMBIGUOUS_REFERENCE_TO_FIELDS, CANNOT_REMOVE_RESERVED_PROPERTY, CF_AMBIGUOUS_AUTH_OPTIONS_ERROR, CF_AMBIGUOUS_INCREMENTAL_LISTING_MODE_ERROR, CF_AZURE_AUTHENTICATION_MISSING_OPTIONS, CF_AZURE_AUTHENTICATION_MULTIPLE_OPTIONS, CF_AZURE_STORAGE_SUFFIXES_REQUIRED, CF_CLEAN_SOURCE_ALLOW_OVERWRITES_BOTH_ON, CF_EMPTY_DIR_FOR_SCHEMA_INFERENCE, CF_FAILED_TO_FIND_PROVIDER, CF_FILE_FORMAT_REQUIRED, CF_GCP_AUTHENTICATION, CF_INCORRECT_SQL_PARAMS, CF_INTERNAL_ERROR, CF_INVALID_ARN, CF_INVALID_AZURE_CERTIFICATE, CF_INVALID_AZURE_CERT_PRIVATE_KEY, CF_INVALID_CHECKPOINT, CF_INVALID_CLEAN_SOURCE_MODE, CF_INVALID_GCP_RESOURCE_TAG_KEY, CF_INVALID_GCP_RESOURCE_TAG_VALUE, CF_INVALID_MANAGED_FILE_EVENTS_OPTION_KEYS, CF_INVALID_SCHEMA_EVOLUTION_MODE, CF_INVALID_SCHEMA_HINTS_OPTION, CF_INVALID_SCHEMA_HINT_COLUMN, CF_MANAGED_FILE_EVENTS_ENDPOINT_NOT_FOUND, CF_MANAGED_FILE_EVENTS_ENDPOINT_PERMISSION_DENIED, CF_MAX_MUST_BE_POSITIVE, CF_MISSING_METADATA_FILE_ERROR, CF_MISSING_PARTITION_COLUMN_ERROR, CF_MISSING_SCHEMA_IN_PATHLESS_MODE, CF_PATH_DOES_NOT_EXIST_FOR_READ_FILES, CF_REGION_NOT_FOUND_ERROR, CF_RESOURCE_SUFFIX_EMPTY, CF_RESOURCE_SUFFIX_INVALID_CHAR_AWS, CF_RESOURCE_SUFFIX_INVALID_CHAR_AZURE, CF_RESOURCE_SUFFIX_INVALID_CHAR_GCP, CF_RESOURCE_SUFFIX_LIMIT, CF_RESOURCE_SUFFIX_LIMIT_GCP, CF_RETENTION_GREATER_THAN_MAX_FILE_AGE, CF_SCHEMA_LOG_DEEP_CLONE_FAILED, CF_SFTP_MISSING_PASSWORD_OR_KEY_FILE, CF_SFTP_USERNAME_NOT_FOUND, 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, CLUSTERING_NOT_SUPPORTED, COMMENT_ON_CONNECTION_NOT_IMPLEMENTED_YET, CONNECTION_ALREADY_EXISTS, CONNECTION_NAME_CANNOT_BE_EMPTY, CONNECTION_NOT_FOUND, CONNECTION_OPTION_NOT_SUPPORTED, CONNECTION_TYPE_NOT_SUPPORTED, COPY_UNLOAD_FORMAT_TYPE_NOT_SUPPORTED, CREATE_FOREIGN_SCHEMA_NOT_IMPLEMENTED_YET, CREATE_FOREIGN_TABLE_NOT_IMPLEMENTED_YET, DELTA_ADDING_COLUMN_WITH_INTERNAL_NAME_FAILED, DELTA_ADDING_DELETION_VECTORS_WITH_TIGHT_BOUNDS_DISALLOWED, DELTA_ALTER_TABLE_CLUSTER_BY_NOT_ALLOWED, DELTA_ALTER_TABLE_CLUSTER_BY_ON_PARTITIONED_TABLE_NOT_ALLOWED, DELTA_ALTER_TABLE_RENAME_NOT_ALLOWED, DELTA_ALTER_TABLE_SET_CLUSTERING_TABLE_FEATURE_NOT_ALLOWED, DELTA_CANNOT_RELATIVIZE_PATH, DELTA_CLONE_INCOMPLETE_FILE_COPY, DELTA_CLUSTERING_NOT_SUPPORTED, DELTA_CLUSTERING_REPLACE_TABLE_WITH_PARTITIONED_TABLE, DELTA_CLUSTERING_TO_PARTITIONED_TABLE_WITH_NON_EMPTY_CLUSTERING_COLUMNS, DELTA_CLUSTERING_WITH_DYNAMIC_PARTITION_OVERWRITE, DELTA_CREATE_TABLE_SET_CLUSTERING_TABLE_FEATURE_NOT_ALLOWED, DELTA_INCONSISTENT_BUCKET_SPEC, DELTA_INCORRECT_GET_CONF, DELTA_INVALID_INVENTORY_SCHEMA, DELTA_INVALID_MANAGED_TABLE_SYNTAX_NO_SCHEMA, DELTA_MAX_ARRAY_SIZE_EXCEEDED, DELTA_MAX_LIST_FILE_EXCEEDED, DELTA_MISSING_TRANSACTION_LOG, DELTA_NAME_CONFLICT_IN_BUCKETED_TABLE, DELTA_NOT_A_DATABRICKS_DELTA_TABLE, DELTA_OVERWRITE_MUST_BE_TRUE, DELTA_STATS_COLLECTION_COLUMN_NOT_FOUND, DROP_SCHEDULE_DOES_NOT_EXIST, DROP_SCHEDULE_SCHEDULE_DOES_NOT_EXIST, FOREIGN_OBJECT_NAME_CANNOT_BE_EMPTY, INVALID_AWS_AUTHENTICATION, INVALID_AWS_AUTHENTICATION_EXPLICIT_OPTIONS, INVALID_COLUMN_OR_FIELD_DATA_TYPE, INVALID_EXTRACT_BASE_FIELD_TYPE, INVALID_EXTRACT_FIELD_TYPE, INVALID_FIELD_NAME, INVALID_INLINE_TABLE, INVALID_QUALIFIED_COLUMN_NAME, INVALID_RESET_COMMAND_FORMAT, INVALID_SAVE_MODE, INVALID_SET_SYNTAX, INVALID_SQL_SYNTAX, INVALID_USAGE_OF_STAR_OR_REGEX, INVALID_WRITE_DISTRIBUTION, MATERIALIZED_VIEW_OVER_STREAMING_QUERY_INVALID, MISSING_CONNECTION_OPTION, MISSING_NAME_FOR_CHECK_CONSTRAINT, MISSING_SCHEDULE_DEFINITION, MOVE_TABLE_BETWEEN_PIPELINES_DESTINATION_PIPELINE_NOT_FOUND, MOVE_TABLE_BETWEEN_PIPELINES_DESTINATION_PIPELINE_PERMISSION_DENIED, MOVE_TABLE_BETWEEN_PIPELINES_SOURCE_PIPELINE_NOT_FOUND, MOVE_TABLE_BETWEEN_PIPELINES_SOURCE_PIPELINE_PERMISSION_DENIED, MULTIPLE_LOAD_PATH, MULTIPLE_QUERY_RESULT_CLAUSES_WITH_PIPE_OPERATORS, NAMESPACE_ALREADY_EXISTS, NAMESPACE_NOT_EMPTY, NAMESPACE_NOT_FOUND, NON_PARTITION_COLUMN, NOTEBOOK_NOT_FOUND, NOT_NULL_ASSERT_VIOLATION, NOT_NULL_CONSTRAINT_VIOLATION, NO_HANDLER_FOR_UDAF, NULLABLE_COLUMN_OR_FIELD, NULLABLE_ROW_ID_ATTRIBUTES, PARTITION_COLUMN_NOT_FOUND_IN_SCHEMA, PS_INVALID_EMPTY_OPTION, PS_INVALID_OPTION, PS_INVALID_OPTION_TYPE, PS_INVALID_READ_LIMIT, PS_MISSING_AUTH_INFO, PS_MISSING_REQUIRED_OPTION, PS_MULTIPLE_AUTH_OPTIONS, PS_PROVIDE_CREDENTIALS_WITH_OPTION, PS_UNABLE_TO_CREATE_SUBSCRIPTION, ROUTINE_PARAMETER_NOT_FOUND, STREAMING_TABLE_QUERY_INVALID, UNSTRUCTURED_OCR_COLUMN_NOT_ALLOWED_WITH_METADATA_MODEL_OPTION, UNSUPPORTED_BATCH_TABLE_VALUED_FUNCTION, UNSUPPORTED_CONSTRAINT_TYPE, UNSUPPORTED_STREAMING_TABLE_VALUED_FUNCTION, VOLUME_ALREADY_EXISTS
42001 编码器错误无效
INVALID_EXPRESSION_ENCODER
42501 授权 ID 无权对标识的对象执行指定的操作。
CANNOT_READ_SENSITIVE_KEY_FROM_SECURE_PROVIDERCF_CLEAN_SOURCE_UNAUTHORIZED_WRITE_PERMISSIONCLUSTER_CREATION_PERMISSION_DENIEDCLUSTER_POLICY_PERMISSION_DENIEDINSUFFICIENT_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_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_IDENTITY_COLUMNS_PARTITION_NOT_SUPPORTED, 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_OPTIMIZE_FULL_NOT_SUPPORTED, DELTA_UNEXPECTED_ACTION_EXPRESSION, DELTA_UNIFORM_COMPATIBILITY_MISSING_OR_INVALID_LOCATION, 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, IDENTITY_COLUMNS_DUPLICATED_SEQUENCE_GENERATOR_OPTION, ILLEGAL_STATE_STORE_VALUE, INVALID_ATTRIBUTE_NAME_SYNTAX, 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, MERGE_WITHOUT_WHEN, MIGRATION_NOT_SUPPORTED, MISSING_CLAUSES_FOR_OPERATION, MV_ST_ALTER_QUERY_INCORRECT_BACKING_TYPE, NOT_ALLOWED_IN_FROM, NOT_ALLOWED_IN_PIPE_OPERATOR_WHERE, NOT_A_CONSTANT_STRING, NOT_UNRESOLVED_ENCODER, PARSE_MODE_UNSUPPORTED, 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, TRAILING_COMMA_IN_SELECT, 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 已检测到名称中无效的字符。
CIRCULAR_CLASS_REFERENCEDATA_SOURCE_OPTION_CONTAINS_INVALID_CHARACTERSDUPLICATED_CTE_NAMESINVALID_DELIMITER_VALUEINVALID_IDENTIFIERINVALID_PROPERTY_KEYINVALID_PROPERTY_VALUEINVALID_SCHEMA_OR_RELATION_NAME
42604 检测到无效的数字或字符串常数。
AS_OF_JOINDELTA_TIME_TRAVEL_INVALID_BEGIN_VALUEEMPTY_JSON_FIELD_VALUEINVALID_ESCINVALID_ESCAPE_CHARINVALID_PIPELINE_IDINVALID_STAGING_PATH_IN_STAGING_ACCESS_QUERYINVALID_TYPED_LITERALINVALID_UUID
42605 为标量函数指定的参数数目无效。
INCORRECT_NUMBER_OF_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_STEPIDENTITY_COLUMNS_ILLEGAL_STEP
42613 子句互斥。
COPY_INTO_FEATURE_INCOMPATIBLE_SETTINGDELTA_AMBIGUOUS_PATHS_IN_CREATE_TABLEDELTA_CANNOT_SET_LOCATION_ON_PATH_IDENTIFIERDELTA_CLONE_AMBIGUOUS_TARGETDELTA_CLUSTERING_WITH_ZORDER_BYDELTA_CLUSTER_BY_WITH_BUCKETINGDELTA_CLUSTER_BY_WITH_PARTITIONED_BYDELTA_FILE_LIST_AND_PATTERN_STRING_CONFLICTDELTA_IDENTITY_COLUMNS_WITH_GENERATED_EXPRESSIONDELTA_OVERWRITE_SCHEMA_WITH_DYNAMIC_PARTITION_OVERWRITEDELTA_PARTITION_SCHEMA_IN_ICEBERG_TABLESDELTA_REPLACE_WHERE_IN_OVERWRITEDELTA_REPLACE_WHERE_WITH_DYNAMIC_PARTITION_OVERWRITEDELTA_REPLACE_WHERE_WITH_FILTER_DATA_CHANGE_UNSETDELTA_STARTING_VERSION_AND_TIMESTAMP_BOTH_SETDELTA_TABLE_LOCATION_MISMATCHDELTA_UNSUPPORTED_TIME_TRAVEL_MULTIPLE_FORMATSINCOMPATIBLE_JOIN_TYPESINVALID_JOIN_TYPE_FOR_JOINWITHINVALID_LATERAL_JOIN_TYPEINVALID_QUERY_MIXED_QUERY_PARAMETERSINVALID_SINGLE_VARIANT_COLUMNMANAGED_TABLE_WITH_CREDMUTUALLY_EXCLUSIVE_CLAUSESNON_LAST_MATCHED_CLAUSE_OMIT_CONDITIONNON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITIONNON_LAST_NOT_MATCHED_BY_TARGET_CLAUSE_OMIT_CONDITIONSTDS_CONFLICT_OPTIONS
42614 重复的关键字或子句无效。
DELTA_MULTIPLE_CDC_BOUNDARYDELTA_MULTIPLE_CONF_FOR_SINGLE_COLUMN_IN_BLOOM_FILTERDUPLICATE_CLAUSESREPEATED_CLAUSE
42616 指定的选项无效
BIGQUERY_OPTIONS_ARE_MUTUALLY_EXCLUSIVEDELTA_CANNOT_MODIFY_COORDINATED_COMMITS_DEPENDENCIESDELTA_CANNOT_OVERRIDE_COORDINATED_COMMITS_CONFSDELTA_CANNOT_SET_COORDINATED_COMMITS_DEPENDENCIESDELTA_CANNOT_SET_MANAGED_STATS_COLUMNS_PROPERTYDELTA_CANNOT_SET_UC_COMMIT_COORDINATOR_CONF_IN_COMMANDDELTA_CANNOT_SET_UC_COMMIT_COORDINATOR_CONF_IN_SESSIONDELTA_CANNOT_UNSET_COORDINATED_COMMITS_CONFSDELTA_CONF_OVERRIDE_NOT_SUPPORTED_IN_COMMANDDELTA_CONF_OVERRIDE_NOT_SUPPORTED_IN_SESSIONDELTA_ILLEGAL_OPTIONDELTA_INVALID_IDEMPOTENT_WRITES_OPTIONSDELTA_MUST_SET_ALL_COORDINATED_COMMITS_CONFS_IN_COMMANDDELTA_MUST_SET_ALL_COORDINATED_COMMITS_CONFS_IN_SESSIONDELTA_NON_UC_COMMIT_COORDINATOR_NOT_SUPPORTED_IN_COMMANDDELTA_NON_UC_COMMIT_COORDINATOR_NOT_SUPPORTED_IN_SESSIONDELTA_UNSET_NON_EXISTENT_PROPERTYINAPPROPRIATE_URI_SCHEME_OF_CONNECTION_OPTIONSTDS_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 子句。
ADD_DEFAULT_UNSUPPORTEDDEFAULT_UNSUPPORTEDGENERATED_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 检测到未定义的对象或限制名称。
ALTER_SCHEDULE_DOES_NOT_EXISTALTER_SCHEDULE_SCHEDULE_DOES_NOT_EXISTAMBIGUOUS_REFERENCECANNOT_RESOLVE_DATAFRAME_COLUMNCANNOT_RESOLVE_STAR_EXPANDCODEC_SHORT_NAME_NOT_FOUNDCOLLATION_INVALID_NAMECOLLATION_INVALID_PROVIDERDATA_SOURCE_NOT_EXISTDEFAULT_DATABASE_NOT_EXISTSDELTA_COLUMN_PATH_NOT_NESTEDDELTA_CONSTRAINT_DOES_NOT_EXISTDELTA_SHARING_CURRENT_RECIPIENT_PROPERTY_UNDEFINEDDELTA_SHARING_RECIPIENT_PROPERTY_NOT_FOUNDDELTA_SHARING_RECIPIENT_TOKENS_NOT_FOUNDENCODER_NOT_FOUNDFIELD_NOT_FOUNDINDEX_NOT_FOUNDNO_SUCH_CATALOG_EXCEPTIONSCHEMA_NOT_FOUNDUC_VOLUME_NOT_FOUNDUNRECOGNIZED_SQL_TYPEUNRECOGNIZED_STATISTIC
42710 检测到重复的对象或约束名称。
ALTER_TABLE_COLUMN_DESCRIPTOR_DUPLICATECREATE_TABLE_COLUMN_DESCRIPTOR_DUPLICATEDATA_SOURCE_ALREADY_EXISTSDELTA_CONSTRAINT_ALREADY_EXISTSDUPLICATED_METRICS_NAMEFIELD_ALREADY_EXISTSFOUND_MULTIPLE_DATA_SOURCESINDEX_ALREADY_EXISTSLOCATION_ALREADY_EXISTSMULTIPLE_XML_DATA_SOURCEREFRESH_MODE_ALREADY_EXISTSSCHEDULE_ALREADY_EXISTS
42711 对象定义或 ALTER TABLE 语句中检测到重复的列名。
COLUMN_ALREADY_EXISTSCONFLICTING_COLUMN_NAMES_ERRORDELTA_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_NAMECOLUMN_MASKS_USING_COLUMN_NAME_SAME_AS_TARGET_COLUMNDUPLICATE_ROUTINE_PARAMETER_NAMESROW_LEVEL_SECURITY_DUPLICATE_COLUMN_NAME
4274K 调用例程时使用的命名参数无效。
DUPLICATE_ROUTINE_PARAMETER_ASSIGNMENTNAMED_PARAMETERS_NOT_SUPPORTEDREAD_FILES_AMBIGUOUS_ROUTINE_PARAMETERSREAD_TVF_UNEXPECTED_REQUIRED_PARAMETERREQUIRED_PARAMETER_ALREADY_PROVIDED_POSITIONALLYREQUIRED_PARAMETER_NOT_FOUNDRESCUED_DATA_COLUMN_CONFLICT_WITH_SINGLE_VARIANTUNEXPECTED_POSITIONAL_ARGUMENTUNKNOWN_POSITIONAL_ARGUMENTUNRECOGNIZED_PARAMETER_NAME
42802 目标值的数目与源值的数目不同。
ASSIGNMENT_ARITY_MISMATCHDELTA_INSERT_COLUMN_ARITY_MISMATCHDELTA_INSERT_COLUMN_MISMATCHSTATEFUL_PROCESSOR_CANNOT_PERFORM_OPERATION_WITH_INVALID_HANDLE_STATESTATEFUL_PROCESSOR_CANNOT_PERFORM_OPERATION_WITH_INVALID_TIME_MODESTATEFUL_PROCESSOR_DUPLICATE_STATE_VARIABLE_DEFINEDSTATEFUL_PROCESSOR_INCORRECT_TIME_MODE_TO_ASSIGN_TTLSTATEFUL_PROCESSOR_TTL_DURATION_MUST_BE_POSITIVESTATEFUL_PROCESSOR_UNKNOWN_TIME_MODESTATE_STORE_CANNOT_CREATE_COLUMN_FAMILY_WITH_RESERVED_CHARSSTATE_STORE_CANNOT_USE_COLUMN_FAMILY_WITH_INVALID_NAMESTATE_STORE_COLUMN_FAMILY_SCHEMA_INCOMPATIBLESTATE_STORE_HANDLE_NOT_INITIALIZEDSTATE_STORE_INCORRECT_NUM_ORDERING_COLS_FOR_RANGE_SCANSTATE_STORE_INCORRECT_NUM_PREFIX_COLS_FOR_PREFIX_SCANSTATE_STORE_NULL_TYPE_ORDERING_COLS_NOT_SUPPORTEDSTATE_STORE_UNSUPPORTED_OPERATION_ON_MISSING_COLUMN_FAMILYSTATE_STORE_VARIABLE_SIZE_ORDERING_COLS_NOT_SUPPORTEDUDTF_ALIAS_NUMBER_MISMATCHUDTF_INVALID_ALIAS_IN_REQUESTED_ORDERING_STRING_FROM_ANALYZE_METHODUDTF_INVALID_REQUESTED_SELECTED_EXPRESSION_FROM_ANALYZE_METHOD_REQUIRES_ALIAS
42803 SELECT 或 HAVING 子句中的列引用无效,因为它不是分组列;或 GROUP BY 子句中的列引用无效。
GROUPING_COLUMN_MISMATCHGROUPING_ID_COLUMN_MISMATCHMISSING_AGGREGATIONMISSING_GROUP_BYUNRESOLVED_ALL_IN_GROUP_BY
42804 CASE 表达式中的结果表达式不兼容。
INVALID_CORRUPT_RECORD_TYPE
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
42808 在 INSERT 或 UPDATE 操作中标识的列不可更新。
DELTA_IDENTITY_COLUMNS_EXPLICIT_INSERT_NOT_SUPPORTEDDELTA_IDENTITY_COLUMNS_UPDATE_NOT_SUPPORTED
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_TARGET_FOR_ALTER_COMMANDINVALID_TARGET_FOR_SET_TBLPROPERTIES_COMMANDINVALID_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_FAILEDINVALID_PARTITION_VALUEPARQUET_CONVERSION_FAILUREPARQUET_TYPE_ILLEGALPARQUET_TYPE_NOT_RECOGNIZEDPARQUET_TYPE_NOT_SUPPORTEDUNEXPECTED_SERIALIZER_FOR_CLASS
42852 在 GRANT 或 REVOKE 中指定的特权无效或不一致。 (例如,对视图运行 GRANT ALTER。)
INVALID_PRIVILEGE
42883 找不到具有匹配签名的例程。
ROUTINE_NOT_FOUNDUNRESOLVABLE_TABLE_VALUED_FUNCTIONUNRESOLVED_ROUTINEUNRESOLVED_VARIABLEVARIABLE_NOT_FOUND
42887 函数或表引用在其上下文中无效。
CF_INCORRECT_BATCH_USAGECF_INCORRECT_STREAM_USAGECYCLIC_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_TYPEEXCEPT_NESTED_COLUMN_INVALID_TYPEIDENTITY_COLUMNS_UNSUPPORTED_DATA_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_PROPERTYDELTA_SHARING_CANNOT_MODIFY_RESERVED_RECIPIENT_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_CHANGEDELTA_CANNOT_CHANGE_DATA_TYPE, DELTA_CANNOT_UPDATE_ARRAY_FIELDDELTA_CANNOT_UPDATE_MAP_FIELDDELTA_CANNOT_UPDATE_OTHER_FIELDDELTA_CANNOT_UPDATE_STRUCT_FIELDDELTA_IDENTITY_COLUMNS_ALTER_COLUMN_NOT_SUPPORTEDDELTA_IDENTITY_COLUMNS_ALTER_NON_IDENTITY_COLUMNDELTA_IDENTITY_COLUMNS_REPLACE_COLUMN_NOT_SUPPORTED
42K01 未完全指定数据类型
DATATYPE_MISSING_SIZEINCOMPLETE_TYPE_DEFINITION
42K02 找不到数据源
DATA_SOURCE_NOT_FOUND, STREAM_NOT_FOUND_FOR_KINESIS_SOURCE
42K03 找不到文件
BATCH_METADATA_NOT_FOUNDCANNOT_LOAD_PROTOBUF_CLASSCLOUD_FILE_SOURCE_FILE_NOT_FOUNDDATA_SOURCE_TABLE_SCHEMA_MISMATCHDEFAULT_FILE_NOT_FOUNDDELTA_CHANGE_DATA_FILE_NOT_FOUNDDELTA_CHECKPOINT_NON_EXIST_TABLEDELTA_CREATE_EXTERNAL_TABLE_WITHOUT_TXN_LOGDELTA_DELETED_PARQUET_FILE_NOT_FOUNDDELTA_EMPTY_DIRECTORYDELTA_FILE_NOT_FOUNDDELTA_FILE_NOT_FOUND_DETAILEDDELTA_FILE_OR_DIR_NOT_FOUNDDELTA_FILE_TO_OVERWRITE_NOT_FOUNDDELTA_LOG_FILE_NOT_FOUND_FOR_STREAMING_SOURCEDELTA_PATH_DOES_NOT_EXISTDELTA_SHALLOW_CLONE_FILE_NOT_FOUNDDELTA_TRUNCATED_TRANSACTION_LOGLOAD_DATA_PATH_NOT_EXISTSPATH_NOT_FOUNDREAD_CURRENT_FILE_NOT_FOUNDRENAME_SRC_PATH_NOT_FOUNDSTDS_FAILED_TO_READ_OPERATOR_METADATASTDS_FAILED_TO_READ_STATE_SCHEMASTREAMING_STATEFUL_OPERATOR_NOT_MATCH_IN_STATE_METADATA
42K04 重复文件
DELTA_FILE_ALREADY_EXISTSDELTA_LOG_ALREADY_EXISTSDELTA_PATH_EXISTSFAILED_RENAME_PATHFILE_IN_STAGING_PATH_ALREADY_EXISTSKINESIS_FETCHED_SHARD_LESS_THAN_TRACKED_SHARDPARTITION_LOCATION_ALREADY_EXISTSPATH_ALREADY_EXISTS
42K05 名称无效
CLEANROOM_INVALID_SHARED_DATA_OBJECT_NAMECOLUMN_MASKS_MULTI_PART_TARGET_COLUMN_NAMECOLUMN_MASKS_MULTI_PART_USING_COLUMN_NAMEDELTA_INVALID_CHARACTERS_IN_COLUMN_NAMEDELTA_INVALID_CHARACTERS_IN_COLUMN_NAMESDELTA_INVALID_COLUMN_NAMES_WHEN_REMOVING_COLUMN_MAPPINGDELTA_NESTED_FIELDS_NEED_RENAMEDELTA_NON_SINGLE_PART_NAMESPACE_FOR_CATALOGDELTA_SHARING_INVALID_SHARED_DATA_OBJECT_NAMEINVALID_EMPTY_LOCATIONREQUIRES_SINGLE_PART_NAMESPACEROW_LEVEL_SECURITY_MULTI_PART_COLUMN_NAMESHOW_COLUMNS_WITH_CONFLICT_NAMESPACE
42K06 选项的类型无效
DELTA_PROTOCOL_PROPERTY_NOT_INTINVALID_OPTIONSSTATE_STORE_DOES_NOT_SUPPORT_REUSABLE_ITERATORSTATE_STORE_INVALID_CONFIG_AFTER_RESTARTSTATE_STORE_INVALID_PROVIDERSTATE_STORE_INVALID_VARIABLE_TYPE_CHANGESTATE_STORE_PROVIDER_DOES_NOT_SUPPORT_FINE_GRAINED_STATE_REPLAYSTATE_STORE_STATE_SCHEMA_FILES_THRESHOLD_EXCEEDEDSTATE_STORE_VALUE_SCHEMA_EVOLUTION_THRESHOLD_EXCEEDED
42K07 不是有效的架构文本
INVALID_SCHEMA
42K08 不是常数
ARGUMENT_NOT_CONSTANTINVALID_SQL_ARGNON_FOLDABLE_ARGUMENTNON_LITERAL_PIVOT_VALUESSEED_EXPRESSION_IS_UNFOLDABLE
42K09 数据类型不匹配
COMPLEX_EXPRESSION_UNSUPPORTED_INPUTDATATYPE_MISMATCHDELTA_CONSTRAINT_DATA_TYPE_MISMATCHDELTA_CONSTRAINT_DEPENDENT_COLUMN_CHANGEDELTA_GENERATED_COLUMNS_DATA_TYPE_MISMATCHDELTA_GENERATED_COLUMNS_DEPENDENT_COLUMN_CHANGEDELTA_GENERATED_COLUMNS_EXPR_TYPE_MISMATCHDELTA_GENERATED_COLUMN_UPDATE_TYPE_MISMATCHDELTA_MERGE_ADD_VOID_COLUMNDELTA_MERGE_INCOMPATIBLE_DATATYPEDELTA_NOT_NULL_COLUMN_NOT_FOUND_IN_STRUCTEVENT_TIME_IS_NOT_ON_TIMESTAMP_TYPEINVALID_VARIABLE_TYPE_FOR_QUERY_EXECUTE_IMMEDIATEPIVOT_VALUE_DATA_TYPE_MISMATCHUNEXPECTED_INPUT_TYPEUNEXPECTED_INPUT_TYPE_OF_NAMED_PARAMETERUNPIVOT_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_TYPEMETRIC_VIEW_CACHE_TABLE_NOT_SUPPORTEDMETRIC_VIEW_FEATURE_DISABLEDMETRIC_VIEW_INVALID_MEASURE_FUNCTION_INPUTMETRIC_VIEW_IN_CTE_NOT_SUPPORTEDMETRIC_VIEW_JOIN_NOT_SUPPORTEDMETRIC_VIEW_MISSING_MEASURE_FUNCTIONMETRIC_VIEW_UNSUPPORTED_USAGEMETRIC_VIEW_WINDOW_FUNCTION_NOT_SUPPORTEDMULTIPLE_TIME_TRAVEL_SPECMULTI_ALIAS_WITHOUT_GENERATORMULTI_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_AVAILABLEDELTA_UNIFORM_COMPATIBILITY_LOCATION_NOT_REGISTEREDSQL_CONF_NOT_FOUND
42K0K 逆分布函数无效
INVALID_INVERSE_DISTRIBUTION_FUNCTION
42K0L 标签的使用无效。
END_LABEL_WITHOUT_BEGIN_LABELINVALID_LABEL_USAGELABELS_MISMATCHLABEL_ALREADY_EXISTS
42K0M 变量声明无效。
INVALID_VARIABLE_DECLARATION
42K0N 外部类型无效。
INVALID_EXTERNAL_TYPE
42K0O ScalarFunction 不重写使用自定义实现的“produceResult(InternalRow)”方法。
SCALAR_FUNCTION_NOT_COMPATIBLE
42K0P ScalarFunction 不实现或重写方法“produceResult(InternalRow)”。
SCALAR_FUNCTION_NOT_FULLY_IMPLEMENTED
42K10 动态选项无效。
INVALID_DYNAMIC_OPTIONS
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_STREAMINGSTREAMING_OUTPUT_MODE
42KDF 必需的例程参数缺少参数。
KINESIS_SOURCE_MUST_BE_IN_EFO_MODE_TO_CONFIGURE_CONSUMERSKINESIS_SOURCE_MUST_SPECIFY_REGISTERED_CONSUMER_ID_AND_TYPEKINESIS_SOURCE_MUST_SPECIFY_STREAM_NAMES_OR_ARNSKINESIS_SOURCE_NO_CONSUMER_OPTIONS_WITH_REGISTERED_CONSUMERSMISSING_PARAMETER_FOR_KAFKAMISSING_PARAMETER_FOR_ROUTINEXML_ROW_TAG_MISSING
42KDG 目标架构与引入的数据不兼容。
COPY_INTO_SCHEMA_MISMATCH_WITH_TARGET_TABLE
42P01 表未定义
DELTA_CANNOT_REPLACE_MISSING_TABLEDELTA_COMMIT_INTERMEDIATE_REDIRECT_STATEDELTA_MISSING_DELTA_TABLEDELTA_MISSING_DELTA_TABLE_COPY_INTODELTA_NO_REDIRECT_RULES_VIOLATEDDELTA_NO_RELATION_TABLEDELTA_TABLE_NOT_FOUNDTABLE_OR_VIEW_NOT_FOUNDTABLE_WITH_ID_NOT_FOUNDVIEW_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 列引用无效
CLUSTERING_COLUMNS_MISMATCHDELTA_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 窗口化错误
MISSING_WINDOW_SPECIFICATIONUNSUPPORTED_EXPR_FOR_WINDOW
42P21 排序规则不匹配
COLLATION_MISMATCH
42P22 不确定的排序规则
INDETERMINATE_COLLATIONINDETERMINATE_COLLATION_IN_EXPRESSIONINDETERMINATE_COLLATION_IN_SCHEMA
42S22 找不到列
NO_SQL_TYPE_IN_PROTOBUF_SCHEMA
42S23 分区转换表达式不在“partitionedBy”中
PARTITION_TRANSFORM_EXPRESSION_NOT_IN_PARTITIONED_BY

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_PATHINVALID_JAVA_IDENTIFIER_AS_FIELD_NAME

51:应用程序状态无效

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

53:资源不足

SQLSTATE 描述和发出错误类
53000 资源不足
CONCURRENT_SCHEDULER_INSUFFICIENT_SLOT
53200 内存不足
EXECUTOR_BROADCAST_JOIN_OOMEXECUTOR_BROADCAST_JOIN_STORE_OOMUNABLE_TO_ACQUIRE_MEMORY

54:超出程序限制

SQLSTATE 描述和发出错误类
54000 超出程序限制
COLLECTION_SIZE_LIMIT_EXCEEDEDDELTA_CLUSTER_BY_INVALID_NUM_COLUMNSDELTA_SHARING_MAXIMUM_RECIPIENT_TOKENS_EXCEEDEDGROUPING_SIZE_LIMIT_EXCEEDEDINSTANCE_POOL_CAPACITY_EXCEEDEDPHOTON_DESERIALIZED_PROTOBUF_MEMORY_LIMIT_EXCEEDEDPHOTON_SERIALIZED_PROTOBUF_MEMORY_LIMIT_EXCEEDEDPIPELINE_TYPE_QUOTA_EXCEEDEDRELATION_LARGER_THAN_8GWORKSPACE_QUOTA_EXCEEDED
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 描述和发出错误类
55000 对象未处于先决条件状态
DELTA_CANNOT_VACUUM_LITEDELTA_FEATURE_CAN_ONLY_DROP_CHECKPOINT_PROTECTION_WITH_HISTORY_TRUNCATIONMOVE_TABLE_BETWEEN_PIPELINES_DESTINATION_PIPELINE_NOT_IN_NEW_ARCHITECTUREMOVE_TABLE_BETWEEN_PIPELINES_DESTINATION_PIPELINE_TYPE_NOT_WORKSPACEMOVE_TABLE_BETWEEN_PIPELINES_SOURCE_PIPELINE_NOT_IN_NEW_ARCHITECTUREMOVE_TABLE_BETWEEN_PIPELINES_SOURCE_PIPELINE_TYPE_NOT_WORKSPACEMOVE_TABLE_BETWEEN_PIPELINES_UPDATE_IS_RUNNING
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_ERRORCLUSTER_CREATION_TRIAL_EXPIREDCODEC_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_ENABLEDNO_WORKER_ENVIRONMENTSSTREAMING_TABLE_NOT_SUPPORTEDUC_HIVE_METASTORE_FEDERATION_CROSS_CATALOG_VIEW_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 错误
CONNECTCONNECT_SESSION_MIGRATION

57:操作员干预

SQLSTATE 描述和发出错误类
57000 操作员干预
集群创建额度耗尽
57012 非数据库资源不可用。 这不会影响后续语句的成功执行。
REMOTE_FUNCTION_HTTP_FAILED_ERRORREMOTE_FUNCTION_HTTP_RESULT_UNEXPECTED_ERRORREMOTE_FUNCTION_HTTP_RETRY_TIMEOUTREMOTE_FUNCTION_MISSING_REQUIREMENTS_ERROR
57KD0 查询执行超时
QUERY_EXECUTION_TIMEOUT_EXCEEDED

58:系统错误

SQLSTATE 描述和发出错误类
58000 系统错误
CLOUD_PROVIDER_ERRORCLUSTER_LAUNCH_CLOUD_FAILURE
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_HANDLEMISSING_TIMEOUT_CONFIGURATION
HY008 操作已取消
AQE_THREAD_INTERRUPTEDOPERATION_CANCELEDSPARK_JOB_CANCELLED
HY109 无效的游标位置
INVALID_CURSOR

KD:特定于数据源的错误

SQLSTATE 描述和发出错误类
KD000 特定于数据源的错误
API_QUOTA_EXCEEDEDDC_API_QUOTA_EXCEEDEDDC_CONNECTION_ERRORDC_DYNAMICS_API_ERRORDC_NETSUITE_ERRORDC_SERVICENOW_API_ERRORDC_SFDC_BULK_QUERY_JOB_INCOMPLETEDC_SHAREPOINT_API_ERRORDC_SOURCE_API_ERRORDC_WORKDAY_RAAS_API_ERROREND_OFFSET_HAS_GREATER_OFFSET_FOR_TOPIC_PARTITION_THAN_LATEST_WITH_TRIGGER_AVAILABLENOWEND_OFFSET_HAS_GREATER_OFFSET_FOR_TOPIC_PARTITION_THAN_PREFETCHEDFAILED_REGISTER_CLASS_WITH_KRYOGRAPHITE_SINK_INVALID_PROTOCOLGRAPHITE_SINK_PROPERTY_MISSINGINCOMPATIBLE_DATA_FOR_TABLELOST_TOPIC_PARTITIONS_IN_END_OFFSET_WITH_TRIGGER_AVAILABLENOWMALFORMED_AVRO_MESSAGEMALFORMED_CSV_RECORDMISMATCHED_TOPIC_PARTITIONS_BETWEEN_END_OFFSET_AND_PREFETCHEDSAAS_CONNECTION_ERRORSAAS_CONNECTOR_SOURCE_API_ERRORSERVICENOW_CONNECTOR_INSTANCE_HIBERNATION_ERRORSERVICENOW_CONNECTOR_INVALID_TABLE_ERRORSERVICENOW_CONNECTOR_MALFORMED_ENDPOINT_URL_ERRORSERVICENOW_CONNECTOR_UNAUTHORIZED_ACCESS_ERRORSFDC_CONNECTOR_BULK_QUERY_JOB_INCOMPLETESFDC_CONNECTOR_CREATE_BULK_QUERY_JOB_FAILED
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 分区不匹配
CONFLICTING_DIRECTORY_STRUCTURESCONFLICTING_PARTITION_COLUMN_NAMESDELTA_UNEXPECTED_NUM_PARTITION_COLUMNS_FROM_FILE_NAMEDELTA_UNEXPECTED_PARTITION_COLUMN_FROM_FILE_NAMEDELTA_UNEXPECTED_PARTITION_SCHEMA_FROM_USERPARTITION_NUMBER_MISMATCH
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
KD00F 云请求错误
HDFS_HTTP_ERRORNATIVE_IO_ERROR
KD010 外部数据源失败
DATA_SOURCE_EXTERNAL_ERROR
KDL01 群集启动错误
CLUSTER_LAUNCH_CLIENT_ERRORCLUSTER_SETUP_CLIENT_ERROR

P0:过程逻辑错误

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