[jira] [Updated] (CARBONDATA-1802) Carbon1.3.0 Alter:Alter query fails if a column is dropped and there is no key column

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-1802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ajeet Rai updated CARBONDATA-1802:
----------------------------------
    Description:
Carbon1.3.0  Alter:Alter query fails if a column is dropped and there is no key column.

Steps:
1: create table ttt(c int,d int,e int) stored by 'carbondata';
2: Alter table ttt drop columns(c);
3: observe that below error is coming:
Error: java.lang.RuntimeException: Alter table drop column operation failed: Alter drop operation failed. AtLeast one key column should exist after drop.

Expected: Since user is able to create a table with all numeric columns, Same should be supported in Alter feature.

  was:
Carbon1.3.0  Alter:Alter query fails if a column is dropped and there is no key column.

Steps:
1: create table ttt(c int,d int,e int) stored by 'carbondata';
2: Alter table ttt drop columns(c);
3: observe that below error is coming:
Error: java.lang.RuntimeException: Alter table drop column operation failed: Alter drop operation failed. AtLeast one key column should exist after drop.

> Carbon1.3.0  Alter:Alter query fails if a column is dropped and there is no key column
> --------------------------------------------------------------------------------------
>
>                 Key: CARBONDATA-1802
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1802
>             Project: CarbonData
>          Issue Type: Bug
>    Affects Versions: 1.3.0
>         Environment:   3 Node ant cluster
>            Reporter: Ajeet Rai
>              Labels: functional
>
> Carbon1.3.0  Alter:Alter query fails if a column is dropped and there is no key column.
> Steps:
> 1: create table ttt(c int,d int,e int) stored by 'carbondata';
> 2: Alter table ttt drop columns(c);
> 3: observe that below error is coming:
> Error: java.lang.RuntimeException: Alter table drop column operation failed: Alter drop operation failed. AtLeast one key column should exist after drop.
> Expected: Since user is able to create a table with all numeric columns, Same should be supported in Alter feature.

--
This message was sent by Atlassian JIRA
(v6.4.14#64029)