Investigate & fix dbt3 scalability problem (MCOL-3471)

[MCOL-3546] Denormalize lineitem & orders tables, alter queries, re-benchmark Created: 2019-10-07  Updated: 2019-11-01  Resolved: 2019-11-01

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: None
Fix Version/s: Icebox

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


 Description   

We actually spend very little wall time processing the join for the problematic queries. Unless we get the data broadcast & construction time down to almost nothing, we won't demonstrate much scaling.

Will see how we do when the biggest join is eliminated.



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

Forgot that I created a task for this.

Did this, did further denormalizing & testing, etc.

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