Progress DataDirect Hadoop Apache Hive JDBC Driver

http://www.datadirect.com/products/jdbc/apache-hadoop-hive

The DataDirect driver for Apache Hive is the only fully-compliant JDBC driver supporting multiple Hadoop distributions out-of-the-box. With the latest release of DataDirect Connect, the JDBC driver also supports the latest iteration of Apache Hive (“Hive2”), which includes improved support for concurrency and authentication. Those enhancements have also become available in key Apache Hadoop distributions such as Cloudera CDH 4.1. DataDirect Connect XE for JDBC 7.1 includes full Hive2 support and Cloudera CDH 4.1 certification. The improved concurrency allows the JDBC driver to manage concurrent connections to the Hive2 server, enabling better scalability and high availability for those applications requiring highly efficient access to Hive databases. In addition, improved authentication to the Hive2 server allows for plain text passwords and better overall authorized access and data security.

  • High-performance and throughput with support for Hive2 and concurrent connections
  • Improved authentication for increased data security
  • Cloudera CDH 4.1 certification plus Cloudera Hive2 support
  • In addition to Cloudera, support for Apache, MapR, and Amazon EMR Hadoop distributions
  • Windows, RedHat, Solaris, SUSE, AIX, and HP-UX platform support
  • SELECT, INSERT [OVERWRITE] SELECT, LOAD, and CREATE/DROP Hive grammar support
  • Full driver metadata
  • Support for parameter arrays, processing the arrays as a series of executions, one execution for each row in the array
  • Support for standard SQL functionality, including Create Index, Create Table, Create View, Drop Index, Drop Table, Drop View
  • Support for a wide range of data types: Int, TinyInt, SmallInt, BigInt, String, Double, Binary, Boolean, Float, and Timestamp

Suported Data Sources

Suported Driver Technologies

Company

Progress DataDirect (http://www.datadirect.com/)