Impala Insert
Category: Data
Node id: cloudera-impala-insert
Standards: HIPAA, GDPR
Append (or overwrite) structured rows in a Cloudera Impala table via INSERT INTO / INSERT OVERWRITE. For idempotent Kudu writes use Kudu Upsert. Server connection is configured on this node.
Runtime
- Performance tier:
variable
Input ports
| Name | Type | Required | Description |
|---|---|---|---|
rows | json | Yes | Array of row objects (column->value); all rows share the same columns |
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 |
|---|---|---|---|---|---|---|
| Table | table | string | Yes | Target Impala table (optionally db-qualified). | ||
| Overwrite | overwrite | boolean | No | false | Use INSERT OVERWRITE (replace) instead of INSERT INTO (append). |
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.count is the number of rows inserted.
See Build any workflow for how to put nodes together and Ports, types and data flow for how port types connect.
Etwas unklar? Senden Sie Feedback zur Dokumentation per E-Mail..