Cloudera JDBC
Connector for
Apache Impala
Important Notice
© 2010-2022 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.29
Date: July 2022
2 |
Cloudera JDBC Connector for Apache Impala
Contents
ABOUT THE CLOUDERA JDBC CONNECTOR FOR APACHE IMPALA 5
SYSTEM REQUIREMENTS 6
CLOUDERA JDBC CONNECTOR FOR APACHE IMPALA FILES 7
INSTALLING AND USING THE CLOUDERA JDBC CONNECTOR FOR APACHE IMPALA 8
REFERENCING THE JDBCCONNECTOR LIBRARIES 8
REGISTERING THE CONNECTOR CLASS 9
BUILDING THE CONNECTION URL 9
CONFIGURING AUTHENTICATION 11
USING NO AUTHENTICATION 11
USING KERBEROS 11
USING USER NAME 12
USING USER NAME AND PASSWORD (LDAP) 13
USING SINGLE SIGN-ON 13
CONFIGURING KERBEROS AUTHENTICATION FOR WINDOWS 14
USING KERBEROS CONSTRAINED DELEGATION 18
CONFIGURING SSL 19
CONFIGURING SERVER-SIDE PROPERTIES 21
CONFIGURING LOGGING 22
FEATURES 24
SQL TRANSLATION 24
DATA TYPES 24
CATALOG AND SCHEMA SUPPORT 25
WRITE-BACK 25
SECURITY AND AUTHENTICATION 26
MULTITHREADING SUPPORT 26
INTERFACES AND SUPPORTED METHODS 27
CONNECTOR CONFIGURATION OPTIONS 83
ALLOWSELFSIGNEDCERTS 83
ASYNCEXECPOLLINTERVAL 83
AUTHMECH 84
CAISSUEDCERTSMISMATCH 84
CATALOGSCHEMASWITCH 84
DEFAULTSTRINGCOLUMNLENGTH 85
DELEGATIONUID 85
HTTPPATH 85
Cloudera JDBC Connector for Apache Impala
| 3
IGNORETRANSACTIONS 86
KRBAUTHTYPE 86
KRBHOSTFQDN 87
KRBREALM 87
KRBSERVICENAME 87
LOGLEVEL 87
LOGPATH 88
LOWERCASERESULTSETCOLUMNNAME 89
NONROWCOUNTQUERYPREFIXES 89
OPTIMIZEDINSERT 89
PREPAREDMETALIMITZERO 90
PWD 90
ROWSFETCHEDPERBLOCK 90
SOCKETTIMEOUT 91
SSL 91
SSLKEYSTORE 91
SSLKEYSTOREPROVIDER 92
SSLKEYSTOREPWD 92
SSLKEYSTORETYPE 92
SSLTRUSTSTOREPROVIDER 92
SSLTRUSTSTORE 93
SSLTRUSTSTOREPWD 93
SSLTRUSTSTORETYPE 93
SSOWEBSERVERTIMEOUT 94
STRIPCATALOGNAME 94
SUPPORTTIMEONLYTIMESTAMP 94
TRANSPORTMODE 94
UID 95
UPPERCASERESULTSETCOLNAME 95
USENATIVEQUERY 96
USESASL (DEPRECATED) 96
CONTACT US 97
4 |
Cloudera JDBC Connector for Apache Impala
About the Cloudera JDBC Connector for Apache Impala
The Cloudera JDBC Connector for Apache 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 connector 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 connector is configurable to pass the query through to the database for
processing. The connector 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 24.
The Cloudera JDBC Connector for Apache Impala complies with the JDBC 4.1 and 4.2 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 connector, 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 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 Connector for Apache Impala
| 5
About the Cloudera JDBC Connector for Apache Impala
