[ https://issues.apache.org/jira/browse/CARBONDATA-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Indhumathi Muthu Murugesh resolved CARBONDATA-4184. --------------------------------------------------- Fix Version/s: 2.2.0 Resolution: Fixed > alter table Set TBLPROPERTIES for RANGE_COLUMN sets unsupported > datatype(complex_datatypes/Binary/Boolean/Decimal) as RANGE_COLUMN > ---------------------------------------------------------------------------------------------------------------------------------- > > Key: CARBONDATA-4184 > URL: https://issues.apache.org/jira/browse/CARBONDATA-4184 > Project: CarbonData > Issue Type: Bug > Components: data-query > Affects Versions: 2.1.1 > Environment: Spark 2.4.5 > Reporter: Chetan Bhat > Priority: Minor > Fix For: 2.2.0 > > Time Spent: 4h 20m > Remaining Estimate: 0h > > [Steps] :- > From Spark Beeline/SQL/Submit/Shell the queries are executed > DROP TABLE IF EXISTS alter_array; > CREATE TABLE alter_array(intField INT, arr1 array<int>) STORED AS carbondata; > ALTER TABLE alter_array SET TBLPROPERTIES('RANGE_COLUMN'='arr1'); > desc formatted alter_array; > DROP TABLE IF EXISTS alter_struct; > create table alter_struct(roll int, struct1 struct<id1:string,name1:string>) > STORED AS carbondata; > ALTER TABLE alter_struct SET TBLPROPERTIES('RANGE_COLUMN'='struct1'); > desc formatted alter_struct; > DROP TABLE IF EXISTS alter_map; > create table alter_map(roll int, map1 map<string,string>) STORED AS > carbondata; > ALTER TABLE alter_map SET TBLPROPERTIES('RANGE_COLUMN'='map1'); > desc formatted alter_map; > DROP TABLE IF EXISTS alter_boolean; > create table alter_boolean(roll int, bool1 boolean) STORED AS carbondata; > ALTER TABLE alter_boolean SET TBLPROPERTIES('RANGE_COLUMN'='bool1'); > desc formatted alter_boolean; > DROP TABLE IF EXISTS alter_binary; > create table alter_binary(roll int, bin1 binary) STORED AS carbondata; > ALTER TABLE alter_binary SET TBLPROPERTIES('RANGE_COLUMN'='bin1'); > desc formatted alter_binary; > DROP TABLE IF EXISTS alter_decimal; > create table alter_decimal(roll int, dec1 decimal(10,5)) STORED AS carbondata; > ALTER TABLE alter_decimal SET TBLPROPERTIES('RANGE_COLUMN'='dec1'); > desc formatted alter_decimal; > [Actual Issue] : - alter table Set TBLPROPERTIES for RANGE_COLUMN sets > unsupported datatype(complex_datatypes/Binary/Boolean/Decimal) as RANGE_COLUMN > > [Expected Result] :- Validation should be provided when alter table Set > TBLPROPERTIES for RANGE_COLUMN tried to be set for unsupported > datatype(complex_datatypes/Binary/Boolean/Decimal) > > -- This message was sent by Atlassian Jira (v8.3.4#803005)