hive 导出数据到文件

导出数据到文件

方法1 推荐

insert overwrite local directory 'path' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
select * from my_table 

方法2

hive -e "select * from my_table" | grep -v "WARN" | tr "\t" "," > 'path'