Cloudera JDBC
Driver for Apache
Hive
Important Notice
© 2010-2018 Cloudera, Inc. All rights reserved.
Cloudera, the Cloudera logo, and any other product or service names or slogans contained in this
document, except as otherwise disclaimed, are trademarks of Cloudera and its suppliers or
licensors, and may not be copied, imitated or used, in whole or in part, without the prior written
permission of Cloudera or the applicable trademark holder.
Hadoop and the Hadoop elephant logo are trademarks of the Apache Software Foundation. All
other trademarks, registered trademarks, product names and company names or logos
mentioned in this document are the property of their respective owners. Reference to any
products, services, processes or other information, by trade name, trademark, manufacturer,
supplier or otherwise does not constitute or imply endorsement, sponsorship or
recommendation thereof by us.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the
rights under copyright, no part of this document may be reproduced, stored in or introduced into
a retrieval system, or transmitted in any form or by any means (electronic, mechanical,
photocopying, recording, or otherwise), or for any purpose, without the express written
permission of Cloudera.
Cloudera may have patents, patent applications, trademarks, copyrights, or other intellectual
property rights covering subject matter in this document. Except as expressly provided in any
written license agreement from Cloudera, the furnishing of this document does not give you any
license to these patents, trademarks copyrights, or other intellectual property.
The information in this document is subject to change without notice. Cloudera shall not be liable
for any damages resulting from technical errors or omissions which may be present in this
document, or from use of this document.
Cloudera, Inc.
1001 Page Mill Road, Building 2
Palo Alto, CA 94304-1008
info@cloudera.com
US: 1-888-789-1488
Intl: 1-650-843-0595
www.cloudera.com
Release Information
Version: 2.6.1
Date: April 27, 2018
2 |
Cloudera JDBC Driver for Apache Hive
Table of Contents
ABOUT THE CLOUDERA JDBC DRIVER FOR APACHE HIVE 5
SYSTEM REQUIREMENTS 6
CLOUDERA JDBC DRIVER FOR APACHE HIVE FILES 7
INSTALLING AND USING THE CLOUDERA JDBC DRIVER FOR APACHE HIVE 8
REFERENCING THE JDBCDRIVER LIBRARIES 8
REGISTERING THE DRIVER CLASS 8
BUILDING THE CONNECTION URL 10
CONFIGURING AUTHENTICATION 12
USING NO AUTHENTICATION 12
USING KERBEROS 12
USING USER NAME 13
USING USER NAME AND PASSWORD (LDAP) 14
USING A HADOOP DELEGATION TOKEN 15
AUTHENTICATION MECHANISMS 17
CONFIGURING KERBEROS AUTHENTICATION FOR WINDOWS 19
KERBEROS ENCRYPTION STRENGTH AND THE JCE POLICY FILES EXTENSION 23
CONFIGURING SSL 25
CONFIGURING SERVER-SIDE PROPERTIES 27
CONFIGURING LOGGING 28
FEATURES 30
SQL QUERY VERSUS HIVEQL QUERY 30
DATA TYPES 30
CATALOG AND SCHEMA SUPPORT 31
WRITE-BACK 31
IHADOOPSTATEMENT 32
IHADOOPCONNECTION 35
SECURITY AND AUTHENTICATION 38
INTERFACES AND SUPPORTED METHODS 38
DRIVER CONFIGURATION OPTIONS 93
ALLOWSELFSIGNEDCERTS 93
ASYNCEXECPOLLINTERVAL 93
AUTHMECH 94
CAISSUEDCERTSMISMATCH 94
CATALOGSCHEMASWITCH 94
DECIMALCOLUMNSCALE 95
Cloudera JDBC Driver for Apache Hive
| 3
DEFAULTSTRINGCOLUMNLENGTH 95
DELEGATIONTOKEN 95
DELEGATIONUID 96
HTTPPATH 96
KRBAUTHTYPE 96
KRBHOSTFQDN 97
KRBREALM 97
KRBSERVICENAME 98
LOGLEVEL 98
LOGPATH 99
PREPAREDMETALIMITZERO 99
PWD 99
ROWSFETCHEDPERBLOCK 100
SOCKETTIMEOUT 100
SSL 100
SSLKEYSTORE 101
SSLKEYSTOREPWD 101
SSLTRUSTSTORE 101
SSLTRUSTSTOREPWD 102
TRANSPORTMODE 102
UID 103
USENATIVEQUERY 103
ZK
103
CONTACT US 105
THIRD-PARTY TRADEMARKS 106
THIRD-PARTY LICENSES 107
4 |
Cloudera JDBC Driver for Apache Hive
About the Cloudera JDBC Driver for Apache Hive
The Cloudera JDBC Driver for Apache Hive is used for direct SQL and HiveQL access to Apache
Hadoop / Hive distributions, enabling Business Intelligence (BI), analytics, and reporting on
Hadoop / Hive-based data. The driver efficiently transforms an application’s SQL query into the
equivalent form in HiveQL, which is a subset of SQL-92. If an application is Hive-aware, then the
driver is configurable to pass the query through to the database for processing. The driver
interrogates Hive to obtain schema information to present to a SQL-based application. Queries,
including joins, are translated from SQL to HiveQL. For more information about the differences
between HiveQL and SQL, see "Features" on page 30.
The Cloudera JDBC Driver for Apache Hive complies with the JDBC 4.0 and 4.1 data standards.
JDBC is one of the most established and widely supported APIs for connecting to and working with
databases. At the heart of the technology is the JDBC driver, which connects an application to the
database. For more information about JDBC, see Data Access Standards on the Simba
Technologies website:https://www.simba.com/resources/data-access-standards-glossary.
This guide is suitable for users who want to access data residing within Hive from their desktop
environment. Application developers might also find the information helpful. Refer to your
application for details on connecting via JDBC.
Cloudera JDBC Driver for Apache Hive
| 5
About the Cloudera JDBC Driver for Apache Hive