Bagikan melalui


Kode kesalahan SQLSTATE

Berlaku untuk: centang ditandai ya Databricks SQL centang ditandai ya Databricks Runtime 12.2 ke atas

Semua kelas kesalahan yang dikembalikan oleh Azure Databricks dikaitkan dengan 5 karakter SQLSTATE. SQLSTATE adalah pengodean standar SQL untuk kondisi kesalahan yang umum digunakan oleh JDBC, ODBC, dan API klien lainnya.

A SQLSTATE terdiri dari dua bagian: Kelas dua karakter, dan tiga subkelas karakter. Setiap karakter harus berupa digit '0' ke '9' atau 'A' ke 'Z'.

Meskipun banyak SQLSTATE nilai ditentukan oleh standar SQL, nilai lain umum di industri, khusus untuk Spark, atau Azure Databricks.

Jika perlu, Spark dan Azure Databricks menggunakan 'KD' rentang kelas dan 'K**' subkelas untuk SQLSTATEs kustom. 'XX' Kelas ini digunakan untuk kesalahan internal yang menjamin laporan bug.

Untuk daftar kelas kesalahan yang diurutkan, lihat: Penanganan kesalahan di Azure Databricks

Azure Databricks menggunakan kelas berikut SQLSTATE :

Kelas 07: kesalahan SQL dinamis

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
07001 menggunakan klausul tidak cocok dengan spesifikasi parameter dinamis
ALL_PARAMETERS_MUST_BE_NAMED, FUNCTION_PARAMETERS_MUST_BE_NAMED
07501 Opsi yang ditentukan pada PREPARE atau EXECUTE tidak valid.
INVALID_STATEMENT_FOR_EXECUTE_INTO, NESTED_EXECUTE_IMMEDIATE

Kelas 08: pengecualian koneksi

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
08000 pengecualian koneksi
AI_FUNCTION_HTTP_REQUEST_ERROR, AI_FUNCTION_INVALID_HTTP_RESPONSE, CANNOT_VALIDATE_CONNECTION
08001 SQL-client tidak dapat membuat koneksi SQL
CANNOT_ESTABLISH_CONNECTION, CANNOT_ESTABLISH_CONNECTION_SERVERLESS
08003 koneksi tidak ada
DELTA_ACTIVE_SPARK_SESSION_NOT_FOUND
08KD1 server sibuk
SERVER_IS_BUSY

Kelas 0A: fitur tidak didukung

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
0A000 fitur tidak didukung
AI_FUNCTION_UNSUPPORTED_REQUEST, AI_FUNCTION_UNSUPPORTED_RETURN_TYPE, AI_QUERY_RETURN_TYPE_COLUMN_TYPE_MISMATCH, AI_SEARCH_EMBEDDING_COLUMN_TYPE_UNSUPPORTED_ERROR, AI_SEARCH_INDEX_TYPE_UNSUPPORTED_ERROR, AI_SEARCH_QUERY_TYPE_CONVERT_ENCODE_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_SAVE_VARIANT, CANNOT_UPDATE_FIELD, CF_ADD_NEW_NOT_SUPPORTED, CF_EVENT_NOTIFICATION_NOT_SUPPORTED, CF_PERIODIC_BACKFILL_NOT_SUPPORTED, 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_MASKS_CHECK_CONSTRAINT_UNSUPPORTED, COLUMN_MASKS_FEATURE_NOT_SUPPORTED, COLUMN_MASKS_INCOMPATIBLE_SCHEMA_CHANGE, COLUMN_MASKS_MERGE_UNSUPPORTED_SOURCE, COLUMN_MASKS_MERGE_UNSUPPORTED_TARGET, COLUMN_MASKS_REQUIRE_UNITY_CATALOG, COLUMN_MASKS_TABLE_CLONE_SOURCE_NOT_SUPPORTED, COLUMN_MASKS_TABLE_CLONE_TARGET_NOT_SUPPORTED, COLUMN_MASKS_UNSUPPORTED_PROVIDER, COLUMN_MASKS_UNSUPPORTED_SUBQUERY, CONCURRENT_QUERY, CONSTRAINTS_REQUIRE_UNITY_CATALOG, COPY_INTO_CREDENTIALS_NOT_ALLOWED_ON, COPY_INTO_ENCRYPTION_NOT_ALLOWED_ON, COPY_INTO_ENCRYPTION_ NOT_SUPPORTED_FOR_AZURE, COPY_INTO_SOURCE_FILE_FORMAT_NOT_SUPPORTED, 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, DISTINCT_WINDOW_FUNCTION_UNSUPPORTED, EXTERNAL_TABLE_INVALID_SCHEME, FABRIC_REFRESH_ INVALID_SCOPE, FROM_JSON_INFERENCE_NOT_SUPPORTED, H3_NOT_ENABLED, INFINITE_STREAMING_TRIGGER_NOT_SUPPORTED, INVALID_PANDAS_UDF_PLACEMENT, INVALID_PARTITION_COLUMN_DATA_TYPE, MATERIALIZED_VIEW_OUTPUT_WITHOUT_EXPLICIT_ALIAS, MATERIALIZED_VIEW_UNSUPPORTED_OPERATION, METRIC_CONSTRAINT_NOT_SUPPORTED, 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_ SELECT_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_CHECK_CONSTRAINT_UNSUPPORTED, ROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTED, ROW_LEVEL_SECURITY_INCOMPATIBLE_SCHEMA_CHANGE, ROW_LEVEL_SECURITY_MERGE_UNSUPPORTED_SOURCE, ROW_LEVEL_SECURITY_MERGE_UNSUPPORTED_TARGET, ROW_LEVEL_SECURITY_REQUIRE_UNITY_CATALOG, ROW_LEVEL_SECURITY_TABLE_CLONE_SOURCE_NOT_SUPPORTED, ROW_LEVEL_SECURITY_TABLE_CLONE_TARGET_NOT_ DIDUKUNG, ROW_LEVEL_SECURITY_UNSUPPORTED_PROVIDER, SCALAR_SUBQUERY_IS_IN_GROUP_BY_OR_AGGREGATE_FUNCTION, STAR_GROUP_BY_POS, STREAMING_AQE_NOT_SUPPORTED_FOR_STATEFUL_OPERATORS, STREAMING_FROM_MATERIALIZED_VIEW, ST_NOT_ENABLED, ST_UNSUPPORTED_RETURN_TYPE, TABLE_VALUED_ARGUMENTS_NOT_YET_IMPLEMENTED_FOR_SQL_FUNCTIONS, UC_HIVE_ METASTORE_FEDERATION_NOT_ENABLED, UDF_PYSPARK_UNSUPPORTED_TYPE, UDF_UNSUPPORTED_PARAMETER_DEFAULT_VALUE, UNSUPPORTED_ADD_FILE, 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_FN_TYPE, UNSUPPORTED_JOIN_TYPE, UNSUPPORTED_NESTED_ROW_OR_COLUMN_ACCESS_POLICY, UNSUPPORTED_SAVE_MODE, 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
0AKD0 Operasi lintas katalog atau skema tidak didukung
CANNOT_COPY_STATE, CANNOT_REFERENCE_UC_IN_HMS, CANNOT_RENAME_ACROSS_CATALOG, CANNOT_RENAME_ACROSS_SCHEMA, CANNOT_SHALLOW_CLONE_ACROSS_UC_AND_HMS
0AKD1 Fitur keamanan tidak didukung
COLUMN_MASKS_UNSUPPORTED_CONSTANT_AS_PARAMETER, ROW_LEVEL_SECURITY_UNSUPPORTED_CONSTANT_AS_PARAMETER
0AKDC Tidak didukung di Delta
DELTA_CANNOT_EVALUATE_EXPRESSION, DELTA_CANNOT_GENERATE_CODE_FOR_EXPRESSION, DELTA_CDC_NOT_ALLOWED_IN_THIS_VERSION, DELTA_CHANGE_DATA_FEED_INCOMPATIBLE_DATA_SCHEMA, DELTA_CHANGE_DATA_FEED_INCOMPATIBLE_SCHEMA_CHANGE, DELTA_CLONE_UNSUPPORTED_SOURCE, DELTA_COLLATIONS_NOT_SUPPORTED, DELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_PARTITIONED_COLUMN, DELTA_COLUMN_DATA_SKIPPING_NOT_ SUPPORTED_TYPE, DELTA_CONVERSION_UNSUPPORTED_COLLATED_PARTITION_COLUMN, DELTA_CONVERSION_UNSUPPORTED_COLUMN_MAPPING, DELTA_CONVERT_NON_PARQUET_TABLE, DELTA_CREATE_TABLE_IDENTIFIER_LOCATION_MISMATCH, DELTA_DROP_COLUMN_ON_SINGLE_FIELD_SCHEMA, DELTA_INCORRECT_LOG_STORE_IMPLEMENTATION, DELTA_MISSING_PROVIDER_FOR_CONVERT, DELTA_MODE_NOT_SUPPORTED, DELTA_ NESTED_NOT_NULL_CONSTRAINT, DELTA_NON_DETERMINISTIC_FUNCTION_NOT_SUPPORTED, DELTA_OPERATION_NOT_ALLOWED, DELTA_OPERATION_NOT_ALLOWED_DETAIL, DELTA_OPERATION_NOT_SUPPORTED_FOR_COLUMN_WITH_COLLATION, DELTA_OPERATION_NOT_SUPPORTED_FOR_EXPRESSION_WITH_COLLATION, DELTA_OPERATION_ON_VIEW_NOT_ALLOWED, DELTA_TABLE_FOR_PATH_UNSUPPORTED_HADOOP_CONF, DELTA_TRUNCATE_TABLE_ PARTITION_NOT_SUPPORTED, DELTA_UNIFORM_INGRESS_NOT_SUPPORTED_FORMAT, DELTA_UNIFORM_NOT_SUPPORTED, DELTA_UNSUPPORTED_ABS_PATH_ADD_FILE, DELTA_UNSUPPORTED_ALTER_TABLE_CHANGE_COL_OP, DELTA_UNSUPPORTED_ALTER_TABLE_REPLACE_COL_OP, DELTA_UNSUPPORTED_CLONE_REPLACE_SAME_TABLE, DELTA_UNSUPPORTED_COLUMN_MAPPING_MODE_CHANGE, DELTA_UNSUPPORTED_COLUMN_MAPPING_SCHEMA_CHANGE, DELTA_UNSUPPORTED_COLUMN_MAPPING_WRITE, DELTA_UNSUPPORTED_COLUMN_TYPE_IN_BLOOM_FILTER, DELTA_UNSUPPORTED_COMMENT_MAP_ARRAY, DELTA_UNSUPPORTED_DATA_TYPES, DELTA_UNSUPPORTED_DROP_CLUSTERING_COLUMN, DELTA_UNSUPPORTED_DROP_COLUMN, DELTA_UNSUPPORTED_DROP_NESTED_COLUMN_FROM_NON_STRUCT_TYPE, DELTA_UNSUPPORTED_DROP_PARTITION_COLUMN, DELTA_UNSUPPORTED_FIELD_UPDATE_NON_ STRUCT, DELTA_UNSUPPORTED_INVARIANT_NON_STRUCT, DELTA_UNSUPPORTED_IN_SUBQUERY, DELTA_UNSUPPORTED_MANIFEST_GENERATION_WITH_COLUMN_MAPPING, DELTA_UNSUPPORTED_MULTI_COL_IN_PREDICATE, DELTA_UNSUPPORTED_NESTED_COLUMN_IN_BLOOM_FILTER, DELTA_UNSUPPORTED_NESTED_FIELD_IN_OPERATION, DELTA_UNSUPPORTED_NON_EMPTY_CLONE, DELTA_UNSUPPORTED_OUTPUT_MODE, DELTA_UNSUPPORTED_PARTITION_COLUMN_IN_BLOOM_FILTER, DELTA_UNSUPPORTED_RENAME_COLUMN, DELTA_UNSUPPORTED_SCHEMA_DURING_READ, DELTA_UNSUPPORTED_SUBQUERY, DELTA_UNSUPPORTED_SUBQUERY_IN_PARTITION_PREDICATES, DELTA_UNSUPPORTED_TIME_TRAVEL_VIEWS, DELTA_UNSUPPORTED_TYPE_CHANGE_IN_SCHEMA, DELTA_UNSUPPORTED_VACUUM_SPECIFIC_PARTITION, DELTA_UNSUPPORTED_ WRITES_WITHOUT_COORDINATOR, WRONG_COLUMN_DEFAULTS_FOR_DELTA_ALTER_TABLE_ADD_COLUMN_NOT_SUPPORTED
0AKDD Fitur memerlukan Delta
DELTA_COPY_INTO_TARGET_FORMAT, DELTA_IDENTITY_COLUMNS_ALTER_NON_DELTA_FORMAT, DELTA_IDENTITY_COLUMNS_NON_DELTA_FORMAT, DELTA_NOT_A_DELTA_TABLE, DELTA_ONLY_OPERATION, DELTA_TABLE_ONLY_OPERATION, DELTA_UNSUPPORTED_SOURCE, DELTA_UNSUPPORTED_STATIC_PARTITIONS, SYNC_METADATA_DELTA_ONLY, UNSUPPORTED_MANAGED_TABLE_CREATION
0AKDE Fitur tidak diaktifkan untuk tabel Delta ini
DELTA_CANNOT_DROP_CHECK_CONSTRAINT_FEATURE, DELTA_CLUSTERING_PHASE_OUT_FAILED, DELTA_DATA_CHANGE_FALSE, DELTA_FEATURES_PROTOCOL_METADATA_MISMATCH, DELTA_FEATURES_REQUIRE_MANUAL_ENABLEMENT, DELTA_FEATURE_DROP_CONFLICT_REVALIDATION_FAIL, DELTA_FEATURE_DROP_DEPENDENT_FEATURE, DELTA_FEATURE_DROP_FEATURE_NOT_PRESENT, DELTA_FEATURE_DROP_HISTORICAL_VERSIONS_EXIST, DELTA_FEATURE_DROP_HISTORY_TRUNCATION_NOT_ALLOWED, DELTA_FEATURE_DROP_NONREMOVABLE_FEATURE, DELTA_FEATURE_DROP_UNSUPPORTED_CLIENT_FEATURE, DELTA_FEATURE_DROP_WAIT_FOR_RETENTION_PERIOD, DELTA_FEATURE_REQUIRES_HIGHER_READER_VERSION, DELTA_FEATURE_REQUIRES_HIGHER_WRITER_VERSION, DELTA_UNSUPPORTED_FEATURE_STATUS, WRONG_COLUMN_DEFAULTS_FOR_DELTA_FEATURE_NOT_ENABLED
0AKUC Tidak didukung di Katalog Unity
CANNOT_SHALLOW_CLONE_NESTED, CANNOT_SHALLOW_CLONE_NON_UC_MANAGED_TABLE_AS_SOURCE_OR_TARGET, INVALID_SCHEME, PARTITION_METADATA, UC_BUCKETED_TABLES, UC_COMMAND_NOT_SUPPORTED, UC_COMMAND_NOT_SUPPORTED_IN_SHARED_ACCESS_MODE, UC_CREDENTIAL_PURPOSE_NOT_SUPPORTED, UC_DATASOURCE_NOT_SUPPORTED, UC_DATASOURCE_OPTIONS_NOT_SUPPORTED, UC_FAILED_PROVISIONING_ STATE, UC_FILE_SCHEME_FOR_TABLE_CREATION_NOT_SUPPORTED, UC_INVALID_NAMESPACE, UC_INVALID_REFERENCE, UPGRADE_NOT_SUPPORTED
0AKUD Fitur memerlukan Katalog Unity
FEATURE_REQUIRES_UC, OPERATION_REQUIRES_UNITY_CATALOG, SYNC_METADATA_NOT_SUPPORTED

