SemanticException at beeline when NULL

[#1]

Hi

When i do a SELECT null; at cli hive i get a good answer -> NULL

when i do this in beeline , i get

Error: Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 1:7 Invalid table alias or column reference 'null': (possible column names are: ) (state=42000,code=10004)

this is working on one of my clusters but not in one of them

(hdp 2.6.1

Connected to: Apache Hive (version 2.1.0.2.6.1.0-129)
Driver: Hive JDBC (version 1.2.1000.2.6.1.0-129)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.2.1000.2.6.1.0-129 by Apache Hive

)

i need this to work, since when i query

INSERT OVERWRITE TABLE schema.customer
SELECT CUST_ACCOUNTS
otherschema.CUST_ACCOUNT_ID,
NULL AS ACCOUNT
FROM xxxx ;

i really appreciate any help

[#2 · Accepted solution]

the fix is to set this: `set hive.support.sql11.reserved.keywords=true;`