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