[GitHub] [incubator-pinot] sunny209868 opened a new pull request #4242: fix non-utc time zone, epoch time aggregation problem

[GitBox <gi...@apache.org>]

sunny209868 opened a new pull request #4242: fix non-utc time zone, epoch time aggregation problem
URL: https://github.com/apache/incubator-pinot/pull/4242
 
 
    we found that the output epoch aggregation method was calculated in UTC time zone, and the non-utc time zone aggregation granularity was incorrect. And then I used SIMPLE_DATE_FORMAT and found DATETIMECONVERT udf conversion to SIMPLE_DATE_FORMAT are 50x slower than conversion to epoch time(https://github.com/apache/incubator-pinot/issues/3515).So we increased the output epoch method with time zone(dateTimeConvert(fdate, '1:MILLISECONDS:EPOCH', '1:MILLISECONDS:EPOCH:tz(Asia/Shanghai)', '1:DAYS'))

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org