Recent Posts

Archive

Tags

No tags yet.

Hive cheatsheet

Few useful commands for quick copy-paste!

Replace comma with CTRL+A in currencies.txt. Ready for load to HDFS/Hive!

sed -i -e 's/,/^A/g' currencies.txt

Hive JDBC:

jdbc:hive2://<host>:<port>/<db>;ssl=true;sslTrustStore=<trust_store_path>;trustStorePassword=<trust_store_password>

beeline -u jdbc:hive2://localhost:10000 -n debian

#Blog #Hive #Hadoop

©2017 BY JIRI DATA WORKS. JIRI DATA WORKS LTD. IS A COMPANY REGISTERED IN ENGLAND AND WALES WITH COMPANY NUMBER 10763223.