Saltar al contenido principal

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​

NameTypeRequiredDescription
sqltextNoStatement to run (overrides config.sql)
paramsjsonNoOptional bind parameters for '?' placeholders

Output ports​

NameTypeRequiredDescription
resultjsonNoParsed JSON response payload from the vendor API
metadatajsonNoOperation, HTTP status code, and content length
successbooleanNoTrue if HTTP 2xx

Settings​

Basic​

SettingNameTypeRequiredDefaultAllowed valuesDescription
SQL StatementsqltextYesDDL/DML to execute (CREATE TABLE, INSERT, UPDATE, DELETE, ALTER, DROP, …). Use '?' for bind params.

Connection​

SettingNameTypeRequiredDefaultAllowed valuesDescription
Impala Hostimpala_hoststringNoImpala coordinator host (Flight SQL / HS2). Required for Impala operations.
Impala Portimpala_portnumberNoImpala port (Flight SQL default 443/tls; HS2 21050).
Impala Protocolimpala_protocolenumNoflightsqlflightsql, hs2Wire protocol: Arrow Flight SQL (preferred) or HiveServer2 Thrift.
Databaseimpala_databasestringNoDefault Impala database/schema for unqualified table names.
Impala TLSimpala_tlsbooleanNotrueUse TLS for the Impala connection (grpc+tls for Flight SQL, https for HS2).
HS2 HTTP Pathimpala_http_pathstringNocliserviceHiveServer2 HTTP path for the hs2 protocol (Cloudera Data Warehouse uses 'cliservice').
HDFS / httpFS URLhdfs_urlstringNoWebHDFS/httpFS base URL, e.g. https://httpfs.cluster:14000. Required for HDFS operations.
HDFS Base Pathhdfs_basestringNoBase path that relative HDFS paths resolve against, e.g. /data/dicom.

Auth​

SettingNameTypeRequiredDefaultAllowed valuesDescription
Impala Username (LDAP)impala_usernamestringNoLDAP user for Impala basic-auth (Cloudera Data Warehouse). Leave blank to use Kerberos.
Impala Password (LDAP)impala_passwordsecretNoLDAP password for the Impala user. Stored as a secret.
Kerberos Principalkerberos_principalstringNoService principal, e.g. tietai@REALM. Leave blank for a non-Kerberized cluster.
Kerberos Realmkerberos_realmstringNoRealm (defaults to the part after @ in the principal).
KDC Hostkerberos_kdcstringNoKey Distribution Center host, e.g. kdc.cluster.
Keytab (base64)keytab_base64secretNoBase64-encoded keytab for the principal. Stored as a secret; sent to Connect over the call.

Advanced​

SettingNameTypeRequiredDefaultAllowed valuesDescription
Mock (dev)mockbooleanNofalseUse 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..