100% CPU usage for two hours when one user is connecting to a published data source from Tableau Desktop.

Tableau / Tableau Server
In Review

Created

Dec 2, 2024

Found in Release

2022.1.21+

Last Updated

Dec 3, 2024

Reference ID

W-17128807

Summary

100% CPU usage for two hours when one user is connecting to a published data source from Tableau Desktop.

Steps to Reproduce

  1. Open a workbook in Tableau Desktop that has is using a Tableau Server published data source
  2. Select a sheet
  3. Drag and drop measurements that will generate a CROSS JOIN calculation in the published data source.
  4. Check the CPU usage of the hyper node it will go 100% until SRM kill the process.


Workaround

The workaround below may help achieve the expected behaviour:


tsm configuration set -k native_api.logical.query.rewrite.disable -v Join:PostFuse --force-keys

tsm pending-changes apply


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.

Reference IDW-17128807
In Review

6 Reports

6 Reports