共用方式為


SQLSTATE 錯誤碼

適用於:核取記號為「是」 Databricks SQL 核取記號為「是」 Databricks Runtime 12.2 和更新版本

Azure Databricks 傳回的所有錯誤類別都會與 5 個字元 SQLSTATE相關聯。 SQLSTATE是、 JDBC和其他用戶端 API 常用ODBC之錯誤狀況的 SQL 標準編碼方式。

SQLSTATE包含兩個部分:兩個字元類別和三個字元子類別。 每個字元都必須是 或 到 '0''9''A'的數位。'Z'

雖然許多 SQLSTATE 值是由 SQL 標準規定,但其他值在產業中很常見,尤其是 Spark 或 Azure Databricks。

必要時,Spark 和 Azure Databricks 會針對自定義 SQLSTATEs 使用 'KD' 類別和 'K**' 子類別範圍。 'XX'類別用於保證錯誤報告的內部錯誤。

如需已排序的錯誤類別清單,請參閱: 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_RESPONSECANNOT_VALIDATE_CONNECTION
08001 SQL-client 無法建立 SQL 連線
CANNOT_ESTABLISH_CONNECTION,CANNOT_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_HMSCANNOT_RENAME_ACROSS_CATALOG、CANNOT_RENAME_ACROSS_SCHEMACANNOT_SHALLOW_CLONE_ACROSS_UC_AND_HMS
0AKD1 不支援安全性功能
COLUMN_MASKS_UNSUPPORTED_CONSTANT_AS_PARAMETERROW_LEVEL_SECURITY_UNSUPPORTED_CONSTANT_AS_PARAMETER
0AKDC Delta 中不支援
DELTA_CANNOT_EVALUATE_EXPRESSIONDELTA_CANNOT_GENERATE_CODE_FOR_EXPRESSIONDELTA_CDC_NOT_ALLOWED_IN_THIS_VERSIONDELTA_CHANGE_DATA_FEED_INCOMPATIBLE_DATA_SCHEMADELTA_CHANGE_DATA_FEED_INCOMPATIBLE_SCHEMA_CHANGEDELTA_CLONE_UNSUPPORTED_SOURCEDELTA_COLLATIONS_NOT_SUPPORTEDDELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_PARTITIONED_COLUMNDELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_TYPEDELTA_CONVERSION_MERGE_ON_READ_NOT_SUPPORTEDDELTA_CONVERSION_UNSUPPORTED_COLLATED_PARTITION_COLUMNDELTA_CONVERSION_UNSUPPORTED_COLUMN_MAPPINGDELTA_CONVERSION_UNSUPPORTED_SCHEMA_CHANGEDELTA_CONVERT_NON_PARQUET_TABLEDELTA_CREATE_TABLE_IDENTIFIER_LOCATION_MISMATCHDELTA_DROP_COLUMN_ON_SINGLE_FIELD_SCHEMADELTA_GEOSPATIAL_NOT_SUPPORTEDDELTA_INCORRECT_LOG_STORE_IMPLEMENTATIONDELTA_MISSING_PROVIDER_FOR_CONVERTDELTA_MODE_NOT_SUPPORTEDDELTA_NESTED_NOT_NULL_CONSTRAINTDELTA_NON_DETERMINISTIC_FUNCTION_NOT_SUPPORTEDDELTA_OPERATION_NOT_ALLOWEDDELTA_OPERATION_NOT_ALLOWED_DETAILDELTA_OPERATION_NOT_SUPPORTED_FOR_COLUMN_WITH_COLLATIONDELTA_OPERATION_NOT_SUPPORTED_FOR_EXPRESSION_WITH_COLLATIONDELTA_OPERATION_ON_VIEW_NOT_ALLOWEDDELTA_TABLE_FOR_PATH_UNSUPPORTED_HADOOP_CONFDELTA_TRUNCATE_TABLE_PARTITION_NOT_SUPPORTEDDELTA_UNIFORM_COMPATIBILITY_LOCATION_CANNOT_BE_CHANGEDDELTA_UNIFORM_INGRESS_NOT_SUPPORTED_FORMATDELTA_UNIFORM_NOT_SUPPORTEDDELTA_UNIFORM_REFRESH_NOT_SUPPORTEDDELTA_UNIFORM_REFRESH_NOT_SUPPORTED_FOR_MANAGED_ICEBERG_TABLE_WITH_METADATA_PATHDELTA_UNSUPPORTED_ABS_PATH_ADD_FILEDELTA_UNSUPPORTED_ALTER_TABLE_CHANGE_COL_OPDELTA_UNSUPPORTED_ALTER_TABLE_REPLACE_COL_OPDELTA_UNSUPPORTED_CLONE_REPLACE_SAME_TABLEDELTA_UNSUPPORTED_COLUMN_MAPPING_MODE_CHANGEDELTA_UNSUPPORTED_COLUMN_MAPPING_OPERATIONS_ON_COLUMNS_WITH_BLOOM_FILTER_INDEXDELTA_UNSUPPORTED_COLUMN_MAPPING_SCHEMA_CHANGEDELTA_UNSUPPORTED_COLUMN_MAPPING_WRITEDELTA_UNSUPPORTED_COLUMN_TYPE_IN_BLOOM_FILTERDELTA_UNSUPPORTED_COMMENT_MAP_ARRAYDELTA_UNSUPPORTED_DATA_TYPESDELTA_UNSUPPORTED_DROP_CLUSTERING_COLUMNDELTA_UNSUPPORTED_DROP_COLUMNDELTA_UNSUPPORTED_DROP_NESTED_COLUMN_FROM_NON_STRUCT_TYPEDELTA_UNSUPPORTED_DROP_PARTITION_COLUMNDELTA_UNSUPPORTED_FIELD_UPDATE_NON_STRUCTDELTA_UNSUPPORTED_INVARIANT_NON_STRUCTDELTA_UNSUPPORTED_IN_SUBQUERYDELTA_UNSUPPORTED_MANIFEST_GENERATION_WITH_COLUMN_MAPPINGDELTA_UNSUPPORTED_MULTI_COL_IN_PREDICATEDELTA_UNSUPPORTED_NESTED_COLUMN_IN_BLOOM_FILTERDELTA_UNSUPPORTED_NESTED_FIELD_IN_OPERATIONDELTA_UNSUPPORTED_NON_EMPTY_CLONEDELTA_UNSUPPORTED_OUTPUT_MODEDELTA_UNSUPPORTED_PARTITION_COLUMN_IN_BLOOM_FILTERDELTA_UNSUPPORTED_RENAME_COLUMNDELTA_UNSUPPORTED_SCHEMA_DURING_READDELTA_UNSUPPORTED_SUBQUERYDELTA_UNSUPPORTED_SUBQUERY_IN_PARTITION_PREDICATESDELTA_UNSUPPORTED_TIME_TRAVEL_VIEWSDELTA_UNSUPPORTED_TYPE_CHANGE_IN_SCHEMADELTA_UNSUPPORTED_TYPE_CHANGE_ON_COLUMNS_WITH_BLOOM_FILTER_INDEXDELTA_UNSUPPORTED_VACUUM_SPECIFIC_PARTITIONDELTA_UNSUPPORTED_WRITES_WITHOUT_COORDINATORWRONG_COLUMN_DEFAULTS_FOR_DELTA_ALTER_TABLE_ADD_COLUMN_NOT_SUPPORTED
0AKDD 功能需要 Delta
DELTA_COPY_INTO_TARGET_FORMAT、DELTA_IDENTITY_COLUMNS_ALTER_NON_DELTA_FORMAT、DELTA_IDENTITY_COLUMNS_NON_DELTA_FORMAT、DELTA_NOT_A_DELTA_TABLEDELTA_ONLY_OPERATION、DELTA_TABLE_ONLY_OPERATION、DELTA_UNSUPPORTED_SOURCE、DELTA_UNSUPPORTED_STATIC_PARTITIONS、SYNC_METADATA_DELTA_ONLY、UNSUPPORTED_MANAGED_TABLE_CREATION
0AKDE 此 Delta 資料表未啟用的功能
DELTA_CANNOT_DROP_CHECK_CONSTRAINT_FEATUREDELTA_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 目錄中不支援
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 目錄
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_MISMATCHINSERT_COLUMN_ARITY_MISMATCHINSERT_PARTITION_COLUMN_ARITY_MISMATCH

