somandal commented on issue #10677: URL: https://github.com/apache/pinot/issues/10677#issuecomment-1525998942
I've requested more information from the user. Need details about the schema for the fields they used and the relevant index configs. User mentioned the type for updatedTime is TIMESTAMP. Tried a few queries (not using TIMESTAMP but using CAST) which seem to work: ``` SET useMultistageEngine=true; SELECT col1, col2, MAX(CAST(col3 AS DOUBLE)) OVER(PARTITION BY col1) from TestTable WHERE col3 = 1000 OR col3 = 1024 AND col1 < 2845947 LIMIT 10000 ``` In the above col3 is a LONG type column. -- 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
