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;
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;
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 |