Skip to content

Instantly share code, notes, and snippets.

@nileema
Created September 26, 2014 23:32
Show Gist options
  • Save nileema/e745dbada85d40df9cdf to your computer and use it in GitHub Desktop.
Save nileema/e745dbada85d40df9cdf to your computer and use it in GitHub Desktop.
- Output[orderpriority, shippriority]
- Project => [orderpriority:varchar, shippriority:bigint]
- Aggregate[orderpriority, shippriority] => [orderpriority:varchar, shippriority:bigint, $hashvalue:bigint]
- Project => [orderpriority:varchar, shippriority:bigint, $hashvalue:bigint]
$hashvalue := "hash"("hash"(0, "$operator$hash_code"("orderpriority")), "$operator$hash_code"("shippriority"))
- TableScan[local:tpch:orders:sf0.01, original constraint=true] => [orderpriority:varchar, shippriority:bigint]
orderpriority := local:tpch:orderpriority:5
shippriority := local:tpch:shippriority:7
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment