02-23-2018 08:53 PM
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.