[GitHub] ly923976094 edited a comment on issue #3626: timezone problem

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

ly923976094 edited a comment on issue #3626: timezone problem
URL: https://github.com/apache/incubator-pinot/issues/3626#issuecomment-450542063
 
 
   > Pinot has an inbuilt transform function for date-time conversion which supports time zone. You can refer to the following for more details: https://github.com/apache/incubator-pinot/wiki/dateTimeConvert-UDF
   > 
   > Also, note that transform functions are currently supported in group-by and projection, but not in filter (predicates).
   
   Thank you very much for your reply， yes ，The following PQL statement 1 can specify the corresponding time zone with SIMPLE_DATE_FORMAT, but the time conversion of SIMPLE_DATE_FORMAT is very time-consuming, so I want to use sentence 2 to convert the result of query to time, but the time zone cannot be defined
   
   pql1: select sum(total) from test group by dateTimeConvert(timestamp, '1:MILLISECONDS:EPOCH','1:MILLISECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd HH:mm:ss tz(Asia/Shanghai)', '1:DAYS')
   
   pql2: select sum(total) from test group by dateTimeConvert(timestamp, '1:MILLISECONDS:EPOCH','1:MILLISECONDS:EPOCH', '1:DAYS')

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on 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: dev-unsubscribe@pinot.apache.org
For additional commands, e-mail: dev-help@pinot.apache.org