question Re: Is there way to add comment to a phoenix table? in Archives of Support Questions (Read Only)

Is there way to add comment to a phoenix table?

sunile_manjee — Mon, 20 Mar 2017 22:20:28 GMT

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.

Re: Is there way to add comment to a phoenix table?

mramasami — Mon, 20 Mar 2017 23:13:47 GMT

@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

Re: Is there way to add comment to a phoenix table?

sunile_manjee — Mon, 20 Mar 2017 23:55:39 GMT

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

Re: Is there way to add comment to a phoenix table?

bpgergo — Tue, 21 Mar 2017 18:31:46 GMT

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.