pjpringle opened a new issue, #11322: URL: https://github.com/apache/pinot/issues/11322
NullPointerException at GapFillProcessor.java:109 for the following Fix is to uppercase DOUBLE within the lastwithvalue aggregate ``` SELECT GAPFILL(time_col,'1:MILLISECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd HH:mm:ss.SSS','2021-10-01 09:00:00.000', '2021-10-01 12:00:00.000','30:MINUTES', FILL(status, 'FILL_PREVIOUS_VALUE'), TIMESERIESON(lotId)), lotId, status FROM ( SELECT DATETIMECONVERT(event_time,'1:MILLISECONDS:EPOCH', '1:MILLISECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd HH:mm:ss.SSS','30:MINUTES') AS time_col, lotId, lastWithTime(is_occupied, event_time, 'double') AS status -- issue here FROM parking_data WHERE event_time >= 1633078800000 AND event_time <= 1633089600000 GROUP BY 1, 2 ORDER BY 1 LIMIT 100) LIMIT 100) ``` Also time column must be the first column in the select statement else we get a time conversion exception. -- 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.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
