hive hdfs 本地数据导出

默认数据库default

 import 数据到指定hive表中

 import table student2 partition(month='201809') from '/user/hive/warehouse/export/student';

 

insert 导出

将hive 查询结果输出到本地

insert overwrite local directory '/opt/module/datas/export/student'  select * from student;

将hive 查询结果格式化后输出到本地

insert overwrite local directory '/opt/module/datas/export/student1'
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'       select * from student;

 

export导出到hdfs

hive (default)> export  table default.student   to   '/user/hive/warehouse/export/student'; 

 

Hadoop 命令导出到本地

dfs -get  /user/hive/warehouse/student/month=201809/000000_0    /opt/module/datas/export/student3.txt;

 

Hive shell 命令导出:

hive -e 'select * from default.student;'  >  /opt/module/datas/export/student4.txt;