SQL-MapReduce Call - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

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;