Cloudera JDBC Driver for Impala
Version 2.5.28
Important Notice
© 2010-2015 Cloudera, Inc. All rights reserved.
Cloudera, the Cloudera logo, Cloudera Impala, Impala, 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.28
Date: October 2, 2015
2 |
Cloudera JDBC Driver for Impala
Table of Contents
INTRODUCTION 5
SYSTEM R EQUIREMENTS 5
CLOUDERA JDBC DRIVER FOR IMPALA FILES 6
USING THE CLOUDERA JDBC DRIVER FOR I MPALA 6
SETTING THE CLASS PATH 7
INITIALIZING THE DRIVER CLASS 7
BUILDING THE CONNECTION URL 7
JAVA SAMPLE CODE 8
CONFIGURING AUTHENTICATION 12
USING NO AUTHENTICATION 12
USING KERBEROS 12
USING USER NAME 13
USING USER NAME AND PASSWORD 13
CONFIGURING SSL 13
FEATURES 14
SQL TRANSLATION 15
DATA TYPES 15
CATALOG AND SCHEMA SUPPORT 16
INTERFACES AND SUPPORTED METHODS 16
CONTACT US 73
APPENDIX A CONFIGURING KERBEROS AUTHENTICATION FOR WINDOWS 74
DOWNLOADING AND INSTALLING MIT KERBEROS FOR WINDOWS 74
USING THE MIT KERBEROS TICKET MANAGER TO GET TICKETS 74
USING THE DRIVER TO GET TICKETS 75
USING AN EXISTING SUBJECT TO AUTHENTICATE THE CONNECTION 76
APPENDIX B DRIVER CONFIGURATION OPTIONS 79
ALLOWSELFSIGNEDCERTS 79
AUTHMECH 79
CAISSUED CERTNAMESMISMATCH 79
CATALOGSCHEMASWITCH 80
DEFAULTSTRINGCOLUMNL ENGTH 80
DELEGATIONUID 80
KRBHOSTFQDN 81
KRBREALM 81
KRBSERVICENAME 81
Cloudera JDBC Driver for Impala
| 3
Introduction
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 14.
The Cloudera JDBC Driver for Impala complies with the JDBC 3.0, 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 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 may also find the information helpful. Refer to your
application for details on connecting via JDBC.
System Requirements
Each computer where you use the Cloudera JDBC Driver for Impala must have Java Runtime
Environment (JRE) installed. The version of JRE that must be installed depends on the version of
the JDBC API you are using with the driver. Table 1 lists the required version of JRE for each
version of the JDBC API.
JDBC API Version JRE Version
3.0 4.0 or 5.0
4.0 6.0 or later
4.1 7.0 or later
Table 1. Cloudera JDBC Driver for Impala System Requirements
The driver is suitable for use with all versions of Cloudera Impala.
Cloudera JDBC Driver for Impala
| 5
Introduction