1.操作准备数据源
drop table if exists b;
create table b as select id,name,tel,age from b;
2.复制文件
如果数据文件恰好是用户需要的格式,那么只需要复制文件或文件夹就可以
hadoop fs -cp source_path target_path
3.导出到本地文件系统
不能使用insert into local directory来导出数据(会报错),只能使用insert overwrite local directory来导出数据
insert overwrite local directory ‘/home/hivecalss/output’ select id,name,tel,age from b;
insert overwrite local directory ‘/home/hivecalss/output’
row format deimited fields terminated by ‘,’
select id,name,tel,age from b;
当然还可以导出数据到逗哥输出文件夹
from b
insert overwrite local directory ‘/home/hivcalss/ouput/a’
select * where base.age = 30
insert overwrite local directory ‘/home/hivcalss/ouput/b’
select * where base.age = 25;
4.导出到HDFS
和导出到本地文件系统相比,命令中少了一个local
insert overwrite directory ‘/hivecalss/output’
select id,name,tel,age from b;
insert overwrite directory ‘/hivecalss/output’
row format deimited fields terminated by ‘,’
select id,name,tel,age from b;
5.导出到Hive的另一个表
use hivecalss;
create table a like b;
insert into table a
select id,name,tel,age from b;
6.使用Hive的-e和-f参数命令导出数据
使用Hive的-e参数
#hive -e “select * from hivecalss.a”>>/home/hivecalss/output/b.txt
使用Hive的-f参数
#cd /home/hivecalss/input
#vim a.hql
#hive -f /home/hivecalss/input/a.hql>>/home/hivecalss/output/a.txt