Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

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

Expert Contributor

Hi @Mer12,

 

The YARN console what show you?

 

Regards,

Manu.

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

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

Highlighted

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

Expert Contributor

Hi @Mer12,

 

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

 

 

Regards,

Manu.