Re: Hive update question

Overwrite your table by taking left join with another table. Let me know if you want any syntactical help. On 14-Feb-2018 12:54 PM, "Andy Srine" wrote: > Hi Team, > > Whats the best way to do an update on one table from another? Variations > of this syntax below doesn't seem to work: > > UPDATE

Hive update question

Hi Team, Whats the best way to do an update on one table from another? Variations of this syntax below doesn't seem to work: UPDATE table_x SET column_1 = B.column_1 FROM table_y B WHERE column_2 = B.column_2 ; Thanks, Andy

Running commands on Hive on Tez failed with NPE

Hi Hive community, I recently encountered with a problem while running command in Hive on Tez as execution engine. The command failed with below stack trace Exception in thread "main" java.lang.RuntimeException: java.lang.NullPointerException at org.apache.hadoop.hive.ql.session.Sessio