Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Metastore Storage and performance

Metastore Storage and performance

New Contributor

Hello,

I have two questions on metastore :
-does the performance of metastore have a big impact on hive queries? does it make sense to invest to make it a lot faster (i'm talking about something like an Optane SSD)?

-browsing the web, I understand that most people store it in postgresql or mysql (or even oracle/msqlserver). Has anyone tried to use a column store rdbms for that (vertica, monetdb...)? And what was the consequence on performance?

Don't have an account?
Coming from Hortonworks? Activate your account here