Posts: 45
Registered: ‎09-29-2016

compute stats or alter statement taking long time

[ Edited ]

when doing compute incremental stats on a table having 4000 partitions in total and 30 gb of data takes 5-6 hrs to complete.

have seen hive.log which is executing lots of queries to update metastore . 

i have cloudera 5.7 with oracle as metastore.


have seen same thing gets completed in 2-3 min in MySQL metastore.

but cant say oracle is creating problem becuase have seen with DBA that everything is smooth at Oracle.

looks some problem at impala/hive.