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.
How do we architect this?
database namespace (or schema_owner) = db_marketing
table name = customer_master
In DEV select * from db_marketing.customer_master would source from /dev/data/marketing/customer_master
In TEST select * from db_marketing.customer_master would source from /test/data/marketing/customer_master
Does this require multiple metastores?
What is best practice for multiple environments on a single Hadoop cluster?