hive 导出数据到文件

导出数据到文件

方法1 推荐

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

方法2

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