Connecting to Hive is easy. Here are the steps:
- To add a new connection, navigate to the File tab and click on Edit Connections, or press [⌘ + O] | [Ctrl + O].
- In the dialog box, click the Add icon (➕) next to the Connections header and select Hive.
3. To finish creating a connection, enter valid data in the fields of the New connection dialog.
- Connection name – Replace the default New Connection with a meaningful value.
- Database JDBC DRIVER – Specify user drivers for the data source, or click the 'download them' link below this field settings area. For detailed instructions on setting up drivers, see Add a user driver to an existing connection.
- Host – Enter the hostname of your Hive server.
- Port – The default value is
- Subprotocol – Select Hive 2 or Spark SQL syntax.
- User and Password – Enter your Hive credentials.
- Database – Select the database you created, or leave the field empty.
- Use Kerberos for authentication – The default value is False, but some organizations require using Kerberos with Hive.
🔎 TIP: Typically, your Hadoop administrator sets the value of these parameters.
It's best to contact them to get the appropriate data.
- Advanced Properties – Supply additional JDBC parameters if needed.
- Click Test to ensure that the connection to the data source is successful.
- Click Save. A newly created connection will be displayed in your Database Explore panel just right under the Connections header.
🔎 NOTE: If you need more advanced information on how to set up a Hive connection,
please, contact us through firstname.lastname@example.org