https://community.cloudera.com/t5/Support-Questions/Best-practice-architecture-and-naming-hdfs-path-names-hive/m-p/58353#M49793 Thank you for your response. To clarify, we have purchased 2 Hadoop clusters: one for dev and test and the second for production. Each cluster will have 15 nodes (4 master, 9 worker, and 2 edge).<BR />My background is in Oracle, so I need further clarification on how to architect the Hadoop environment. (It is my understanding that in Hadoop, a "database namespace" is synonymous with "schema owner" in Oracle)<BR />We current have three Oracle databases: dwdev, dwtst, and dwprd and they are each on their own hardware server.<BR />Within each database, there is a schema owner named marketing which owns a set of tables, ie. customer_master, product_master, etc.<BR />If we want to simulate this in Hadoop, except that dev and test will exist on the same hardware cluster, how do we do that given that we do not want to change the existing schema owner and table names? So, in oracle, you have .,. Does this require having separate metastores?<BR /> Wed, 02 Aug 2017 14:23:02 GMT kjfischer 2017-08-02T14:23:02Z