類別 22:數據例外狀況

SQLSTATE 描述和發出錯誤類別
22000 數據例外狀況
AI_FUNCTION_JSON_PARSE_ERRORCF_BUCKET_MISMATCHCF_CANNOT_EVOLVE_SCHEMA_LOG_EMPTYCF_CANNOT_PARSE_QUEUE_MESSAGECF_CANNOT_RESOLVE_CONTAINER_NAMECF_CANNOT_RUN_DIRECTORY_LISTINGCF_DUPLICATE_COLUMN_IN_DATACF_EVENT_GRID_AUTH_ERRORCF_EVENT_GRID_CREATION_FAILEDCF_EVENT_GRID_NOT_FOUND_ERRORCF_FAILED_TO_CHECK_STREAM_NEWCF_FAILED_TO_CREATED_PUBSUB_SUBSCRIPTIONCF_FAILED_TO_CREATED_PUBSUB_TOPICCF_FAILED_TO_DELETE_GCP_NOTIFICATIONCF_FAILED_TO_DESERIALIZE_PERSISTED_SCHEMACF_FAILED_TO_EVOLVE_SCHEMACF_FAILED_TO_INFER_SCHEMACF_FAILED_TO_WRITE_TO_SCHEMA_LOGCF_FOUND_MULTIPLE_AUTOLOADER_PUBSUB_SUBSCRIPTIONSCF_GCP_LABELS_COUNT_EXCEEDEDCF_GCP_RESOURCE_TAGS_COUNT_EXCEEDEDCF_INCOMPLETE_LOG_FILE_IN_SCHEMA_LOGCF_INCOMPLETE_METADATA_FILE_IN_CHECKPOINTCF_INVALID_MANAGED_FILE_EVENTS_RESPONSECF_LATEST_OFFSET_READ_LIMIT_REQUIREDCF_LOG_FILE_MALFORMEDCF_MANAGED_FILE_EVENTS_BACKFILL_IN_PROGRESSCF_METADATA_FILE_CONCURRENTLY_USEDCF_MULTIPLE_PUBSUB_NOTIFICATIONS_FOR_TOPICCF_NEW_PARTITION_ERRORCF_PARTITON_INFERENCE_ERRORCF_PREFIX_MISMATCHCF_PROTOCOL_MISMATCHCF_RESTRICTED_GCP_RESOURCE_TAG_KEYCF_SAME_PUB_SUB_TOPIC_NEW_KEY_PREFIXCF_THREAD_IS_DEADCF_UNABLE_TO_LIST_EFFICIENTLYCF_UNEXPECTED_READ_LIMITCF_UNKNOWN_READ_LIMITDELTA_CANNOT_FIND_BUCKET_SPECDELTA_CLUSTERING_COLUMN_MISSING_STATSDELTA_CLUSTERING_CREATE_EXTERNAL_NON_LIQUID_TABLE_FROM_LIQUID_TABLEDELTA_COMPACTION_VALIDATION_FAILEDDELTA_CONVERT_TO_DELTA_ROW_TRACKING_WITHOUT_STATSDELTA_DV_HISTOGRAM_DESERIALIZATONDELTA_INVALID_FORMATDELTA_INVALID_TABLE_VALUE_FUNCTIONDELTA_MATERIALIZED_ROW_TRACKING_COLUMN_NAME_MISSINGDELTA_ROW_ID_ASSIGNMENT_WITHOUT_STATSDELTA_STREAMING_METADATA_EVOLUTIONDELTA_STREAMING_SCHEMA_EVOLUTION_UNSUPPORTED_ROW_FILTER_COLUMN_MASKSDELTA_STREAMING_SCHEMA_LOCATION_CONFLICTDELTA_STREAMING_SCHEMA_LOCATION_NOT_UNDER_CHECKPOINTDELTA_STREAMING_SCHEMA_LOG_DESERIALIZE_FAILEDDELTA_STREAMING_SCHEMA_LOG_INCOMPATIBLE_DELTA_TABLE_IDDELTA_STREAMING_SCHEMA_LOG_INCOMPATIBLE_PARTITION_SCHEMADELTA_STREAMING_SCHEMA_LOG_INIT_FAILED_INCOMPATIBLE_METADATADELTA_STREAMING_SCHEMA_LOG_PARSE_SCHEMA_FAILEDDELTA_VACUUM_COPY_INTO_STATE_FAILEDHLL_UNION_DIFFERENT_LG_KINVALID_TIMESTAMP_FORMATKAFKA_DATA_LOSSKINESIS_COULD_NOT_READ_SHARD_UNTIL_END_OFFSETKINESIS_RECORD_SEQ_NUMBER_ORDER_VIOLATIONMALFORMED_CHARACTER_CODINGPS_FETCH_RETRY_EXCEPTIONPS_INVALID_KEY_TYPEPS_INVALID_UNSAFE_ROW_CONVERSION_FROM_PROTOPS_MOVING_CHECKPOINT_FAILUREPS_MULTIPLE_FAILED_EPOCHSPS_OPTION_NOT_IN_BOUNDSPS_UNABLE_TO_PARSE_PROTOSTAGING_PATH_CURRENTLY_INACCESSIBLE
22001 字串數據,右截斷
DELTA_EXCEED_CHAR_VARCHAR_LIMIT
22003 數值超出範圍
算術溢位二進位算術溢位強制轉換溢位資料表插入中的強制轉換溢位列順序超出範圍小數精度超出最大精度Delta無法還原資料表版本Delta無法還原早期時間戳Delta無法還原較大時間戳Delta資料表寫入中的強制轉換溢位Delta 無效的 CDC 範圍不正確的漸升率無效的陣列索引元素中的無效陣列索引無效的位圖位置無效的邊界零的無效索引無效的數值文字範圍頻率表達式中的負值數值超出支持範圍數值超出範圍排程期間無效限制和偏移的總和超出最大整數觸發間隔無效觸發間隔值無效
22004 不允許 null 值
COMPARATOR_RETURNS_NULL、NULL_QUERY_STRING_EXECUTE_IMMEDIATE
22005 指派中的錯誤
DELTA_COMPLEX_TYPE_COLUMN_CONTAINS_NULL_TYPE、DELTA_FAILED_TO_MERGE_FIELDSDELTA_MERGE_UNEXPECTED_ASSIGNMENT_KEY
22006 無效的間隔格式
CANNOT_PARSE_INTERVALDELTA_INVALID_INTERVALINVALID_INTERVAL_FORMATINVALID_INTERVAL_WITH_MICROSECONDS_ADDITION
22007 無效的日期時間格式
CANNOT_PARSE_TIMESTAMPDELTA_INVALID_TIMESTAMP_FORMATINVALID_DATETIME_PATTERN
22008 datetime 欄位溢位
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 欄位元
INTERVAL_ARITHMETIC_OVERFLOW
22018 轉換的字元值無效
CANNOT_PARSE_DECIMAL、CANNOT_PARSE_PROTOBUF_DESCRIPTORCAST_INVALID_INPUTCONVERSION_INVALID_INPUTDELTA_FAILED_CAST_PARTITION_VALUE、FAILED_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_WORDS、AI_INVALID_ARGUMENT_VALUE_ERRORINVALID_JSON_ROOT_FIELDINVALID_JSON_SCHEMA_MAP_TYPE、REMOTE_FUNCTION_HTTP_RESULT_PARSE_ERROR
2203G sql json 項目無法轉換成目標類型
AI_FUNCTION_HTTP_PARSE_CAST_ERROR、AI_FUNCTION_HTTP_PARSE_COLUMNS_ERRORAI_FUNCTION_MODEL_SCHEMA_PARSE_ERRORCANNOT_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_BUFFERHLL_INVALID_LG_K、INVALID_BOOLEAN_STATEMENT
22KD0 暫時性錯誤
DELTA_FEATURE_DROP_CHECKPOINT_FAILEDDELTA_FEATURE_DROP_CHECKPOINT_PROTECTION_WAIT_FOR_RETENTION_PERIOD
22KD1 URI 或 PATH 無效
DELTA_CANNOT_RECONSTRUCT_PATH_FROM_URI、DELTA_CANNOT_RENAME_PATHDELTA_INVALID_CLONE_PATH、DELTA_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_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_ALLOWEDCOPY_INTO_ROCKSDB_MAX_RETRY_EXCEEDED、DATA_LINEAGE_SECURE_VIEW_LEAF_NODE_HAS_NO_RELATION、DELTA_INVALID_ISOLATION_LEVEL、DELTA_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_DELETEDELTA_CONCURRENT_DELETE_READDELTA_CONCURRENT_TRANSACTIONDELTA_CONCURRENT_WRITEDELTA_DELETION_VECTOR_MISSING_NUM_RECORDS、DELTA_DUPLICATE_ACTIONS_FOUND、DELTA_METADATA_CHANGED、DELTA_PROTOCOL_CHANGED
2DKD0 認可攔截失敗。
DELTA_POST_COMMIT_HOOK_FAILED

