beeline对数据的导出操作
(2019-07-26 20:31:18)beeline 数据导出
beeline --showHeader=false --outputformat=dsv
--delimiterForDSV=$'\001' -e 'select * from evan_test3'
>test.csv
----导出干净的格式
beeline -u
'jdbc:hive2://h7:2181,h6:2181,h5:2181/ods;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hs2_zk'
--incremental=true
-n 'username' -p 'password'
--showHeader=false --outputformat=dsv --delimiterForDSV=$'\t' -e
"select * from db.tbname where bizdate=20190322 limit 10;" >>
test.csv
参考:https://www.cnblogs.com/huaxiaoyao/p/4672316.html