You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Michel Sumbul <mi...@gmail.com> on 2019/09/09 13:54:32 UTC

Sizing hive3 underlying DB

Hi guys,

I would like to ask you if anyone has sizing guideline / recommendation for
the underlying DB of hive? Like a postgres or MySQL.
How many CPU/Ram will be needed according to a number of query per day /
size of a cluster?
Also what about the IOPS?

Since ACID is the default in Hive 3, m I right to expect a bigger load on
the DB of the metastore?

Thanks for your help,
Michel