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