optimize hash table construction for UM joins (MCOL-3586)

[MCOL-3604] Benchmarking new um join Created: 2019-11-08  Updated: 2019-11-22  Resolved: 2019-11-22

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: None
Fix Version/s: 1.4.0

Type: Sub-Task Priority: Major
Reporter: Patrick LeBlanc (Inactive) Assignee: Patrick LeBlanc (Inactive)
Resolution: Done Votes: 0
Labels: None


 Comments   
Comment by Patrick LeBlanc (Inactive) [ 2019-11-14 ]

the dbt3 queries use a lot of large joins, will use that as the benchmark

Comment by Patrick LeBlanc (Inactive) [ 2019-11-22 ]

Got it humming. Initial test, joining l_orderkey to o_orderkey shows nearly linear scaling. If the keys don't hash evenly the scaling ratio will fall, but not concerned with that right now.

Generated at Thu Feb 08 02:43:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.