[jira] [Resolved] (CARBONDATA-4002) Altering the value of sort columns and unsetting the longStringColumns results in deletion of columns from table schema.

[Akash R Nilugal (Jira)]

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

Akash R Nilugal resolved CARBONDATA-4002.
-----------------------------------------
    Fix Version/s:     (was: 2.0.0)
                   2.1.0
       Resolution: Fixed

> Altering the value of sort columns and unsetting the longStringColumns results in deletion of columns from table schema.
> -------------------------------------------------------------------------------------------------------------------------
>
>                 Key: CARBONDATA-4002
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-4002
>             Project: CarbonData
>          Issue Type: Bug
>          Components: core
>            Reporter: Karan
>            Priority: Major
>             Fix For: 2.1.0
>
>          Time Spent: 5h
>  Remaining Estimate: 0h
>
> When we change the value of sortColumns by alter table query and then run unset for longStringColumn. it removes some columns from table schema.
> CREATE TABLE if not exists $longStringTable(id INT, name STRING, description STRING, address STRING, note STRING) STORED AS carbondataTBLPROPERTIES('sort_columns'='id,name');
> alter table long_string_table set tblproperties('sort_columns'='ID','sort_scope'='no_sort');
> alter table long_string_table unset tblproperties('long_string_columns');
> these queries will remove Name column from the schema because initially it was a sortColumn and after that value of sortColumns is changed.
>  

--
This message was sent by Atlassian Jira
(v8.3.4#803005)