[jira] [Commented] (CARBONDATA-1671) Support set/unset table comment for ALTER table

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (CARBONDATA-1671) Support set/unset table comment for ALTER table

Akash R Nilugal (Jira)

    [ https://issues.apache.org/jira/browse/CARBONDATA-1671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16254813#comment-16254813 ]

Pawan Malwal commented on CARBONDATA-1671:
------------------------------------------

Features proposed in this jira::

Table comment set/unset using **ALTER TABLE  SET/UNSET TBLPROPERTIES** query is not supported

eg: ALTER TABLE table_with_comment SET TBLPROPERTIES("comment"= "modified comment)
If user wants to alter the table properties and adds/updates table comment, inorder  to handle this requirement, update the comment field value with the newly added/modified comment when user executes **ALTER TABLE  SET TBLPROPERTIES** query.

This will also take care of unsetting the table comment when user executes query  **ALTER TABLE  UNSET TBLPROPERTIES** inorder to unset or remove table comment.
eg: ALTER TABLE table_comment UNSET TBLPROPERTIES IF EXISTS ('comment')

> Support set/unset table comment for ALTER table
> -----------------------------------------------
>
>                 Key: CARBONDATA-1671
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1671
>             Project: CarbonData
>          Issue Type: Sub-task
>            Reporter: Pawan Malwal
>            Assignee: Pawan Malwal
>
> Table comment set/unset using **ALTER TABLE  SET/UNSET TBLPROPERTIES**



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