Mohammad Shahid Khan created CARBONDATA-27:
----------------------------------------------

             Summary: filter expression to_date( productdate ) = '2012-12-12' 
not working
                 Key: CARBONDATA-27
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-27
             Project: CarbonData
          Issue Type: Bug
            Reporter: Mohammad Shahid Khan
            Assignee: Mohammad Shahid Khan


Scenario:

CREATE TABLE comb04 (imei string,name string,age int,productdate 
timestamp,enddate timestamp,country string,city string,sale int,num 
double,gamePointId double,level decimal(10,3),score decimal(18,3)) STORED BY 
'org.apache.carbondata.format' tblproperties('DICTIONARY_INCLUDE'='age');

LOAD DATA LOCAL INPATH '$testData' INTO TABLE comb04 options ('DELIMITER'=',', 
'QUOTECHAR'='\"')

data:
imei,name,age,productdate,enddate,country,city,sale,num,gamePointId,level,score
imei0,name0,1,2016-05-02 05:45:49,2016-05-02 
05:45:59,zhejiang,hangzhou,15895877,145,15.692,1025412.235,89
imei1,name1,2,2016-05-03 05:15:49,2016-05-03 
05:25:59,zhejiang,wenzhou,15895237,152,15.529,1025412.854,81
imei1,name1,2,2016-05-03 05:15:49,2016-05-03 
05:25:59,zhejiang,wenzhou,15529,152,15.529,15.529,81





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to