https://community.cloudera.com/t5/Support-Questions/SemanticException-at-beeline-when-NULL/m-p/241451#M203254 <P>Hi</P><P>When i do a SELECT null; at cli hive i get a good answer -&gt; NULL</P><P>when i do this in beeline , i get </P><P>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)<BR /><BR /></P><P>this is working on one of my clusters but not in one of them </P><P>(hdp 2.6.1 </P><P>Connected to: Apache Hive (version 2.1.0.2.6.1.0-129)<BR />Driver: Hive JDBC (version 1.2.1000.2.6.1.0-129)<BR />Transaction isolation: TRANSACTION_REPEATABLE_READ<BR />Beeline version 1.2.1000.2.6.1.0-129 by Apache Hive<BR /><BR /></P><P>)</P><P>i need this to work, since when i query </P><P> INSERT OVERWRITE TABLE schema.customer<BR />SELECT CUST_ACCOUNTS<BR />otherschema.CUST_ACCOUNT_ID,<BR />NULL AS ACCOUNT<BR />FROM xxxx ;</P><P><BR /></P>i really appreciate any help<BR /><P><BR /></P><P> </P><P><BR /></P> Fri, 31 May 2019 21:41:11 GMT MarceloSaiedOK 2019-05-31T21:41:11Z https://community.cloudera.com/t5/Support-Questions/SemanticException-at-beeline-when-NULL/m-p/241451#M203254 <P>Hi</P><P>When i do a SELECT null; at cli hive i get a good answer -&gt; NULL</P><P>when i do this in beeline , i get </P><P>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)<BR /><BR /></P><P>this is working on one of my clusters but not in one of them </P><P>(hdp 2.6.1 </P><P>Connected to: Apache Hive (version 2.1.0.2.6.1.0-129)<BR />Driver: Hive JDBC (version 1.2.1000.2.6.1.0-129)<BR />Transaction isolation: TRANSACTION_REPEATABLE_READ<BR />Beeline version 1.2.1000.2.6.1.0-129 by Apache Hive<BR /><BR /></P><P>)</P><P>i need this to work, since when i query </P><P> INSERT OVERWRITE TABLE schema.customer<BR />SELECT CUST_ACCOUNTS<BR />otherschema.CUST_ACCOUNT_ID,<BR />NULL AS ACCOUNT<BR />FROM xxxx ;</P><P><BR /></P>i really appreciate any help<BR /><P><BR /></P><P> </P><P><BR /></P> Fri, 31 May 2019 21:41:11 GMT https://community.cloudera.com/t5/Support-Questions/SemanticException-at-beeline-when-NULL/m-p/241451#M203254 MarceloSaiedOK 2019-05-31T21:41:11Z https://community.cloudera.com/t5/Support-Questions/SemanticException-at-beeline-when-NULL/m-p/241452#M203255 <P>the fix is to set this: `set hive.support.sql11.reserved.keywords=true;`</P> Fri, 31 May 2019 22:57:55 GMT https://community.cloudera.com/t5/Support-Questions/SemanticException-at-beeline-when-NULL/m-p/241452#M203255 MarceloSaiedOK 2019-05-31T22:57:55Z