Reply
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 b.channel = a.channel.

 

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

 

 

Announcements