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.