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)