[jira] [Created] (CARBONDATA-23) Filter query issue for >, <, <= than filter

["Mohammad Shahid Khan (JIRA)" <ji...@apache.org>]

Mohammad Shahid Khan created CARBONDATA-23:
----------------------------------------------

             Summary: Filter query issue for >, <, <= than filter
                 Key: CARBONDATA-23
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-23
             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)