DROP TABLE IF EXISTS T1; CREATE TABLE T1(A STRING,B STRING, C STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; LOAD DATA LOCAL INPATH '/path/to/sourceData1.txt' OVERWRITE INTO TABLE T1; DROP TABLE IF EXISTS T2; CREATE TABLE T2(A1 STRING,B1 STRING, C1 STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; LOAD DATA LOCAL INPATH '/path/to/sourceData1.txt' OVERWRITE INTO TABLE T2; DROP TABLE IF EXISTS T4; CREATE TABLE T4(A STRING, B STRING, C STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; LOAD DATA LOCAL INPATH '/path/to/sourceData1.txt' OVERWRITE INTO TABLE T4; CREATE TABLE T6(col0 STRING, col1 STRING, col2 DOUBLE, col3 ARRAY, col4 STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' COLLECTION ITEMS TERMINATED BY '|' STORED AS TEXTFILE; LOAD DATA LOCAL INPATH '/path/to/sourceData2.txt' OVERWRITE INTO TABLE T6;