[GitHub] [pinot] walterddr commented on issue #9531: Aggregation query's shouldn't return rows when there isn't any data

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

walterddr commented on issue #9531:
URL: https://github.com/apache/pinot/issues/9531#issuecomment-1278243048

   > apologies missed this. Maybe the multi-stage engine supports this, but these are not valid queries at the moment in Pinot, so I don't think they apply.
   > 
   
   yes they are valid queries in v2 engine
   
   > ```
   > SELECT * FROM tbl WHERE count > (SELECT count(*) FROM tbl);
   > ```
   > 
   > I don't really understand this query. What is `count`? Is it a field in `tbl`?
   
   yes assume `"count"` is a column in `tbl`
   
   


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