Hello, do exists an Out Of the box for fill in gaps between rows with a given condition? As example: I have a source table with data and a column with the day number, but the record only register a event and no necessary all days have events, so the table no necessary has all days. But I want a resultant Table with all days, filled in the data with 0 o same as row before.
I'm using SQLContext. I think window function will do that, but I cant use it without hive context, Is that right? regards -- Ing. Ivaldi Andres