Create Training and Testing Tables - 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

From the sparse input table svm_iris_input, create a training table (with 80% of the rows) and a testing table (with 20% of the rows):

CREATE TABLE svm_iris_input_train AS
  SELECT * FROM svm_iris_input WHERE id%5!=0;

CREATE TABLE svm_iris_input_test AS
  SELECT * FROM svm_iris_input WHERE id%5=0;

The testing table is input to the SparseSVMPredictor function. The testing table, which is input to the SparseSVMPredictor function, is Input.

SparseSVMTrainer Example Input Table svm_iris_input_train
id species attribute value
1 setosa sepal_length 5.1
1 setosa sepal_width 3.5
1 setosa petal_length 1.4
1 setosa petal_width 0.2
2 setosa sepal_length 4.9
2 setosa sepal_width 3.0
2 setosa petal_length 1.4
2 setosa petal_width 0.2
3 setosa sepal_length 4.7
3 setosa sepal_width 3.2
... ... ... ...