Simba Apache Hive Drivers for ODBC & JDBC
Posted by: Simba Technologies
Simba's Apache Hive ODBC Driver with SQL Connector is direct SQL and HiveQL access to Apache? Hadoop? / Hive? distributions.
Overview
Simba's Apache Hive ODBC Driver efficiently transforms an application's SQL query into the equivalent form in HiveQL. The Hive Query Language, a subset of SQL-92, allows Simba's solution 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 standard based ODBC 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 standardized solution enables standard SQL-92 access directly to Apache Hive distributions. It efficiently maps 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.52 data access solution for Apache Hive.
Features
Direct BI connectivity to data without extraction.Supports all major on premise and cloud Hadoop / Hive distributions.Only direct, universal ODBC 3.52 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 & Access, SAP Crystal Reports, Tableau and more.Maps SQL to HiveQLHiveQL pass-through query option.Provides full driver and query metadata.- 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.52 specification.
- Supports Unicode
- Supports multiple platforms, including Windows, RedHat, SUSE, Solaris, AIX, HP-UX 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.
Resources
Support
Simba Technologies is the technology leader in data access and analytics software and enables you to access and analyze any data, anywhere, any time. We provide ?the glue? between front-end business intelligence applications and back-end data servers ensuring products interoperate across vendors according to established data standards such as SQL, ODBC, JDBC, ADO.NET OData, XMLA and MDX. As industry's recognized expert in real time, standards based connectivity, our solutions in Big Data and traditional Data Warehouse markets allow connectivity with legacy and next generation Business Intelligence (BI), Analytics, Reporting Tools and other Applications. Companies worldwide like Hortonworks, Google, Intel, Microsoft, Splunk, Tableau, Oracle, and SAP have partnered with Simba to enable seamless connections. Literally, millions of people use our software every day. Headquaters Simba Technologies Inc. 938 West 8th Avenue Vancouver, BC Canada V5Z 1E5. www.simba.comSolutions@simba.com Phone : +1.604.633.0008 [ext. 3] Fax : +1.604.633.0004 www.simba.com
