KNOWLEDGE BASE

"unable To Materialize Temporary Table" Error From Denodo


Published: 13 Apr 2020
Last Modified Date: 02 Jun 2020

Issue

Applying a filter that contains en dash (–) character causes "Unable to materialize temporary table" error.

User-added image

Environment

  • Tableau Desktop
  • Windows 10
  • Denodo

Cause

The en dash '–', "E2 80 93", or '\u2013' used in the filter causes an error.
The Unicode character was included in the query whilst the denodo database's Unicode support was not enabled.
Did this article resolve the issue?