[
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)
