phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jaanai Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-4815) support alter table modify column
Date Tue, 24 Jul 2018 07:00:00 GMT

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

Jaanai Zhang updated PHOENIX-4815:
----------------------------------
    Attachment: PHOENIX-4815.patch

> support alter table modify column 
> ----------------------------------
>
>                 Key: PHOENIX-4815
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4815
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Jaanai Zhang
>            Priority: Major
>         Attachments: PHOENIX-4815.patch
>
>
> if we want to change max length or scale of  fields of  variable length type(  example
for :varchar, char and decimal type etc),  we can not drop column to recreate new column when
the table has massive data,  which may affects online service´╝îmeanwhile, it is also very
expensive. so sometimes this function is very useful.
> Taking ORACLE dialect as an reference 
> {code:java}
> alter table
>    table_name
> modify
>    column_name  datatype;
> {code}



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

Mime
View raw message