Setting up Hive Connections

You can set up a connection to a Hive databases here. Simply populate the requested data into the form.

mceclip0.png

Picking Subprotocol

You can choose either Hive 2 or Spark SQL syntax when executing against Hive databases. You can choose either value in this drop down.

Setting up Kerberos connections

In a lot of cases organisations require the use of Kerberos with Hive so by clicking on the radio button for Use Kerberos for authentication you will be prompted to enter the following:

  • Realm
  • FQDN
  • Service name
 
Note
The value of these parameters are typically set by your Hadoop
administrator and it is best to work with them to obtain the appropriate values.

Advanced Parameters

You can supply additional Hive JDBC parameters using the Advanced Properties section.

See also
Here is the link to other configurable parameters supported within Hive JDBC’s driver
 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request