INVALID_SQL_SYNTAX error condition
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 the table or view name (for example, table.column, database.table.column, or catalog.database.table.column).
CREATE_FUNC_WITH_COLUMN_CONSTRAINTS
CREATE FUNCTION with constraints on parameters is not allowed.
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.
CREATE_TEMP_TABLE_USING_PROVIDER
CREATE TEMPORARY TABLE ... USING ... is a deprecated syntax. To create a temporary table, please remove the USING clause and retry. To create a temporary view, please use CREATE TEMPORARY VIEW instead.
DUPLICATE_JSON_TABLE_COLUMN
JSON_TABLE has duplicate column name <columnName>. Column names in the COLUMNS clause must be unique.
EMPTY_IN_PREDICATE
IN predicate requires at least one value. Empty IN clauses like 'IN ()' are not allowed. Consider using 'WHERE FALSE' if you need an always-false condition, or provide at least one value in the IN list.
EMPTY_PARTITION_VALUE
Partition key <partKey> must set value.
EMPTY_QUANTIFIED_PATTERN
Expected something between '(' and ')'.
EMPTY_REFRESH_RESOURCE_PATH
Resource paths cannot be empty in REFRESH statements. Use / to match everything.
FUNCTION_WITH_UNSUPPORTED_SYNTAX
The function <prettyName> does not support <syntax>.
INVALID_COLUMN_REFERENCE
Expected a column reference for transform <transform>: <expr>.
INVALID_REFRESH_RESOURCE_PATH
REFRESH statements cannot contain ' ', '\n', '\r', '\t' inside unquoted resource paths.
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_FUNCTION_TABLE_ARGUMENT_PARTITIONING
The table function call includes a table argument with an invalid partitioning/ordering specification: the <clause> clause included multiple expressions without parentheses surrounding them; please add parentheses around these expressions and then retry the query again.
INVALID_TABLE_VALUED_FUNC_NAME
Table valued function cannot specify database name: <funcName>.
INVALID_WINDOW_FRAME_BOUND
Frame bound value must be a literal.
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.
MATCH_RECOGNIZE_CLASSIFIER_INVALID_ARGUMENT
CLASSIFIER() argument must be a pattern variable name (for example, CLASSIFIER(A)), but found <argument>. Arbitrary expressions are not permitted.
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_ROW_FORMAT_LINES_TERMINATED_BY
LINES TERMINATED BY only supports newline '\n' right now: <value>.
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.