How to Resolve the Issue of Forcing SQL Execution via JDBC to Use TiFlash Failing

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 通过jdbc执行sql强制走tiflash失效，如何解决

| username: Running

In the SQL statement, forcing the use of the TiFlash engine for queries, after going through JDBC to TiDB, the monitored SQL did not use the TiFlash engine. The statement by default removed the [/*+ read_from_storage(tiflash[a,b]) */] hint.

2
| username: h5n1 | Original post link

Try binding the execution plan with SPM and this HINT.

3
| username: dba-kit | Original post link

Try adding the database name? However, whether it can reach TiFlash depends on the value of the tidb_isolation_read_engines parameter.

4
| username: Running | Original post link

The default three engines

5
| username: Running | Original post link

Adding the database name doesn’t work either.