[jira] [Created] (CARBONDATA-4184) alter table Set TBLPROPERTIES for RANGE_COLUMN sets unsupported datatype(complex_datatypes/Binary/Boolean/Decimal) as RANGE_COLUMN

[Akash R Nilugal (Jira)]

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)