http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Updated-CARBONDATA-177-Greater-than-and-Less-than-filter-returning-wrong-result-tp1444.html
> Greater than and Less than filter returning wrong result
> --------------------------------------------------------
>
> Key: CARBONDATA-177
> URL:
https://issues.apache.org/jira/browse/CARBONDATA-177> Project: CarbonData
> Issue Type: Bug
> Reporter: Mohammad Shahid Khan
> Assignee: Mohammad Shahid Khan
> Fix For: 0.2.0-incubating, 0.1.1-incubating
>
>
> DDL:
> "CREATE TABLE IF NOT EXISTS carbonTable(date Timestamp, country String, salary Int) STORED " +
> "BY " +
> "'carbondata'
> Data:
> 2015-7-23 12:07:28,china,15000
> 2018-7-24 12:07:28,china,15001
> 2017-7-25 12:07:28,china,15002
> Load command:
> "LOAD DATA LOCAL INPATH '" + csvFilePath + "' into table carbonTable OPTIONS " +
> "('FILEHEADER'='date,country,salary')"
> greather than less than filter not returning correct result