INVALID_SQL_SYNTAX error class
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
.