Jackie-Jiang opened a new pull request #6022:
URL: https://github.com/apache/incubator-pinot/pull/6022


   ## Description
   Add `IN_SUBQUERY` transform function to support `IDSET` aggregation function 
as the subquery. The subquery is handled as a separate query on broker side.
   
   E.g. The following 2 queries can be combined into one query:
   `SELECT ID_SET(col) FROM table WHERE date = 20200901`
   `SELECT DISTINCT_COUNT(col), date FROM table WHERE IN_ID_SET(col, 
'<serializedIdSet>') = 1 GROUP BY date`
   ->
   `SELECT DISTINCT_COUNT(col), date FROM table WHERE IN_SUBQUERY(col, 'SELECT 
ID_SET(col) FROM table WHERE date = 20200901') = 1 GROUP BY date`


----------------------------------------------------------------
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:
us...@infra.apache.org



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

Reply via email to