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

[FEATURE] Support expression in indexed column #204

Open
dai-chen opened this issue Dec 21, 2023 · 2 comments
Open

[FEATURE] Support expression in indexed column #204

dai-chen opened this issue Dec 21, 2023 · 2 comments
Labels
0.5 enhancement New feature or request

Comments

@dai-chen
Copy link
Collaborator

Is your feature request related to a problem?

Currently, only column name is accepted as indexed column for both skipping and covering index. In certain case, user may want to transform the column value before indexing.

What solution would you like?

Support expression in indexed column:

CREATE SKIPPING INDEX ON test
( expr(col) VALUE_SET ... )
@dai-chen
Copy link
Collaborator Author

This may be useful for certain use case such as IP address: #203. For such specific field, user can do some cast/transform before indexing it via value set or bloom filter for instance.

@dai-chen
Copy link
Collaborator Author

Covering index may also have the same requirement.

@dai-chen dai-chen added the 0.5 label Jul 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0.5 enhancement New feature or request
Projects
Development

No branches or pull requests

1 participant