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, 17 Jul 2018 01:26:00 GMT

     [ 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)

Mime
View raw message