pio
#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?
ipazin
#2
Hi there @pio,
to what database are you connecting and what does your query look like?
Br,
Ivan
pio
#3
Hi @ipazin,
I am connecting to presto Dbeaver
ipazin
#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 
Br,
Ivan
pio
#5
Hi @ ipazin,
Thanks. I got it sorted. it was to do with trasnactional query being enabled. Once I disabled the transactional query. it worked
1 Like
ipazin
#6
Hi @pio,
glad to hear it is working now.
Br,
Ivan
system
closed
#7
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.