INVALID_SQL_SYNTAX error class

SQLSTATE: 42000

Invalid SQL syntax:

ANALYZE_TABLE_DELTA_STATS_UNEXPECTED_TOKEN

ANALYZE TABLE(S) … COMPUTE DELTA STATISTICS <ctx> doesn’t support: FOR ALL COLUMNS, FOR COLUMNS, NOSCAN, and PARTITION clauses.

ANALYZE_TABLE_UNEXPECTED_NOSCAN

ANALYZE TABLE(S) … COMPUTE STATISTICS … <ctx> must be either NOSCAN or empty.

COMMENT_ON_COLUMN_INCORRECT_IDENTIFIER

COMMENT ON COLUMN requires an identifier with at least two parts. Please qualify the column with table or view name.

CREATE_FUNC_WITH_GENERATED_COLUMNS_AS_PARAMETERS

CREATE FUNCTION with generated columns as parameters is not allowed.

CREATE_OR_REFRESH_WITH_SYNC_AND_ASYNC

SYNC and ASYNC cannot be specified together.

CREATE_ROUTINE_WITH_IF_NOT_EXISTS_AND_REPLACE

Cannot create a routine with both IF NOT EXISTS and REPLACE specified.

CREATE_TEMP_FUNC_WITH_DATABASE

CREATE TEMPORARY FUNCTION with specifying a database(<database>) is not allowed.

CREATE_TEMP_FUNC_WITH_IF_NOT_EXISTS

CREATE TEMPORARY FUNCTION with IF NOT EXISTS is not allowed.

EMPTY_PARTITION_VALUE

Partition key <partKey> must set value.

FUNCTION_WITH_UNSUPPORTED_SYNTAX

The function <prettyName> does not support <syntax>.

INVALID_COLUMN_REFERENCE

Expected a column reference for transform <transform>: <expr>.

INVALID_TABLE_FUNCTION_IDENTIFIER_ARGUMENT_MISSING_PARENTHESES

Syntax error: call to table-valued function is invalid because parentheses are missing around the provided TABLE argument <argumentName>; please surround this with parentheses and try again.

INVALID_TABLE_VALUED_FUNC_NAME

Table valued function cannot specify database name: <funcName>.

INVALID_WINDOW_REFERENCE

Window reference <windowName> is not a window specification.

LATERAL_WITHOUT_SUBQUERY_OR_TABLE_VALUED_FUNC

LATERAL can only be used with subquery and table-valued functions.

MULTI_PART_NAME

<statement> with multiple part name(<name>) is not allowed.

OPTION_IS_INVALID

option or property key <key> is invalid; only <supported> are supported

OPTION_WITH_UDF_IS_INVALID

option or property key <key> is invalid; user-defined functions are not allowed

REPETITIVE_WINDOW_DEFINITION

The definition of window <windowName> is repetitive.

SHOW_FUNCTIONS_INVALID_PATTERN

Invalid pattern in SHOW FUNCTIONS: <pattern>. It must be a “STRING” literal.

SHOW_FUNCTIONS_INVALID_SCOPE

SHOW <scope> FUNCTIONS not supported.

TRANSFORM_WRONG_NUM_ARGS

The transform`<transform> requires <expectedNum> parameters but the actual number is <actualNum>`.

UNRESOLVED_WINDOW_REFERENCE

Cannot resolve window reference <windowName>.

UNSUPPORTED_FUNC_NAME

Unsupported function name <funcName>.

UNSUPPORTED_SQL_STATEMENT

Unsupported SQL statement: <sqlText>.

VARIABLE_TYPE_OR_DEFAULT_REQUIRED

The definition of a SQL variable requires either a datatype or a DEFAULT clause.

For example, use DECLARE name STRING or DECLARE name = 'SQL' instead of DECLARE name.