You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2021/03/22 20:50:01 UTC

[GitHub] [incubator-pinot] fx19880617 opened a new issue #6706: Support IF statement in Transform function for post aggregation

fx19880617 opened a new issue #6706:
URL: https://github.com/apache/incubator-pinot/issues/6706


   This is for queries like:
   ```
   SELECT
      IF AVG(met1) == 0 THEN 0 ELSE SUM(met0) / AVG(met1)
   FROM "auctions"
   WHERE event_time = 1601510400000
   LIMIT 1
   ```


-- 
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



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

[GitHub] [incubator-pinot] fx19880617 commented on issue #6706: Support IF statement in Transform function for post aggregation

Posted by GitBox <gi...@apache.org>.
fx19880617 commented on issue #6706:
URL: https://github.com/apache/incubator-pinot/issues/6706#issuecomment-804385891


   @Jackie-Jiang does pinot support transform function on top of aggregations?


-- 
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



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

[GitHub] [incubator-pinot] Jackie-Jiang commented on issue #6706: Support IF statement in Transform function for post aggregation

Posted by GitBox <gi...@apache.org>.
Jackie-Jiang commented on issue #6706:
URL: https://github.com/apache/incubator-pinot/issues/6706#issuecomment-805307730


   Yes, modeled as post-aggregation


-- 
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



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