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

The NeuralNetPredict call must use the same argument values that were used in the NeuralNet call that created the model for the following arguments: InputColumns, HiddenLayers, WeightTable, NumOutputs, and GroupByColumns. In this example, only InputColumns and HiddenLayers are applicable.

DROP TABLE IF EXISTS nn_bc_predict;

CREATE TABLE nn_bc_predict DISTRIBUTE BY hash(samplecode) AS
SELECT * FROM NeuralNetPredict (
  ON breast_cancer_test AS testdata PARTITION BY ANY
  ON cancer_output AS modeldata DIMENSION
  InputColumns ('clumpthickness', 'uniformityofcellsize',
                'uniformityofcellshape', 'marginaladhesion',
                'singleepithelialcell', 'barenuclei','blandchromatin',
                'normalnucleoli', 'mitoses')
  HiddenLayers ('10')
  Accumulate ('samplecode', 'class')
) ORDER BY samplecode;