Overview
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.
Hive 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.
The followings are highlights of some enhancements and new features:
- 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.52 data access solution for Apache Hive
Contact Us
Telephone: +1.604.633.0008
Email: solutions@simba.com
Web: www.simba.com
Twitter: @SimbaTech
About Simba Technologies Inc.
Simba Technologies (www.simba.com, @SimbaTech) is the recognized world leader in standards-based data access and analytics products and solutions for both relational and multi-dimensional data sources. Simba provides data connectivity solutions to many of the world’s leading companies on various platforms, including Windows, Mac, UNIX, Linux and many mobile device platforms. Simba’s data connectivity products support multiple interfaces, including ODBC, JDBC, OLE DB, OLE DB for OLAP (ODBO), XML for Analysis (XMLA), ADO, ADO.NET, ADOMD and ADOMD.NET.
Simba’s software is used worldwide. Its customers include leading independent software vendors and global enterprises like Alteryx®, Altiscale®, Cloudera®, Couchbase®, Databricks®, Datastax®, Google®, Hortonworks®, MapR®, Microsoft®, Oracle®, Qubole®, SAP®, Splunk®, Tableau®, and Teradata®.