Kelas 0B: inisiasi transaksi tidak valid

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
0B000 inisiasi transaksi tidak valid
DELTA_ACTIVE_TRANSACTION_ALREADY_SET

Kelas 0N: Kesalahan pemetaan SQL/XML

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
0N000 Kesalahan pemetaan SQL/XML
XML_UNSUPPORTED_NESTED_TYPES

Kelas 21: pelanggaran kardinalitas

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
21000 pelanggaran kardinalitas
BOOLEAN_STATEMENT_WITH_EMPTY_ROW, ROW_SUBQUERY_TOO_MANY_ROWS, SCALAR_SUBQUERY_TOO_MANY_ROWS
21506 Baris tabel yang sama tidak dapat menjadi target untuk lebih dari satu operasi pembaruan, hapus, atau sisipkan.
DELTA_MULTIPLE_SOURCE_ROW_MATCHING_TARGET_ROW_IN_MERGE
21S01 Sisipkan daftar nilai tidak cocok dengan daftar kolom
COPY_INTO_COLUMN_ARITY_MISMATCH, CREATE_VIEW_COLUMN_ARITY_MISMATCH, INSERT_COLUMN_ARITY_MISMATCH, INSERT_PARTITION_COLUMN_ARITY_MISMATCH

Kelas 22: pengecualian data

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
22000 pengecualian data
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 data string, pemotongan kanan
DELTA_EXCEED_CHAR_VARCHAR_LIMIT
22003 nilai numerik di luar rentang
ARITHMETIC_OVERFLOW, BINARY_ARITHMETIC_OVERFLOW, CAST_OVERFLOW, CAST_OVERFLOW_IN_TABLE_INSERT, DECIMAL_PRECISION_EXCEEDS_MAX_PRECISION, DELTA_CANNOT_RESTORE_TABLE_VERSION, DELTA_CANNOT_RESTORE_TIMESTAMP_EARLIER, DELTA_CANNOT_RESTORE_TIMESTAMP_GREATER, DELTA_CAST_OVERFLOW_IN_TABLE_WRITE, DELTA_INVALID_CDC_RANGE, INCORRECT_RAMP_UP_RATE, INVALID_ARRAY_INDEX, INVALID_ARRAY_INDEX_IN_ELEMENT_AT, INVALID_BITMAP_POSITION, INVALID_BOUNDARY, INVALID_INDEX_OF_ZERO, INVALID_NUMERIC_LITERAL_RANGE, NUMERIC_OUT_OF_SUPPORTED_RANGE, NUMERIC_VALUE_OUT_OF_RANGE, SCHEDULE_PERIOD_INVALID, SUM_OF_LIMIT_AND_OFFSET_EXCEEDS_MAX_INT
22004 nilai null tidak diperbolehkan
COMPARATOR_RETURNS_NULL, NULL_QUERY_STRING_EXECUTE_IMMEDIATE
22005 kesalahan dalam penugasan
DELTA_COMPLEX_TYPE_COLUMN_CONTAINS_NULL_TYPE, DELTA_FAILED_TO_MERGE_FIELDS, DELTA_MERGE_UNEXPECTED_ASSIGNMENT_KEY
22006 format interval tidak valid
CANNOT_PARSE_INTERVAL, DELTA_INVALID_INTERVAL, INVALID_INTERVAL_FORMAT
22007 format tanggalwaktu tidak valid
CANNOT_PARSE_TIMESTAMP, DELTA_INVALID_TIMESTAMP_FORMAT, INVALID_DATETIME_PATTERN
22008 meluapnya bidang datetime
DATETIME_OVERFLOW
2200E nilai null dalam target array
NULL_MAP_KEY
2200G jenis yang paling spesifik tidak cocok
DELTA_COLUMN_STRUCT_TYPE_MISMATCH
2200P nilai interval di luar rentang
DELTA_INVALID_CALENDAR_INTERVAL_EMPTY
22012 pembagian dengan nol
DIVIDE_BY_ZERO, INTERVAL_DIVIDED_BY_ZERO
22015 meluapnya bidang interval
INTERVAL_ARITHMETIC_OVERFLOW
22018 nilai karakter tidak valid untuk cast
CANNOT_PARSE_DECIMAL, CANNOT_PARSE_PROTOBUF_DESCRIPTOR, CAST_INVALID_INPUT, CONVERSION_INVALID_INPUT, DELTA_FAILED_CAST_PARTITION_VALUE, FAILED_PARSE_STRUCT_TYPE
2201B ekspresi reguler tidak valid
DELTA_REGEX_OPT_SYNTAX_ERROR
2201E argumen tidak valid untuk logaritma alami
STRUCT_ARRAY_LENGTH_MISMATCH
22022 luapan indikator
INVALID_CONF_VALUE
22023 nilai parameter tidak valid
AI_FUNCTION_INVALID_MODEL_PARAMETERS, CONFLICTING_PROVIDER, DELTA_INVALID_AUTO_COMPACT_TYPE, DELTA_INVALID_BUCKET_COUNT, DELTA_INVALID_BUCKET_INDEX, DELTA_UNSUPPORTED_STRATEGY_NAME, EMPTY_LOCAL_FILE_IN_STAGING_ACCESS_QUERY, EWKB_PARSE_ERROR, GEOJSON_PARSE_ERROR, H3_INVALID_CELL_ID, H3_INVALID_GRID_DISTANCE_VALUE, H3_INVALID_RESOLUTION_ VALUE, H3_PENTAGON_ENCOUNTERED_ERROR, H3_UNDEFINED_GRID_DISTANCE, INVALID_FRACTION_OF_SECOND, INVALID_PARAMETER_MARKER_VALUE, INVALID_PARAMETER_VALUE, INVALID_VARIANT_CAST, INVALID_VARIANT_FROM_PARQUET, INVALID_VARIANT_GET_PATH, MALFORMED_RECORD_IN_PARSING, MALFORMED_VARIANT, MAX_RECORDS_PER_FETCH_INVALID_FOR_KINESIS_SOURCE, METRIC_STORE_INVALID_ARGUMENT_VALUE_ERROR, ROW_VALUE_IS_NULL, RULE_ID_NOT_FOUND, SECOND_FUNCTION_ARGUMENT_NOT_INTEGER, ST_DIFFERENT_SRID_VALUES, ST_INVALID_ARGUMENT, ST_INVALID_ARGUMENT_TYPE, ST_INVALID_CRS_TRANSFORMATION_ERROR, ST_INVALID_ENDIANNESS_VALUE, ST_INVALID_GEOHASH_VALUE, ST_INVALID_PRECISION_VALUE, ST_INVALID_SRID_ NILAI, TABLE_VALUED_FUNCTION_REQUIRED_METADATA_INCOMPATIBLE_WITH_CALL, TABLE_VALUED_FUNCTION_REQUIRED_METADATA_INVALID, UNKNOWN_PRIMITIVE_TYPE_IN_VARIANT, VARIANT_CONSTRUCTOR_SIZE_LIMIT, VARIANT_DUPLICATE_KEY, VARIANT_SIZE_LIMIT, WKB_PARSE_ERROR, WKT_PARSE_ERROR, XML_WILDCARD_RESCUED_DATA_CONFLICT_ERROR
22024 untai (karakter) C yang tidak ditentukan
NULL_DATA_SOURCE_OPTION
22029 noncharacter dalam string UCS
INVALID_UTF8_STRING
22032 teks JSON tidak valid
AI_FUNCTION_INVALID_MAX_WORDS, AI_INVALID_ARGUMENT_VALUE_ERROR, INVALID_JSON_ROOT_FIELD, INVALID_JSON_SCHEMA_MAP_TYPE, REMOTE_FUNCTION_HTTP_RESULT_PARSE_ERROR
2203G item sql json tidak dapat dilemparkan ke jenis target
AI_FUNCTION_HTTP_PARSE_CAST_ERROR, AI_FUNCTION_HTTP_PARSE_COLUMNS_ERROR, AI_FUNCTION_MODEL_SCHEMA_PARSE_ERROR, CANNOT_PARSE_JSON_FIELD, FAILED_ROW_TO_JSON, INVALID_JSON_DATA_TYPE, INVALID_JSON_DATA_TYPE_FOR_COLLATIONS
22525 Nilai kunci partisi tidak valid.
DELTA_PARTITION_COLUMN_CAST_FAILED
22531 Argumen rutinitas bawaan atau sistem yang disediakan mengakibatkan kesalahan.
INVALID_SECRET_LOOKUP
22546 Nilai untuk argumen rutin tidak valid.
CANNOT_DECODE_URL, HLL_INVALID_INPUT_SKETCH_BUFFER, HLL_INVALID_LG_K, INVALID_BOOLEAN_STATEMENT
22KD1 URI atau PATH tidak valid
DELTA_CANNOT_RECONSTRUCT_PATH_FROM_URI, DELTA_CANNOT_RENAME_PATH, DELTA_INVALID_CLONE_PATH, DELTA_INVALID_PARTITION_PATH, INVALID_NON_ABSOLUTE_PATH
22KD2 Klaim identitas tidak diatur
OAUTH_CUSTOM_IDENTITY_CLAIM_NOT_PROVIDED
22KD3 Tidak dapat mengembangkan jenis sumber ke jenis target.
AVRO_INCOMPATIBLE_READ_TYPE, FROM_JSON_SCHEMA_EVOLUTION_FAILED
22P02 representasi teks tidak valid
INVALID_URL
22P03 representasi biner tidak valid
INVALID_BYTE_STRING

