创建表:
CREATE EXTERNAL TABLE person(id INT, name string,age int)
row format delimited
fields terminated by '\t'
lines terminated by '\n'
STORED AS TEXTFILE;
导入本地文件:
load data local inpath '/home/masterj/modules/apache-hive-1.2.2-bin/test_data/person.txt' into table person;