Impala Execute
Category: Data
Node id: cloudera-impala-execute
Standards: HIPAA, GDPR
Run a write-path or DDL statement against Cloudera Impala: CREATE/ALTER/DROP TABLE, INSERT/UPDATE/DELETE, INSERT ... SELECT, COMPUTE STATS, etc. Returns rows affected. Server connection is configured on this node.
What it does
- DDL (CREATE/ALTER/DROP) and DML (INSERT/UPDATE/DELETE)
- Parameterized statements
- Inline server + Kerberos config
Runtime
- Performance tier:
variable
Input ports
| Name | Type | Required | Description |
|---|---|---|---|
sql | text | No | Statement to run (overrides config.sql) |
params | json | No | Optional bind parameters for '?' placeholders |
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 Statement | sql | text | Yes | DDL/DML to execute (CREATE TABLE, INSERT, UPDATE, DELETE, ALTER, DROP, …). Use '?' for bind params. |
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. |
Runtime notes
- result.rows_affected holds the affected count (DDL reports 0/-1).
See Build any workflow for how to put nodes together and Ports, types and data flow for how port types connect.
¿Algo no está claro? Envíe sus comentarios sobre la documentación por correo electrónico..