[
https://issues.apache.org/jira/browse/PHOENIX-2787?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16766192#comment-16766192
]
Hans Deragon commented on PHOENIX-2787:
---------------------------------------
[~yanxinyi], I believe that the code change should be simple. The algorithm
should be:
IF TABLE <xyz> EXISTS:
EXEC "ALTER TABLE <xyz> <command>" # As if "IF EXISTS" was never typed.
ELSE
NOP # Do nothing. Do not generate any error if the table is missing.
That is what I am expecting.
> support IF EXISTS for ALTER TABLE SET options
> ---------------------------------------------
>
> Key: PHOENIX-2787
> URL: https://issues.apache.org/jira/browse/PHOENIX-2787
> Project: Phoenix
> Issue Type: Improvement
> Affects Versions: 4.8.0
> Reporter: Vincent Poon
> Priority: Trivial
>
> A nice-to-have improvement to the grammar:
> ALTER TABLE my_table IF EXISTS SET options
> currently the 'IF EXISTS' only works for dropping/adding a column
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)