Simba’s Apache Hive Drivers efficiently transform an application’s SQL query into the equivalent form in HiveQL. The Hive Query Language, a subset of SQL-92, allows Simba’s solutions to interrogate Hive to obtain schema information to present to a SQL-based application. Queries, including joins, are translated from SQL to HiveQL. Market leaders such as Alteryx®, DataStax®, Hortonworks®, MapR® are powered by Simba standards-based ODBC and JDBC to enable Business Intelligence (BI), analytics and reporting on Hive-based data.

Simba Hive ODBC & JDBC Driver Connectivity diagramHive 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.

Simba’s ODBC and JDBC standardized solutions enable standard SQL-92 access directly to Apache Hive distributions. They efficiently map SQL to HiveQL delivering full SQL application functionality and real-time analytic and reporting capabilities to users.

Product Highlights

  • Supports all major on-premise and cloud Hadoop / Hive distributions: Apache, Cloudera, DataStax, Hortonworks, MapR and others
  • Supports data types: TinyInt, SmallInt, Int, BigInt, Float, Double, Boolean, String, Decimal and TimeStamp
  • Maps SQL to HiveQL
  • Only direct, universal ODBC 3.8 data access solution for Apache Hive
  • Supports JDBC 3.0 and 4.0

Features

  • Direct BI connectivity to data without extraction
  • Supports all major on-premise and cloud Hadoop / Hive distributions
  • Only direct, universal ODBC 3.8 data access solution for Apache Hive
  • 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, Tableau, PowerBI and more
  • Maps SQL to HiveQL
  • HiveQL pass-through query option
  • Provides full driver and query metadata

Specifications

  • Supports all major on-premise and cloud Hadoop / Hive distributions: Apache, Cloudera, DataStax, Hortonworks, MapR and others
  • Supports Hive 0.70 and later
  • Supports 32- and 64-bit applications
  • Complies with latest ODBC 3.8 specification
  • Supports Unicode
  • Supports multiple platforms, including Windows, RedHat, SUSE, Solaris SPARC, AIX,  and Mac OS X
  • Supports HiveQL: 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, Decimal and TimeStamp

Get Hive ODBC and JDBC Drivers with SQL Connector

Simba’s Apache Hive ODBC and JDBC Drivers with SQL Connector offer direct SQL and HiveQL access to Apache™ Hadoop™ / Hive™ distributions.

Download Now 30 Days Free Trial

Contact us

Questions? Ready to Buy?
Let's talk.

We'll get back to you within the next business day.

Evaluation and Sales Support
If you are evaluating our drivers or our SimbaEngine X SDK, our Sales Engineers would be happy to assist you. If you are ready to buy or you require licensing information, please complete the form provided, or contact us by email or phone:
+1-604-633-0008 x2 or connectivity@magnitude.com

Customer Technical Support

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