[jira] [Commented] (PHOENIX-7199) Support declaration of DEFAULT in ALTER statement

["Istvan Toth (Jira)" <ji...@apache.org>]

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

Istvan Toth commented on PHOENIX-7199:
--------------------------------------

Be aware that the current default implementation in Phoenix is broken.
It does not set a default value, it just replaces any null values seen in the cell.

> Support declaration of DEFAULT in ALTER statement
> -------------------------------------------------
>
>                 Key: PHOENIX-7199
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-7199
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Nikita Pande
>            Priority: Major
>
> I cannot modify the default value of an existing column in Apache Phoenix.
> If I need to change the default value of a column, I have to create a new table with the desired schema and migrate the data from the old table to the new one.
> I think to modify column level DEFAULT, https://issues.apache.org/jira/browse/PHOENIX-4815 needs to be fixed
> Refernce from IBM DB2
> {code:java}
> ALTER TABLE MYEMP ALTER COLUMN JOB SET DEFAULT 'PENDING'
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)