search

apache / pinot

Apache Pinot - A realtime distributed OLAP datastore
https://pinot.apache.org/
Apache License 2.0
5.39k stars 1.26k forks source link

Support group-by without aggregation #11923

Open Jackie-Jiang opened 10 months ago

Jackie-Jiang commented 10 months ago

Currently queries such as SELECT a, b FROM table GROUP BY a, b is rewritten to SELECT DISTINCT a, b FROM table and we solve it as distinct query. But queries such as SELECT a + b FROM table GROUP BY a, b should not be solved as distinct because query semantic is different. We stopped rewriting such queries in #9605, and they are no longer supported. We should support this query natively without query rewrite

tibrewalpratik17 commented 1 month ago

Assigning this to @tarun11Mavani as he is helping us on this! This has been a tech-debt for us from quite some time as discussed in this issue - https://github.com/apache/pinot/issues/11866#issuecomment-1789351098

tarun11Mavani commented 1 month ago

@tibrewalpratik17 please assign this to me