[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)" <ji...@apache.org>]

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)