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

[Enhancement]: optimize murmurhash64A with SIMD #1939

Open
Dragonliu2018 opened this issue Apr 26, 2024 · 1 comment
Open

[Enhancement]: optimize murmurhash64A with SIMD #1939

Dragonliu2018 opened this issue Apr 26, 2024 · 1 comment

Comments

@Dragonliu2018
Copy link

Enhancement
In vectorized operators, such as Hash Group By, there are many scenarios where fixed-length data batches are being hashed in bulk. In such cases, we can use SIMD to optimize.

In particular, the Q36 query in clickbench will benefit from the enhancement.

SELECT  /*+ CB_Q36 parallel(64) */ ClientIP, ClientIP - 1, ClientIP - 2, ClientIP - 3, COUNT(*) AS c FROM hits GROUP BY ClientIP, ClientIP - 1, ClientIP - 2, ClientIP - 3 ORDER BY c DESC LIMIT 10;
@hnwyllmm
Copy link
Contributor

Would you like to take this issue?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants