Terminate Query Execution in Apache Hive & Impala

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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s