Jaa


STREAMING_TABLE_OPERATION_NOT_ALLOWED error class

SQLSTATE: 42601

The operation <operation> is not allowed:

APPLY_CHANGES_UNSUPPORTED_OPERATION

The operation is not supported on APPLY CHANGES Streaming Tables.

CREATE_OR_REPLACE

REPLACE is not allowed for Streaming Tables; please update the command to use CREATE OR REFRESH instead and then retry the command.

CREATE_TABLE_IN_HIVE_METASTORE

Cannot CREATE a streaming table in the Hive Metastore. Streaming tables are only supported in Unity Catalog. Please specify a destination catalog for this table in your Unity Catalog metastore by USE CATALOG catalogName; CREATE STREAMING TABLE schemaName.tableName or CREATE STREAMING TABLE catalogName.schemaName.tableName. You can see a list of available catalogs by SHOW CATALOGS.

DROP_DELTA_LIVE_TABLE

The operation does not apply to Streaming Tables created from Delta Live Tables, instead remove the Streaming Table from the pipeline definition in Delta Live Tables.

INVALID_ALTER

To alter the schema or properties of Streaming Tables, please use the CREATE OR REFRESH command.

NON_STREAMING_TABLE

<tableName> is not a Streaming Table.

REFRESH_DELTA_LIVE_TABLE

The operation does not apply to Streaming Tables created from Delta Live Tables, instead refresh the Streaming Table in Delta Live Tables.

REQUIRES_SHARED_COMPUTE

Cannot <operation> a Streaming Table <tableName> from an Assigned or No isolation shared cluster, please use a SHARED cluster or a Databricks SQL warehouse instead.

UNKNOWN_FEATURES

Streaming Table <tableName> supports features from newer versions. Please run this <operation> operation on a newer release.

UNSUPPORTED_OPERATION

The operation is not supported on Streaming Tables.