[ https://issues.apache.org/jira/browse/CARBONDATA-803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ravindra Pesala resolved CARBONDATA-803. ---------------------------------------- Resolution: Fixed Fix Version/s: 1.0.1-incubating > Incorrect results returned by not equal to filter on dictionary column with > numeric data type > --------------------------------------------------------------------------------------------- > > Key: CARBONDATA-803 > URL: https://issues.apache.org/jira/browse/CARBONDATA-803 > Project: CarbonData > Issue Type: Bug > Reporter: Manish Gupta > Assignee: Manish Gupta > Fix For: 1.1.0-incubating, 1.0.1-incubating > > Time Spent: 2h > Remaining Estimate: 0h > > Whenever a not equal to filter is applied on dictionary column with numeric > datatype, the cast added by spark plan is removed while creating carbon > filters from spark filter. Due to this plan modification incorrect results > are returned by spark. > Steps to reproduce the issue: > 1. CREATE TABLE IF NOT EXISTS carbon(ID Int, date Timestamp, country String, > name String, phonetype String, serialname String, salary Int) STORED BY > 'org.apache.carbondata.format' TBLPROPERTIES('dictionary_include'='id') > 2. LOAD DATA LOCAL INPATH '$csvFilePath' into table carbon > 3. select Id from test_not_equal_to_carbon where id != '7' -- This message was sent by Atlassian JIRA (v6.3.15#6346)