Kelas 23: pelanggaran batasan integritas

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
23001 membatasi pelanggaran
DELTA_VIOLATE_CONSTRAINT_WITH_VALUES
23502 Nilai sisipkan atau perbarui null, tetapi kolom tidak boleh berisi nilai null.
DELTA_MISSING_NOT_NULL_COLUMN_VALUE, DELTA_NOT_NULL_CONSTRAINT_VIOLATED
23505 Pelanggaran batasan yang diberlakukan oleh indeks unik atau batasan unik terjadi.
DUPLICATED_MAP_KEY, DUPLICATE_KEY
23512 Batasan pemeriksaan tidak dapat ditambahkan, karena tabel berisi baris yang tidak memenuhi definisi batasan.
DELTA_NEW_CHECK_CONSTRAINT_VIOLATION, DELTA_NEW_NOT_NULL_VIOLATION
23K01 Pelanggaran kardinalitas MERGE
MERGE_CARDINALITY_VIOLATION

Kelas 25: status transaksi tidak valid

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
25000 status transaksi tidak valid
COPY_INTO_DUPLICATED_FILES_COPY_NOT_ALLOWED, COPY_INTO_NON_BLIND_APPEND_NOT_ALLOWED, COPY_INTO_ROCKSDB_MAX_RETRY_EXCEEDED, DATA_LINEAGE_SECURE_VIEW_LEAF_NODE_HAS_NO_RELATION, DELTA_INVALID_ISOLATION_LEVEL, DELTA_MERGE_MATERIALIZE_SOURCE_FAILED_REPEATEDLY

Kelas 28: spesifikasi otorisasi tidak valid

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
28000 spesifikasi otorisasi tidak valid
DELTA_SHARING_INVALID_PROVIDER_AUTH, DELTA_SHARING_INVALID_RECIPIENT_AUTH

Kelas 2B: deskriptor hak istimewa dependen masih ada

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
2BP01 objek dependen masih ada
SCHEMA_NOT_EMPTY

Kelas 2D: penghentian transaksi tidak valid

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
2D521 SQL COMMIT atau ROLLBACK tidak valid di lingkungan operasi saat ini.
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 Pasca penerapan hook gagal.
DELTA_POST_COMMIT_HOOK_FAILED

Kelas 38: pengecualian rutin eksternal

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
38000 pengecualian rutin eksternal
CLASS_NOT_OVERRIDE_EXPECTED_METHOD, FAILED_FUNCTION_CALL, INVALID_UDF_IMPLEMENTATION, NO_UDF_INTERFACE, PYTHON_DATA_SOURCE_ERROR, PYTHON_STREAMING_DATA_SOURCE_RUNTIME_ERROR, TABLE_VALUED_FUNCTION_FAILED_TO_ANALYZE_IN_PYTHON

Kelas 39: pengecualian pemanggilan rutin eksternal

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
39000 pengecualian pemanggilan rutin eksternal
FAILED_EXECUTE_UDF, FLATMAPGROUPSWITHSTATE_USER_FUNCTION_ERROR, FOREACH_BATCH_USER_FUNCTION_ERROR, FOREACH_USER_FUNCTION_ERROR, UDF_PYSPARK_ERROR, UDF_PYSPARK_USER_CODE_ERROR, UDF_USER_CODE_ERROR

Kelas 3D: nama katalog tidak valid

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
3D000 nama katalog tidak valid
UC_CATALOG_NAME_NOT_PROVIDED

Kelas 40: pembatalan transaksi

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
40000 pembatalan transaksi
CONCURRENT_STREAM_LOG_UPDATE, DELTA_MAX_COMMIT_RETRIES_EXCEEDED

