Databricks ODBC driver for Apache Spark
The Databricks ODBC Driver with SQL Connector for Apache Shark is used for direct SQL and HiveQL access to Apache Hadoop / Shark distributions, enabling Business Intelligence (BI), analytics, and reporting on Hadoop-based data. The driver efficiently transforms an application’s SQL query into the equivalent form in HiveQL. Hive Query Language is a subset of SQL-92. If an application is Hive-aware, then the driver is configurable to pass the query through. The driver interrogates Shark to obtain schema information to present to a SQL-based application. Queries, including joins, are translated from SQL to HiveQL.