I'm using some of RStudio's new features to edit and run SQL scripts, then bring the data into R. Previously I used Aginity Workbench to run Netezza SQL. Workbench has a handy stop-sign icon that can be selected to stop a running query. How can I similarly stop an active query in RStudio? The usual ctrl + C doesn't seem stop the execution of SQL code...
1 Like
Has anybody tried this?
In general, I find it hard to stop a SQL query (either MySQL or PostgreSQL) from within the R console, and I'm assuming that RStudio is using the console as well.
What I do as a workaround is run pg_admin or MySQL workbench so I can kill the query from there when I've messed up.
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.