[jira] [Created] (CARBONDATA-4344) Create MV fails with "LOCAL_DICTIONARY_INCLUDE/LOCAL _DICTIONARY_EXCLUDE column: does not exist in table. Please check the DDL" error

[SHREELEKHYA GAMPA (Jira)]

SHREELEKHYA GAMPA created CARBONDATA-4344:
---------------------------------------------

             Summary:  Create MV fails with "LOCAL_DICTIONARY_INCLUDE/LOCAL 
_DICTIONARY_EXCLUDE column: does not exist in table. Please check the DDL" error
                 Key: CARBONDATA-4344
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-4344
             Project: CarbonData
          Issue Type: Bug
            Reporter: SHREELEKHYA GAMPA


[Steps] :-

>From spark beeline the queries are executed.

drop table if exists uniqdata;

CREATE TABLE uniqdata(CUST_ID int ,CUST_NAME string,ACTIVE_EMUI_VERSION string, 
DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 
bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 
decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double, INTEGER_COLUMN1 
int) STORED AS carbondata;

LOAD DATA INPATH 'hdfs://hacluster/chetan/2000_UniqData.csv' into table 
uniqdata OPTIONS ('FILEHEADER'='CUST_ID,CUST_NAME ,ACTIVE_EMUI_VERSION,DOB,DOJ, 
BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1, 
Double_COLUMN2,INTEGER_COLUMN1','BAD_RECORDS_ACTION'='FORCE');

alter table uniqdata add columns(a int);

take store from hdfs

Drop table uniqdata;

Put store in hdfs

refresh table uniqdata;

drop MATERIALIZED VIEW if exists uniq2_mv;

create MATERIALIZED VIEW uniq2_mv as select CUST_NAME, sum(CUST_ID) from 
uniqdata group by CUST_NAME;

[Expected Result] :- Create MV fails should be successful for table created in 
older version.

[Actual Issue]:- Create MV fails with "LOCAL_DICTIONARY_INCLUDE/LOCAL 
_DICTIONARY_EXCLUDE column: does not exist in table. Please check the DDL" error



--
This message was sent by Atlassian Jira
(v8.20.7#820007)