Hive Result into File

  • hive
  • linux

posted on 09 Mar 2018 under category 人生经验

hive -e 'set hive.cli.print.header=true; select * from your_Table' | sed 's/[\t]/,/g'  > /home/yourfile.csv

set hive.cli.print.header=true

导出字段名称

sed ‘s/[\t]/,/g’

hive 结果默认用tab分隔字段，sed将tab替换为逗号