alamb commented on issue #4809: URL: https://github.com/apache/arrow-datafusion/issues/4809#issuecomment-1372176134
> But my concern is, to provide a good use experience and functionality, we may need a bunch of "gap-filling" functions. Like filling it with null, filling it with the last value, filling it with the last value if the gap is less than 1 day otherwise left blank etc. I'm not sure if these "time-series functions" is also useful to other users of DataFusion (but it might be fine as PostgreSQL also provides such utils). I agree specifying the interpolation policy / gap filling is important. In addition to the simple https://docs.timescale.com/api/latest/hyperfunctions/gapfilling-interpolation/locf/ function they have `interpolate` and one of the examples shows how to do some complicated lookup that appear similar to what you are suggesting https://docs.timescale.com/api/latest/hyperfunctions/gapfilling-interpolation/interpolate/ I wonder if that would be sufficient 🤔 -- 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: github-unsubscr...@arrow.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
