Bug Report

Please answer these questions before submitting your issue. Thanks!
Currently, inside join, it does not aware of cancel signal, so if you wants to cancel a query that contains join, it can only wait until joinBlock returns

https://github.com/pingcap/tiflash/blob/v8.3.0/dbms/src/Interpreters/Join.h#L201

If joinBlock() takes a long time(it could happen in some extrame cases, like cross join with a lot of build side data), the query can not be cancelled for a long time

1. Minimal reproduce step (Required)

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiFlash version? (Required)