[jira] [Created] (CARBONDATA-2042) Data Mismatch issue in case of Timeseries Year, Month and Day level table

[kumar vishal (JIRA)]

kumar vishal created CARBONDATA-2042:
----------------------------------------

             Summary: 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: Improvement
            Reporter: kumar vishal
            Assignee: kumar vishal
         Attachments: data_sort.csv

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)