[jira] [Resolved] (IMPALA-5614) Add COMMENT ON syntax to support comments on all objects

["Fredy Wijaya (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fredy Wijaya resolved IMPALA-5614.
----------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 3.1.0

> Add COMMENT ON syntax to support comments on all objects
> --------------------------------------------------------
>
>                 Key: IMPALA-5614
>                 URL: https://issues.apache.org/jira/browse/IMPALA-5614
>             Project: IMPALA
>          Issue Type: New Feature
>          Components: Frontend
>    Affects Versions: Impala 2.9.0
>            Reporter: Greg Rahn
>            Assignee: Fredy Wijaya
>            Priority: Minor
>              Labels: newbie, sql-language
>             Fix For: Impala 3.1.0
>
>         Attachments: Screenshot 2018-04-24 09.51.29.png
>
>
> The current SQL grammar (v2.9) allows for comments on objects at creation time but does not allow for modification post-fact. Postgres and others support the COMMENT ON syntax although it is not part of the ANSI standard.
> For example:
> {noformat}
> COMMENT ON DATABASE my_database IS 'Development Database';
> COMMENT ON TABLE my_schema.my_table IS 'Employee Information';
> COMMENT ON COLUMN my_table.my_column IS 'Employee ID number';
> COMMENT ON VIEW my_view IS 'View of departmental costs';
> COMMENT ON FUNCTION my_function (timestamp) IS 'Returns Roman Numeral';
> COMMENT ON DATABASE my_database IS NULL; -- to remove a comment
> {noformat}
> References:
>  - [Postgres |https://www.postgresql.org/docs/current/static/sql-comment.html]
>  - [Vertica |https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/COMMENT/COMMENTONStatements.htm]
>  - [Netezza |https://www.ibm.com/support/knowledgecenter/en/SSULQD_7.2.1/com.ibm.nz.dbu.doc/r_dbuser_comment.html]
>  - [Redshift|http://docs.aws.amazon.com/redshift/latest/dg/r_COMMENT.html]
>  - [DB2|https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000901.html]
>  - [Oracle|https://docs.oracle.com/database/121/SQLRF/statements_4010.htm#SQLRF01109]
>  - [Snowflake|https://docs.snowflake.net/manuals/sql-reference/sql/comment.html]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)