[ https://issues.apache.org/jira/browse/CARBONDATA-4344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Indhumathi resolved CARBONDATA-4344. ------------------------------------ Fix Version/s: 2.3.1 Resolution: Fixed > 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 > Priority: Major > Fix For: 2.3.1 > > Time Spent: 1h > Remaining Estimate: 0h > > [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)