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

ASF GitHub Bot commented on PHOENIX-4815:
-----------------------------------------

GitHub user jaanai0 opened a pull request:

    https://github.com/apache/phoenix/pull/354

     support alter modify column grammar

     #PHOENIX-4815 @twdsilva  Can u please review?  :)

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/jaanai0/phoenix master

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/phoenix/pull/354.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #354
    
----
commit 5fac224c93e8123aa07cebf130d1f131977e48a0
Author: jaanai <cloud.poster@...>
Date:   2018-08-01T06:02:43Z

    Merge pull request #1 from apache/master
    
    merge master

commit b3fa8aa7149eca541fd21f5c4fc6887b627bacf1
Author: jinqian.zy <jinqian.zy@...>
Date:   2018-09-21T03:18:50Z

    Merge remote-tracking branch 'upstream/master'

commit 46ccd00448e8884f7922f868e45b8ea827047e77
Author: [email protected] <jinqian.zy@...>
Date:   2018-09-21T09:44:41Z

    support alter modify column grammar

----


> 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
>            Reporter: Jaanai
>            Assignee: Jaanai
>            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)

Reply via email to