類別 38:外部例程例外狀況

SQLSTATE 描述和發出錯誤類別
38000 外部例程例外狀況
類別未覆蓋預期的方法功能呼叫失敗載入例程失敗UDF 實作無效無 UDF 介面Python資料來源錯誤Python串流資料來源運行時錯誤在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 無效的架構名稱
缺少 V1 會話目錄的資料庫

類別 40:交易回復

SQLSTATE 描述和發出錯誤類別
40000 交易回復
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 授權標識碼沒有在識別物件上執行指定作業的許可權。
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_ALLOWEDCOMMA_PRECEDING_CONSTRAINT_ERRORCOPY_INTO_CREDENTIALS_REQUIREDCOPY_INTO_ENCRYPTION_REQUIREDCOPY_INTO_ENCRYPTION_REQUIRED_WITH_EXPECTEDCOPY_INTO_SYNTAX_ERRORCREDENTIAL_MISSINGDATA_SOURCE_OPTION_IS_REQUIREDDELTA_CANNOT_CHANGE_LOCATIONDELTA_COLUMN_MISSING_DATA_TYPEDELTA_CREATE_EXTERNAL_TABLE_WITHOUT_SCHEMADELTA_CREATE_TABLE_MISSING_TABLE_NAME_OR_LOCATIONDELTA_CREATE_TABLE_WITH_NON_EMPTY_LOCATIONDELTA_DUPLICATE_DOMAIN_METADATA_INTERNAL_ERRORDELTA_FAILED_RECOGNIZE_PREDICATEDELTA_IDENTITY_COLUMNS_PARTITION_NOT_SUPPORTEDDELTA_ILLEGAL_USAGEDELTA_MERGE_MISSING_WHENDELTA_MERGE_RESOLVED_ATTRIBUTE_MISSING_FROM_INPUTDELTA_MERGE_UNRESOLVED_EXPRESSIONDELTA_NON_LAST_MATCHED_CLAUSE_OMIT_CONDITIONDELTA_NON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITIONDELTA_NON_LAST_NOT_MATCHED_CLAUSE_OMIT_CONDITIONDELTA_NON_PARSABLE_TAGDELTA_NO_START_FOR_CDC_READDELTA_ONEOF_IN_TIMETRAVELDELTA_OPERATION_MISSING_PATHDELTA_OPTIMIZE_FULL_NOT_SUPPORTEDDELTA_UNEXPECTED_ACTION_EXPRESSIONDELTA_UNIFORM_COMPATIBILITY_MISSING_OR_INVALID_LOCATIONDELTA_UNKNOWN_PRIVILEGEDELTA_UNKNOWN_READ_LIMITDELTA_UNRECOGNIZED_COLUMN_CHANGEEVENT_LOG_REQUIRES_SHARED_COMPUTEFROM_JSON_CONFLICTING_SCHEMA_UPDATESFROM_JSON_CORRUPT_RECORD_COLUMN_IN_SCHEMAFROM_JSON_CORRUPT_SCHEMAFROM_JSON_INFERENCE_FAILEDFROM_JSON_INVALID_CONFIGURATIONGET_WARMUP_TRACING_FAILEDGET_WARMUP_TRACING_FUNCTION_NOT_ALLOWEDIDENTIFIER_TOO_MANY_NAME_PARTSIDENTITY_COLUMNS_DUPLICATED_SEQUENCE_GENERATOR_OPTIONILLEGAL_STATE_STORE_VALUEINVALID_ATTRIBUTE_NAME_SYNTAXINVALID_BUCKET_COLUMN_DATA_TYPEINVALID_EXTRACT_FIELDINVALID_FORMATINVALID_PARTITION_OPERATIONINVALID_SHARED_ALIAS_NAMEINVALID_STATEMENT_OR_CLAUSEINVALID_WINDOW_SPEC_FOR_AGGREGATION_FUNCLOCAL_MUST_WITH_SCHEMA_FILEMERGE_WITHOUT_WHENMIGRATION_NOT_SUPPORTEDMISSING_CLAUSES_FOR_OPERATIONMV_ST_ALTER_QUERY_INCORRECT_BACKING_TYPENOT_ALLOWED_IN_FROMNOT_ALLOWED_IN_PIPE_OPERATOR_WHERENOT_A_CONSTANT_STRINGNOT_UNRESOLVED_ENCODERPARSE_MODE_UNSUPPORTEDPARSE_SYNTAX_ERRORPROCEDURE_CREATION_PARAMETER_OUT_INOUT_WITH_DEFAULTREF_DEFAULT_VALUE_IS_NOT_ALLOWED_IN_PARTITIONSORT_BY_WITHOUT_BUCKETINGSPECIFY_BUCKETING_IS_NOT_ALLOWEDSPECIFY_PARTITION_IS_NOT_ALLOWEDSTDS_REQUIRED_OPTION_UNSPECIFIEDSTREAMING_TABLE_OPERATION_NOT_ALLOWEDSYNTAX_DISCONTINUEDTRAILING_COMMA_IN_SELECTUC_EXTERNAL_VOLUME_MISSING_LOCATIONUC_LOCATION_FOR_MANAGED_VOLUME_NOT_SUPPORTEDUNCLOSED_BRACKETED_COMMENTUSER_DEFINED_FUNCTIONSWINDOW_FUNCTION_WITHOUT_OVER_CLAUSEWITH_CREDENTIALWRITE_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_JOIN、DELTA_TIME_TRAVEL_INVALID_BEGIN_VALUEEMPTY_JSON_FIELD_VALUE、INVALID_ESCINVALID_ESCAPE_CHARINVALID_PIPELINE_ID、INVALID_STAGING_PATH_IN_STAGING_ACCESS_QUERY、INVALID_TYPED_LITERAL、INVALID_UUID
42605 為純量函式指定的自變數數目無效。
INCORRECT_NUMBER_OF_ARGUMENTS、PROCEDURE_ARGUMENT_NUMBER_MISMATCHWRONG_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_SETTING、DELTA_AMBIGUOUS_PATHS_IN_CREATE_TABLEDELTA_CANNOT_SET_LOCATION_ON_PATH_IDENTIFIERDELTA_CLONE_AMBIGUOUS_TARGET、DELTA_CLUSTERING_WITH_ZORDER_BY、DELTA_CLUSTER_BY_WITH_BUCKETING、DELTA_CLUSTER_BY_WITH_PARTITIONED_BYDELTA_FILE_LIST_AND_PATTERN_STRING_CONFLICT、DELTA_IDENTITY_COLUMNS_WITH_GENERATED_EXPRESSION、 DELTA_OVERWRITE_SCHEMA_WITH_DYNAMIC_PARTITION_OVERWRITE、DELTA_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_SET、DELTA_TABLE_LOCATION_MISMATCHDELTA_UNSUPPORTED_TIME_TRAVEL_MULTIPLE_FORMATSINCOMPATIBLE_JOIN_TYPES、INVALID_JOIN_TYPE_FOR_JOINWITHINVALID_LATERAL_JOIN_TYPEINVALID_QUERY_MIXED_QUERY_PARAMETERS、INVALID_SINGLE_VARIANT_COLUMNMANAGED_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_CONDITIONSTDS_CONFLICT_OPTIONS
42614 重複的關鍵詞或子句無效。
DELTA_MULTIPLE_CDC_BOUNDARY、DELTA_MULTIPLE_CONF_FOR_SINGLE_COLUMN_IN_BLOOM_FILTERDUPLICATE_CLAUSES、REPEATED_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_REFERENCESDELTA_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_COLUMN、DELTA_DUPLICATE_COLUMNS_ON_INSERTDELTA_DUPLICATE_COLUMNS_ON_UPDATE_TABLE、DELTA_DUPLICATE_DATA_SKIPPING_COLUMNSDUPLICATE_ASSIGNMENTS、EXEC_IMMEDIATE_DUPLICATE_ARGUMENT_ALIASES
42702 數據行參考模棱兩可,因為名稱重複。
AMBIGUOUS_COLUMN_OR_FIELD、AMBIGUOUS_COLUMN_REFERENCEAMBIGUOUS_LATERAL_COLUMN_ALIAS、DELTA_AMBIGUOUS_PARTITION_COLUMNEXCEPT_OVERLAPPING_COLUMNS
42703 偵測到未定義的數據行或參數名稱。
COLUMN_NOT_DEFINED_IN_TABLE、COLUMN_NOT_FOUNDDELTA_BLOOM_FILTER_DROP_ON_NON_EXISTING_COLUMNSDELTA_CANNOT_CREATE_BLOOM_FILTER_NON_EXISTING_COLDELTA_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_SCHEMADELTA_FAILED_FIND_ATTRIBUTE_IN_OUTPUT_COLUMNS、DELTA_MISSING_COLUMNDELTA_MISSING_SET_COLUMNDELTA_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_KEYUNRESOLVED_USING_COLUMN_FOR_JOIN、ZORDERBY_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_STRUCT,STATIC_PARTITION_COLUMN_IN_INSERT_COLUMN_LIST
42723 具有相同簽章的例程已存在於定義它的架構、模組或複合區塊中。
ROUTINE_ALREADY_EXISTSVARIABLE_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_ASSIGNMENT、NAMED_PARAMETERS_NOT_SUPPORTEDREAD_FILES_AMBIGUOUS_ROUTINE_PARAMETERSREAD_TVF_UNEXPECTED_REQUIRED_PARAMETERREQUIRED_PARAMETER_ALREADY_PROVIDED_POSITIONALLYREQUIRED_PARAMETER_NOT_FOUND、RESCUED_DATA_COLUMN_CONFLICT_WITH_SINGLE_VARIANT、UNEXPECTED_POSITIONAL_ARGUMENT、UNKNOWN_POSITIONAL_ARGUMENT、UNRECOGNIZED_PARAMETER_NAME
42802 目標值的數目與來源值的數目不同。
ASSIGNMENT_ARITY_MISMATCH、DELTA_INSERT_COLUMN_ARITY_MISMATCH、DELTA_INSERT_COLUMN_MISMATCHSTATEFUL_PROCESSOR_CANNOT_PERFORM_OPERATION_WITH_INVALID_HANDLE_STATESTATEFUL_PROCESSOR_CANNOT_PERFORM_OPERATION_WITH_INVALID_TIME_MODESTATEFUL_PROCESSOR_DUPLICATE_STATE_VARIABLE_DEFINED、STATEFUL_PROCESSOR_INCORRECT_TIME_MODE_TO_ASSIGN_TTL、STATEFUL_PROCESSOR_TTL_DURATION_MUST_BE_正、STATEFUL_PROCESSOR_UNKNOWN_TIME_MODESTATE_STORE_CANNOT_CREATE_COLUMN_FAMILY_WITH_RESERVED_CHARS、STATE_STORE_CANNOT_USE_COLUMN_FAMILY_WITH_INVALID_NAME、STATE_STORE_COLUMN_FAMILY_SCHEMA_INCOMPATIBLE、STATE_STORE_HANDLE_NOT_INITIALIZEDSTATE_STORE_INCORRECT_NUM_ORDERING_COLS_FOR_RANGE_SCANSTATE_STORE_INCORRECT_NUM_PREFIX_COLS_FOR_PREFIX_SCAN、 STATE_STORE_NULL_TYPE_ORDERING_COLS_NOT_SUPPORTED、STATE_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_METHOD、UDTF_INVALID_REQUESTED_SELECTED_EXPRESSION_FROM_ANALYZE_METHOD_REQUIRES_ALIAS
42803 SELECT 或 HAVING 子句中的數據行參考無效,因為它不是群組數據行;或 GROUP BY 子句中的數據行參考無效。
GROUPING_COLUMN_MISMATCH、GROUPING_ID_COLUMN_MISMATCHMISSING_AGGREGATION、MISSING_GROUP_BYUNRESOLVED_ALL_IN_GROUP_BY
42804 CASE 運算式中的結果表達式不相容。
INVALID_CORRUPT_RECORD_TYPE
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
42808 INSERT 或 UPDATE 作業中所識別的欄無法更新。
DELTA_IDENTITY_COLUMNS_EXPLICIT_INSERT_NOT_SUPPORTED,DELTA_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 表達式中的 datetime 值或持續時間無效。
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_MISMATCHNUM_TABLE_VALUE_ALIASES_MISMATCH
42830 外鍵不符合父索引鍵的描述。
FOREIGN_KEY_MISMATCH
42832 系統物件上不允許此作業。
BUILT_IN_CATALOG、CANNOT_DELETE_SYSTEM_OWNEDEVENT_LOG_UNSUPPORTED_TABLE_TYPE、MODIFY_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_FOUND、UNRESOLVABLE_TABLE_VALUED_FUNCTIONUNRESOLVED_ROUTINE、UNRESOLVED_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_COLUMN、CANNOT_ALTER_PARTITION_COLUMNDELTA_ALTER_COLLATION_NOT_SUPPORTED_BLOOM_FILTERDELTA_ALTER_COLLATION_NOT_SUPPORTED_CLUSTER_BY
428FT CREATE 或 ALTER 上指定的數據分割子句無效。
DELTA_CANNOT_USE_ALL_COLUMNS_FOR_PARTITION、PARTITIONS_ALREADY_EXISTPARTITIONS_NOT_FOUND
428GU 數據表必須包含至少一個未隱含隱藏的數據行。
DELTA_EMPTY_DATA、DELTA_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_AGGREGATEGROUP_BY_POS_AGGREGATE、INVALID_AGGREGATE_FILTERINVALID_WHERE_CONDITION
42908 語句不包含必要的資料列清單。
DELTA_CLUSTER_BY_SCHEMA_NOT_PROVIDED、DELTA_SCHEMA_NOT_PROVIDEDSPECIFY_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_PROPERTYDELTA_SHARING_CANNOT_MODIFY_RESERVED_RECIPIENT_PROPERTY、RESERVED_CDC_COLUMNS_ON_WRITEROUTINE_USES_SYSTEM_RESERVED_CLASS_NAME
42996 指定的數據列不能用於資料分割索引鍵中。
DELTA_INVALID_PARTITION_COLUMNDELTA_INVALID_PARTITION_COLUMN_NAMEDELTA_INVALID_PARTITION_COLUMN_TYPE
429BB 不支援數據行、參數或 SQL 變數的數據類型。
CANNOT_RECOGNIZE_HIVE_TYPE
429BQ 不允許指定之數據類型或屬性的改變。
DELTA_AMBIGUOUS_DATA_TYPE_CHANGE、DELTA_CANNOT_CHANGE_DATA_TYPEDELTA_CANNOT_UPDATE_ARRAY_FIELDDELTA_CANNOT_UPDATE_MAP_FIELDDELTA_CANNOT_UPDATE_OTHER_FIELDDELTA_CANNOT_UPDATE_STRUCT_FIELD、DELTA_IDENTITY_COLUMNS_ALTER_COLUMN_NOT_SUPPORTEDDELTA_IDENTITY_COLUMNS_ALTER_NON_IDENTITY_COLUMN、DELTA_IDENTITY_COLUMNS_REPLACE_COLUMN_NOT_SUPPORTED
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_CLASSCLOUD_FILE_SOURCE_FILE_NOT_FOUNDDATA_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_FOUNDDELTA_FILE_TO_OVERWRITE_NOT_FOUNDDELTA_LOG_FILE_NOT_FOUND_FOR_STREAMING_SOURCE、DELTA_PATH_DOES_NOT_EXISTDELTA_SHALLOW_CLONE_FILE_NOT_FOUND、DELTA_TRUNCATED_TRANSACTION_LOGLOAD_DATA_PATH_NOT_EXISTS、PATH_NOT_FOUND、READ_CURRENT_FILE_NOT_FOUND、RENAME_SRC_PATH_NOT_FOUNDSTDS_FAILED_TO_READ_OPERATOR_METADATASTDS_FAILED_TO_READ_STATE_SCHEMA、STREAMING_STATEFUL_OPERATOR_NOT_MATCH_IN_STATE_METADATA
42K04 重複的檔案
DELTA_FILE_ALREADY_EXISTS、DELTA_LOG_ALREADY_EXISTSDELTA_PATH_EXISTSFAILED_RENAME_PATHFILE_IN_STAGING_PATH_ALREADY_EXISTSKINESIS_FETCHED_SHARD_LESS_THAN_TRACKED_SHARD、PARTITION_LOCATION_ALREADY_EXISTS、PATH_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_CONSTANT、INVALID_SQL_ARGNON_FOLDABLE_ARGUMENTNON_LITERAL_PIVOT_VALUES、SEED_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_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_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_FOUND、PROTOBUF_DESCRIPTOR_FILE_NOT_FOUNDPROTOBUF_FIELD_MISSINGPROTOBUF_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_類型
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 唯讀會話模式不支援作業。
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_OPERATION、DELTA_STREAMING_INCOMPATIBLE_SCHEMA_CHANGEDELTA_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_FOUNDDELTA_MISSING_PARTITION_COLUMNDELTA_MISSING_PART_FILES
42KD7 數據表簽章不符。
DELTA_CREATE_TABLE_SCHEME_MISMATCH、DELTA_CREATE_TABLE_WITH_DIFFERENT_CLUSTERINGDELTA_CREATE_TABLE_WITH_DIFFERENT_PARTITIONING、DELTA_CREATE_TABLE_WITH_DIFFERENT_PROPERTYDELTA_SET_LOCATION_SCHEMA_MISMATCH
42KD8 數據行位置超出範圍。
DELTA_DROP_COLUMN_AT_INDEX_LESS_THAN_ZERO、DELTA_INDEX_LARGER_OR_EQUAL_THAN_STRUCTDELTA_INDEX_LARGER_THAN_STRUCT
42KD9 無法推斷數據表架構。
CANNOT_MERGE_SCHEMAS、COPY_INTO_SOURCE_SCHEMA_INFERENCE_FAILEDDELTA_FAILED_INFER_SCHEMAUNABLE_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_UNSUPPORTEDCANNOT_CREATE_DATA_SOURCE_TABLEINVALID_WRITER_COMMIT_MESSAGE、NON_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 undefined 參數
UNBOUND_SQL_PARAMETER
42P06 重複的架構
SCHEMA_ALREADY_EXISTS
42P07 重複的數據表
DELTA_TABLE_ALREADY_EXISTS、TABLE_OR_VIEW_ALREADY_EXISTSTEMP_TABLE_OR_VIEW_ALREADY_EXISTS、VIEW_ALREADY_EXISTS
42P08 模棱兩可的參數
CATALOG_NOT_FOUND
42P10 無效的數據行參考
CLUSTERING_COLUMNS_MISMATCH、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 窗口錯誤
MISSING_WINDOW_SPECIFICATION,UNSUPPORTED_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:具有 check 選項違規

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_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 描述和發出錯誤類別
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_ERRORDIFFERENT_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_ERROR、REMOTE_FUNCTION_HTTP_RESULT_UNEXPECTED_ERRORREMOTE_FUNCTION_HTTP_RETRY_TIMEOUT、REMOTE_FUNCTION_MISSING_REQUIREMENTS_ERROR
57KD0 查詢執行時間超時
查詢執行超時

