In some instances, we may need to abort the query execution. The reason might be because an erroneous query was executed, a change of mind, or the execution is taking longer than intended.
In both Apache Hive and Impala, there are two ways to terminate the session/query execution.
Connect to the WebUI in the /queriestab of the Impalad host OR use the KILL command along with the job number provided during the query execution in Apache Hive – OR just press ^C (Control + C) to end the query execution.
Please keep in mind that pressing Control+C once will end the query execution, while pressing twice will end the daemon’s current connection.