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

Use the Accumulate argument to pass the homestyle variable, to easily compare the actual and predicted response for each observation.

CREATE TABLE rf_housing_predict DISTRIBUTE BY hash (sn) AS
SELECT * FROM Forest_Predict (
  ON housing_test
  Forest ('rft_model')
  NumericInputs ('price ', 'lotsize ', 'bedrooms ', 'bathrms ',
                 'stories ', 'garagepl')
  CategoricalInputs ('driveway ', 'recroom ', 'fullbase ', 'gashw ',
                     'airco ', 'prefarea')
  IdColumn ('sn')
  Accumulate ('homestyle')
  Detailed ('false')
);