- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Is there way to add comment to a phoenix table?
- Labels:
-
Apache HBase
-
Apache Phoenix
Created ‎03-20-2017 03:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there way to add comment to a phoenix table? I know of the "comments" functinality but it only is used to add comments to a script. I need to add comment to a table (ie field) like TD or oracle functionality.
Created ‎03-21-2017 11:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You cannot add a description / comment to a Phoenix table in the same way as you would add in Oracle/TD, that is: no equivalent to the `COMMENT ON TABLE` SQL command, neither in the Phoenix SQL, nor in the underlying Hbase api.
You can accomplish your goal by using external tools to keep tab on your table metadata.
Created ‎03-20-2017 04:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Sunile Manjee Comments functionality is supported in Phoenix as well.
Ex: "SELECT /* this is a comment */ CAST(USNIG_LONG_ID as DECIMAL) FROM <Table_Name> ORDER BY USNIG_LONG_ID DESC limit 3;"
Created ‎03-20-2017 04:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is adding a comment within the script and I am aware of the functionality. The question is about adding comment to table or column, ie like oracle/TD
Created ‎03-21-2017 11:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You cannot add a description / comment to a Phoenix table in the same way as you would add in Oracle/TD, that is: no equivalent to the `COMMENT ON TABLE` SQL command, neither in the Phoenix SQL, nor in the underlying Hbase api.
You can accomplish your goal by using external tools to keep tab on your table metadata.
