Perform Impala Canary Operations

Pulse provides Impala Canary actions that help you test, validate, and monitor Impala availability and query performance. You can configure, execute, and track these actions directly from the Pulse UI.

Available Canary Actions:

• impala-canary-create-delete-table – Creates and deletes a table in Impala to validate responsiveness and stability.
• impala-canary-select – Executes a select query to measure query latency and success rate.

impala_canary_create_delete

This action validates end-to-end Impala operations by creating and deleting a table on a specified Impala Server.

Workload

• Creates a table on a user-specified Impala Server.
• Deletes the table.

Metrics Collected

• Query success/failure status.
• Query execution time (end-to-end latency).

Steps to Configure

1. In the Pulse UI, go to Actions from the left navigation bar.
2. From the list of actions, select impala_canary_create_delete-table or hover over the name and click the three-dots menu (⋮) > Edit.

3. The Create Action Plan page opens, showing the Action Workflow.
4. In the Action Workflow, click the Edit icon for the following action to configure parameters as required.

Perform Impala Canary Operations

• The Impala Canary test is prefilled with the action impala_canary_create_delete.
• db_name: Enter the database name. Ensure that the database already exists.
• Is cluster kerberized: Enable this option if Kerberos authentication is enabled on the cluster.
• Keytab: Provide the location of the Hive keytab file.
• Principal: Enter the node where you want to run the canary test.
• Table Name: Specify the table name that the canary should create and then delete.
• Impala Coordinator Host: Hostname of the Impala coordinator node the canary connects to for running the test.
• Enable Impala SSL: Enable this to use TLS/SSL when connecting via impala-shell.
• Impala CA Certificate Path: File path to the CA certificate used to verify the Impala server’s SSL certificate.

After configuring the action plan, see Finalize and Execute the Action Plan for the next step.

impala_canary_select

This action validates read operations on an Impala table.

Workload

• Runs a read query on a specified table.

Metrics Collected

• Query success/failure status.
• Query execution time (end-to-end latency).

Steps to Configure

• From the list of actions, select Impala_canary_select.
• On the Create Action Plan page, edit the action runbooks in Action Flow.
• Configure Perform Impala Canary Operations as shown in impala_canary_create_delete > Steps to Configure > Step 4 for the task impala canary select.

The only changes are as follows:

• The Impala Canary test is prefilled with the action impala_canary_select.

After configuring the action plan, see Finalize and Execute the Action Plan for the next step.