Connecting Apache Hive™ to ODBC/JDBC Applications: A How-to

(This Simba Technologies-authored post is published at MapR. Read it in its entirety here.)

The MapR Distribution including Apache™ Hadoop® employs drivers from Simba Technologies to connect to client ODBC and JDBC applications allowing you to access data on MapR from tools like Tableau with ODBC or SQuirreL with JDBC. This post will walk you through the steps to set up and connect your Apache Hive instance to both an ODBC and JDBC application running on your laptop or other client machine. Although you may already have your own Hive cluster set up, this post focuses on the MapR Sandbox for Hadoop virtual machine (VM). There are several steps to setting up, and then connecting Hive to your ODBC/JDBC app:

  1. Configure Hive
  2. Create Data
  3. Create Hive Table
  4. Configure ODBC

  5. Connect via ODBC
  6. Connect via JDBC


Read more…