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”.