carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "kumar vishal (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CARBONDATA-2042) Data Mismatch issue in case of Timeseries Year, Month and Day level table
Date Wed, 17 Jan 2018 12:38:00 GMT

     [ https://issues.apache.org/jira/browse/CARBONDATA-2042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

kumar vishal updated CARBONDATA-2042:
-------------------------------------
    Issue Type: Bug  (was: Improvement)

> Data Mismatch issue in case of Timeseries Year, Month and Day level table
> -------------------------------------------------------------------------
>
>                 Key: CARBONDATA-2042
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2042
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: kumar vishal
>            Assignee: kumar vishal
>            Priority: Major
>         Attachments: data_sort.csv
>
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> sql(s"LOAD DATA LOCAL INPATH '$resourcesPath/timeseriestest.csv' into table mainTable")
> sql("CREATE TABLE table_03 (imei string,age int,mac string,productdate timestamp,updatedate
timestamp,gamePointId double,contractid double ) STORED BY 'org.apache.carbondata.format'")
> sql(s"LOAD DATA inpath '$resourcesPath/data_sort.csv' INTO table table_03 options ('DELIMITER'=',',
'QUOTECHAR'='','FILEHEADER'='imei,age,mac,productdate,updatedate,gamePointId,contractid')")
> sql("create datamap ag1 on table table_03 using 'preaggregate' DMPROPERTIES ( 'timeseries.eventtime'='productdate','timeseries.hierarchy'='second=1,minute=1,hour=1,day=1,month=1,year=1')as
select productdate,mac,sum(age) from table_03 group by productdate,mac")



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message