[Discussion]Alter table column rename feature

[akashrn5]

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

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

... [show rest of quote]

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

... [show rest of quote]

[akashrn5]

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/

[ravipesala]

+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/

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

[xubo245]

+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/