Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Hive Query Issue after CDH Upgrade

avatar
Contributor

Hi All,

 

We upgraded our CDH version from 5.9 to 5.12.2 one of the hive query which is running fine was taking more time now. 

 

Hive query - Select count(*) from table 

 

in CDH 5.9 - results in less than 1 min

in CDH 5.12.2 - restults in 13 min

 

what may be the cause.

 

I check JVM thread for hive metastore and hive server2 which is normal like 40 threads

 

 

Please do the needful.

 

Regards

Krishnan

Who agreed with this topic