[
https://issues.apache.org/jira/browse/CARBONDATA-2042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ravindra Pesala resolved CARBONDATA-2042.
-----------------------------------------
Resolution: Fixed
Fix Version/s: 1.3.0
> 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
> Fix For: 1.3.0
>
> Attachments: data_sort.csv
>
> Time Spent: 1h 50m
> 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)
