impala-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Rahn (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IMPALA-5614) Add COMMENT ON syntax to support comments on all objects
Date Wed, 05 Jul 2017 18:44:00 GMT
Greg Rahn created IMPALA-5614:
---------------------------------

             Summary: 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
            Priority: Minor


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';
{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]



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message