7.00.02 - SQL-MapReduce Call - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

These two calls produce the same result.

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