Skip to content

Instantly share code, notes, and snippets.

@vithalsamp

vithalsamp/Export hive table to CSV.sh

Last active February 25, 2018 11:57
Show Gist options
  • Save vithalsamp/22cc2dc8c3b0602642aea1483ca2d327 to your computer and use it in GitHub Desktop.
Save vithalsamp/22cc2dc8c3b0602642aea1483ca2d327 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Export hive table to CSV.sh
$ beeline -u jdbc:hive2://192.168.0.41:10000/test_db -n user1 -p password --outputformat=csv2 -e "select * from t1";
Connecting to jdbc:hive2://192.168.0.41:10000/test_db
Connected to: Apache Hive (version 1.2.1000.2.5.0.0-1245)
Driver: Hive JDBC (version 1.2.1000.2.5.0.0-1245)
Transaction isolation: TRANSACTION_REPEATABLE_READ
t1.x,t1.s
1,one
3,three
2,two
1,one
1,four
3,five
2,six
7,seven
8 rows selected (0.197 seconds)
Beeline version 1.2.1000.2.5.0.0-1245 by Apache Hive
Closing: 0: jdbc:hive2://192.168.0.41:10000/test_db
$ beeline -u jdbc:hive2://192.168.0.41:10000/test_db -n user1 -p password --outputformat=csv2 -e "select * from t1" > result.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment