Vertica has a special feature to join tables and fill in the last available values where values would otherwise be null. I had a similar use case and wanted to test how I could make the best use of it. I played with simple examples and got it right, but with a slightly more complex one, I was stuck or maybe I just couldn’t understand what was happening. So I posted a question at Stackoverflow
Exploring Vertica's INTERPOLATE predicate
Exploring Vertica's INTERPOLATE predicate, which joins tables and fills gaps with the last known value, with simple examples and the case that stumped me.
