Redshift ODBC - error when using WITH clause

Anonymous — Wed, 20 Jan 2016 09:16:00 GMT

Hi all,

This is probably a Redshift IDBC driver issue, but thought maybe someone here has also encountered the problem.

and when I'm trying to use the WITH clause (WITH Clause - Amazon Redshift), I get an unkown statement error.

I know the query's syntax correct since it executes fine when running it via any client like datagrip / sql workbench j.

Anybody encountered this problem before and managed to solve it?

Thanks!

Assaf

Re: Redshift ODBC - error when using WITH clause

Anonymous — Wed, 20 Jan 2016 10:00:59 GMT

Solved.

I forgot the SQL prefix before the actual SQL statement.

I usually omit this prefix and queries run just fine. Turns out that WITH needs that prefix.

The following syntax will work:

SQL

WITH

[table_name] as (select col1 from t1)

select col1 from table_name;