[ https://issues.apache.org/jira/browse/CARBONDATA-25?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ChenLiang closed CARBONDATA-25. ------------------------------- > Filter query issue for >, <, <= than filter > ------------------------------------------- > > Key: CARBONDATA-25 > URL: https://issues.apache.org/jira/browse/CARBONDATA-25 > Project: CarbonData > Issue Type: Bug > Reporter: Mohammad Shahid Khan > > 1. select count(*) from a12 where dob > '2014-07-01 12:07:28' > throwing runtime exception > 2. select count(*) from a12 where dob < '2014-07-01 12:07:28' > is including the null values also. > 3. select count(*) from a12 where dob <= '2014-07-01 12:07:28' > is including the null value > Null should not considered in less than filter. > create cube command: > create table a12(empid String,ename String,sal double,deptno int,mgr > string,gender string," + > "dob timestamp,comm decimal(4,2),desc string) stored by > 'org.apache.carbondata.format > data: > empid,ename,sal,deptno,mgr,gender,dob,comm,desc > 1,abc,1233,10,2,,2014-07-01 12:07:28,1234.191,string_null > 2,bcd,1322,,3,f,2014-07-01 12:07:28,19.99,int_null > 3,cde,4322,,4,m,,16.996,date_null > 4, ,43243,,5,m,,999.117,string_space > 5,,43242,20,6,m,2017-07-01 12:07:28,99.999,string_null > 6,ijk,,20,6,m,2017-07-01 12:07:28,50089,double_null > 7,pqr,2422,20,6,m,2017-07-01 12:07:28,32.339,decimal_null > 8 -- This message was sent by Atlassian JIRA (v6.3.4#6332)