You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "shuitai (via GitHub)" <gi...@apache.org> on 2023/06/08 00:25:15 UTC

[GitHub] [pinot] shuitai opened a new issue, #10872: Has pinot supported subquery?

shuitai opened a new issue, #10872:
URL: https://github.com/apache/pinot/issues/10872

   I find the doc link https://docs.pinot.apache.org/users/user-guide-query/gap-fill-functions
   In section: Aggregation/Gapfill/Aggregation
   
   The query supports subquery or nested sql, which means pinot support nested sql now?
   
   SELECT time_col, SUM(status) AS occupied_slots_count
   FROM (
       SELECT GAPFILL(time_col,'1:MILLISECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd HH:mm:ss.SSS','2021-10-01 09:00:00.000',
                      '2021-10-01 12:00:00.000','30:MINUTES', FILL(status, 'FILL_PREVIOUS_VALUE'),
                       TIMESERIESON(lotId)), lotId, status
       FROM (
           SELECT DATETIMECONVERT(event_time,'1:MILLISECONDS:EPOCH',
                  '1:MILLISECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd HH:mm:ss.SSS','30:MINUTES') AS time_col,
                  lotId, lastWithTime(is_occupied, event_time, 'INT') AS status
           FROM parking_data
           WHERE event_time >= 1633078800000 AND  event_time <= 1633089600000
           GROUP BY 1, 2
           ORDER BY 1
           LIMIT 100)
       LIMIT 100)
   GROUP BY 1
   LIMIT 100
   


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

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org.apache.org

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] [pinot] shuitai commented on issue #10872: Has pinot supported subquery?

Posted by "shuitai (via GitHub)" <gi...@apache.org>.
shuitai commented on issue #10872:
URL: https://github.com/apache/pinot/issues/10872#issuecomment-1590277354

   @Jackie-Jiang  Thanks for your reply, the topic In #7043 is about two years ago, so what about the release plan? We are comparing druid and pinot, druid could support subquery, but pinot has some features which druid doesn't have, so if pinot could support subquery, we will prefer to pinot.


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

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

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] [pinot] Jackie-Jiang commented on issue #10872: Has pinot supported subquery?

Posted by "Jackie-Jiang (via GitHub)" <gi...@apache.org>.
Jackie-Jiang commented on issue #10872:
URL: https://github.com/apache/pinot/issues/10872#issuecomment-1589843700

   Currently that is supported only within GAP_FILL. We are evaluating the correctness and overhead of enabling it for general queries. If it works well, we can enable it for all queries.


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

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

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] [pinot] Jackie-Jiang commented on issue #10872: Has pinot supported subquery?

Posted by "Jackie-Jiang (via GitHub)" <gi...@apache.org>.
Jackie-Jiang commented on issue #10872:
URL: https://github.com/apache/pinot/issues/10872#issuecomment-1589844576

   Same topic as #7043 


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

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

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] [pinot] walterddr commented on issue #10872: Has pinot supported subquery?

Posted by "walterddr (via GitHub)" <gi...@apache.org>.
walterddr commented on issue #10872:
URL: https://github.com/apache/pinot/issues/10872#issuecomment-1595598701

   sub-query is supported. the problem is this particular sub-query is not supported :-) reason is exactly in GAP-FILL


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

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

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] [pinot] Jackie-Jiang commented on issue #10872: Has pinot supported subquery?

Posted by "Jackie-Jiang (via GitHub)" <gi...@apache.org>.
Jackie-Jiang commented on issue #10872:
URL: https://github.com/apache/pinot/issues/10872#issuecomment-1595488581

   The new multi-stage query engine (with join support) should support sub-query (cc @walterddr to confirm). One concern of directly supporting sub-query in the single-stage query engine is that the outer query is executed on the single broker, which might potentially consume too much resource.
   If this is a deal breaker and multi-stage engine doesn't work, we can consider prioritizing this feature request.


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

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

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] [pinot] shuitai commented on issue #10872: Has pinot supported subquery?

Posted by "shuitai (via GitHub)" <gi...@apache.org>.
shuitai commented on issue #10872:
URL: https://github.com/apache/pinot/issues/10872#issuecomment-1596410859

   @walterddr  @Jackie-Jiang  if sub-query is supported or not support fully, could you please provide detail examples in document?
   


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

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

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