Hive几种数据导出方式

转自：http://www.iteblog.com/archives/955

http://blog.csdn.net/xiao_jun_0820/article/details/32328755

谈到了Hive中几种数据的导入方式，不同的数据导入方式用途不一样。今天我们再谈谈Hive中的几种不同的数据导出方式。可以根据导出的地方不一样，将这些方式分为三种：（1）、导出到本地文件系统；（2）、导出到HDFS中；（3）、导出到Hive的另一个表中。为了避免单纯的文字，我将一步一步地用命令进行说明。

　　一、导出到本地文件系统

　　hive> insert overwrite local directory '/home/wyp/wyp'    > select * from wyp;
hive -e"
use dim_pubdb;
use dw_analysisdb; 
select orderdate,checkindate,ahead,hotelid,hotelname,basichotelid
,roomid,roomname,basicroomid,basicroomname,a.country,a.city,a.cityname,zone,zonename,star                                                                                                                 
,starlevel,balancetype,ordertype,ismodifiedorder,biztype,totalrooms                                                                                                                 
,totalroomsnotcancel,successrooms,totalamount,totalcost,totalamountrefund                                               
,totalamountnotcancel,totalcostnotcancel,totalamountnotcancelrefund                                      
,orderidset,insertdate     
from dw_analysisdb.FactBuyOutHotelCheckInRoomsNew2 
 a inner join 
(select country,countryname,cityid,cityname 
from dim_pubdb.dimcity )
 b on (a.country=b.country and a.city=b.cityid and a.country=3 and a.zone=794)">>/home/bihtlread/pxx/sing1.csv