Kelas 42: kesalahan sintaks atau pelanggaran aturan akses

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
42000 kesalahan sintaks atau pelanggaran aturan akses
AMBIGUOUS_REFERENCE_TO_FIELDS, CF_AMBIGUOUS_AUTH_OPTIONS_ERROR, CF_AMBIGUOUS_INCREMENTAL_LISTING_MODE_ERROR, CF_AZURE_STORAGE_SUFFIXES_REQUIRED, CF_CLEAN_SOURCE_ALLOW_OVERWRITES_BOTH_ON, CF_EMPTY_DIR_FOR_SCHEMA_INFERENCE, CF_FAILED_TO_FIND_PROVIDER, CF_FILE_FORMAT_REQUIRED, CF_GCP_AUTHENTICATION, CF_INCORRECT_SQL_PARAMS, CF_INTERNAL_ERROR CF_INVALID_ARN, CF_INVALID_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_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, FOREIGN_OBJECT_NAME_CANNOT_BE_EMPTY, INVALID_COLUMN_OR_FIELD_DATA_TYPE, INVALID_EXTRACT_BASE_FIELD_TYPE, INVALID_ EXTRACT_FIELD_TYPE, INVALID_FIELD_NAME, INVALID_INLINE_TABLE, INVALID_SAVE_MODE, INVALID_SET_SYNTAX, INVALID_SQL_SYNTAX, INVALID_USAGE_OF_STAR_OR_REGEX, INVALID_WRITE_DISTRIBUTION, MATERIALIZED_VIEW_OVER_STREAMING_QUERY_INVALID, MISSING_CONNECTION_OPTION, MISSING_NAME_FOR_CHECK_CONSTRAINT, MULTIPLE_LOAD_ PATH, NAMESPACE_ALREADY_EXISTS, NAMESPACE_NOT_EMPTY, NAMESPACE_NOT_FOUND, NON_PARTITION_COLUMN, NOT_NULL_ASSERT_VIOLATION, NOT_NULL_CONSTRAINT_VIOLATION, NO_HANDLER_FOR_UDAF, NULLABLE_COLUMN_OR_FIELD, NULLABLE_ROW_ID_ATTRIBUTES, PS_INVALID_EMPTY_OPTION, PS_INVALID_OPTION, PS_INVALID_OPTION_ TYPE, PS_INVALID_READ_LIMIT, PS_MISSING_AUTH_INFO, PS_MISSING_REQUIRED_OPTION, PS_PROVIDE_CREDENTIALS_WITH_OPTION, PS_UNABLE_TO_CREATE_SUBSCRIPTION, ROUTINE_PARAMETER_NOT_FOUND, STREAMING_TABLE_QUERY_INVALID, UNSUPPORTED_BATCH_TABLE_VALUED_FUNCTION, UNSUPPORTED_CONSTRAINT_TYPE, UNSUPPORTED_STREAMING_TABLE_VALUED_ FUNCTION, VOLUME_ALREADY_EXISTS
42001 Kesalahan encoder tidak valid
INVALID_EXPRESSION_ENCODER
42501 ID otorisasi tidak memiliki hak istimewa untuk melakukan operasi yang ditentukan pada objek yang diidentifikasi.
CANNOT_READ_SENSITIVE_KEY_FROM_SECURE_PROVIDER, CF_CLEAN_SOURCE_UNAUTHORIZED_WRITE_PERMISSION, INSUFFICIENT_PERMISSIONS, INSUFFICIENT_PERMISSIONS_EXT_LOC, INSUFFICIENT_PERMISSIONS_NO_OWNER, INSUFFICIENT_PERMISSIONS_OWNERSHIP_SECURABLE, INSUFFICIENT_PERMISSIONS_SECURABLE, INSUFFICIENT_PERMISSIONS_SECURABLE_PARENT_OWNER, INSUFFICIENT_PERMISSIONS_STORAGE_CRED, INSUFFICIENT_PERMISSIONS_UNDERLYING_SECURABLES, INSUFFICIENT_PERMISSIONS_UNDERLYING_SECURABLES_VERBOSE, INVALID_S3_COPY_CREDENTIALS, UNAUTHORIZED_ACCESS
42601 Karakter, token, atau klausa tidak valid atau hilang.
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_ SKEMA, 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_ EKSPRESI, DELTA_UNKNOWN_PRIVILEGE, DELTA_UNKNOWN_READ_LIMIT, DELTA_UNRECOGNIZED_COLUMN_CHANGE, EVENT_LOG_REQUIRES_SHARED_COMPUTE, FROM_JSON_CONFLICTING_SCHEMA_UPDATES, FROM_JSON_CORRUPT_RECORD_COLUMN_IN_SCHEMA, FROM_JSON_CORRUPT_SCHEMA, FROM_JSON_INFERENCE_FAILED, FROM_JSON_INVALID_CONFIGURATION, GET_WARMUP_TRACING_FAILED, GET_WARMUP_TRACING_FUNCTION_NOT_ALLOWED, IDENTIFIER_TOO_MANY_NAME_PARTS, ILLEGAL_STATE_STORE_VALUE, INVALID_BUCKET_COLUMN_DATA_TYPE, INVALID_EXTRACT_FIELD, INVALID_FORMAT, INVALID_PARTITION_OPERATION, INVALID_SHARED_ALIAS_NAME, INVALID_STATEMENT_OR_CLAUSE, INVALID_WINDOW_SPEC_FOR_AGGREGATION_FUNC, LOCAL_MUST_WITH_SCHEMA_FILE, MV_ST_ALTER_QUERY_INCORRECT_BACKING_TYPE, NOT_ALLOWED_IN_FROM, NOT_A_CONSTANT_STRING, NOT_UNRESOLVED_ENCODER, PARSE_SYNTAX_ERROR, PROCEDURE_CREATION_PARAMETER_OUT_INOUT_WITH_DEFAULT, REF_DEFAULT_VALUE_IS_NOT_ALLOWED_IN_PARTITION, SORT_BY_WITHOUT_BUCKETING, SPECIFY_BUCKETING_IS_NOT_ALLOWED, SPECIFY_PARTITION_IS_NOT_ALLOWED, STDS_REQUIRED_OPTION_UNSPECIFIED, STREAMING_TABLE_OPERATION_NOT_ALLOWED, SYNTAX_DISCONTINUED, UC_EXTERNAL_VOLUME_MISSING_LOCATION, UC_LOCATION_FOR_MANAGED_VOLUME_NOT_SUPPORTED, UNCLOSED_BRACKETED_COMMENT, USER_DEFINED_FUNCTIONS, WINDOW_FUNCTION_WITHOUT_OVER_CLAUSE, WITH_CREDENTIAL, WRITE_STREAM_NOT_ALLOWED
42602 Karakter yang tidak valid dalam nama telah terdeteksi.
DATA_SOURCE_OPTION_CONTAINS_INVALID_CHARACTERS, INVALID_DELIMITER_VALUE, INVALID_IDENTIFIER, INVALID_PROPERTY_KEY, INVALID_PROPERTY_VALUE, INVALID_SCHEMA_OR_RELATION_NAME
42604 Konstanta numerik atau string yang tidak valid telah terdeteksi.
AS_OF_JOIN, DELTA_TIME_TRAVEL_INVALID_BEGIN_VALUE, EMPTY_JSON_FIELD_VALUE, INVALID_ESC, INVALID_ESCAPE_CHAR, INVALID_PIPELINE_ID, INVALID_STAGING_PATH_IN_STAGING_ACCESS_QUERY, INVALID_TYPED_LITERAL, INVALID_UUID
42605 Jumlah argumen yang ditentukan untuk fungsi skalar tidak valid.
INCORRECT_NUMBER_OF_ARGUMENTS, PROCEDURE_ARGUMENT_NUMBER_MISMATCH, WRONG_NUM_ARGS
42607 Operan fungsi agregat atau operator CONCAT tidak valid.
NESTED_AGGREGATE_FUNCTION
42608 Penggunaan NULL atau DEFAULT dalam NILAI atau pernyataan penugasan tidak valid.
DEFAULT_PLACEMENT_INVALID, NO_DEFAULT_COLUMN_VALUE_AVAILABLE
42611 Definisi kolom, argumen, parameter, atau variabel global tidak valid.
CANNOT_ASSIGN_EVENT_TIME_COLUMN_WITHOUT_WATERMARK, DELTA_IDENTITY_COLUMNS_ILLEGAL_STEP
42613 Klausul saling eksklusif.
COPY_INTO_FEATURE_INCOMPATIBLE_SETTING, DELTA_AMBIGUOUS_PATHS_IN_CREATE_TABLE, DELTA_CANNOT_SET_LOCATION_ON_PATH_IDENTIFIER, DELTA_CLONE_AMBIGUOUS_TARGET, DELTA_CLUSTERING_WITH_ZORDER_BY, DELTA_CLUSTER_BY_WITH_BUCKETING, DELTA_CLUSTER_BY_WITH_PARTITIONED_BY, DELTA_FILE_LIST_AND_PATTERN_STRING_CONFLICT, DELTA_IDENTITY_COLUMNS_WITH_GENERATED_EXPRESSION, DELTA_OVERWRITE_SCHEMA_WITH_DYNAMIC_PARTITION_OVERWRITE, DELTA_PARTITION_SCHEMA_IN_ICEBERG_TABLES, DELTA_REPLACE_WHERE_IN_OVERWRITE, DELTA_REPLACE_WHERE_WITH_DYNAMIC_PARTITION_OVERWRITE, DELTA_REPLACE_WHERE_WITH_FILTER_DATA_CHANGE_UNSET, DELTA_STARTING_VERSION_AND_TIMESTAMP_BOTH_SET, DELTA_TABLE_LOCATION_MISMATCH, DELTA_UNSUPPORTED_TIME_TRAVEL_MULTIPLE_FORMATS, INCOMPATIBLE_JOIN_TYPES, INVALID_JOIN_TYPE_FOR_JOINWITH, INVALID_LATERAL_JOIN_TYPE, INVALID_QUERY_MIXED_QUERY_PARAMETERS, INVALID_SINGLE_VARIANT_COLUMN, MANAGED_TABLE_WITH_CRED, MUTUALLY_EXCLUSIVE_CLAUSES, NON_LAST_MATCHED_CLAUSE_OMIT_CONDITION, NON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITION, NON_LAST_NOT_MATCHED_BY_TARGET_CLAUSE_OMIT_ KONDISI, STDS_CONFLICT_OPTIONS
42614 Kata kunci atau klausa duplikat tidak valid.
DELTA_MULTIPLE_CDC_BOUNDARY, DELTA_MULTIPLE_CONF_FOR_SINGLE_COLUMN_IN_BLOOM_FILTER, DUPLICATE_CLAUSES, REPEATED_CLAUSE
42616 Opsi yang ditentukan tidak valid
BIGQUERY_OPTIONS_ARE_MUTUALLY_EXCLUSIVE, DELTA_CANNOT_MODIFY_COORDINATED_COMMITS_DEPENDENCIES, DELTA_CANNOT_OVERRIDE_COORDINATED_COMMITS_CONFS, DELTA_CANNOT_SET_COORDINATED_COMMITS_DEPENDENCIES, DELTA_CANNOT_SET_MANAGED_STATS_COLUMNS_PROPERTY, DELTA_CANNOT_UNSET_COORDINATED_COMMITS_CONFS, DELTA_CONF_OVERRIDE_NOT_SUPPORTED_IN_COMMAND, DELTA_CONF_OVERRIDE_NOT_SUPPORTED_IN_SESSION, DELTA_ILLEGAL_OPTION, DELTA_INVALID_IDEMPOTENT_WRITES_OPTIONS, DELTA_MUST_SET_ALL_COORDINATED_COMMITS_CONFS_IN_COMMAND, DELTA_MUST_SET_ALL_COORDINATED_COMMITS_CONFS_IN_SESSION, DELTA_UNSET_NON_EXISTENT_PROPERTY, STDS_INVALID_OPTION_VALUE, UNSUPPORTED_COMMON_ANCESTOR_LOC_FOR_FILE_STREAM_SOURCE, UNSUPPORTED_INITIAL_POSITION_AND_TRIGGER_PAIR_FOR_KINESIS_SOURCE
42617 String pernyataan kosong atau kosong.
PARSE_EMPTY_STATEMENT
42621 Batasan pemeriksaan atau ekspresi kolom yang dihasilkan tidak valid.
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 Klausa DEFAULT tidak dapat ditentukan.
GENERATED_COLUMN_WITH_DEFAULT_VALUE, INVALID_DEFAULT_VALUE
42701 Target yang sama ditentukan lebih dari sekali untuk penugasan dalam pernyataan SQL yang sama.
DELTA_CONFLICT_SET_COLUMN, DELTA_DUPLICATE_COLUMNS_ON_INSERT, DELTA_DUPLICATE_COLUMNS_ON_UPDATE_TABLE, DELTA_DUPLICATE_DATA_SKIPPING_COLUMNS, DUPLICATE_ASSIGNMENTS, EXEC_IMMEDIATE_DUPLICATE_ARGUMENT_ALIASES
42702 Referensi kolom ambigu, karena nama duplikat.
AMBIGUOUS_COLUMN_OR_FIELD, AMBIGUOUS_COLUMN_REFERENCE, AMBIGUOUS_LATERAL_COLUMN_ALIAS, DELTA_AMBIGUOUS_PARTITION_COLUMN, EXCEPT_OVERLAPPING_COLUMNS
42703 Nama kolom atau parameter yang tidak ditentukan terdeteksi.
COLUMN_NOT_DEFINED_IN_TABLE, COLUMN_NOT_FOUND, DELTA_BLOOM_FILTER_DROP_ON_NON_EXISTING_COLUMNS, DELTA_CANNOT_CREATE_BLOOM_FILTER_NON_EXISTING_COL, DELTA_CANNOT_DROP_BLOOM_FILTER_ON_NON_INDEXED_COLUMN, DELTA_CANNOT_RESOLVE_COLUMN, DELTA_COLUMN_MAPPING_MAX_COLUMN_ID_NOT_SET, DELTA_COLUMN_MAPPING_MAX_COLUMN_ID_NOT_SET_CORRECTLY, DELTA_COLUMN_NOT_FOUND, DELTA_COLUMN_NOT_FOUND_IN_MERGE, DELTA_COLUMN_NOT_FOUND_IN_SCHEMA, DELTA_FAILED_FIND_ATTRIBUTE_IN_OUTPUT_COLUMNS, DELTA_MISSING_COLUMN, DELTA_MISSING_SET_COLUMN, DELTA_PARTITION_COLUMN_NOT_FOUND, DELTA_ZORDERING_COLUMN_DOES_NOT_EXIST, EXCEPT_RESOLVED_COLUMNS_WITHOUT_MATCH, EXCEPT_UNRESOLVED_COLUMN_IN_STRUCT_EXPANSION, UNRESOLVED_COLUMN, UNRESOLVED_FIELD, UNRESOLVED_MAP_KEY, UNRESOLVED_USING_COLUMN_FOR_JOIN, ZORDERBY_COLUMN_DOES_NOT_EXIST
42704 Objek atau nama batasan yang tidak ditentukan terdeteksi.
AMBIGUOUS_REFERENCE, CANNOT_RESOLVE_DATAFRAME_COLUMN, CANNOT_RESOLVE_STAR_EXPAND, CODEC_SHORT_NAME_NOT_FOUND, COLLATION_INVALID_NAME, COLLATION_INVALID_PROVIDER, DATA_SOURCE_NOT_EXIST, DEFAULT_DATABASE_NOT_EXISTS, DELTA_COLUMN_PATH_NOT_NESTED, DELTA_CONSTRAINT_DOES_NOT_EXIST, DELTA_SHARING_CURRENT_RECIPIENT_PROPERTY_UNDEFINED, DELTA_ SHARING_RECIPIENT_PROPERTY_NOT_FOUND, DELTA_SHARING_RECIPIENT_TOKENS_NOT_FOUND, ENCODER_NOT_FOUND, FIELD_NOT_FOUND, INDEX_NOT_FOUND, SCHEMA_NOT_FOUND, UC_VOLUME_NOT_FOUND, UNRECOGNIZED_SQL_TYPE
42710 Objek duplikat atau nama batasan terdeteksi.
ALTER_TABLE_COLUMN_DESCRIPTOR_DUPLICATE, CREATE_TABLE_COLUMN_DESCRIPTOR_DUPLICATE, DATA_SOURCE_ALREADY_EXISTS, DELTA_CONSTRAINT_ALREADY_EXISTS, DUPLICATED_METRICS_NAME, FIELD_ALREADY_EXISTS, FOUND_MULTIPLE_DATA_SOURCES, INDEX_ALREADY_EXISTS, LOCATION_ALREADY_EXISTS, MULTIPLE_XML_DATA_SOURCE, STATEFUL_PROCESSOR_CANNOT_REINITIALIZE_STATE_ON_KEY
42711 Nama kolom duplikat terdeteksi dalam definisi objek atau pernyataan ALTER TABLE.
COLUMN_ALREADY_EXISTS, DELTA_DUPLICATE_COLUMNS_FOUND, DELTA_TABLE_ALREADY_CONTAINS_CDC_COLUMNS, DUPLICATE_ROUTINE_RETURNS_COLUMNS
42713 Objek duplikat terdeteksi dalam daftar atau sama dengan objek yang ada.
DUPLICATED_FIELD_NAME_IN_ARROW_STRUCT, STATIC_PARTITION_COLUMN_IN_INSERT_COLUMN_LIST
42723 Rutinitas dengan tanda tangan yang sama sudah ada dalam skema, modul, atau blok gabungan tempat tanda tangan didefinisikan.
ROUTINE_ALREADY_EXISTS, VARIABLE_ALREADY_EXISTS
42734 Nama parameter duplikat, nama variabel SQL, label, atau nama kondisi terdeteksi.
COLUMN_MASKS_DUPLICATE_USING_COLUMN_NAME, COLUMN_MASKS_USING_COLUMN_NAME_SAME_AS_TARGET_COLUMN, DUPLICATE_ROUTINE_PARAMETER_NAMES, ROW_LEVEL_SECURITY_DUPLICATE_COLUMN_NAME
4274K Penggunaan argumen bernama tidak valid saat memanggil rutinitas.
DUPLICATE_ROUTINE_PARAMETER_ASSIGNMENT, NAMED_PARAMETERS_NOT_SUPPORTED, READ_FILES_AMBIGUOUS_ROUTINE_PARAMETERS, READ_TVF_UNEXPECTED_REQUIRED_PARAMETER, REQUIRED_PARAMETER_ALREADY_PROVIDED_POSITIONALLY, REQUIRED_PARAMETER_NOT_FOUND, RESCUED_DATA_COLUMN_CONFLICT_WITH_SINGLE_VARIANT, UNEXPECTED_POSITIONAL_ARGUMENT, UNKNOWN_POSITIONAL_ARGUMENT, UNRECOGNIZED_ PARAMETER_NAME
42802 Jumlah nilai target tidak sama dengan jumlah nilai sumber.
ASSIGNMENT_ARITY_MISMATCH, DELTA_INSERT_COLUMN_ARITY_MISMATCH, DELTA_INSERT_COLUMN_MISMATCH, STATEFUL_PROCESSOR_CANNOT_PERFORM_OPERATION_WITH_INVALID_HANDLE_STATE, STATEFUL_PROCESSOR_CANNOT_PERFORM_OPERATION_WITH_INVALID_TIME_MODE, STATEFUL_PROCESSOR_DUPLICATE_STATE_VARIABLE_DEFINED, STATEFUL_PROCESSOR_INCORRECT_TIME_MODE_TO_ASSIGN_TTL, STATEFUL_PROCESSOR_TTL_DURATION_MUST_BE_ POSITIF, STATEFUL_PROCESSOR_UNKNOWN_TIME_MODE, STATE_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_INITIALIZED, STATE_STORE_INCORRECT_NUM_ORDERING_COLS_FOR_RANGE_SCAN, STATE_STORE_INCORRECT_NUM_PREFIX_COLS_FOR_PREFIX_SCAN, STATE_STORE_NULL_TYPE_ORDERING_COLS_NOT_SUPPORTED, STATE_STORE_UNSUPPORTED_OPERATION_ON_MISSING_COLUMN_FAMILY, STATE_STORE_VARIABLE_SIZE_ORDERING_COLS_NOT_SUPPORTED, UDTF_ALIAS_NUMBER_MISMATCH, UDTF_INVALID_ALIAS_IN_REQUESTED_ORDERING_STRING_FROM_ANALYZE_METHOD, UDTF_INVALID_REQUESTED_SELECTED_EXPRESSION_FROM_ANALYZE_METHOD_REQUIRES_ALIAS
42803 Referensi kolom dalam klausa SELECT atau HAVING tidak valid, karena bukan kolom pengelompokan; atau referensi kolom dalam klausa GROUP BY tidak valid.
GROUPING_COLUMN_MISMATCH, GROUPING_ID_COLUMN_MISMATCH, MISSING_AGGREGATION, MISSING_GROUP_BY, UNRESOLVED_ALL_IN_GROUP_BY
42805 Bilangan bulat dalam klausa ORDER BY tidak mengidentifikasi kolom tabel hasil.
GROUP_BY_POS_OUT_OF_RANGE, ORDER_BY_POS_OUT_OF_RANGE
42806 Nilai tidak dapat ditetapkan ke variabel, karena jenis data tidak kompatibel.
DELTA_MERGE_INCOMPATIBLE_DECIMAL_TYPE
42807 Pernyataan perubahan data tidak diizinkan pada objek ini.
DELTA_CHANGE_TABLE_FEED_DISABLED, DELTA_UNSUPPORTED_WRITES_STAGED_TABLE
42808 Kolom yang diidentifikasi dalam operasi INSERT atau UPDATE tidak dapat diperbarui.
DELTA_IDENTITY_COLUMNS_EXPLICIT_INSERT_NOT_SUPPORTED, DELTA_IDENTITY_COLUMNS_UPDATE_NOT_SUPPORTED
42809 Objek yang diidentifikasi bukan tipe objek yang diterapkan pernyataan.
DELTA_CANNOT_DESCRIBE_VIEW_HISTORY, DELTA_CANNOT_MODIFY_APPEND_ONLY, DELTA_SHOW_PARTITION_IN_NON_PARTITIONED_TABLE, DELTA_TABLE_NOT_SUPPORTED_IN_OP, DELTA_UNSUPPORTED_DESCRIBE_DETAIL_VIEW, EXPECT_PERMANENT_VIEW_NOT_TEMP, EXPECT_TABLE_NOT_VIEW, EXPECT_VIEW_NOT_TABLE, FORBIDDEN_OPERATION, INVALID_DEST_CATALOG, INVALID_SOURCE_CATALOG, INVALID_UPGRADE_SYNTAX, NOT_A_PARTITIONED_TABLE, UNSUPPORTED_INSERT, WRONG_COMMAND_FOR_OBJECT_TYPE
42815 Jenis data, panjang, skala, nilai, atau CCSID tidak valid.
EMITTING_ROWS_OLDER_THAN_WATERMARK_NOT_ALLOWED
42816 Nilai atau durasi tanggalwaktu dalam ekspresi tidak valid.
DELTA_TIMESTAMP_GREATER_THAN_COMMIT, DELTA_TIMESTAMP_INVALID
42818 Operan operator atau fungsi tidak kompatibel atau sebanding.
INCOMPARABLE_PIVOT_COLUMN
42822 Ekspresi dalam klausa ORDER BY atau klausa GROUP BY tidak valid.
EXPRESSION_TYPE_IS_NOT_ORDERABLE, GROUP_EXPRESSION_TYPE_IS_NOT_ORDERABLE
42823 Beberapa kolom dikembalikan dari subkueri yang hanya mengizinkan satu kolom.
INVALID_SUBQUERY_EXPRESSION
42825 Baris UNION, INTERSECT, EXCEPT, atau VALUES tidak memiliki kolom yang kompatibel.
CANNOT_MERGE_INCOMPATIBLE_DATA_TYPE, INCOMPATIBLE_COLUMN_TYPE
42826 Baris UNION, INTERSECT, EXCEPT, atau VALUES tidak memiliki jumlah kolom yang sama.
NUM_COLUMNS_MISMATCH, NUM_TABLE_VALUE_ALIASES_MISMATCH
42830 Kunci asing tidak sesuai dengan deskripsi kunci induk.
FOREIGN_KEY_MISMATCH
42832 Operasi ini tidak diperbolehkan pada objek sistem.
BUILT_IN_CATALOG, CANNOT_DELETE_SYSTEM_OWNED, EVENT_LOG_UNSUPPORTED_TABLE_TYPE, MODIFY_BUILTIN_CATALOG, SAMPLE_TABLE_PERMISSIONS
42837 Kolom tidak dapat diubah, karena atributnya tidak kompatibel dengan atribut kolom saat ini.
DELTA_ALTER_TABLE_CHANGE_COL_NOT_SUPPORTED
42845 Penggunaan fungsi NOT DETERMINISTIC atau EXTERNAL ACTION tidak valid terdeteksi.
AGGREGATE_FUNCTION_WITH_NONDETERMINISTIC_EXPRESSION
42846 Transmisi dari jenis sumber ke jenis target tidak didukung.
CANNOT_CAST_DATATYPE, CANNOT_CONVERT_PROTOBUF_FIELD_TYPE_TO_SQL_TYPE, CANNOT_CONVERT_PROTOBUF_MESSAGE_TYPE_TO_SQL_TYPE, CANNOT_CONVERT_SQL_TYPE_TO_PROTOBUF_FIELD_TYPE, CANNOT_CONVERT_SQL_VALUE_TO_PROTOBUF_ENUM_TYPE, CANNOT_UP_CAST_DATATYPE, DELTA_UPDATE_SCHEMA_MISMATCH_EXPRESSION, EXPRESSION_DECODING_FAILED, EXPRESSION_ENCODING_FAILED, PARQUET_CONVERSION_ KEGAGALAN, UNEXPECTED_SERIALIZER_FOR_CLASS
42852 Hak istimewa yang ditentukan dalam GRANT atau REVOKE tidak valid atau tidak konsisten. (Misalnya, GRANT ALTER pada tampilan.)
INVALID_PRIVILEGE
42883 Tidak ada rutinitas yang ditemukan dengan tanda tangan yang cocok.
ROUTINE_NOT_FOUND, UNRESOLVABLE_TABLE_VALUED_FUNCTION, UNRESOLVED_ROUTINE, UNRESOLVED_VARIABLE, VARIABLE_NOT_FOUND
42887 Fungsi atau referensi tabel tidak valid dalam konteks di mana fungsi tersebut terjadi.
CYCLIC_FUNCTION_REFERENCE, DELTA_SHARING_INVALID_OP_IN_EXTERNAL_SHARED_VIEW, INVALID_CURRENT_RECIPIENT_USAGE, NOT_A_SCALAR_FUNCTION, NOT_A_TABLE_FUNCTION
42891 Batasan duplikat sudah ada.
MULTIPLE_MATCHING_CONSTRAINTS
428C4 Jumlah elemen di setiap sisi operator predikat tidak sama.
UNPIVOT_VALUE_SIZE_MISMATCH
428EK Kualifikasi skema tidak valid.
TEMP_VIEW_NAME_TOO_MANY_NAME_PARTS
428FR Kolom tidak dapat diubah seperti yang ditentukan.
CANNOT_ALTER_COLLATION_BUCKET_COLUMN, CANNOT_ALTER_PARTITION_COLUMN, DELTA_ALTER_COLLATION_NOT_SUPPORTED_BLOOM_FILTER, DELTA_ALTER_COLLATION_NOT_SUPPORTED_CLUSTER_BY
428FT Klausa partisi yang ditentukan pada CREATE atau ALTER tidak valid.
DELTA_CANNOT_USE_ALL_COLUMNS_FOR_PARTITION, PARTITIONS_ALREADY_EXIST, PARTITIONS_NOT_FOUND
428GU Tabel harus menyertakan setidaknya satu kolom yang tidak disembunyikan secara implisit.
DELTA_EMPTY_DATA, DELTA_READ_TABLE_WITHOUT_COLUMNS, DELTA_TARGET_TABLE_FINAL_SCHEMA_EMPTY
428H2 Jenis data tidak didukung dalam konteks tempat data digunakan.
DELTA_IDENTITY_COLUMNS_UNSUPPORTED_DATA_TYPE, EXCEPT_NESTED_COLUMN_INVALID_TYPE
428HD Pernyataan tidak dapat diproses karena masker kolom tidak dapat diterapkan atau definisi masker bertentangan dengan pernyataan.
QUERIED_TABLE_INCOMPATIBLE_WITH_COLUMN_MASK_POLICY, QUERIED_TABLE_INCOMPATIBLE_WITH_ROW_LEVEL_SECURITY_POLICY
42902 Objek INSERT, UPDATE, atau DELETE juga diidentifikasi (mungkin secara implisit melalui tampilan) dalam klausa FROM.
UNSUPPORTED_OVERWRITE
42903 Penggunaan fungsi agregat atau fungsi OLAP tidak valid.
DELTA_AGGREGATION_NOT_SUPPORTED, GROUP_BY_AGGREGATE, GROUP_BY_POS_AGGREGATE, INVALID_AGGREGATE_FILTER, INVALID_WHERE_CONDITION
42908 Pernyataan tidak menyertakan daftar kolom yang diperlukan.
DELTA_CLUSTER_BY_SCHEMA_NOT_PROVIDED, DELTA_SCHEMA_NOT_PROVIDED, SPECIFY_CLUSTER_BY_WITH_BUCKETING_IS_NOT_ALLOWED, SPECIFY_CLUSTER_BY_WITH_PARTITIONED_BY_IS_NOT_ALLOWED
42939 Nama tidak dapat digunakan, karena pengidentifikasi yang ditentukan dicadangkan untuk penggunaan sistem.
DELTA_CANNOT_CHANGE_PROVIDER, DELTA_CANNOT_MODIFY_TABLE_PROPERTY, DELTA_SHARING_CANNOT_MODIFY_RESERVED_RECIPIENT_PROPERTY, RESERVED_CDC_COLUMNS_ON_WRITE, ROUTINE_USES_SYSTEM_RESERVED_CLASS_NAME
42996 Kolom tertentu tidak boleh digunakan dalam kunci partisi.
DELTA_INVALID_PARTITION_COLUMN, DELTA_INVALID_PARTITION_COLUMN_NAME, DELTA_INVALID_PARTITION_COLUMN_TYPE
429BB Jenis data kolom, parameter, atau variabel SQL tidak didukung.
CANNOT_RECOGNIZE_HIVE_TYPE
429BQ Perubahan jenis atau atribut data yang ditentukan tidak diperbolehkan.
DELTA_AMBIGUOUS_DATA_TYPE_CHANGE, DELTA_CANNOT_CHANGE_DATA_TYPE, DELTA_CANNOT_UPDATE_ARRAY_FIELD, DELTA_CANNOT_UPDATE_MAP_FIELD, DELTA_CANNOT_UPDATE_OTHER_FIELD, DELTA_CANNOT_UPDATE_STRUCT_FIELD, DELTA_IDENTITY_COLUMNS_ALTER_COLUMN_NOT_SUPPORTED, DELTA_IDENTITY_COLUMNS_ALTER_NON_IDENTITY_COLUMN, DELTA_IDENTITY_COLUMNS_REPLACE_COLUMN_NOT_SUPPORTED
42K01 tipe data tidak sepenuhnya ditentukan
DATATYPE_MISSING_SIZE, INCOMPLETE_TYPE_DEFINITION
42K02 sumber data tidak ditemukan
DATA_SOURCE_NOT_FOUND, STREAM_NOT_FOUND_FOR_KINESIS_SOURCE
42K03 File tidak ditemukan
BATCH_METADATA_NOT_FOUND, CANNOT_LOAD_PROTOBUF_CLASS, CLOUD_FILE_SOURCE_FILE_NOT_FOUND, DATA_SOURCE_TABLE_SCHEMA_MISMATCH, DEFAULT_FILE_NOT_FOUND, DELTA_CHANGE_DATA_FILE_NOT_FOUND, DELTA_CHECKPOINT_NON_EXIST_TABLE, DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_TXN_LOG, DELTA_DELETED_PARQUET_FILE_NOT_FOUND, DELTA_EMPTY_DIRECTORY, DELTA_FILE_NOT_FOUND, DELTA_FILE_NOT_FOUND_DETAILED, DELTA_FILE_OR_DIR_NOT_FOUND, DELTA_FILE_TO_OVERWRITE_NOT_FOUND, DELTA_LOG_FILE_NOT_FOUND_FOR_STREAMING_SOURCE, DELTA_PATH_DOES_NOT_EXIST, DELTA_SHALLOW_CLONE_FILE_NOT_FOUND, DELTA_TRUNCATED_TRANSACTION_LOG, LOAD_DATA_PATH_NOT_EXISTS, PATH_NOT_FOUND, READ_CURRENT_FILE_NOT_FOUND, RENAME_SRC_PATH_NOT_ DITEMUKAN, STDS_FAILED_TO_READ_OPERATOR_METADATA, STDS_FAILED_TO_READ_STATE_SCHEMA, STREAMING_STATEFUL_OPERATOR_NOT_MATCH_IN_STATE_METADATA
42K04 File duplikat
DELTA_FILE_ALREADY_EXISTS, DELTA_LOG_ALREADY_EXISTS, DELTA_PATH_EXISTS, FAILED_RENAME_PATH, FILE_IN_STAGING_PATH_ALREADY_EXISTS, KINESIS_FETCHED_SHARD_LESS_THAN_TRACKED_SHARD, PARTITION_LOCATION_ALREADY_EXISTS, PATH_ALREADY_EXISTS
42K05 Nama tidak valid
CLEANROOM_INVALID_SHARED_DATA_OBJECT_NAME, COLUMN_MASKS_MULTI_PART_TARGET_COLUMN_NAME, COLUMN_MASKS_MULTI_PART_USING_COLUMN_NAME, DELTA_INVALID_CHARACTERS_IN_COLUMN_NAME, DELTA_INVALID_CHARACTERS_IN_COLUMN_NAMES, DELTA_INVALID_COLUMN_NAMES_WHEN_REMOVING_COLUMN_MAPPING, DELTA_NESTED_FIELDS_NEED_RENAME, DELTA_NON_SINGLE_PART_NAMESPACE_FOR_CATALOG, DELTA_SHARING_INVALID_ SHARED_DATA_OBJECT_NAME, INVALID_EMPTY_LOCATION, INVALID_LOCATION, REQUIRES_SINGLE_PART_NAMESPACE, ROW_LEVEL_SECURITY_MULTI_PART_COLUMN_NAME
42K06 Tipe tidak valid untuk opsi
DELTA_PROTOCOL_PROPERTY_NOT_INT, INVALID_OPTIONS, STATE_STORE_INVALID_CONFIG_AFTER_RESTART, STATE_STORE_INVALID_PROVIDER, STATE_STORE_INVALID_VARIABLE_TYPE_CHANGE, STATE_STORE_PROVIDER_DOES_NOT_SUPPORT_FINE_GRAINED_STATE_REPLAY
42K07 Bukan skema harfiah yang valid
INVALID_SCHEMA
42K08 Bukan konstanta
ARGUMENT_NOT_CONSTANT, INVALID_SQL_ARG, NON_FOLDABLE_ARGUMENT, NON_LITERAL_PIVOT_VALUES, SEED_EXPRESSION_IS_UNFOLDABLE
42K09 Ketidakcocokan tipe data
COMPLEX_EXPRESSION_UNSUPPORTED_INPUT, DATATYPE_MISMATCH, DELTA_CONSTRAINT_DATA_TYPE_MISMATCH, DELTA_CONSTRAINT_DEPENDENT_COLUMN_CHANGE, DELTA_GENERATED_COLUMNS_DATA_TYPE_MISMATCH, DELTA_GENERATED_COLUMNS_DEPENDENT_COLUMN_CHANGE, DELTA_GENERATED_COLUMNS_EXPR_TYPE_MISMATCH, DELTA_GENERATED_COLUMN_UPDATE_TYPE_MISMATCH, DELTA_MERGE_ADD_VOID_COLUMN, DELTA_MERGE_ INCOMPATIBLE_DATATYPE, DELTA_NOT_NULL_COLUMN_NOT_FOUND_IN_STRUCT, EVENT_TIME_IS_NOT_ON_TIMESTAMP_TYPE, INVALID_VARIABLE_TYPE_FOR_QUERY_EXECUTE_IMMEDIATE, PIVOT_VALUE_DATA_TYPE_MISMATCH, UNEXPECTED_INPUT_TYPE, UNPIVOT_VALUE_DATA_TYPE_MISMATCH
42K0A Klausa UNPIVOT tidak valid
UNPIVOT_REQUIRES_ATTRIBUTES, UNPIVOT_REQUIRES_VALUE_COLUMNS
42K0B Fitur warisan diblokir
INCONSISTENT_BEHAVIOR_CROSS_VERSION
42K0C Referensi ambigu ke batasan
AMBIGUOUS_CONSTRAINT, CANNOT_DROP_AMBIGUOUS_CONSTRAINT
42K0D Fungsi lambda tidak valid
INVALID_LAMBDA_FUNCTION_CALL
42K0E Ekspresi tidak valid dalam konteks yang digunakan
INVALID_LIMIT_LIKE_EXPRESSION, INVALID_NON_DETERMINISTIC_EXPRESSIONS, INVALID_OBSERVED_METRICS, INVALID_TIME_TRAVEL_SPEC, INVALID_TIME_TRAVEL_TIMESTAMP_EXPR, JOIN_CONDITION_IS_NOT_BOOLEAN_TYPE, MULTIPLE_TIME_TRAVEL_SPEC, MULTI_SOURCES_UNSUPPORTED_FOR_EXPRESSION, NO_MERGE_ACTION_SPECIFIED, ONLY_SECRET_FUNCTION_SUPPORTED_HERE, SECRET_FUNCTION_ INVALID_LOCATION, UNSUPPORTED_EXPR_FOR_OPERATOR, UNSUPPORTED_EXPR_FOR_PARAMETER, UNSUPPORTED_GENERATOR, UNSUPPORTED_GROUPING_EXPRESSION, UNSUPPORTED_MERGE_CONDITION, UNTYPED_SCALA_UDF, WINDOW_FUNCTION_AND_FRAME_MISMATCH
42K0F Objek yang bertahan tidak dapat mereferensikan objek sementara.
INVALID_TEMP_OBJ_REFERENCE
42K0G Protobuf tidak valid
PROTOBUF_DEPENDENCY_NOT_FOUND, PROTOBUF_DESCRIPTOR_FILE_NOT_FOUND, PROTOBUF_FIELD_MISSING, PROTOBUF_FIELD_MISSING_IN_SQL_SCHEMA, PROTOBUF_FIELD_TYPE_MISMATCH, PROTOBUF_MESSAGE_NOT_FOUND, PROTOBUF_TYPE_NOT_SUPPORT, RECURSIVE_PROTOBUF_SCHEMA, SCHEMA_REGISTRY_CONFIGURATION_ERROR, UNABLE_TO_CONVERT_TO_PROTOBUF_MESSAGE_TYPE, UNKNOWN_PROTOBUF_MESSAGE_ JENIS
42K0H Pemanggilan siklik telah terdeteksi.
RECURSIVE_VIEW
42K0I Konfigurasi SQL tidak ditemukan.
CONFIG_NOT_AVAILABLE, SQL_CONF_NOT_FOUND
42K0K Fungsi distribusi terbalik tidak valid
INVALID_INVERSE_DISTRIBUTION_FUNCTION
42K0L Penggunaan label tidak valid.
END_LABEL_WITHOUT_BEGIN_LABEL, INVALID_LABEL_USAGE, LABELS_MISMATCH
42K0M Deklarasi variabel tidak valid.
INVALID_VARIABLE_DECLARATION
42K10 Opsi dinamis tidak valid.
INVALID_DYNAMIC_OPTIONS
42KD0 Referensi nama ambigu.
AMBIGUOUS_ALIAS_IN_NESTED_CTE
42KD1 Operasi tidak didukung dalam mode sesi BACA SAJA.
OP_NOT_SUPPORTED_READ_ONLY
42KD2 Nama tabel sumber dan target dari operaton SYNC harus sama.
SYNC_SRC_TARGET_TBL_NOT_SAME
42KD3 Kolom tidak dapat ditambahkan seperti yang ditentukan.
DELTA_ADD_COLUMN_AT_INDEX_LESS_THAN_ZERO, DELTA_ADD_COLUMN_PARENT_NOT_STRUCT, DELTA_ADD_COLUMN_STRUCT_NOT_FOUND
42KD4 Operasi tidak didukung karena skema tabel telah berubah.
DELTA_BLOCK_COLUMN_MAPPING_AND_CDC_OPERATION, DELTA_STREAMING_INCOMPATIBLE_SCHEMA_CHANGE, DELTA_STREAMING_INCOMPATIBLE_SCHEMA_CHANGE_USE_SCHEMA_LOG
42KD5 Tidak dapat membuat file atau jalur.
DELTA_CANNOT_CREATE_LOG_PATH, PARTITION_LOCATION_IS_NOT_UNDER_TABLE_DIRECTORY
42KD6 Tidak ada informasi partisi yang ditemukan.
DELTA_CONVERSION_NO_PARTITION_FOUND, DELTA_MISSING_PARTITION_COLUMN, DELTA_MISSING_PART_FILES
42KD7 Tanda tangan tabel tidak cocok.
DELTA_CREATE_TABLE_SCHEME_MISMATCH, DELTA_CREATE_TABLE_WITH_DIFFERENT_CLUSTERING, DELTA_CREATE_TABLE_WITH_DIFFERENT_PARTITIONING, DELTA_CREATE_TABLE_WITH_DIFFERENT_PROPERTY, DELTA_SET_LOCATION_SCHEMA_MISMATCH
42KD8 Posisi kolom di luar rentang.
DELTA_DROP_COLUMN_AT_INDEX_LESS_THAN_ZERO, DELTA_INDEX_LARGER_OR_EQUAL_THAN_STRUCT, DELTA_INDEX_LARGER_THAN_STRUCT
42KD9 Tidak dapat menyimpulkan skema tabel.
CANNOT_MERGE_SCHEMAS, COPY_INTO_SOURCE_SCHEMA_INFERENCE_FAILED, DELTA_FAILED_INFER_SCHEMA, UNABLE_TO_INFER_SCHEMA
42KDA Gagal menggabungkan file ke dalam skema tabel.
DELTA_FAILED_MERGE_SCHEMA_FILE
42KDB URL tidak valid
DATA_SOURCE_URL_NOT_ALLOWED
42KDC Referensi file yang diarsipkan.
DELTA_ARCHIVED_FILES_IN_LIMIT, DELTA_ARCHIVED_FILES_IN_SCAN
42KDD Operasi yang tidak didukung dalam tampilan streaming.
UNEXPECTED_OPERATOR_IN_STREAMING_VIEW
42KDE Operasi yang tidak didukung pada himpunan data streaming.
CALL_ON_STREAMING_DATASET_UNSUPPORTED, CANNOT_CREATE_DATA_SOURCE_TABLE, INVALID_WRITER_COMMIT_MESSAGE, NON_TIME_WINDOW_NOT_SUPPORTED_IN_STREAMING, STREAMING_OUTPUT_MODE
42KDF Parameter rutin yang diperlukan tidak memiliki argumen.
MISSING_PARAMETER_FOR_KAFKA, MISSING_PARAMETER_FOR_ROUTINE, XML_ROW_TAG_MISSING
42KDG Skema target tidak kompatibel dengan data yang diserap.
COPY_INTO_SCHEMA_MISMATCH_WITH_TARGET_TABLE
42P01 tabel yang tidak ditentukan
DELTA_CANNOT_REPLACE_MISSING_TABLE, DELTA_MISSING_DELTA_TABLE, DELTA_MISSING_DELTA_TABLE_COPY_INTO, DELTA_NO_RELATION_TABLE, DELTA_TABLE_NOT_FOUND, TABLE_OR_VIEW_NOT_FOUND, TABLE_WITH_ID_NOT_FOUND, VIEW_NOT_FOUND
42P02 parameter yang tidak ditentukan
UNBOUND_SQL_PARAMETER
42P06 skema duplikat
SCHEMA_ALREADY_EXISTS
42P07 tabel duplikat
DELTA_TABLE_ALREADY_EXISTS, TABLE_OR_VIEW_ALREADY_EXISTS, TEMP_TABLE_OR_VIEW_ALREADY_EXISTS, VIEW_ALREADY_EXISTS
42P08 parameter ambigu
CATALOG_NOT_FOUND
42P10 referensi kolom tidak valid
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 tipe data yang tidak ditentukan
DELTA_NULL_SCHEMA_IN_STREAMING_WRITE
42P20 kesalahan windowing
MISSING_WINDOW_SPECIFICATION, UNSUPPORTED_EXPR_FOR_WINDOW
42P21 ketidakcocokan kolab
COLLATION_MISMATCH
42P22 penyusunan yang tidak ditentukan
INDETERMINATE_COLLATION
42S22 Kolom tidak ditemukan
NO_SQL_TYPE_IN_PROTOBUF_SCHEMA

