Max number of databases and tables allowed in Hive Metastore
Crossposting from: Stack Overflow
(I will respond and give updates on both places)
I would like to know if there is also maximum number for items below:
- Maximum number of databases in a catalog (I assume Hive Metastore only has one catalog, which is "hive")
- Maximum number of tables per database (as in, can I create 10 million tables in a database or due to limitation must I split them into 10 databases each with 1 million tables)
I also would like to know whether the limitations are hard limit (unconfigurable), or configurable by Hive, or dependent on RDBMS it is using.

