We all love Hue. However, it isn't always the perfect tool for doing a lot of querying, so you've probably looked toward some 3rd party tools for database connectivity. There are many such tools, but DBeaver has a very capable free version and is among the most popular. Connecting it to a Hive virtual warehouse isn't difficult, but there are a few gotchas that can make it frustrating. So let's conquer those obstacles.
Here is a video walkthrough of the process.
Provision a Hive Virtual Warehouse
Log into a CDP instance
Navigate to Data Warehouse
Enable your Data Warehouse Environment & Database Catalog
Create a New Virtual Warehouse
Give your virtual warehouse a unique name
Select your database catalog from the dropdown SSO may be enabled or disabled, the choice is yours!
Set Availability Zone and User Groups per your requirements or leave as-is
Pick the size (aka decide how much money you want to spend) The remaining options are going to depend on your needs, but the defaults are fine for our purposes.
Click Create. Expect approximately 5 minutes to create your virtual warehouse.
Download the JDBC Jar
From your virtual warehouse tile, click on the kebab icon in the upper right. You'll find all sorts of fun options under there, but we're primarily interested in the Download JDBC Jar option, which will download the Hive jar to your local machine. You can leave it in your Downloads folder, or move it to wherever you like to store your jars. It will be named similar to this:
Copy the JDBC URL
Again, from the kebab icon in your virtual warehouse tile, copy the JDBC URL. This URL has all the necessary information to make the connection, and should be of the form: