CREATE TABLE table_1 (
ind STRING,
val1 FLOAT,
val2 FLOAT)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;

LOAD DATA INPATH '<Local System Input Data Folder>/InputData.txt'
OVERWRITE INTO TABLE table_1;

SELECT COUNT(*)
 FROM u0_kv3_data;

CREATE TABLE  table_2 (
ind STRING,
val1 FLOAT,
val2 FLOAT,
val3 FLOAT)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t';

add FILE Threesetmapper.py;
add FILE Threesetreducer.py;

INSERT OVERWRITE TABLE table_2
SELECT
      TRANSFORM (ind,val1,val2)
      USING 'python Threesetmapper.py'
      AS (ind,val1,val2,val3)
      FROM table_1
      CLUSTER BY ind;

SELECT ind,val1,val2,val3
FROM  table_2 limit 10;

CREATE TABLE table_3 (
ind STRING,
val1 FLOAT,
val2 FLOAT,
val3 FLOAT)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t';

INSERT OVERWRITE TABLE table_3
SELECT
   TRANSFORM (ind, val1, val2, val3)
    USING 'python Threesetreducer.py' 
    AS (ind,val1,val2,val3)
    FROM table_2;

SELECT ind,val1,val2,val3
FROM table_3 limit 10;