Curiosity question: Can someone explain why Redshift goes through the step of hashing the join columns in some joins? I’m not sure I computationally understand what happens there and would be interested in knowing more. Couldn’t find anything good online.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Splitting arrays into rows in Redshift with dbt macros | 1 | 5985 | May 14, 2019 | |
| Surrogate keys in dbt: Integers or hashes? | 8 | 4924 | February 1, 2024 | |
| Querying hierarchical data | 3 | 11510 | July 23, 2020 | |
| What are the best practices to partition big tables in Redshift | 2 | 29922 | April 28, 2020 | |
| CTEs are Passthroughs--Some research! | 15 | 18880 | February 7, 2024 |