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 Purchase
Customer Technical Support

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