Support Questions
Find answers, ask questions, and share your expertise

Hive Join Query in HUE Stacked in the Reduce Step - CDH 5.15

New Contributor

Hello,

 

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?

 

Thanks,

 

Mer12

3 REPLIES 3

Expert Contributor

Hi @Mer12,

 

The YARN console what show you?

 

Regards,

Manu.

New Contributor

Yarn--> Application Tab --> Results tab shows 2 bars for the job-MAP and Reduce. Map is 100% complete and the Reduce is stacked.

 

Thanks

Expert Contributor

Hi @Mer12,

 

Go to IU Web of ResourceManager  tab ---> The "application running" can be show you more information.

 

 

Regards,

Manu.