7.00.02 - SQL-MapReduce Call - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
SELECT * FROM XGBoost_Drive (
  ON (SELECT 1) PARTITION BY 1
  InputTable ('housing_train_binary')
  OutputTable ('xgboost_model')
  ResponseColumn ('homestyle')
  PredictionType ('classification') 
  NumericInputs ('price','lotsize','bedrooms','bathrms','stories','garagepl')
  CategoricalInputs ('driveway','recroom','fullbase','gashw','airco',
    'prefarea')
  LossFunction ('binomial')
  IterNum (10)
  MaxDepth (10)
  MinNodeSize (1)
  RegularizationLambda ('1')
  ShrinkageFactor ('0.1')
  IdColumn ('sn')
  NumBoostedTrees ('2')
  DropOutputTable ('true')
);