You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Jaanai Zhang (JIRA)" <ji...@apache.org> on 2018/07/17 01:26:00 UTC
[jira] [Updated] (PHOENIX-4815) support alter table modify column
[ https://issues.apache.org/jira/browse/PHOENIX-4815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jaanai Zhang updated PHOENIX-4815:
----------------------------------
Description:
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}
was:
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 reference
{code:java}
alter table
table_name
modify
column_name datatype;
{code}
> 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
>
> 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)