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)