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