[Discussion]Alter table column rename feature

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

[Discussion]Alter table column rename feature

akashrn5
This post was updated on .
Hi community,

Currently carbon supports alter table rename, add column, drop column and
change datatype command.

I want to propose alter table column rename feature in carbondata.
If user has an old table and he wants to change some column names as those
columns does not meet his current business scenarios. So we can support
this feature.

Please give your inputs to this so that i can start with the design and the
implementation.

DDL used for this is same as existing datatype change command DDL
ALTER TABLE table_name CHANGE [COLUMN] col_old_name col_new_name column_type;


JIRA link for the same https://issues.apache.org/jira/browse/CARBONDATA-3149

Regards,
Akash
Reply | Threaded
Open this post in threaded view
|

Re: [Discussion]Alter table column rename feature

Jacky Li
+1
Wondering will you add new command or re-use the ALTER TABLE for change datatype command, since it is also for the specified column

Regards,
Jacky

> 在 2018年12月5日,下午7:03,Akash Nilugal <[hidden email]> 写道:
>
> Hi community,
>
> Currently carbon supports alter table rename, add column, drop column and
> change datatype command.
>
> I want to propose alter table column rename feature in carbondata.
> If user has an old table and he wants to change some column names as those
> columns does not meet his current business scenarios. So we can support
> this feature.
>
> Please give your inputs to this so that i can start with the design and the
> implementation.
>
>
> Regards,
> Akash
>

Reply | Threaded
Open this post in threaded view
|

Re: [Discussion]Alter table column rename feature

kumarvishal09
+1
@Akash Nilugal <[hidden email]> Can u please Grammar for the same.

-Regards
Kumar Vishal

On Thu, Dec 6, 2018 at 9:22 PM Jacky Li <[hidden email]> wrote:

> +1
> Wondering will you add new command or re-use the ALTER TABLE for change
> datatype command, since it is also for the specified column
>
> Regards,
> Jacky
>
> > 在 2018年12月5日,下午7:03,Akash Nilugal <[hidden email]> 写道:
> >
> > Hi community,
> >
> > Currently carbon supports alter table rename, add column, drop column and
> > change datatype command.
> >
> > I want to propose alter table column rename feature in carbondata.
> > If user has an old table and he wants to change some column names as
> those
> > columns does not meet his current business scenarios. So we can support
> > this feature.
> >
> > Please give your inputs to this so that i can start with the design and
> the
> > implementation.
> >
> >
> > Regards,
> > Akash
> >
>
>
kumar vishal
Reply | Threaded
Open this post in threaded view
|

Re: [Discussion]Alter table column rename feature

akashrn5
In reply to this post by Jacky Li
we can use the same existing command for both datatype change and rename



--
Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/
Reply | Threaded
Open this post in threaded view
|

Re: [Discussion]Alter table column rename feature

ravipesala
In reply to this post by akashrn5
+1

Please make sure the DDL is consistent with HIve, no need to add any new
DDL.

Regards,
Ravindra



--
Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/
Reply | Threaded
Open this post in threaded view
|

Re: [Discussion]Alter table column rename feature

manishgupta88
+1

We already have a DDL for data type change and the same can be used for
rename column. The DDL is same as that of hive.

Regards
Manish Gupta



--
Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/
Reply | Threaded
Open this post in threaded view
|

Re: [Discussion]Alter table column rename feature

xubo245
In reply to this post by akashrn5
+1
Carbon already support RENAME TABLE, if carbon can support RENAME column
name and data type, it's better.

Can we support like this?

ALTER TABLE table_name CHANGE [COLUMN] col_old_name col_new_name
[column_type];

column_type is optional. default is keep the same data type with old column
data type



--
Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/