jnturton edited a comment on issue #2421: URL: https://github.com/apache/drill/issues/2421#issuecomment-1008235930
@paul-rogers I can imagine vectorisation helping hash joins because of all the hashing to be crunched. I haven't got a good paper to cite but a search from my phone did turn up at least one story on these lines. https://www.cockroachlabs.com/blog/vectorized-hash-joiner/ Regarding pivoting between row and column orientation depending on the operator, I would expect that all the ensuing memory copying would outweigh any gain but again I bring no references or data. EDIT: There are quite a few open access papers returned by "sql join SIMD". I've got some bedtime reading to do. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
