Train and Test Set - Aster Analytics

The input data set has 150 rows that are split into a train set (80%) and a test set (20%). You can perform the split either with the following code or with the Sample function (giving the SampleFraction attribute the value 0.8).

DROP TABLE IF EXISTS svm_iris_train;
DROP TABLE IF EXISTS svm_iris_test;

CREATE TABLE svm_iris_train AS
SELECT * FROM svm_iris WHERE id%5 != 0;

CREATE TABLE svm_iris_test AS
SELECT * FROM svm_iris WHERE id%5 = 0;

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

SELECT * FROM svm_iris_train ORDER BY id;

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

SELECT * FROM svm_iris_test ORDER BY id;