You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@carbondata.apache.org by "Ravindra Pesala (JIRA)" <ji...@apache.org> on 2016/08/17 11:19:20 UTC
[jira] [Reopened] (CARBONDATA-27) filter expression to_date(
productdate ) = '2012-12-12' not working
[ https://issues.apache.org/jira/browse/CARBONDATA-27?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ravindra Pesala reopened CARBONDATA-27:
---------------------------------------
> 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
> Fix For: 0.1.0-incubating
>
>
> 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)