@balajip Hi thank you for your answer. For the student table it is working but for the table i create using Join operation, i get the same error: Here is the query i used: CREATE TABLE testjoin as SELECT * FROM table1 t1 FULL JOIN table2 t2 ON t1.bu_id = t2.bu_id; The table is created but when i do Select from that table: testjoin, i get the same error: Error: Error while compiling statement: FAILED: RuntimeException java.lang.NullPointerException (state=42000,code=40000) What could be the reason? P.S I started having this issue since past 3 days now. Before it was working. I also reinstalled Hive but it didn't work.
... View more
