Simba’s ODBC and JDBC standardized solutions enable standard SQL-92 access directly to Apache Hive distributions. 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. 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. Queries, including joins, are translated from SQL to 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.
Simba’s Apache Hive Drivers efficiently transform an application’s SQL query into the equivalent form in HiveQL.
