Ask Your Question
0

we are trying to connect to presto

asked 2020-08-07 15:17:57 -0600

jdbc:presto://hostanme:8080/catalog/schemaname?user=kxmani1

JDBC_00 - Cannot connect to specified database: SQLState: null Error Code: 65536 Message: Query failed (#20200807_201522_00066_83x4u): Session properties cannot be overridden once a transaction is active Cause: java.lang.IllegalStateException: Session properties cannot be overridden once a transaction is active

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2020-08-21 08:44:48 -0600

mathewJose gravatar image

Hi While using Presto Hive connections strings in JDBC query consumer, I have enabled Auto-commit(JDBC query consumer > Advanced > Auto-commit). This resolved the above error in my pipeline.

edit flag offensive delete link more

Comments

Thanks for the answer @mathewJose!

iamontheinet gravatar imageiamontheinet ( 2020-08-21 10:58:21 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-08-07 15:17:57 -0600

Seen: 263 times

Last updated: Aug 21