Query Cloudera Hadoop Hive using Oracle SQL Developer.

First download and install the popular free tool Oracle SQL Developer for Windows from Oracle website. Read this blog for a good idea about connecting Oracle SQL Developer to Hadoop Hive:¬† ¬†https://blogs.oracle.com/bigdataconnectors/move-data-between-apache-hadoop-and-oracle-database-with-sql-developer Note when configuring Cloudera-Hive JDBC drivers use the below website to download the 64bit JDBC driver for windows. https://www.cloudera.com/downloads/connectors/hive/jdbc/2-5-19.html In the Tools->Preferences->Database->Third party … Continue reading Query Cloudera Hadoop Hive using Oracle SQL Developer.

Advertisements