You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Thomas D'Silva (JIRA)" <ji...@apache.org> on 2018/03/21 18:42:00 UTC
[jira] [Commented] (PHOENIX-4651) Support ALTER TABLE ... MODIFY
COLUMN
[ https://issues.apache.org/jira/browse/PHOENIX-4651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16408401#comment-16408401 ]
Thomas D'Silva commented on PHOENIX-4651:
-----------------------------------------
If we are renaming a column on a table that uses column encoding that we just need to change the metadata.
If we are changing data types we would need to rewrite data, even if the table uses column encoding.
FYI [~karanmehta93]
> Support ALTER TABLE ... MODIFY COLUMN
> -------------------------------------
>
> Key: PHOENIX-4651
> URL: https://issues.apache.org/jira/browse/PHOENIX-4651
> Project: Phoenix
> Issue Type: New Feature
> Affects Versions: 4.10.0
> Reporter: Jepson
> Priority: Critical
> Original Estimate: 504h
> Remaining Estimate: 504h
>
> Modify the column type length, is very inconvenient, drop first ,then add.
> Such as:
> alter table jydw.test drop column name;
> alter table jydw.test add name varchar(256);
> The alter table test modify column sql is not support.
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)