Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

how to load table from hive warehouse in hdfs ?

Highlighted

how to load table from hive warehouse in hdfs ?

Contributor

hello,

i am using HDInsight cluster for hadoop and azure storage as HDFS. as HDInsight charges per hour i am deleting cluster whenever i am not using it. i am working on HIVE, whenever i create HDInsight cluster again i have to create whole HIVE database from scratch. is there any way to restore it from azure storage.?

2 REPLIES 2

Re: how to load table from hive warehouse in hdfs ?

@JAy PaTel

If the idea is to retain the Hive metadata, then take backup of MySQL Hive database and restore under new instance.

Re: how to load table from hive warehouse in hdfs ?

Contributor

Hi @Sindhu

how can I take backup of MySQL Hive database and restore under new instance? Could You please guide me ?

I am new to Hadoop I am trying to create a demo.

Regards,

Jay.

Don't have an account?
Coming from Hortonworks? Activate your account here