Connect Beeline to Secure Hive Server2

Question

Can someone tell me how to connect to Hive Server 2 from Hive Beeline? I have installed and configured HIve Server 2 and beeline, now want to make connections between them.

Answer 1

Use the following command to start beeline and connect to a secure HiveServer2 process. In this example, the HiveServer2 process is running on localhost at port 12345:

$ /usr/lib/hive/bin/beeline
beeline> !connect jdbc:hive2://localhost:12345/default;principal=hive/HiveServer2Host@YOUR-REALM.COM
0: jdbc:hive2://localhost:10000/default>