phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jepson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4815) support alter table modify column
Date Tue, 28 May 2019 11:02:00 GMT

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

Jepson commented on PHOENIX-4815:
---------------------------------

Support for CDH versions?

> support alter table modify column 
> ----------------------------------
>
>                 Key: PHOENIX-4815
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4815
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.12.0, 4.13.0, 4.14.0
>            Reporter: jaanai
>            Assignee: jaanai
>            Priority: Major
>         Attachments: PHOENIX-4815-master-v2.patch, 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}
> reference link: https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_3001.htm#i2103956



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

Mime
View raw message