Can anyone explain the causes of the above issue?
If it is related to threads, can it be resolved by increasing threads in the kernel?
This looks like an application issue (or possibly an Impala connector issue). The error message states that the Impala query was cancelled by another thread. Likely, another thread in your application got a handle to the query and cancelled it.
The full runtime profile of the query would help as well.