28732
DISCUSSIONS
101749
MEMBERS
3157
ARTICLES
Created on 02-23-2018 08:53 PM - edited 09-16-2022 05:54 AM
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