Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]
Created 03-20-2017 03:20 PM
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
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
@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
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
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.