Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
2.1.1
-
None
-
Spark 2.4.5
Description
[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)
