[jira] [Resolved] (CARBONDATA-803) Incorrect results returned by not equal to filter on dictionary column with numeric data type

["Ravindra Pesala (JIRA)" <ji...@apache.org>]

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