Simba’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.

Simba Impala ODBCand JDBC Driver connectivity diagram
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.8 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

Features

  • Direct BI connectivity to data without extraction
  • Supports on-premise and cloud deployments
  • Only direct, universal ODBC 3.8 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

Specifications

  • Supports on-premise and cloud deployments
  • Supports 32- and 64-bit applications
  • Complies with latest ODBC 3.8 specification
  • Supports Unicode
  • Support for Impala 2.8
  • Supports ANSI SQL-92 DDL and DML
  • 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 data types: TinyInt, SmallInt, Int, BigInt, Float, Double, Boolean, String and TimeStamp

Get Impala ODBC and JDBC Drivers with SQL Connector

Simba’s Impala ODBC and JDBC Drivers with SQL Connector leverage the low-latency SQL query and Massive Parallel-processing capabilities of Cloudera Impala

Download Now 30 Days Free Trial Purchase
Customer Technical Support

If you are a customer, please use our Magnitude Customer Support Portal