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
SELECT * FROM VARMAX (
  ON milk_3 AS data PARTITION BY id_partition ORDER BY period
  ON (
    SELECT * FROM TimeSeriesOrders (
      ON milk_3 PARTITION BY id_partition ORDER BY period ASC
      TimestampColumns ('period')
      ResponseColumn ('milkpound')
      PartitionColumns ('id_partition')
    )
  ) AS orders PARTITION BY id_partition
  ResponseColumns ('milkpound')
  PartitionColumns ('id_partition')
  MaxIterNum (1000)
  Method ('ML')
);