[GitHub] [pinot] mapshen commented on issue #7977: lastwithtime() multiple column support

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

mapshen commented on issue #7977:
URL: https://github.com/apache/pinot/issues/7977#issuecomment-1013533004


   > In order to make the follow query work: select max(A), lastwithtime(A, array(C0, C1)) from table group by B There are two things we need pay attention to:
   > 
   > 1. We need add the data type for C0,C1 since when creating the aggregation function, there is no data type for each column;
   > 2. C0 and C1 should have the same data type
   > 
   > Here is my proposal: select max(A), lastwithtime(A, 'dataType', C0, C1) from table group by B MV should work for this use case
   
   In our use case, C0 and C1 don't necessarily are of the same type. Couldn't the function read the column type definitions from the schema directly?


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