weixiangsun commented on issue #7977: URL: https://github.com/apache/pinot/issues/7977#issuecomment-1013529526
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 -- 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