類別 58:系統錯誤

SQLSTATE 描述和發出錯誤類別
58000 系統錯誤
CLOUD_PROVIDER_ERRORCLUSTER_LAUNCH_CLOUD_FAILURE
58030 I/O 錯誤
CANNOT_LOAD_STATE_STORE、CANNOT_RESTORE_PERMISSIONS_FOR_PATHCANNOT_WRITE_STATE_STOREFAILED_RENAME_TEMP_FILEINVALID_BUCKET_FILE、TASK_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_CONFDELTA_UNKNOWN_CONFIGURATION、INVALID_DRIVER_MEMORYINVALID_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_EVOLUTION、DELTA_STREAMING_CHECK_COLUMN_MAPPING_NO_SNAPSHOT
KD003 數據類型的存取不正確
CANNOT_READ_ARCHIVED_FILE、CANNOT_READ_FILEDELTA_FOUND_MAP_TYPE_COLUMNDELTA_INCORRECT_ARRAY_ACCESS、DELTA_INCORRECT_ARRAY_ACCESS_BY_NAMEUNKNOWN_FIELD_EXCEPTION
KD004 差異通訊協定版本錯誤
DELTA_INVALID_PROTOCOL_DOWNGRADE、DELTA_INVALID_PROTOCOL_VERSIONDELTA_MISSING_COMMIT_INFODELTA_MISSING_COMMIT_TIMESTAMP、DELTA_READ_FEATURE_PROTOCOL_REQUIRES_WRITEDELTA_UNSUPPORTED_COLUMN_MAPPING_PROTOCOL
KD005 數據表至少必須包含一個非數據分割數據行
ALL_PARTITION_COLUMNS_NOT_ALLOWED,DELTA_NON_PARTITION_COLUMN_ABSENT
KD006 記錄路徑上找不到任何認可
DELTA_NO_COMMITS_FOUND、DELTA_NO_RECREATABLE_HISTORY_FOUNDSTDS_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_OPTIONSDELTA_SCHEMA_CHANGED_WITH_VERSION、DELTA_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_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_VIOLATIONDELTA_UNIVERSAL_FORMAT_CONVERSION_FAILEDDELTA_UNIVERSAL_FORMAT_VIOLATION
KD00F 雲端要求錯誤
HDFS_HTTP_ERROR,NATIVE_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