Manish Gupta created CARBONDATA-803: ---------------------------------------
Summary: 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 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)