Chetan Bhat created CARBONDATA-4184: ---------------------------------------
Summary: 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 [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)