question Re: hive metastore database sizing in Support Questions

hive metastore database sizing

arunpoy — Mon, 07 Aug 2017 12:18:40 GMT

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.

Re: hive metastore database sizing

ssubhas — Mon, 07 Aug 2017 13:19:14 GMT

@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.

Re: hive metastore database sizing

arunpoy — Mon, 07 Aug 2017 18:16:15 GMT

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

Re: hive metastore database sizing

ssubhas — Thu, 10 Aug 2017 13:10:07 GMT

@ARUN

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

Re: hive metastore database sizing

arunpoy — Thu, 10 Aug 2017 14:16:55 GMT

Thanks @Sindhu, it helps