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

To generate a reliable model, the function must converge at a low threshold value. The function typically requires thousands of iterations to converge at a low threshold, which can take hours.

For reproducibility, train a model with MaxIterNum ('6000') and use a Seed ('100').

SELECT * FROM NeuralNet (
  ON (SELECT 1) PARTITION BY 1
  InputTable ('breast_cancer_train')
  OutputTable ('cancer_output')
  InputColumns ('clumpthickness', 'uniformityofcellsize',                 'uniformityofcellshape', 'marginaladhesion',                 'singleepithelialcell', 'barenuclei', 'blandchromatin',                 'normalnucleoli', 'mitoses')
  ResponseColumns ('class')
  HiddenLayers ('10')
  OverwriteOutput ('true')
  MaxIterNum ('6000')
  Threshold ('1')
  Seed ('100')
);