KNOWLEDGE BASE

Error "Syntax Error Exception" When Using AND, OR, NOT in a Calculated Field with Denovo


Published: 22 May 2019
Last Modified Date: 27 May 2019

Issue

When using “<expr1> AND <expr2>” or "<expr1> OR <expr2>" or "NOT <expr1>"as a calculated field with the Denodo connector the following error might occur:


Syntax Error Exception

Environment

  • Tableau Desktop 2018.1.3, 2019.2
  • Denodo

Resolution

As workaround use CASE or IF ELSE statement.

Note: Changing to using CASE statements for boolean expressions has severe performance issues when those expressions are used on filters.
 

Cause

Denodo DB does not allow a logical expression in the form of “<expr1> AND <expr2>”, or “<expr1> OR <expr2>”, or "NOT <expr1>" as a SELECT column. The Denodo team is aware of this limitation within their engine.
Did this article resolve the issue?