Configuring Client Access to Impala
Application developers have a number of options to interface with Impala.
The core development language with Impala is SQL. You can also use Java or other languages to interact with Impala through the standard JDBC and ODBC interfaces used by many business intelligence tools. For specialized kinds of analysis, you can supplement the Impala built-in functions by writing user-defined functions in C++ or Java.
You can connect and submit requests to the Impala through:
- The impala-shell interactive command interpreter
- The Hue web-based user interface
- JDBC
- ODBC
- Impyla
Impala clients can connect to any Coordinator Impala Daemon
(impalad) via HiveServer2 over HTTP or over the TCP
binary or via Beeswax. All interfaces support Kerberos and LDAP for
authentication to Impala. See below for the default ports and the Impala
configuration field names to change the ports in Cloudera Manager.
| Protocol | Default Port | Cloudera Manager Field to Specify an Alternate Port |
|---|---|---|
| HiveServer2 HTTP | 28000 | Impala Daemon HiveServer2 HTTP Port |
| HiveServer2 binary TCP | 21050 | Impala Daemon HiveServer2 Port |
| Beeswax | 21000 | Impala Daemon Beeswax Port |
