Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support Redis key pushdown in Redis connector #12218

Closed
polaris6 opened this issue May 3, 2022 · 0 comments · Fixed by #12219
Closed

Support Redis key pushdown in Redis connector #12218

polaris6 opened this issue May 3, 2022 · 0 comments · Fixed by #12219
Assignees
Labels
enhancement New feature or request

Comments

@polaris6
Copy link
Member

polaris6 commented May 3, 2022

Redis is a key-value database that utilizes the concept of key and value to store data, we can use methods such as GET key to fetch value. when querying Redis data through Trino, the following sql is used in many cases:

select * from redis.schema.table where redis_key = 'key_data' limit 100;

This sql should return the record instantly, however it is not, it will take a long time to get the record. The reason is that Trino uses SCAN first, it will keep scanning data until the specified key is scanned, It takes a lot of time.

I see that stack users have also raised this problem, so I plan to do some optimization.
https://app.slack.com/client/TFKPX15NC/CGB0QHWSW/thread/CGB0QHWSW-1639826990.317500
image

@polaris6 polaris6 self-assigned this May 3, 2022
@polaris6 polaris6 added the enhancement New feature or request label May 3, 2022
@polaris6 polaris6 changed the title Support redis key pushdown in Redis connector Support Redis key pushdown in Redis connector May 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Development

Successfully merging a pull request may close this issue.

1 participant