hive metastore database sizing

[#1]

Is there any standard or template available for hive metastore database sizing. We need to provide to the database platform team our requirements. we have a 30 node cluster with 3 masters and 27 slaves.

[#2]

@ARUN

We cannot decide the Hive metastore database size depending on the cluster size as the database would be for holding the metadata of the Hive tables and databases created. There are total of 57 tables under the metastore database.

[#3]

Thanks @Sindhu, just wanted to come up with the db instance sizing.

[#4 · Accepted solution]

@ARUN

Refer below HCC article for the sample DB sizing:
https://community.hortonworks.com/articles/98489/hdp-supporting-database-sizing-guidelines.html

[#5]

Thanks @Sindhu, it helps