Skip to content

[GLUTEN-3143][CH] Transform arrayJoin function to array join step to apply max_block_size#3191

Merged
liuneng1994 merged 1 commit intoapache:mainfrom
bigo-sg:gluten_3143
Sep 20, 2023
Merged

[GLUTEN-3143][CH] Transform arrayJoin function to array join step to apply max_block_size#3191
liuneng1994 merged 1 commit intoapache:mainfrom
bigo-sg:gluten_3143

Conversation

@taiyang-li
Copy link
Copy Markdown
Contributor

@taiyang-li taiyang-li commented Sep 18, 2023

What changes were proposed in this pull request?

Notice that arrayJoin function and array join step are executing in different places. The former is in ExpressionActions::execute, and latter is in ArrayJoinAction::execute. max_block_size is currently only valid in array join step, so we must transform arrayJoin function to array join step to apply max_block_size.

Notice: This pr relies on ClickHouse/ClickHouse#54664, but it can be merge firstly.

(Fixes: #3143)

@github-actions
Copy link
Copy Markdown

#3143

@github-actions
Copy link
Copy Markdown

Run Gluten Clickhouse CI

@taiyang-li taiyang-li marked this pull request as draft September 18, 2023 10:32
@taiyang-li taiyang-li marked this pull request as ready for review September 19, 2023 03:02
@github-actions
Copy link
Copy Markdown

Run Gluten Clickhouse CI

3 similar comments
@github-actions
Copy link
Copy Markdown

Run Gluten Clickhouse CI

@github-actions
Copy link
Copy Markdown

Run Gluten Clickhouse CI

@github-actions
Copy link
Copy Markdown

Run Gluten Clickhouse CI

@github-actions
Copy link
Copy Markdown

Run Gluten Clickhouse CI

@github-actions
Copy link
Copy Markdown

Run Gluten Clickhouse CI

1 similar comment
@github-actions
Copy link
Copy Markdown

Run Gluten Clickhouse CI

@github-actions
Copy link
Copy Markdown

Run Gluten Clickhouse CI

@taiyang-li taiyang-li force-pushed the gluten_3143 branch 2 times, most recently from 024e54a to 71c26f9 Compare September 19, 2023 13:29
@taiyang-li
Copy link
Copy Markdown
Contributor Author

@liuneng1994 @baibaichen There has been serveral uts about lateral view explode/posexplode, so this pr didn't add new uts.

Copy link
Copy Markdown
Contributor

@liuneng1994 liuneng1994 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

@liuneng1994 liuneng1994 merged commit c721ace into apache:main Sep 20, 2023
@GlutenPerfBot
Copy link
Copy Markdown
Contributor

===== Performance report for TPCH SF2000 with Velox backend, for reference only ====

query log/native_master_09_20_2023_time.csv log/native_master_09_19_2023_7d9763c31_time.csv difference percentage
q1 43.74 42.27 -1.474 96.63%
q2 24.76 24.49 -0.269 98.91%
q3 36.95 37.17 0.222 100.60%
q4 41.94 41.53 -0.408 99.03%
q5 70.07 70.33 0.256 100.37%
q6 6.73 5.01 -1.722 74.43%
q7 87.08 82.44 -4.643 94.67%
q8 79.39 79.40 0.006 100.01%
q9 116.92 116.28 -0.637 99.46%
q10 46.95 47.47 0.517 101.10%
q11 19.26 18.94 -0.316 98.36%
q12 26.14 23.67 -2.465 90.57%
q13 49.26 49.99 0.726 101.47%
q14 14.99 18.57 3.585 123.91%
q15 29.01 30.46 1.448 104.99%
q16 15.98 16.01 0.026 100.16%
q17 120.85 124.64 3.790 103.14%
q18 162.91 160.41 -2.494 98.47%
q19 13.36 11.89 -1.471 88.99%
q20 31.10 23.90 -7.200 76.85%
q21 244.65 234.75 -9.898 95.95%
q22 15.41 15.10 -0.314 97.96%
total 1297.44 1274.71 -22.736 98.25%

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

[CH] Multiple Lateral view posexplode use too much memory

3 participants