Karan created CARBONDATA-4002: --------------------------------- Summary: 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 Fix For: 2.0.0
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)