Archives of Support Questions (Read Only)

smayani · ‎11-20-2015

We have a Old Cluster with HDP 2.0.6 (Hive 0.12.0).. New Cluster with HDP 2.3.2 (Hive 1.2.1). We need to hive query the same tables in new environment and old environment after data forklift in same manner (implying database names, partitioning, etc. work). We migrated all the hdfs data over using distcp.

deepesh1 · ‎11-20-2015

If its just a migration, you can make a copy of your old database and then point the HDP 2.3.2 cluster to the copy of your old database. Before starting the Hive services upgrade the hive database by using schemaTool. You can use metatool to update the HDFS locations to the new cluster. Start the hive services.

View solution in original post

writetoaditikum · ‎06-05-2017

Do we have a way to generate the DDLs for hive databases ?

Cloudera Community

Archives of Support Questions (Read Only)

how to migrate Hive data over to new cluster?