Impala ODBC and JDBC Driver
Transform application SQL into Impala SQL
Simba ODBC and JDBC drivers for Impala are the official Cloudera-endorsed ODBC and JDBC interfaces for Impala. Simba connectors 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 connectors 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.
Apache 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 connectors efficiently map ANSI SQL to Impala SQL delivering full SQL application functionality and real-time analytic and reporting capabilities to users.
Features
| Direct BI connectivity to data without extraction |
| Supports on-premise and cloud deployments |
| Only direct, universal ODBC 3.8 data access solution for Apache 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 connector 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 versions 2.7. through 3.3. |
| 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 |
Ready to buy? We're here to help!
If you are evaluating our drivers or our Simba SDK, our Sales Engineers would be
happy to assist you.