7.00.02 - Response Tables - 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)

Response tables, created from the raw train and test data, are used as inputs.

DROP TABLE IF EXISTS iris_response_train;
CREATE DIMENSION TABLE iris_response_train (pid INTEGER, response VARCHAR);
INSERT INTO iris_response_train SELECT id, species FROM iris_train;

The following query returns the output shown in the following table:

SELECT * FROM iris_response_train ORDER BY pid;
Single_Tree_Drive Example 1 Response Table iris_response_train
pid response
1 1
2 1
3 1
4 1
6 1
7 1
8 1
9 1
11 1
12 1
13 1
14 1
16 1
... ...
DROP TABLE IF EXISTS iris_response_test;
CREATE DIMENSION TABLE iris_response_test (pid INTEGER, response VARCHAR);
  INSERT INTO iris_response_test SELECT id, species FROM iris_test;

The following query returns the output shown in the following table:

SELECT * FROM iris_response_test ORDER BY pid;
Single_Tree_Drive Example 1 Response Table iris_response_test
pid response
5 1
10 1
15 1
20 1
25 1
30 1
35 1
40 1
45 1
50 1
55 2
60 2
65 2
70 2
75 2
80 2
85 2
90 2
95 2
100 2
105 3
110 3
115 3
120 3
125 3
130 3
135 3
140 3
145 3
150 3