You are trying to do a linear interpolation with a null value and that will create a NULL value.
You have null in 00:10 and the previous value is 00:05, so all the slide_time that will use those 2 values to do an linear interpolation, will return null.
Does make sense?
Search found 2 matches
- Wed Feb 13, 2013 8:59 pm
- Forum: vSQL
- Topic: Timeseries Aggregate Function and NULL Values
- Replies: 2
- Views: 18876
- Wed Feb 13, 2013 8:41 pm
- Forum: New to Vertica
- Topic: Does Size Matter?
- Replies: 6
- Views: 17705
Re: Does Size Matter?
In addition when loading the data the size matter too! At a customer site who has all the varchar(64000) when we change the columns size with got 3x load improvement.