Is it possible for Hive Metastore to support multi-tenancy? I'm trying to build a multi-tenant feature in Hive Metastore. It means that there will be multiple user and each user can create databases, tables, etc. Also, the database or tables created by that user cannot be accessed by another users. I've thought maybe by providing an authentication to Hive will give a multi-tenancy feature. But after tried it with Kerberos, it seems that different users cannot create database with the same name, for example when user1 have a database named dbA then user2 cannot create database named dbA. I've not tried using authorization tools like Ranger, but it looks like it will not give me multi-tenancy feature (different user can create database with the same name). There are several solutions that I can think of, that is: - Each user have their own Metastore. It seems inefficient to have a lot of hive metastore, but it is the most straight forward solution to me. - Include username in database name. Database name will have this format: <username>_<database-name>. But I'm not so sure about this one. I've been searching about this topic but found very little information. The official Hive documentation doesn't even mention about it, or maybe I missed it (?). Or are there any other method/solution to implement multi-tenant feature in Hive Metastore? Thank you ... View more