Description
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.