ERROR DB Query Reader

#1

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?

0 Likes

#2

Hi there @pio,

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

Br,
Ivan

0 Likes

#3

Hi @ipazin,
I am connecting to presto Dbeaver

0 Likes

#4

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 :slight_smile:

Br,
Ivan

0 Likes