导入:
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数据导出到外部