Kelas 44: dengan pelanggaran opsi centang

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
44000 dengan pelanggaran opsi centang
DELTA_REPLACE_WHERE_MISMATCH

Kelas 46: Java DDL 1

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
46103 nama kelas yang belum terselesaikan
CANNOT_LOAD_FUNCTION_CLASS
46110 fitur yang tidak didukung
CANNOT_MODIFY_CONFIG
46121 nama kolom tidak valid
INVALID_COLUMN_NAME_AS_PATH

Kelas 51: Status Aplikasi Tidak Valid

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
51024 Objek tidak dapat digunakan, karena telah ditandai tidak operasi.
INCOMPATIBLE_VIEW_SCHEMA_CHANGE

Kelas 53: sumber daya tidak mencukup

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
53200 kehabisan memori
EXECUTOR_BROADCAST_JOIN_OOM, UNABLE_TO_ACQUIRE_MEMORY

Kelas 54: batas program terlampaui

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
54000 batas program terlampaui
COLLECTION_SIZE_LIMIT_EXCEEDED, DELTA_CLUSTER_BY_INVALID_NUM_COLUMNS, DELTA_SHARING_MAXIMUM_RECIPIENT_TOKENS_EXCEEDED, GROUPING_SIZE_LIMIT_EXCEEDED, RELATION_LARGER_THAN_8G
54001 Pernyataan terlalu panjang atau terlalu kompleks.
FAILED_TO_PARSE_TOO_COMPLEX
54006 String hasil terlalu panjang.
EXCEED_LIMIT_LENGTH, KRYO_BUFFER_OVERFLOW
54023 terlalu banyak argumen
TABLE_VALUED_FUNCTION_TOO_MANY_TABLE_ARGUMENTS
54K00 Kedalaman maksimum tampilan berlapis terlampaui.
VIEW_EXCEED_MAX_NESTED_DEPTH
54KD0 Jumlah UDF maksimum dalam rencana kueri terlampaui.
UDF_LIMITS, UDF_MAX_COUNT_EXCEEDED
54KD1 Jumlah objek maksimum dalam sesi terlampaui.
MAX_NUMBER_VARIABLES_IN_SESSION_EXCEEDED

