2

I have 1500 partition in my hive tables but while doing query it is taking more time then expected. Maximum number of partitions can be created in hive table.

1 Answers1

3

Current Hive versions with RDBMS metastore backend should be able to handle 10000+ partitions.

For numerous reasons, the community is moving away from this design to leverage HBase for the metastore. Follow https://issues.apache.org/jira/browse/HIVE-9452 .

Overall design document is available here: https://issues.apache.org/jira/secure/attachment/12697601/HBaseMetastoreApproach.pdf

Mayank Porwal
  • 33,470
  • 8
  • 37
  • 58