Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Is there any way to export Metadata of Hive, Impala or any other component from Cloudera Navigator

avatar
Explorer

Hello Folks,

 

I was browing through the metadata management through Cloudera Navigator however could not find any export option to export the metadata to Excel.

 

Is there a possibility or a way to export metadata of Impala or Hive to excel?

 

 

1 REPLY 1

avatar
Explorer

Hi,

 

I don't think there is a solution to export hive / impala metadata directly into excel file.

 

You can export metastore to sql dump :

 

https://discuss.pivotal.io/hc/en-us/articles/115000104847-How-to-migrate-Hive-from-one-Hadoop-cluste...

 

Then, convert the sql dump to csv file :

 

https://blog.twineworks.com/converting-a-mysql-dump-to-csv-files-b5e92d7cc5dd