https://community.cloudera.com/t5/Support-Questions/Best-practice-architecture-and-naming-hdfs-path-names-hive/m-p/58316#M49792 <P>You can have seprate database on Hive Metastore &nbsp;for all the three enviroments ,plus the HDFS directory structure I would strongly recommend you to have sperate Hadoop clusters for your production . Because you will have 2 or more Hadoop Namenode HA or Resourcemanager HA configured for all the three enviroments maintaining them &nbsp;will be a cubersome if there is going to be heavy load on all the three enviroment on a single Hadoop Clusters</P><P>&nbsp;</P><P>What you can do is isolate the production from the other two enviroment have a sperate Hadoop clusters .</P><P>&nbsp;</P><P>And I assume you are plaining to &nbsp;have a shared Metastore for HIVE / IMPALA .&nbsp;</P><P>You should also take in to consideration of other eco systems .&nbsp;</P><P>Please let me know if you need more information.&nbsp;</P> Wed, 02 Aug 2017 02:48:05 GMT csguna 2017-08-02T02:48:05Z