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 binner join table2 aon b.channel = a.channel.
One table is of around 100GB and other is of around 1GB.