文件格式
1 a
2 b
3 c
4 d
a.txt
表:
hive> CREATE TABLE a (id INT, bar STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ;
hive> LOAD DATA LOCAL INPATH '/usr/cooler-tmp/hive/a.txt' OVERWRITE INTO TABLE a;
hive> select * from c;
OK
1 a
2 b
3 c
4 d
Time taken: 0.117 seconds
结果如上。。呵呵,成功~~
1 a
2 b
3 c
4 d
a.txt
表:
hive> CREATE TABLE a (id INT, bar STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ;
hive> LOAD DATA LOCAL INPATH '/usr/cooler-tmp/hive/a.txt' OVERWRITE INTO TABLE a;
hive> select * from c;
OK
1 a
2 b
3 c
4 d
Time taken: 0.117 seconds
结果如上。。呵呵,成功~~