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