If a query using a Common Table Expression (CTE) is run using an ODBC connection to an IMPALA Data source, it will produce an error related to the Syntax.
"[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : ParseException: Syntax error in line 1:"
If the query is run without using a CTE, it will run fine.
WORKAROUND:
Workaround is to not use With with Cast
STATUS:
Waiting for fix in a future release of Toad Data Point.
