GsHZ7Pd7

1CREATE EXTERNAL TABLE IF NOT EXISTS inputData (lines STRING) location '/user/maria_dev/data/';
2CREATE TABLE IF NOT EXISTS dataset(i1 INT, i2 INT, i3 INT, i4 INT, i5 INT, i6 INT, i7 INT, i8 INT, i9 INT, class STRING);
3
4INSERT INTO dataset SELECT split(lines, ' ')[0], 
5  split(lines, ' ')[1], 
6  split(lines, ' ')[2], 
7  split(lines, ' ')[3], 
8  split(lines, ' ')[4], 
9  split(lines, ' ')[5], 
10  split(lines, ' ')[6], 
11  split(lines, ' ')[7], 
12  split(lines, ' ')[8], 
13  split(lines, ' ')[9] FROM inputData;
14  
15SELECT * FROM dataset