Posts: 10
Registered: ‎05-07-2016

Hiverserver2 peformance for tables with many partitions

Hi Guys, Any solution incorporated in CDH bundle to overcome ?


In a multi-tenant environment, this has become a blocker. What solutions do you suggest? Already have metastore partition limit req=10,000. Would be helpful, if you have some patch.

For example if some query where compiling takes time is submitted, it blocks even other queries with a simple show databases command? It takes 10 minutes to list the database.

The same queries work faster via hive shell or spark-shell as they dont route through HS2.