I try to run a join query (2 tables, 700k rec) in Hive through Hue and it seems it stacked in the reduce step. I see in the YARN --> Applications that it in the reduce step for a long time with no progress so I cancel it..
It doesn't stack for simple queries on these tables.
Any idea what can cause this problem?
Yarn--> Application Tab --> Results tab shows 2 bars for the job-MAP and Reduce. Map is 100% complete and the Reduce is stacked.