search

prestodb / presto-python-client

Python DB-API client for Presto
Apache License 2.0
239 stars 87 forks source link

autocommit issue #52

Open qli-aa opened 6 years ago

qli-aa commented 6 years ago

presto-python-client == 0.4.1 Presto server == 0.166

after i ran insert sql, after about 5mins, presto will rollback and delete the data in the table? is there some bugs or hints?

i just follow the README to write the SQL

qli-aa commented 6 years ago

Tested with Presto 0.152.3, it was ok, I guess some changes with Presto server code which leads this issue

qli-aa commented 6 years ago

If I use SQLWorkbench/J with JDBC, both version was ok

ggreg commented 6 years ago

Can you paste the code you used? Did you create the PrestoConnection in a with statement?

ggreg commented 5 years ago

@qli-aa if it's still an issue, can you please share the code you ran?