Support Questions
Find answers, ask questions, and share your expertise

Refresh Hive Views metadata for the first time use

Refresh Hive Views metadata for the first time use

Hi, We have a number of hive databases, tables, columns and views already created on the Hive before we installed Atlas on our servers.

For getting the metadata for all the existing hive objects we used the COMPUTE STATISTICS command in Hive to make sure that the metadata is available in the Atlas. It works fine with the Hive tables.

ANALYZE TABLE <TABLENAME> COMPUTE STATISTICS;

But we are still missing the Hive views in the Atlas, is there any command that we can use to make sure that the Hive Views are also available in the Atlas? One way that I can think of is the drop and recreate the views. But wanted to see if there is any alternative approach for this.

1 REPLY 1

Re: Refresh Hive Views metadata for the first time use

Expert Contributor

@Jigar Chhadwa,

Atlas provides a script/tool to import metadata from hive for all hive entities like tables, database, views, columns etc... This tool/script requires hadoop and hive classpath jars, to make them available to the script

You can use import hive script to import hive entities in Atlas metadata.

Refer this article https://community.hortonworks.com/articles/61274/import-hive-metadata-into-atlas.html

Hope this is helpful to you.

Nixon