一 语法
LOAD DATA [LOCAL] INPATH 'filepath' [OVERWRITE]
INTO TABLE tablename [PARTITION (partcol1=val1,partcol2=val2 ...)]
二 表
hive> desc t2;
OK
tid int
tname string
age int
Time taken: 2.176 seconds, Fetched: 3 row(s)
hive> desc t3;
OK
tid int
tname string
age int
Time taken: 0.525 seconds, Fetched: 3 row(s)
三 要导入的数据
[root@localhost ~]# more student01.txt
1,Tom,23
2,Mary,20
[root@localhost ~]# more student02.txt
3,Mike,25
[root@localhost ~]# more student03.txt
4,Scott,21
5,King,20