Split Input into Training and Testing Data Sets - Aster Analytics

This code divides the 150 data rows into a training data set (70%) and a testing data set (30%). The training data set is input for the NeuralNet function.

DROP TABLE IF EXISTS breast_cancer_train;

CREATE TABLE breast_cancer_train DISTRIBUTE BY hash(samplecode) AS
SELECT * from breast_cancer_data ORDER BY samplecode ASC LIMIT 489;

SELECT * FROM breast_cancer_train ORDER BY samplecode;

DROP TABLE IF EXISTS breast_cancer_test;
CREATE TABLE breast_cancer_test DISTRIBUTE BY hash(samplecode) AS
SELECT * FROM breast_cancer_data ORDER BY samplecode DESC LIMIT 210;
SELECT * FROM breast_cancer_train ORDER BY samplecode;