Support Questions

Find answers, ask questions, and share your expertise
Announcements
Welcome to the upgraded Community! Read this blog to see What’s New!

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

avatar
New Contributor

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

Labels