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.

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

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

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

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

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