You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@carbondata.apache.org by "Manish Gupta (JIRA)" <ji...@apache.org> on 2017/03/21 17:51:41 UTC

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

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)