Skip to content
Advertisement

Tag: hive-query

Hive Union of two queries is giving compile error

I am not sure what is wrong with following hive query. However, it’s throwing error. I am able to run this queries individually. However, facing issues while running with union Error Answer Hive versions prior to 1.2.0 only support UNION ALL Workaround: Use UNION ALL instead of UNION, wrap all into subquery and apply distinct UNION is the same as

Hive nested query left join

I’am new to hive and i want to implement the following query It works fine untill the last left join. Nested queries are obviously not authorized in hive. How can i approach this. Answer Use sub-query instead of joined table: Or better move last join condition inside the WHERE clause in the subquery:

Advertisement