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


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


  • Tableau Desktop 2018.1.3, 2019.2
  • Denodo


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.


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?