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?