Amazon
Web Services
Microsoft Azure
Google Cloud PlatformUNSUPPORTED_FEATURE error class
The feature is not supported:
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>.
INSERT_PARTITION_SPEC_IF_NOT_EXISTS
INSERT INTO <tableName> with IF NOT EXISTS in the PARTITION spec.
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_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>.
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.
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.
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.
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.
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_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_WITH_POSITIONAL_PARAMETERS
Positional parameters are not supported with 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”.