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:06: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}


reference link: https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_3001.htm#i2103956

  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 an 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
>         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}
> 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