Skip to content

Instantly share code, notes, and snippets.

@vithalsamp

vithalsamp/Export hive table to CSV using DSV format.sh

Created February 25, 2018 11:58
Show Gist options
  • Save vithalsamp/e6c767c696886cc2d20fdead8e008298 to your computer and use it in GitHub Desktop.
Save vithalsamp/e6c767c696886cc2d20fdead8e008298 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Export hive table to CSV using DSV format.sh
$ beeline -u jdbc:hive2://192.168.0.41:10000/test_db -n user1 -p password --outputformat=dsv --delimiterForDSV=',' -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.323 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment