51cto赵强HADOOP学习（十四）hive数据导入

使用load语句

语法

image.png

将student01.txt数据导入t2
load data local inpath '/root/data/student01.txt' into table t2;
将student01.txt数据导入t3
load data local inpath '/root/data/student01.txt' into table t3;

将/root/下的所有数据文件导入t3表中，并且覆盖原来的数据
load data local inpath '/root/data/' overwrite into table t3;

将HDSF中,/input/student01.txt'  导入到t3
load data inpath '/input/student01.txt' overwrite into table t3;

vi data1.txt
1,Tom,M
3,Mike,M
vi data2.txt
2,Mary,F

load data local inpath '/root/data/data1.txt' into table partition_table partition (gender='M');
load data local inpath '/root/data/data2.txt' into table partition_table partition (gender='F');