SYNTAX_DISCONTINUED error class
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”.