UNSUPPORTED_FEATURE error condition
The feature is not supported:
AES_MODE
AES-<mode> with the padding <padding> by the <functionName> function.
AES_MODE_AAD
<functionName> with AES-<mode> does not support additional authenticate data (AAD).
AES_MODE_IV
<functionName> with AES-<mode> does not support initialization vectors (IVs).
AI_FUNCTION
AI function <functionName> is only available in Interactive Workloads, Jobs, SQL Pro and SQL Serverless, or it's disabled explicitly.
AI_FUNCTION_PREVIEW
AI function <functionName> is in preview and currently disabled in this environment.
ALTER_TABLE_SERDE_FOR_DATASOURCE_TABLE
ALTER TABLE SET SERDE is not supported for table <tableName> created with the datasource API. Consider using an external Hive table or updating the table properties with compatible options for your table format.
ANALYZE_UNCACHED_TEMP_VIEW
The ANALYZE TABLE FOR COLUMNS command can operate on temporary views that have been cached already. Consider to cache the view <viewName>.
ANALYZE_UNSUPPORTED_COLUMN_TYPE
The ANALYZE TABLE FOR COLUMNS command does not support the type <columnType> of the column <columnName> in the table <tableName>.
ANALYZE_VIEW
The ANALYZE TABLE command does not support views.
ASOF_JOIN
SQL ASOF JOIN syntax. Set <config> to true to enable it.
BIN_BY
The BIN BY relation operator is not yet supported.
CATALOG_INTERFACE_METHOD
Catalog API <methodName> is not supported by <catalogClass>.
CATALOG_LEVEL_COLLATIONS
Default collation for the specified catalog.
CATALOG_LEVEL_COLLATIONS_UNSUPPORTED_FOR_SHARED_CATALOG
Default collation is not supported for shared catalog.
CATALOG_OPERATION
Catalog <catalogName> does not support <operation>.
CHANGE_DATA_CAPTURE
Catalog <catalogName> does not support Change Data Capture (CDC).
CHANGE_DATA_CAPTURE_ON_RELATION
Relation <relationId> does not support Change Data Capture (CDC).
CLAUSE_WITH_PIPE_OPERATORS
The SQL pipe operator syntax using |> does not support <clauses>.
COLLATION
Collation is not yet supported.
COLLATIONS_IN_MAP_KEYS
Collated strings for keys of maps
COMBINATION_QUERY_RESULT_CLAUSES
Combination of ORDER BY/SORT BY/DISTRIBUTE BY/CLUSTER BY.
COMMENT_NAMESPACE
Attach a comment to the namespace <namespace>.
CONTINUE_EXCEPTION_HANDLER
CONTINUE exception handler is not supported. Use EXIT handler.
COUNTER_DIFF_WINDOW_FUNCTION
Window function <function> is currently disabled.
CREATE_FLOW_QUERY_EXECUTION
Direct execution of a CREATE FLOW statement is not supported. To create a flow, create and execute a pipeline with a SQL file containing your statement attached in the pipeline spec.
CREATE_PIPELINE_DATASET_QUERY_EXECUTION
Direct execution of a CREATE ... <pipelineDatasetType> query. To create a pipeline dataset, create and execute a pipeline with a SQL file containing your query attached in the pipeline definition.
CREATE_STREAMING_TABLE_FLOW_AUTO_CDC_IDENTIFIER_EXPRESSION_NOT_SUPPORTED
IDENTIFIER expressions are not supported with FLOW AUTO CDC syntax. Use a simple table name instead.
CREATE_TABLE_STAGING_LOCATION
Create a catalog table in a staging location.
DESC_JSON_TABLE_TYPE
DESCRIBE AS JSON not supported for table type of <tableName>. Please try again without the AS JSON clause.
DESC_TABLE_COLUMN_JSON
DESC TABLE COLUMN AS JSON not supported for individual columns.
DESC_TABLE_COLUMN_PARTITION
DESC TABLE COLUMN for a specific partition.
DISTRIBUTE_BY
DISTRIBUTE BY clause.
DROP_DATABASE
Drop the default database <database>.
DROP_NAMESPACE
Drop the namespace <namespace>.
DROP_NAMESPACE_CASCADE
Drop namespace cascade is not supported in <provider> catalogs.
ENVIRONMENT_NOT_ALLOWED
Environment clause is not supported in this context.
EXPLAIN_PROFILE_ON_STREAMING_QUERY
EXPLAIN PROFILE is not supported for streaming queries.
EXTERNAL_UDF
External UDF expressions are disabled. Set <config> to true to enable planning.
EXTERNAL_UDF_IN_ON_CLAUSE
External UDF in the ON clause of a <joinType> JOIN. In case of an INNER JOIN consider rewriting to a CROSS JOIN with a WHERE clause.
EXTERNAL_UDF_WITH_MULTIPLE_CHILDREN
External UDF <funcName> uses columns from more than one input relation. Rewrite the query so the UDF is evaluated after the inputs are combined.
EXTERNAL_UDF_WITH_UNSUPPORTED_PYTHON_RUNNER_STATE
External UDF execution does not support the following Python runner state: <unsupportedFields>.
GEO_TYPE_IN_OPERATION
<operation> is unsupported for <dataType>.
GET_DIAGNOSTICS
GET DIAGNOSTICS command is not supported.
HIVE_TABLE_TYPE
The <tableName> is hive <tableType>.
HIVE_WITH_ANSI_INTERVALS
Hive table <tableName> with ANSI intervals.
INSERT_PARTITION_SPEC_IF_NOT_EXISTS
INSERT INTO <tableName> with IF NOT EXISTS in the PARTITION spec.
INTERRUPT_TYPE
Unsupported interrupt type: <interruptType>.
ISOLATION_CLAUSE_NOT_SUPPORTED
ISOLATION clause is not supported for <feature>.
LAMBDA_FUNCTION_WITH_EXTERNAL_UDF
Lambda function with External UDF <funcName> in a higher order function.
LAMBDA_FUNCTION_WITH_PYTHON_UDF
Cannot evaluate the Python UDF <funcName> inside the lambda of a higher-order function.
This placement is not supported. Rewrite the query so the UDF is applied outside the lambda.
LATERAL_COLUMN_ALIAS_IN_AGGREGATE_FUNC
Referencing a lateral column alias <lca> in the aggregate function <aggFunc>.
LATERAL_COLUMN_ALIAS_IN_AGGREGATE_WITH_WINDOW_AND_HAVING
Referencing lateral column alias <lca> in the aggregate query both with window expressions and with having clause. Please rewrite the aggregate query by removing the having clause or removing lateral alias reference in the SELECT list.
LATERAL_COLUMN_ALIAS_IN_GENERATOR
Referencing a lateral column alias <lca> in generator expression <generatorExpr>.
LATERAL_COLUMN_ALIAS_IN_GROUP_BY
Referencing a lateral column alias via GROUP BY alias/ALL is not supported yet.
LATERAL_COLUMN_ALIAS_IN_WINDOW
Referencing a lateral column alias <lca> in window expression <windowExpr>.
LATERAL_COLUMN_ALIAS_ON_IMPLICITLY_GENERATED_ALIAS
Referencing lateral column alias <lca> is not allowed because <implicitAlias> is not an explicit alias. In order to be able able to reference it, please assign an explicit alias to <implicitAlias>.
LATERAL_JOIN_NEAREST_BY
LATERAL correlation with NEAREST BY clause.
LATERAL_JOIN_USING
JOIN USING with LATERAL correlation.
LITERAL_TYPE
Literal for '<value>' of <type>.
MATCH_RECOGNIZE_ROWS_PER_MATCH_MODE
MATCH_RECOGNIZE with <mode>.
MATCH_RECOGNIZE_SUBSET
MATCH_RECOGNIZE SUBSET clause is only supported by the Photon engine.
MATERIALIZED_VIEW_WITH_SCHEMA_BINDING_MODE
materialized views cannot be created with the WITH SCHEMA clause. Recreate the materialized view when the underlying schema changes, or use a persisted view.
MULTIPLE_BUCKET_TRANSFORMS
Multiple bucket TRANSFORMs.
MULTI_ACTION_ALTER
The target JDBC server hosting table <tableName> does not support ALTER TABLE with multiple actions. Split the ALTER TABLE up into individual actions to avoid this error.
OBJECT_LEVEL_COLLATIONS
Default collation for the specified object.
ORC_TYPE_CAST
Unable to convert <orcType> of Orc to data type <toType>.
OVERWRITE_BY_SUBQUERY
INSERT OVERWRITE with a subquery condition.
PANDAS_UDAF_IN_PIVOT
Pandas user defined aggregate function in the PIVOT clause.
PARAMETER_MARKER_IN_UNEXPECTED_STATEMENT
Parameter markers are not allowed in <statement>.
PARTITION_BY_FILE
Cannot use FILE type expressions to partition a DataFrame, but the type of expression <expr> is <dataType>.
PARTITION_BY_VARIANT
Cannot use VARIANT producing expressions to partition a DataFrame, but the type of expression <expr> is <dataType>.
PARTITION_WITH_NESTED_COLUMN_IS_UNSUPPORTED
Invalid partitioning: <cols> is missing or is in a map or array.
PIPE_OPERATOR_AGGREGATE_UNSUPPORTED_CASE
The SQL pipe operator syntax with aggregation (using |> AGGREGATE) does not support <case>.
PIVOT_AFTER_GROUP_BY
PIVOT clause following a GROUP BY clause. Consider pushing the GROUP BY into a subquery.
PIVOT_TYPE
Pivoting by the value '<value>' of the column data type <type>.
PURGE_PARTITION
Partition purge.
PURGE_TABLE
Purge table.
PYTHON_DATA_SOURCE
Python data sources.
PYTHON_UDF_IN_ON_CLAUSE
Python UDF in the ON clause of a <joinType> JOIN. In case of an INNER JOIN consider rewriting to a CROSS JOIN with a WHERE clause.
QUERY_ONLY_CORRUPT_RECORD_COLUMN
Queries from raw JSON/CSV/XML files are disallowed when the
referenced columns only include the internal corrupt record column
(named _corrupt_record by default). For example:
spark.read.schema(schema).json(file).filter($"_corrupt_record".isNotNull).count()
and spark.read.schema(schema).json(file).select("_corrupt_record").show().
Instead, you can cache or save the parsed results and then send the same query.
For example, val df = spark.read.schema(schema).json(file).cache() and then
df.filter($"_corrupt_record".isNotNull).count().
REMOVE_NAMESPACE_COMMENT
Remove a comment from the namespace <namespace>.
REPLACE_NESTED_COLUMN
The replace function does not support nested column <colName>.
ROLLING_WINDOW_OPERATOR
Rolling window operator is not enabled. Set <config> to true to enable this feature.
SCHEMA_LEVEL_COLLATIONS
Default collation for the specified schema.
SESSION_LEVEL_COLLATIONS
Setting a non-UTF8_BINARY collation as the session default collation.
SESSION_TEMP_VOLUME
session-temp volume.
SET_NAMESPACE_PROPERTY
<property> is a reserved namespace property, <msg>.
SET_OPERATION_ON_FILE_TYPE
Cannot have FILE type columns in a DataFrame that calls set operations (INTERSECT, EXCEPT, etc.), but the type of column <colName> is <dataType>.
SET_OPERATION_ON_MAP_TYPE
Cannot have MAP type columns in a set operation (INTERSECT, EXCEPT, etc.), but the type of column <colName> is <dataType>.
SET_OPERATION_ON_MEASURE
Set operation (UNION, INTERSECT, EXCEPT) on measure column <colName>.
SET_OPERATION_ON_VARIANT_TYPE
Cannot have VARIANT type columns in a set operation (INTERSECT, EXCEPT, etc.), but the type of column <colName> is <dataType>.
SET_PATH_WHEN_DISABLED
SET PATH is disabled. Set <config> to true to enable it.
SET_PROPERTIES_AND_DBPROPERTIES
set PROPERTIES and DBPROPERTIES at the same time.
SET_TABLE_PROPERTY
<property> is a reserved table property, <msg>.
SET_VARIABLE_USING_SET
<variableName> is a VARIABLE and cannot be updated using the SET statement. Use SET VARIABLE <variableName> = ... instead.
SHOW_TABLE_EXTENDED_JSON_WITH_PARTITION
SHOW TABLE EXTENDED with PARTITION does not support AS JSON output.
SQL_CURSOR
SQL cursor operations (DECLARE CURSOR, OPEN, FETCH, CLOSE) are not supported.
SQL_SCRIPTING
SQL Scripting is under development and not all features are supported. SQL Scripting enables users to write procedural SQL including control flow and error handling. To enable existing features set <sqlScriptingEnabled> to true.
SQL_SCRIPTING_DROP_TEMPORARY_VARIABLE
DROP TEMPORARY VARIABLE is not supported within SQL scripts. To bypass this, use EXECUTE IMMEDIATE 'DROP TEMPORARY VARIABLE ...' .
SQL_SCRIPTING_WITH_ATOMIC_BODY
Atomic transaction blocks in SQL Scripting are currently in development. To enable existing features set <sqlScriptingAtomicBodyEnabled> to true.
SQL_SCRIPTING_WITH_ATOMIC_BODY_IN_EXCEPTION_HANDLERS
Atomic transaction blocks within exception handlers in SQL Scripting are not allowed.
SQL_SCRIPTING_WITH_EXCEPTION_HANDLERS_IN_ATOMIC_BODY
Exception handlers within an atomic transaction block in SQL Scripting are not allowed.
SQL_SCRIPTING_WITH_NESTED_ATOMIC_BODY
Nested atomic transaction blocks in SQL Scripting are currently not allowed.
SQL_SCRIPTING_WITH_NESTED_BODIES_IN_ATOMIC
Nested compound bodies within an atomic transaction block in SQL Scripting are currently not allowed.
SQL_SCRIPTING_WITH_POSITIONAL_PARAMETERS
Positional parameters are not supported with SQL Scripting.
SQL_SCRIPTING_WITH_UNSUPPORTED_COMMANDS_IN_ATOMIC_BODY
Command <command> is currently unsupported in Atomic blocks. Only DML commands (such as INSERT, UPDATE, DELETE, MERGE), SELECT and variable assignments are allowed within atomic transaction blocks in SQL Scripting.
STATE_STORE_MULTIPLE_COLUMN_FAMILIES
Creating multiple column families with <stateStoreProvider> is not supported.
STATE_STORE_REMOVING_COLUMN_FAMILIES
Removing column families with <stateStoreProvider> is not supported.
STATE_STORE_TTL
State TTL with <stateStoreProvider> is not supported. Please use RocksDBStateStoreProvider.
STORE_BACKEND_NOT_SUPPORTED_FOR_ROLLING_WINDOW
Store backend <stateStoreProvider> is not supported by RollingWindow operator. Please use RocksDBStateStoreProvider.
STORE_BACKEND_NOT_SUPPORTED_FOR_TWS
Store backend <stateStoreProvider> is not supported by TransformWithState operator. Please use RocksDBStateStoreProvider.
TABLEREF_PROCEDURE_PARAM_NON_SQL
TABLEREF parameter <paramName> is only supported in SQL stored procedures.
TABLEREF_VARIABLE
TABLEREF is not supported in this environment.
TABLESAMPLE_SYSTEM
TABLESAMPLE SYSTEM is only supported by data sources that implement block-level sampling.
TABLESAMPLE_SYSTEM_NO_SCAN
TABLESAMPLE SYSTEM requires a direct reference to a data source table that supports block-level sampling. It cannot be applied to subqueries, views, or tables with intervening operations.
TABLESAMPLE_SYSTEM_REPEATABLE
TABLESAMPLE SYSTEM does not support the REPEATABLE clause. Use TABLESAMPLE BERNOULLI for repeatable sampling with a seed.
TABLESAMPLE_SYSTEM_SAMPLE_METHOD
TABLESAMPLE SYSTEM does not support <sampleMethod> sampling. Only PERCENT sampling is supported.
TABLE_OPERATION
Table <tableName> does not support <operation>. Please check the current catalog and namespace to make sure the qualified table name is expected, and also check the catalog implementation which is configured by "spark.sql.catalog".
TARGET_FRESHNESS
Target freshness syntax is not supported.
TEMPORARY_VIEW_WITH_SCHEMA_BINDING_MODE
Temporary views cannot be created with the WITH SCHEMA clause. Recreate the temporary view when the underlying schema changes, or use a persisted view.
TEMP_VARIABLE_ON_DBSQL
Temporary variables are not yet supported for queries from SQL warehouses.
TIMESTAMP_NANOS_WITH_LEGACY_TIME_PARSER
Parsing or formatting nanosecond-precision timestamps (TIMESTAMP_LTZ/TIMESTAMP_NTZ with precision in [7, 9]) under the LEGACY time parser policy. Set <config> to CORRECTED.
TIME_TRAVEL
Time travel on the relation: <relationId>.
TIME_TRAVEL_AT_SYNTAX
Time travel using the '@' suffix in table names. Set <config> to true to enable it.
TOO_MANY_TYPE_ARGUMENTS_FOR_UDF_CLASS
UDF class with <num> type arguments.
TRANSFORM_DISTINCT_ALL
TRANSFORM with the DISTINCT/ALL clause.
TRANSFORM_NON_HIVE
TRANSFORM with SERDE is only supported in hive mode.
TRIM_COLLATION
TRIM specifier in the collation.
UPDATE_COLUMN_NULLABILITY
Update column nullability for MySQL and MS SQL Server.
V1_DATA_SOURCE_OPERATION
V1 Data Source <operation> is not supported for table <tableIdentifier>.
WRITE_FOR_BINARY_SOURCE
Write for the binary file data source.
WRITE_FOR_FILE_SOURCE
Write for the file reference data source.