hive表导出

1. 导出到hadoop hdfs

启动hive , 在hive中输入：

hive> insert overwrite directory '/user/output/ouye_payed'
select TransactionMoney from OUYE_TransactionLog where transactionjob='payed';
    >

1. 导出到本地系统（hdfs格式）

hive> insert overwrite local directory '/soft_ins/test'
    > select * from test;

1. 导出到本地txt文件

bin/hive -e "SELECT  * from e6admin.gxzl_kgx_drw where mat_track_no='20150927222804386620'" >> /soft_ins/gxzl_kgx_drw.txt