Impala Query
Category: Data
Node id: cloudera-impala-query
Standards: HIPAA, GDPR
Run a read-path SQL query against Cloudera Impala. Configure the server connection (host, protocol, database, Kerberos/keytab) on this node; supports '?' bind params.
What it does
- Parameterized Impala SQL
- Inline server + Kerberos config
- Proxied + audited via Connect
Runtime
- Performance tier:
variable
Input ports
| Name | Type | Required | Description |
|---|---|---|---|
params | json | No | Optional bind parameters for the SQL '?' placeholders |
sql | text | No | Optional SQL overriding config.sql |
Output ports
| Name | Type | Required | Description |
|---|---|---|---|
result | json | No | Parsed JSON response payload from the vendor API |
metadata | json | No | Operation, HTTP status code, and content length |
success | boolean | No | True if HTTP 2xx |
Settings
Basic
| Setting | Name | Type | Required | Default | Allowed values | Description |
|---|---|---|---|---|---|---|
| SQL | sql | text | Yes | SELECT statement with optional '?' bind params. | ||
| Max Rows | max_rows | number | No | 0 | Cap rows returned (0 = no cap). |
Connection
| Setting | Name | Type | Required | Default | Allowed values | Description |
|---|---|---|---|---|---|---|
| Impala Host | impala_host | string | No | Impala coordinator host (Flight SQL / HS2). Required for Impala operations. | ||
| Impala Port | impala_port | number | No | Impala port (Flight SQL default 443/tls; HS2 21050). | ||
| Impala Protocol | impala_protocol | enum | No | flightsql | flightsql, hs2 | Wire protocol: Arrow Flight SQL (preferred) or HiveServer2 Thrift. |
| Database | impala_database | string | No | Default Impala database/schema for unqualified table names. | ||
| Impala TLS | impala_tls | boolean | No | true | Use TLS for the Impala connection (grpc+tls for Flight SQL, https for HS2). | |
| HS2 HTTP Path | impala_http_path | string | No | cliservice | HiveServer2 HTTP path for the hs2 protocol (Cloudera Data Warehouse uses 'cliservice'). | |
| HDFS / httpFS URL | hdfs_url | string | No | WebHDFS/httpFS base URL, e.g. https://httpfs.cluster:14000. Required for HDFS operations. | ||
| HDFS Base Path | hdfs_base | string | No | Base path that relative HDFS paths resolve against, e.g. /data/dicom. |
Auth
| Setting | Name | Type | Required | Default | Allowed values | Description |
|---|---|---|---|---|---|---|
| Impala Username (LDAP) | impala_username | string | No | LDAP user for Impala basic-auth (Cloudera Data Warehouse). Leave blank to use Kerberos. | ||
| Impala Password (LDAP) | impala_password | secret | No | LDAP password for the Impala user. Stored as a secret. | ||
| Kerberos Principal | kerberos_principal | string | No | Service principal, e.g. tietai@REALM. Leave blank for a non-Kerberized cluster. | ||
| Kerberos Realm | kerberos_realm | string | No | Realm (defaults to the part after @ in the principal). | ||
| KDC Host | kerberos_kdc | string | No | Key Distribution Center host, e.g. kdc.cluster. | ||
| Keytab (base64) | keytab_base64 | secret | No | Base64-encoded keytab for the principal. Stored as a secret; sent to Connect over the call. |
Advanced
| Setting | Name | Type | Required | Default | Allowed values | Description |
|---|---|---|---|---|---|---|
| Mock (dev) | mock | boolean | No | false | Use an in-memory mock backend (no cluster/Kerberos) for local development and testing. |
Errors
| Code | Description |
|---|---|
SERVER_REQUIRED | No Impala host / HDFS URL configured (and mock disabled) |
Runtime notes
- result.columns + result.rows carry the query result (rows aligned to columns).
See Build any workflow for how to put nodes together and Ports, types and data flow for how port types connect.
Something unclear? Send documentation feedback by email.