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)