Using the Hive IDE

Besides the command-line interface, there are other Integrated Development Environment (IDE) tools available to support Hive. One of the best is Oracle SQL Developer, which leverages the powerful functionalities of the Oracle IDE and is totally free to use. Since Oracle SQL Developer supports general JDBC connections, it is quite convenient to switch between Hive and other JDBC-supported databases in the same IDE. Oracle SQL Developer has supported Hive since v4.0.3. Configuring it to work with Hive is quite straightforward:

1. Download Oracle SQL Developer (http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html).
2. Download the Hive JDBC drivers (https://www.cloudera.com/downloads/connectors/hive/jdbc.html).
3. Unzip the driver file to a local directory.
4. Start Oracle SQL Developer and navigate to Preferences | Database | Third Party JDBC...