Hi Ashok, You can achieve this by either sharing same metastore between test and dev instance. With isolated access to databases , say test-user and dev-user, where dev-user can access all test databases.Or you can use Hive/LanguageManual+ImportExport <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ImportExport> for migration.
Thanks, Chetna Chaudhari On 11 November 2015 at 13:55, Ashok Kumar <ashok34...@yahoo.com> wrote: > Hi gurus, > > What is the easiest way of exporting one database in Hive in Test and > importing it to say DEV database in another instance. > > How metastore at target will handle this please? > > Thanks >