Interpolator Example 1: Aggregation - Teradata Vantage

SQL Calls

These two calls produce the same result.

SELECT * FROM Interpolator (
  ON company1_stock1 AS input_table PARTITION BY id ORDER BY period
  USING
  TimeColumn ('period')
  TimeInterval (86400) 
  ValueColumns ('stockprice')
  AggregationType ('min[(window(2))]') 
  ValuesBeforeFirst (0)
  ValuesAfterLast (0)
  Accumulate ('id')
) AS dt ORDER BY period;

SELECT * FROM Interpolator (
  ON company1_stock1 AS input_table PARTITION BY id ORDER BY period
  ON time_table1 AS time_table DIMENSION ORDER BY period 
  USING 
  TimeColumn ('period')
  ValueColumns ('stockprice')
  AggregationType ('min[(window(2))]')
  ValuesBeforeFirst (0)
  ValuesAfterLast (0)
  Accumulate ('id')
) AS dt ORDER BY period;

Output