hive重定向输出指定分隔符

hive重定向输出指定分隔符

20191114

---

• 1

insert overwrite local directory '/home/mypath/test' row format delimited fields terminated by ',' select * from mytable;

• 2

hive -e "select * from mytable" | tr "\t" "," > test.csv

• 3

hive -e "select * from mytable" | sed 's/\t/,/g' >  > test.csv

参考

参考1
参考2
参考3
参考4