Hive中导入和导出数据的方式

导入：
1从本地导入： load data local inpath ‘/home/1.txt’ (overwrite)into table student;
2从Hdfs导入： load data inpath ‘/user/hive/warehouse/1.txt’ (overwrite)into table student;
3建表导入： create table student1 as select * from student;
4插入导入：insert （overwrite）into table staff select * from student;

导出：
1导出到本地：（注意insert后没有into ）
insert overwrite local directory ‘/home/robot’
rom format delimited fields terminated by ‘\t’
select * from staff;
2导出到HDFS
insert overwrite directory ‘/user/hive/1/2’ rom format delimited fields terminated by ‘\t’
select * from staff;
3通过shell导出
$ bin/hive -e “select * from staff;” > /home/z/backup.log
4Sqoop把hive数据导出到外部