Kelas 55: objek tidak dalam status prasyarat

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
55019 Objek dalam status tidak valid untuk operasi.
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

Kelas 56: Lain-lain SQL atau Kesalahan Produk

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
56000 Lain-lain SQL atau Kesalahan Produk
CHECKPOINT_RDD_BLOCK_ID_NOT_FOUND
56038 Fitur yang diminta tidak didukung di lingkungan ini.
AI_FUNCTION_UNSUPPORTED_ERROR, ANSI_CONFIG_CANNOT_BE_DISABLED, CF_MANAGED_FILE_EVENTS_ONLY_ON_SERVERLESS, CLUSTER_BY_AUTO_REQUIRES_CLUSTERING_FEATURE_ENABLED, CLUSTER_BY_AUTO_REQUIRES_PREDICTIVE_OPTIMIZATION, CLUSTER_BY_AUTO_UNSUPPORTED_TABLE_TYPE_ERROR, CODEC_NOT_AVAILABLE, COLUMN_MASKS_NOT_ENABLED, DATABRICKS_DELTA_NOT_ENABLED, DELTA_MISSING_ICEBERG_CLASS, DELTA_UNRECOGNIZED_INVARIANT, DELTA_UNSUPPORTED_FEATURES_FOR_READ, DELTA_UNSUPPORTED_FEATURES_FOR_WRITE, DELTA_UNSUPPORTED_FEATURES_IN_CONFIG, DLT_EXPECTATIONS_NOT_SUPPORTED, DLT_VIEW_CLUSTER_BY_NOT_SUPPORTED, DLT_VIEW_LOCATION_NOT_SUPPORTED, DLT_VIEW_SCHEMA_WITH_TYPE_NOT_SUPPORTED, DLT_VIEW_TABLE_CONSTRAINTS_NOT_SUPPORTED, FEATURE_NOT_ENABLED, FEATURE_NOT_ON_CLASSIC_WAREHOUSE, FEATURE_UNAVAILABLE, GET_TABLES_BY_TYPE_UNSUPPORTED_BY_HIVE_VERSION, INCOMPATIBLE_DATASOURCE_REGISTER, MATERIALIZED_VIEW_OPERATION_NOT_ALLOWED, METRIC_STORE_UNSUPPORTED_ERROR, NATIVE_XML_DATA_SOURCE_NOT_ENABLED, STREAMING_TABLE_NOT_SUPPORTED, UC_HIVE_METASTORE_FEDERATION_CROSS_CATALOG_VIEW_NOT_SUPPORTED, UC_ LAKEHOUSE_FEDERATION_WRITES_NOT_ALLOWED, UC_NOT_ENABLED, UC_QUERY_FEDERATION_NOT_ENABLED, UC_SERVICE_CREDENTIALS_NOT_ENABLED, UC_VOLUMES_NOT_ENABLED, UC_VOLUMES_SHARING_NOT_ENABLED, UNSUPPORTED_TIMESERIES_COLUMNS
56098 Terjadi kesalahan selama pengikatan ulang implisit, kompilasi ulang, atau validasi ulang.
UC_INVALID_DEPENDENCIES
56K00 Kesalahan Spark Connect
SAMBUNG

