Versions Compared

Old Version 4

changes.mady.by.user Wenhai Li

Saved on

compared with

New Version 5

changes.mady.by.user Wenhai Li

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 

 

4. Binary In-Equal Join

 

use dataverse tpch;

for $d in dataset Lineitem

for $t in dataset Orders
/*+ psort */

where $d.l_extendedprice - $t.o_totalprice > -2 and $d.l_extendedprice - $t.o_totalprice < 2

return

Wiki Markup
{"ok": $d.l_orderkey, "ln": $d.l_linenumber}

 


4.1 Five stages of parallel sort-based binary join

...