Can a single query retrieve results from both TiFlash and TiKV simultaneously?

Translated
1

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

Original topic: 一条语句可以同时从tiflash或者tikv中取结果嘛

| username: Raymond

Excuse me, teachers, in the TiDB architecture with the TiFlash component, when a statement is executed, can the result be obtained from both TiKV and TiFlash? Are both components, TiKV and TiFlash, used simultaneously?

2
| username: h5n1 | Original post link

The same table is not allowed.

3
| username: Raymond | Original post link

If a statement involves multiple tables, for example, table A can fetch data from TiKV, and table B can fetch data from TiFlash, is this feasible?

4
| username: h5n1 | Original post link

Yes, you can then join on the TiDB side.

5
| username: system | Original post link

This topic will be automatically closed 60 days after the last reply. No new replies are allowed.