Impala Drivers for ODBC and JDBC

Transforms an application’s SQL query into the equivalent Impala SQL.
Overview
Features
Specifications
Documentation

Simba’s Impala ODBC Driver with SQL Connector leverages the low latency SQL queries and Massive Parallel Processing capabilities of Cloudera Impala

impala-diagramcloudera-impalaSimba’s ODBC and JDBC Drivers for Impala are the official Cloudera-endorsed ODBC and JDBC interfaces for Impala. The Simba drivers efficiently transform any application’s SQL queries into the equivalent form in Impala SQL. Impala SQL provides a high degree of compatibility with the Hive Query Language, and is a subset of SQL-92. The Simba ODBC and JDBC drivers are fully aware of the capabilities of Impala and can take any standard ODBC, JDBC, and SQL queries and ensure full compatibility with Impala. Queries, including joins, are translated from ANSI SQL to Impala SQL.

Impala is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Impala is based on Hive, and developed by Cloudera to deliver fast performance. Simba’s ODBC and JDBC drivers efficiently map ANSI SQL to Impala SQL delivering full SQL application functionality and real-time analytic and reporting capabilities to users.

Product Highlights

  • Supports on-premise and cloud deployments
  • Supports data types: TinyInt, SmallInt, Int, BigInt, Float, Double, Boolean, String and TimeStamp
  • Maps ANSI SQL to Impala SQL
  • Only direct, universal ODBC 3.52 data access solution for Impala
  • Endorsed by Cloudera as the only ODBC driver included in CDH
  • JDBC version supports JDBC 3.0 and 4.0

The Simba Impala driver for ODBC is currently available with Cloudera’s CDH (which includes Impala) here: http://go.cloudera.com/odbc-driver-hive-impala.html

m4s0n501

Product Features

  • Direct BI connectivity to data without extraction
  • Supports on-premise and cloud deployments
  • Only direct, universal ODBC 3.52 data access solution for Cloudera Impala
  • Powerful SQL Connector allows users to define schemas on the fly on schema-less data
  • Full compatibility with leading analytic/reporting apps, including Alteryx, Microsoft Excel & Access, SAP Crystal Reports, Tableau and more
  • Maps ANSI SQL to Impala SQL
  • Impala SQL pass-through query option
  • Provides full driver and query metadata

Product Specifications

  • Supports on-premise and cloud deployments
  • Supports 32- and 64-bit applications
  • Complies with latest ODBC 3.52 specification
  • Supports Unicode
  • Supports multiple platforms, including Windows, RedHat Linux, SUSE Linux, Solaris, AIX, HP-UX and Mac OS X
  • Supports Impala SQL: SELECT, INSERT [OVERWRITE] SELECT, LOAD, and CREATE/DROP statements
  • Supports ANSI SQL-92: SELECT/ORDER BY/GROUP BY/HAVING/CROSSJOIN/INNER JOIN/(LEFT|RIGHT|FULL) OUTER JOIN|UNION ALL
  • Supports ANSI SQL-92 DDL and DML
  • Supports data types: TinyInt, SmallInt, Int, BigInt, Float, Double, Boolean, String and TimeStamp

Product FAQ

Product Documentation

FREE Trial

ODBC

A password will be emailed to you.

JDBC

Contact Us

+1 (604) 633-0008

Contact Sales

+1 (604) 633-0008
solutions@simba.com

Webinar

How to Build an ODBC Driver in Just 5 Days!

Play Webinar