Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have put properties "spark.driver.extraJavaOptions", "spark.executor.extraJavaOptions" and JVM Arguments with this
--add-opens=java.base/java.nio=ALL-UNNAMED
--add-opens=java.base/java.lang=ALL-UNNAMED
--add-opens=java.base/java.util=ALL-UNNAMED
--add-opens=java.base/java.lang.invoke=ALL-UNNAMED
--add-opens java.base/java.net=ALL-UNNAMED
--add-opens=java.base/sun.nio.ch=ALL-UNNAMED
but job still error
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
We work with Qliksense On Preim in the three-tier model (Load data, schema, application)
How do you implement in the cloud?
As I understand it, there are 3 types of spaces:
Shared, managed, data
Shared – development environment
Managed – publishing to customers
Data – data creation and storage
Personal – personal environment, parallel to work
Our architecture:
load data - shared space
Schema – shared space
Qvd files, excels and all data files – data space
Applications – managed spaces
Is this the right way?
And do you create shared, Data and managed spaces for each environment (dev, test, prod)
Hi team,
I tried to set up this LLM but currently, to make the test with Swagger on Power Automate to authorize the OAuth session, it indicates that the redirect URI is not registered, and I made this in the before steps.
Some have the same problem or know other steps to work with Qlik Cloud MCP and Copilot.
Thanks
I am currently preparing for an upgrade to Qlik Sense November 2025 (Shared Persistence) and am following the official Qlik Help documentation.
Based on my review, I’ve compiled the following backup checklist. I would appreciate it if the community could validate if I am missing any critical locations or steps.
1. Certificates
2. Repository Database Dumps (PostgreSQL)
I plan to run pg_dump for the following databases:
3. File Share (Shared Root Folder)
4. Supporting Content & Configuration Files
I have identified the following local server paths for backup. Are there any specific service-level configuration files or sub-folders I might be missing here?
5. Question on Centralized Logging (QLogs)
I noticed that the February 2020 documentation mentioned backing up the QLogs database, but this is absent from the November 2025 guide.
Any advice or "lessons learned" from those who have already moved to the 2025 releases would be greatly appreciated!
Thanks in advance,
Poonam
Hello,
I have sometimes this error in Qlik Answer (generally, when the chart agent takes the lead).
Qlik Answer : A temporary processing issue occurred. Please try again in a moment. Reason: (Error DAA-016)
Ok, if I retry, it works, but I notice that error request count in the administration home page.
We should not pay if Qlik is not answer to our request.
Regards,
Hi,
Recently i did some research about Qlik Answer. I was impressed of what was possible and how we can add the output to sheets.
Today (23/02/2026) i cannot do it anymore. What has changes?
Still possible to ask questions, but after a while now is a sheet generated linked to the last questions.
Is there permission right changed?
When will met generated sheets and when is this visibel? How can I add one bar sheet output to my sheet now?
Thx.
Hi everyone,
I am facing a challenge with a Pivot Table in Qlik Sense and I was wondering if anyone has found a workaround.
My Scenario: I have a Pivot Table with the following structure:
Rows: Product Group, Brand.
Columns: Day (Dynamic, e.g., Day 5, 6, 7...).
Measure: Sales.
The Requirement: I need the Row Total to be displayed at the beginning (Left) of the table, and critically, it must remain frozen (pinned) alongside the dimensions when the user scrolls horizontally to see the later days.
What I have tried:
Native Pivot Table: Does not support freezing measures/totals natively.
Vizlib Pivot Table: I have the full Vizlib Library. I configured the "Row Totals Position" to "Before" (Top/Left). Result: The Total column correctly appears on the left side, BUT it is not frozen. When I scroll to the right to see "Day 20", the Total column disappears/scrolls away along with the data columns.
My Question: Is there a specific setting in Vizlib Pivot Table to force the Total column to be part of the "Frozen Pane" (like the dimensions)? Or is there a known workaround to achieve a fixed Total column on the left?
Thanks in advance for your help!
Stream Qlik Connect Live on April 14–15 and learn how to succeed with data and AI by daring to be different.
Data heroes, suit up. Hackathons and Late-Night Lunacy events are back. Seating is limited — register now to lock in your spot
Introducing a new agentic experience in Qlik Answers and open AI access through MCP. Later this March: Discovery Agent and trusted data products embedded into analytics.
Think you’ve got game? Step into the Performance Zone — a data-driven sports arena on the show floor featuring Qlik customers Topgolf, the Malmö Redhawks, and Pinarello-Q36.5 Pro Cycling
Your journey awaits! Join us by Logging in and let the adventure begin.
Global container shipping giant delivers data transparency to enable confident decision-making and operational efficiency.
Qlik turns raw data into valuable learning experiences, empowering both students and faculty at TTUHSC.
MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.
Migration to Qlik Cloud Analytics optimizes analytics applications within months.
With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.
Through the Qlik Academic Program and Qlik Sense, Universidad Nacional del Sur transforms complex data into interactive insights while preparing students for the modern workforce.
Join one of our Location and Language groups. Find one that suits you today!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
Join us April 13–15, 2026 in Kissimmee, Florida for 2+ immersive days of innovation, hands-on learning, and powerful connections shaping the future of data and AI.
You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.
You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.