O'Reilly logo

Apache Hive Essentials by Dayong Du

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Hive-integrated development environment

Besides the command-line interface, there are a few integrated development environment (IDE) tools available for Hive development. One of the best is Oracle SQL Developer, which leverages the powerful functionalities of Oracle IDE and is totally free to use. If we have to use Oracle along with Hive in a project, it is quite convenient to switch between them only from the same IDE.

Oracle SQL developer has supported Hive since version 4.0.3. Configuring it to work with Hive is quite straightforward. The following are a few steps to configure the IDE to connect to Hive:

  1. Download Hive JDBC drivers from the vendor website, such as Cloudera.
  2. Unzip the JDBC version 4 driver to a local directory.
  3. Start Oracle SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required