search

trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.55k stars 3.03k forks source link

Unable to cancel query in batch mode of presto cli #506

Open combineads opened 5 years ago

combineads commented 5 years ago

  1. Execute long term sql. ./presto --server https://xxxx --user xxxxx --password --file "sql file" --catalog xxx --progress --ignore-errors

  2. Check presto cli pid ps -ef | grep -i presto

  3. kill pid, even kill -2 pid

    Screen Shot 2019-03-20 at 02 28 44

  4. Check Presto Condinator UI. Still, the query is running.

hashhar commented 3 months ago

This can be solved by adding more code to the shutdown hook that the CLI already installs. (see Console.java for Runtime.addShutdownHook).

I'm working on this.