New Contributor
Posts: 2
Registered: ‎02-11-2018

Inner join hive queries stuck at reduce phase in CDH 5.12

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 =


One table is of around 100GB and other is of around 1GB.