Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hiverserver2 peformance for tables with many partitions

Highlighted

Hiverserver2 peformance for tables with many partitions

Explorer

Hi Guys, Any solution incorporated in CDH bundle to overcome issues.apache.org/jira/browse/HI ?

 

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.

Don't have an account?
Coming from Hortonworks? Activate your account here