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 | 6033 | May 14, 2019 | |
| Surrogate keys in dbt: Integers or hashes? | 8 | 5030 | February 1, 2024 | |
| Querying hierarchical data | 3 | 11571 | July 23, 2020 | |
| What are the best practices to partition big tables in Redshift | 2 | 30154 | April 28, 2020 | |
| CTEs are Passthroughs--Some research! | 15 | 19002 | February 7, 2024 |