Today, Simba Technologies Inc. announced the launch of its innovative Spark ODBC Driver version 1.0.2.
The Simba ODBC Driver with SQL Connector for Apache Spark is used for direct SQL and Spark SQL access to Apache Hadoop / Spark distributions, enabling Business Intelligence (BI), analytics, and reporting on Hadoop-based data.
How it works: The driver efficiently transforms an application’s SQL query into the equivalent form in Spark SQL, a subset of SQL-92. If an application is Spark-aware, then the driver is configurable to pass the query through. The driver interrogates Spark to obtain schema information to present to a SQL-based application. Queries, including joins, are translated from SQL to Spark SQL.
Some cool new features/benefits
- SQL Query versus Spark SQL Query
- SQL Connector
- Supports all Common Data Types
- Catalog and Schema Support
Learn more about Spark 1.0.2 in the official release notes.