ERROR DB Query Reader

[pio]

Hi,
I am using DBeaver to connect to a server to read a query. Every time I run it , I get the following error

Execute failed: Query failed (#20200110_141034_01758_784i4): Session properties cannot be overridden once a transaction is active

What should I do to get it working?

[ipazin]

Hi there @pio,

to what database are you connecting and what does your query look like?

Br,
Ivan

[pio]

Hi @ipazin,
I am connecting to presto Dbeaver

[ipazin]

Hi there @pio,

and your SQL statement looks like what? I found this issue that is still open: https://github.com/prestodb/presto/issues/8199

Now I don’t know if you are trying to change some property with SQL or KNIME does something it shouldn’t

Br,
Ivan

[pio]

Hi @ ipazin,
Thanks. I got it sorted. it was to do with trasnactional query being enabled. Once I disabled the transactional query. it worked

[ipazin]

Hi @pio,

glad to hear it is working now.

Br,
Ivan