SQL-MapReduce Call - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
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;