Installing the driver on Linux 

Install the Databricks ODBC Driver with SQL Connector for Apache Shark on Linux for direct SQL and HiveQL access to Apache Hadoop / Shark distributions.

To install the ODBC driver for Spark on Linux.

Prerequisites

  • System Requirements
    • Red Hat® Enterprise Linux® (RHEL) 5.0, CentOS 5.0 or SUSE Linux Enterprise Server (SLES) 11. Both 32 and 64-bit editions are supported.
    • 45 MB of available disk space.
    • An installed ODBC driver manager (either of the following):
      • iODBC 3.52.7 or above
      • unixODBC 2.2.12 or above
  • The driver requires a Hadoop cluster with the Spark service installed and running.
  • The driver is suitable for use with all versions of Spark.

Procedure

  1. Download the driver from Client Libraries and CQL Drivers.
  2. Decompress and unarchive the file you downloaded.
    $ tar zxvf SimbaSharkODBC-32bit-0.1.0.0001-1.i686.tar.gz
  3. Add the driver's lib directory to your system's LD_LIBRARY_PATH environmental variable.