The hive query is getting stuck at reduce phase indefinitely. Some reduce tasks are stuck at 66.67% and some at 100%. After some time due to timeout the whole query fails. Following is the query: select a.*, b.* from table1 b inner join table2 a on b.channel = a.channel. One table is of around 100GB and other is of around 1GB.
... View more