Loading

Hyper Queries Using High CPU After Upgrade to Tableau Server 2022.1.7 or Later Releases

Дата публикации: Dec 22, 2025
Описание

After upgrading to Tableau Server starting with 2022.1.7 and all versions updated on Sept. 28, 2022, high sustained CPU use by Hyper may cause Tableau Server to become inaccessible. Hyper may be terminated numerous times for sustained high CPU utilization.
 

Cause

This behavior is a known issue outlined here. 
 

Решение

A solution was deployed In 2023.3.5, so upgrade to that version or newer.

As a workaround, to identify and mitigate this issue, confirm that all three of the following factors are true:

  1. Extracts using SQL queries with CROSS JOIN are used on the server
    • Hyper logs on the server will show CROSS JOIN queries occurring shortly before or during the issue 
  2. Hyper CPU utilization is higher than it was before the upgrade, and may hit 100% of available resources.
  3. Setting native_api.logical.query.rewrite.disable: Join:PostFuse resolves the above behavior in #2 (even if there are other performance impacts as a result of this change).
Note that, after the Join:PostFuse rewrite rule has been disabled, the performance of queries that use CROSS JOIN may be slower than before the upgrade. (This includes view loads connecting to these data sources, as well as extract refreshes.) Further testing would be needed to confirm this impact as the performance will vary depending on the query executed.

To disable the Join:PostFuse rewrite rule, use these commands:
tsm configuration set -k native_api.logical.query.rewrite.disable -v Join:PostFuse --force-keys
tsm pending-changes apply

If needed, the above change can be reverted using these commands:

tsm configuration set -k native_api.logical.query.rewrite.disable -d
tsm pending-changes apply

 

Номер статьи базы знаний

001497104

 
Загрузка
Salesforce Help | Article