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

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

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

[floras12]

A discussion around schema changes like column rename in systems such as CarbonData shows how even small metadata updates can affect downstream queries and data reliability if dependencies are not fully aligned, similar to how careful handling is needed in broader data workflows and reporting structures like those often explored in Salary related data insights, where accuracy and consistency across sources remain critical.