Trino error while querying for DELETE and INSERT after inserting semicolon at end of query

213 Views Asked by At

I'm trying to connect to trino and querying to delete rows and inserting rows for my Alteryx workflow. getting error after adding semicolon at the end of query which is a blocking currently the workflow. The same query works after removing semicolon. After adding semicolon getting error Removing semicolon works fine

I tried connecting to trino datasource using trino driver. example query DELETE FROM test_semicolon_pg without semicolon at end which works fine. but i expect the query should work fine even after adding adding semicolon at end of the query.

0

There are 0 best solutions below