Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Is there way to add comment to a phoenix table?

avatar
Master Guru

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.

1 ACCEPTED SOLUTION

avatar
Rising Star

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.

View solution in original post

3 REPLIES 3

avatar
Rising Star

@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;"

Reference: https://phoenix.apache.org/language/#comments

avatar
Master Guru

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

avatar
Rising Star

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.