mapshen opened a new issue #7977: URL: https://github.com/apache/pinot/issues/7977
Say a user has a table `t1` with 200+ columns `A`, `B`, `C0`…, `C200`. When the user runs `select max(A) from table group by B`, they get the max `A` for each `B`. If they would like to get the corresponding `C0`, …, `C200` for each `max(A)` per `B` without aggregating on or grouping by the `C` columns, they need to do ``` select max(A), lastwithtime(C0, A, 'datatype'), ..., lastwithtime(C200, A, 'datatype') from table group by B ``` But applying `lastwithtime()` for each of the columns increases the latency significantly. Is it possible to enhance `lastwithtime()` and support an arbitrary number of columns? For example, ``` select max(A), lastwithtime(A, array(C0, C1)) from table group by B ``` returns the associated values in `C0` and `C1` along with A. And by default, ``` select max(A), lastwithtime(A) from table group by B ``` can return all the columns in the record for the matching value of A. -- 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-unsubscr...@pinot.apache.org 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