Kelas 57: intervensi operator

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
57012 Sumber daya non-database tidak tersedia. Ini tidak akan memengaruhi keberhasilan eksekusi pernyataan berikutnya.
REMOTE_FUNCTION_HTTP_FAILED_ERROR, REMOTE_FUNCTION_HTTP_RESULT_UNEXPECTED_ERROR, REMOTE_FUNCTION_HTTP_RETRY_TIMEOUT, REMOTE_FUNCTION_MISSING_REQUIREMENTS_ERROR

Kelas 58: Kesalahan sistem

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
58000 Kesalahan sistem
CLOUD_PROVIDER_ERROR
58030 Kesalahan I/O
CANNOT_LOAD_STATE_STORE, CANNOT_RESTORE_PERMISSIONS_FOR_PATH, CANNOT_WRITE_STATE_STORE, FAILED_RENAME_TEMP_FILE, INVALID_BUCKET_FILE, TASK_WRITE_FAILED, UNABLE_TO_FETCH_HIVE_TABLES

Kelas 82: kehabisan memori

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
82100 kehabisan memori (tidak dapat mengalokasikan)
DELTA_BLOOM_FILTER_OOM_ON_WRITE

Kelas F0: kesalahan file konfigurasi

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
F0000 kesalahan file konfigurasi
DELTA_INCONSISTENT_LOGSTORE_CONFS, DELTA_INVALID_LOGSTORE_CONF, DELTA_UNKNOWN_CONFIGURATION, INVALID_DRIVER_MEMORY, INVALID_EXECUTOR_MEMORY, INVALID_KRYO_SERIALIZER_BUFFER_SIZE

