Is it possible to use the same metastore by multiple users, in case of the embedded hive?
No, we cannot use metastore in sharing mode. It is possible to use it in standalone “real” database. Such as MySQL or PostGresSQL.
