How can I kill the query by looking query explain plan and costs or can i look memory usage to kill query?

Question

I use hive for sql to get data from my hadoop.

How can I kill the query by looking query explain plan and costs or can i look memory usage to kill query?

I use this to look at query :

explain
select * from
default.my_table
where my_query like '%61%';

But as I can see there is no cost information in this plain. Or can I kill the query by looking at how much it takes memory for example after 100TB ram I want to kill that query automatically?