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.
The dev and test hadoop environment will exist on a single physical hadoop cluster.
Re: What are best practices for architecture and naming hdfs file path names and hive database namespaces when development and test environments are on one cluster and production is on another cluster?