Skip to main content

UNSUPPORTED_FEATURE error condition

SQLSTATE: 0A000

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.

CATALOG_OPERATION​

Catalog <catalogName> does not support <operation>.

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.

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.

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.

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.

LAMBDA_FUNCTION_WITH_EXTERNAL_UDF​

Lambda function with External UDF <funcName> in a higher order function.

LAMBDA_FUNCTION_WITH_PYTHON_UDF​

Lambda function with Python UDF <funcName> in a higher order function.

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_JOIN_USING​

JOIN USING with LATERAL correlation.

LITERAL_TYPE​

Literal for '<value>' of <type>.

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_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.

REMOVE_NAMESPACE_COMMENT​

Remove a comment from the namespace <namespace>.

REPLACE_NESTED_COLUMN​

The replace function does not support nested column <colName>.

SET_NAMESPACE_PROPERTY​

<property> is a reserved namespace property, <msg>.

SET_OPERATION_ON_MAP_TYPE​

Cannot have MAP type columns in DataFrame which calls set operations (INTERSECT, EXCEPT, etc.), but the type of column <colName> is <dataType>.

SET_OPERATION_ON_VARIANT_TYPE​

Cannot have VARIANT type columns in DataFrame which calls set operations (INTERSECT, EXCEPT, etc.), but the type of column <colName> is <dataType>.

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.

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 now 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.

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".

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.

TIME_TRAVEL​

Time travel on the relation: <relationId>.

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.

WRITE_FOR_BINARY_SOURCE​

Write for the binary file data source.

Last updated on