Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

How to add OR modify comment for an existing hive table

Contributor

After creating a table in Hive is it possible to modify the "comment" shown in highlight in attached screenshot?

Also for a table without any comment key field, is it possible to add the comment value?

8865-newspaper.jpg

3 REPLIES 3

There is no support for editing entities from UI as of now. But you can use the entity update REST API to update comment section for the hive table.

Please refer to below documents for the same:

http://atlas.incubator.apache.org/AtlasTechnicalUserGuide.pdf

http://atlas.incubator.apache.org/api/resource_EntityResource.html

Expert Contributor

It's not possible to make edits in UI as of now. In addition to @Ayub Khan 's answer , hive table can be altered using the hive command ALTER TABLE table1 SET TBLPROPERTIES ('comment' = 'your comments'); , and an update is sent to Atlas. You can see the updated comment in the UI.

For the second question , if hive table is created without any comments , it is marked "null". So it can be updated via REST APIs or through hive command itself.

Explorer

The article: Modify Atlas Entity properties using REST API commands contains a full description for how to update both the comment and description entity properties for Atlas managed hive_table types.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.