Cloudera JDBC Driver for Impala
Version 2.5.36
Important Notice
© 2010-2016 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.5.36
Date: December 15, 2016
2 |
Cloudera JDBC Driver for Impala
Table of Contents
ABOUT THE CLOUDERA JDBC DRIVER FOR IMPALA 5
SYSTEM REQUIREMENTS 6
CLOUDERA JDBC DRIVER FOR IMPALA FILES 7
INSTALLING AND USING THE CLOUDERA JDBC DRIVER FOR IMPALA 8
REFERENCING THE JDBCDRIVER LIBRARIES 8
REGISTERING THE DRIVER CLASS 8
BUILDING THE CONNECTION URL 9
CONFIGURING AUTHENTICATION 11
USING NO AUTHENTICATION 11
USING KERBEROS 11
USING USER NAME 12
USING USER NAME AND PASSWORD 12
CONFIGURING KERBEROS AUTHENTICATION FOR WINDOWS 13
USING KERBEROS CONSTRAINED DELEGATION 17
CONFIGURING SSL 18
CONFIGURING SERVER-SIDE PROPERTIES 20
CONFIGURING LOGGING 21
FEATURES 23
SQL TRANSLATION 23
DATA TYPES 23
CATALOG AND SCHEMA SUPPORT 24
SECURITY AND AUTHENTICATION 24
INTERFACES AND SUPPORTED METHODS 25
DRIVER CONFIGURATION OPTIONS 79
ALLOWSELFSIGNEDCERT 79
AUTHMECH 79
CAISSUEDCERTNAMESMISMATCH 80
CATALOGSCHEMASWITCH 80
DEFAULTSTRINGCOLUMNLENGTH 80
DELEGATIONUID 81
KRBAUTHTYPE 81
KRBHOSTFQDN 81
KRBREALM 82
KRBSERVICENAME 82
LOGLEVEL 82
Cloudera JDBC Driver for Impala
| 3
LOGPATH 83
LOWERCASERESULTSETCOLUMNNAME 83
OPTIMIZEDINSERT 84
PREPAREDMETALIMITZERO 84
PWD 84
ROWSFETCHEDPERBLOCK 85
SOCKETTIMEOUT 85
SSL 85
SSLKEYSTORE 86
SSLKEYSTOREPWD 86
SSLTRUSTSTORE 86
SSLTRUSTSTOREPWD 87
STRIPCATALOGNAME 87
SUPPORTTIMEONLYTIMESTAMP 87
UID 88
USENATIVEQUERY 88
USESASL 88
CONTACT US 89
4 |
Cloudera JDBC Driver for Impala
About the Cloudera JDBC Driver for Impala
The Cloudera JDBC Driver for Impala is used for direct SQL and Impala SQL access to Apache
Hadoop / Impala distributions, enabling Business Intelligence (BI), analytics, and reporting on
Hadoop / Impala-based data. The driver efficiently transforms an application’s SQL query into the
equivalent form in Impala SQL, which is a subset of SQL-92. If an application is Impala-aware, then
the driver is configurable to pass the query through to the database for processing. The driver
interrogates Impala to obtain schema information to present to a SQL-based application. Queries,
including joins, are translated from SQL to Impala SQL. For more information about the
differences between Impala SQL and SQL, see "Features" on page 23.
The Cloudera JDBC Driver for Impala 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 the Data Access Standards Glossary:
http://www.simba.com/resources/data-access-standards-library.
This guide is suitable for users who want to access data residing within Impala 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 Impala
| 5
About the Cloudera JDBC Driver for Impala