SYNTAX_DISCONTINUED error class

SQLSTATE: 42601

Support of the clause or keyword: <clause> has been discontinued in this context.

BANG_EQUALS_NOT

The ‘!’ keyword is only supported as an alias for the prefix operator ‘NOT’.

Use the ‘NOT’ keyword instead for infix clauses such as NOT LIKE, NOT IN, NOT BETWEEN, etc.

To re-enable the ‘!’ keyword, set “spark.sql.legacy.bangEqualsNot” to “true”.

INVALID_VIEW_COLUMN_SPEC

CREATE VIEW supports column lists with column names and column comments.

Do not use column type-definition, NOT NULL, or DEFAULT.

To accept but ignore these options, set “spark.sql.legacy.expandedViewColumnListSyntax” to “true”.