Calling Stored procedure from Impala using shell script or bat file

[Imran]

Hello All,

I am looking to run stored procedure script(DB Impala) from Qlik Sense On-Prem environment using Shell Script or Bat file or any other mode and post that show the data in Qlik Sense UI. 

Is there any way or solution to achieve this? 

#!/bin/bash

# -----------------------------

# Impala Connection Details

# -----------------------------

#IMPALA_HOST="impala-hostname"

#IMPALA_PORT="21000"

DATABASE="kan_adhoc"

impala_cli="impala-shell -i kancdhdatap6.kanhadoopprd.net -d default -k --ssl"

# -----------------------------

# Impala CREATE TABLE

# -----------------------------

SQL_QUERY1="DROP TABLE IF EXISTS ${DATABASE}.aca_type;"

SQL_QUERY="CREATE TABLE IF NOT EXISTS ${DATABASE}.aca_type as select * from kan_ref.aca_type ;"

# -----------------------------

# Execute Query

# -----------------------------

#impala-shell \  -i ${IMPALA_HOST}:${IMPALA_PORT} \  -q "${SQL_QUERY}"

  $impala_cli -q "${SQL_QUERY1}"

  $impala_cli -q "${SQL_QUERY}"

# -----------------------------

# Status Check

# -----------------------------

if [ $? -eq 0 ]; then

  echo "✅ Table created successfully in Impala."

else

  echo "❌ Failed to create table in Impala."

  exit 1

fi

[henrikalmen]

It is possible to make settings for qlik that enables you to run other sql commands than just loads, for example you could trigger a stored procedure in the db: https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Enterprise-on-Windows-Execute-SQL... 

It is also possible to call external scripts from QSEoW, see for example https://help.qlik.com/en-US/sense-admin/May2026/Subsystems/DeployAdministerQSE/Content/Sense_DeployA...  or https://community.qlik.com/t5/Official-Support-Articles/How-to-create-an-external-program-task-in-Ql...

And you could trigger external tasks from load script, if you alter settings for qlik: https://help.qlik.com/en-US/sense/May2026/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularSt... 

I do not believe that data is returned in to qlik using the last two methods though, but you could make the external script store a status file (e.g. csv format), and load that status file into qlik as a table and process it's data.