Does LIKE support computation distributed to individual KV nodes?

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

Original topic: like支持下发到个个kv节点计算吗

| username: 小于同学

Does like support being distributed to each KV node for computation? Do these three patterns “%21”, “%123%”, and “342%” all support it?

| username: 有猫万事足 | Original post link

The like function is supported for pushdown.

| username: TiDBer_5cwU0ltE | Original post link

When using LIKE, if the condition starts with the wildcard %, indexes cannot be used. Pushing down should not be a big problem.

| username: Kongdom | Original post link

Yes, all three will be issued, it’s just a matter of whether the index is used or not.

| username: dba远航 | Original post link

The main issue is whether or not to use indexes, not whether or not to push down.

| username: Kongdom | Original post link

:joy: Yes, I got confused at first~

| username: TIDB-Learner | Original post link

:100: :100: :100:

| username: DBAER | Original post link

Push down everything

| username: zhang_2023 | Original post link

LIKE supports pushdown

| username: Hacker_QGgM2nks | Original post link

Of course it is supported, but it may not necessarily use the index.

| username: 健康的腰间盘 | Original post link

Pushdown, index cannot be used.

| username: 呢莫不爱吃鱼 | Original post link

Support pushdown

| username: 友利奈绪 | Original post link

Support pushdown

| username: TiDBer_QYr0vohO | Original post link

Supports pushdown

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.