You can set up a connection to a Hive databases here. Simply populate the requested data into the form.
You can choose either Hive 2 or Spark SQL syntax when executing against Hive databases. You can choose either value in this dropdown.
Setting up Kerberos connections
In a lot of cases organizations 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:
- Service name
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.
You can supply additional Hive JDBC parameters using the Advanced Properties section.
Here is the link to other configurable parameters supported within Hive JDBC’s driver