https://community.cloudera.com/t5/Support-Questions/Best-practice-architecture-and-naming-hdfs-path-names-hive/m-p/58302#M49791 <P>We are moving our Oracle "landing" data into Hadoop. In Oracle we have three environments and three Oracle databases: dwdev, dwtest, and dwprod. The goal is to have three separate "landing" zones in Hadoop that will feed into each Oracle database, respectively, i.e. Hadoop dev feeds Oracle dwdev, etc.</P><P>The dev and test hadoop environment will exist on a single physical hadoop cluster.</P><P>How do we architect this?</P><P>HDFS</P><P>/&lt;env&gt;/data/&lt;information_area&gt;/&lt;table_name&gt;</P><P>/dev/data/marketing/customer_master</P><P>/test/data/marketing/customer_master</P><P>HIVE</P><P>database namespace (or schema_owner) = db_marketing</P><P>table name = customer_master</P><P>In DEV select * from db_marketing.customer_master would source from /dev/data/marketing/customer_master</P><P>&nbsp;</P><P>In TEST select * from db_marketing.customer_master would source from /test/data/marketing/customer_master</P><P>Does this require multiple metastores?</P><P>What is best practice for multiple environments on a single Hadoop cluster?</P> Fri, 16 Sep 2022 12:01:55 GMT kjfischer 2022-09-16T12:01:55Z