pjpringle opened a new issue, #11668: URL: https://github.com/apache/pinot/issues/11668
In V1 can write a query like this where updatedTimestamp is a long millis column. `select country, lastwithtime( val, updatedTimestamp, 'double' ) from myTable where purchaseDate='2023-09-25' group by country limit 10` Running the same thing in V2 gives this error `Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 16 to line 1, column 62: Cannot apply 'LASTWITHTIME' to arguments of type 'LASTWITHTIME(<DOUBLE>, <BIGINT>, <CHAR(6)>)'. Supported form(s): 'LASTWITHTIME(<ANY>, <TIMESTAMP>, <CHARACTER>)'` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
