Chapter 2 - Four Options for Aster Data Table Design
“Speak in a moment of anger and you’ll deliver the greatest speech you’ll ever regret.”
There are Four Options to Aster Table Design
1. Straight up Distribute by Hash:
All of your fact tables will use the Distribute by Hash design of simply having a single column serving as the Distribution Key. These tables will distribute the rows of the table among the vworkers with a consistent and straightforward Hash Formula.
2. Straight up Distribute by Replication:
Most of your dimension tables will use the Distribute by Replication design which makes a complete copy of all rows in the table and distributes the entire copy across all vworkers. Each vworker has an exact copy of the entire ...