Kelas HV: Kondisi khusus FDW

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
HV000 Kondisi khusus FDW
FAILED_JDBC
HV091 pengidentifikasi bidang deskriptor tidak valid
NONEXISTENT_FIELD_NAME_IN_LIST

Kelas HY: Kondisi khusus CLI

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
HY000 Kondisi khusus CLI
INVALID_HANDLE
HY008 operasi dibatalkan
AQE_THREAD_INTERRUPTED, OPERATION_CANCELED, SPARK_JOB_CANCELLED
HY109 posisi kursor tidak valid
INVALID_CURSOR

Kelas KD: kesalahan spesifik sumber data

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
KD000 kesalahan spesifik sumber data
DC_API_QUOTA_EXCEEDED, DC_CONNECTION_ERROR, DC_DYNAMICS_API_ERROR, DC_NETSUITE_ERROR, DC_SERVICENOW_API_ERROR, DC_SFDC_BULK_QUERY_JOB_INCOMPLETE, DC_SHAREPOINT_API_ERROR, DC_SOURCE_API_ERROR, DC_WORKDAY_RAAS_API_ERROR, END_OFFSET_HAS_GREATER_OFFSET_FOR_TOPIC_PARTITION_THAN_LATEST_WITH_TRIGGER_AVAILABLENOW, END_OFFSET_HAS_GREATER_OFFSET_FOR_TOPIC_ PARTITION_THAN_PREFETCHED, FAILED_REGISTER_CLASS_WITH_KRYO, GRAPHITE_SINK_INVALID_PROTOCOL, GRAPHITE_SINK_PROPERTY_MISSING, INCOMPATIBLE_DATA_FOR_TABLE, LOST_TOPIC_PARTITIONS_IN_END_OFFSET_WITH_TRIGGER_AVAILABLENOW, MALFORMED_AVRO_MESSAGE, MALFORMED_CSV_RECORD, MISMATCHED_TOPIC_PARTITIONS_BETWEEN_END_OFFSET_AND_PREFETCHED
KD001 Tidak dapat membaca footer file
DELTA_FAILED_READ_FILE_FOOTER, FAILED_READ_FILE
KD002 Versi tak terduga
DELTA_FAILED_SCAN_WITH_HISTORICAL_VERSION, DELTA_MISSING_CHANGE_DATA, DELTA_STREAMING_CANNOT_CONTINUE_PROCESSING_POST_SCHEMA_EVOLUTION, DELTA_STREAMING_CHECK_COLUMN_MAPPING_NO_SNAPSHOT
KD003 Akses yang salah ke jenis data
CANNOT_READ_ARCHIVED_FILE, CANNOT_READ_FILE, DELTA_FOUND_MAP_TYPE_COLUMN, DELTA_INCORRECT_ARRAY_ACCESS, DELTA_INCORRECT_ARRAY_ACCESS_BY_NAME, UNKNOWN_FIELD_EXCEPTION
KD004 Kesalahan versi protokol 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 Tabel harus menyertakan setidaknya satu kolom non partisi
ALL_PARTITION_COLUMNS_NOT_ALLOWED, DELTA_NON_PARTITION_COLUMN_ABSENT
KD006 Tidak ada penerapan yang ditemukan di jalur log
DELTA_NO_COMMITS_FOUND, DELTA_NO_RECREATABLE_HISTORY_FOUND, STDS_COMMITTED_BATCH_UNAVAILABLE, STDS_NO_PARTITION_DISCOVERED_IN_STATE_STORE, STDS_OFFSET_LOG_UNAVAILABLE, STDS_OFFSET_METADATA_LOG_UNAVAILABLE
KD007 Tanda tangan tabel diubah
DELTA_SCHEMA_CHANGED, DELTA_SCHEMA_CHANGED_WITH_STARTING_OPTIONS, DELTA_SCHEMA_CHANGED_WITH_VERSION, DELTA_SCHEMA_CHANGE_SINCE_ANALYSIS, DELTA_TABLE_ID_MISMATCH
KD008 Tanda tangan tabel tidak diatur
DELTA_SCHEMA_NOT_SET
KD009 Partisi tidak cocok
CONFLICTING_PARTITION_COLUMN_NAMES, DELTA_UNEXPECTED_NUM_PARTITION_COLUMNS_FROM_FILE_NAME, DELTA_UNEXPECTED_PARTITION_COLUMN_FROM_FILE_NAME, DELTA_UNEXPECTED_PARTITION_SCHEMA_FROM_USER
KD00A Pemindaian parsial yang tidak terduga
DELTA_UNEXPECTED_PARTIAL_SCAN
KD00B File tidak dikenal
DELTA_UNRECOGNIZED_LOGFILE, ERROR_READING_AVRO_UNKNOWN_FINGERPRINT
KD00C Penerapan versi tidak bersebelahan
DELTA_VERSIONS_NOT_CONTIGUOUS
KD00D Statistik diperlukan
DELTA_ZORDERING_ON_COLUMN_WITHOUT_STATS
KD00E kegagalan validasi fitur tabel
DELTA_ICEBERG_COMPAT_VIOLATION, DELTA_UNIFORM_ICEBERG_INGRESS_VIOLATION, DELTA_UNIVERSAL_FORMAT_CONVERSION_FAILED, DELTA_UNIVERSAL_FORMAT_VIOLATION
KD00F kesalahan permintaan cloud
HDFS_HTTP_ERROR, NATIVE_IO_ERROR
KD010 kegagalan sumber data eksternal
DATA_SOURCE_EXTERNAL_ERROR

Kelas P0: kesalahan logika prosedural

SQLSTATE Deskripsi dan mengeluarkan kelas kesalahan
P0001 memunculkan pengecualian
USER_RAISED_EXCEPTION, USER_RAISED_EXCEPTION_PARAMETER_MISMATCH, USER_RAISED_EXCEPTION_UNKNOWN_ERROR_CLASS