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

["Karan (Jira)" <ji...@apache.org>]

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)