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