1、创建hive表person1、person2
CREATE TABLE person1(
id INT,
name STRING,
age INT,
fav ARRAY<STRING>
)
COMMENT 'This is the person table'
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
COLLECTION ITEMS TERMINATED BY '-'
STORED AS TEXTFILE;
CREATE TABLE person2(
id INT,
name STRING,
age INT
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS&nb