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)