Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]

2024-12-04 Thread via GitHub


morrySnow merged PR #44857:
URL: https://github.com/apache/doris/pull/44857


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]

2024-12-04 Thread via GitHub


github-actions[bot] commented on PR #44857:
URL: https://github.com/apache/doris/pull/44857#issuecomment-2519042271

   PR approved by at least one committer and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]

2024-12-03 Thread via GitHub


doris-robot commented on PR #44857:
URL: https://github.com/apache/doris/pull/44857#issuecomment-2516079520

   
   
   ClickBench: Total hot run time: 32.74 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 4f6c7f5c6d0be032af47d0d389c7df502eda46d9, 
data reload: false
   
   query1   0.040.030.04
   query2   0.060.030.03
   query3   0.230.070.08
   query4   1.630.110.11
   query5   0.430.420.43
   query6   1.190.660.64
   query7   0.020.020.02
   query8   0.040.030.03
   query9   0.580.510.50
   query10  0.560.550.57
   query11  0.140.100.10
   query12  0.130.110.10
   query13  0.620.600.59
   query14  2.812.742.83
   query15  0.900.830.82
   query16  0.390.390.38
   query17  1.001.021.02
   query18  0.220.210.21
   query19  1.851.842.02
   query20  0.020.010.01
   query21  15.40   0.610.59
   query22  2.732.552.14
   query23  17.17   1.050.89
   query24  2.851.720.71
   query25  0.300.050.14
   query26  0.480.140.14
   query27  0.040.040.05
   query28  10.51   1.111.08
   query29  12.58   3.263.20
   query30  0.260.070.06
   query31  2.870.370.39
   query32  3.270.460.46
   query33  2.983.093.15
   query34  17.33   4.424.54
   query35  4.494.534.51
   query36  0.680.470.50
   query37  0.090.060.06
   query38  0.050.040.04
   query39  0.030.020.03
   query40  0.170.120.13
   query41  0.080.020.02
   query42  0.030.020.02
   query43  0.030.030.03
   Total cold run time: 107.28 s
   Total hot run time: 32.74 s
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]

2024-12-03 Thread via GitHub


doris-robot commented on PR #44857:
URL: https://github.com/apache/doris/pull/44857#issuecomment-2516074337

   
   
   TPC-DS: Total hot run time: 196035 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 4f6c7f5c6d0be032af47d0d389c7df502eda46d9, 
data reload: false
   
   query1   1269940 935 935
   query2   6246206420812064
   query3   10927   434344044343
   query4   67175   28526   23435   23435
   query5   4992457 428 428
   query6   422 195 182 182
   query7   5578299 296 296
   query8   320 239 248 239
   query9   8756274127382738
   query10  450 249 253 249
   query11  17222   15120   15826   15120
   query12  158 100 101 100
   query13  1495447 420 420
   query14  9941768266466646
   query15  216 190 208 190
   query16  7119509 444 444
   query17  1267577 562 562
   query18  1805292 296 292
   query19  199 143 146 143
   query20  119 114 139 114
   query21  205 101 98  98
   query22  4726460945764576
   query23  35018   34328   34562   34328
   query24  5481241125242411
   query25  480 400 392 392
   query26  666 151 150 150
   query27  1732278 291 278
   query28  4712249124962491
   query29  683 443 393 393
   query30  208 148 150 148
   query31  1018852 810 810
   query32  67  56  55  55
   query33  397 293 291 291
   query34  932 526 531 526
   query35  895 740 737 737
   query36  1101977 958 958
   query37  119 76  72  72
   query38  4434440744134407
   query39  1514147614761476
   query40  209 96  95  95
   query41  45  41  42  41
   query42  106 99  96  96
   query43  541 504 503 503
   query44  1198816 817 816
   query45  186 167 172 167
   query46  1160739 702 702
   query47  2080194619751946
   query48  415 311 307 307
   query49  713 382 398 382
   query50  834 386 381 381
   query51  7316721970287028
   query52  96  86  88  86
   query53  258 176 174 174
   query54  504 375 402 375
   query55  73  75  69  69
   query56  271 218 221 218
   query57  1252114211371137
   query58  214 207 203 203
   query59  3097289130312891
   query60  270 238 252 238
   query61  118 107 108 107
   query62  770 679 656 656
   query63  207 183 187 183
   query64  1383662 634 634
   query65  3241317832093178
   query66  695 292 300 292
   query67  16044   15554   15657   15554
   query68  4240559 550 550
   query69  410 259 246 246
   query70  1160115311001100
   query71  344 247 242 242
   query72  6426409841154098
   query73  756 349 355 349
   query74  10296   907191749071
   query75  3388263726612637
   query76  1837116210611061
   query77  485 255 256 255
   query78  10303   947594119411
   query79  1302590 591 590
   query80  924 414 476 414
   query81  523 237 234 234
   query82  211 116 113 113
   query83  173 139 143 139
   query84  285 69  66  66
   query85  984 295 296 295
   query86  380 296 293 293
   query87  4704464346004600
   query88  4005218221742174
   query89  402 292 280 280
   query90  2139183 182 182
   query91  135 102 102 102
   query92  60  49  49  49
   query93  2145541 513 513
   query94  918 286 285 285
   query95  342 246 255 246
   query96  616 278 275 275
   query97  2831264526522645
   query98  214 195 194 194
   query99  1592133513301330
   Total cold run time: 317890 ms
   Total hot run time: 196035 ms
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to 

Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]

2024-12-03 Thread via GitHub


doris-robot commented on PR #44857:
URL: https://github.com/apache/doris/pull/44857#issuecomment-2516062435

   
   
   TPC-H: Total hot run time: 40068 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 4f6c7f5c6d0be032af47d0d389c7df502eda46d9, 
data reload: false
   
   -- Round 1 --
   q1   17603   749172927292
   q2   2040177 166 166
   q3   10596   108411801084
   q4   10542   728 721 721
   q5   7596274426542654
   q6   235 148 146 146
   q7   998 610 596 596
   q8   9251187018981870
   q9   6720652065366520
   q10  7047230523182305
   q11  475 257 261 257
   q12  413 228 223 223
   q13  17769   300330113003
   q14  243 205 217 205
   q15  579 535 524 524
   q16  657 572 574 572
   q17  983 587 524 524
   q18  7263677867086708
   q19  13331043969 969
   q20  466 178 187 178
   q21  4105325932323232
   q22  383 328 319 319
   Total cold run time: 107297 ms
   Total hot run time: 40068 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7334728272647264
   q2   327 233 238 233
   q3   2944287529572875
   q4   2057180818411808
   q5   5701581356425642
   q6   238 144 147 144
   q7   2238180118041801
   q8   3426360235503550
   q9   8997906390519051
   q10  3614356336233563
   q11  611 507 510 507
   q12  822 617 633 617
   q13  10163   320632573206
   q14  309 275 274 274
   q15  580 535 535 535
   q16  701 664 642 642
   q17  1868162615731573
   q18  8186768876027602
   q19  1721165915041504
   q20  2088186218571857
   q21  5750549154765476
   q22  688 578 566 566
   Total cold run time: 70363 ms
   Total hot run time: 60290 ms
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]

2024-12-03 Thread via GitHub


seawinde commented on PR #44857:
URL: https://github.com/apache/doris/pull/44857#issuecomment-2515994877

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]

2024-12-02 Thread via GitHub


github-actions[bot] commented on PR #44857:
URL: https://github.com/apache/doris/pull/44857#issuecomment-2511235543

   PR approved by anyone and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]

2024-12-02 Thread via GitHub


github-actions[bot] commented on PR #44857:
URL: https://github.com/apache/doris/pull/44857#issuecomment-2511235455

   PR approved by at least one committer and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]

2024-12-02 Thread via GitHub


doris-robot commented on PR #44857:
URL: https://github.com/apache/doris/pull/44857#issuecomment-2510992594

   
   
   ClickBench: Total hot run time: 33.44 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 33cca52f58895ae7c926c664005eaf65580d55c4, 
data reload: false
   
   query1   0.030.020.03
   query2   0.070.030.03
   query3   0.230.070.07
   query4   1.630.100.11
   query5   0.400.410.41
   query6   1.170.660.66
   query7   0.020.010.01
   query8   0.050.030.03
   query9   0.590.510.51
   query10  0.540.550.57
   query11  0.140.100.10
   query12  0.130.110.11
   query13  0.600.620.61
   query14  2.842.742.87
   query15  0.920.830.83
   query16  0.390.370.38
   query17  1.031.041.01
   query18  0.210.210.20
   query19  1.941.822.01
   query20  0.010.010.01
   query21  15.36   0.600.59
   query22  2.612.092.09
   query23  16.89   1.070.88
   query24  2.591.462.12
   query25  0.350.100.12
   query26  0.610.150.15
   query27  0.050.050.04
   query28  9.871.111.09
   query29  12.52   3.193.18
   query30  0.250.060.07
   query31  2.870.400.37
   query32  3.270.460.48
   query33  2.983.053.05
   query34  17.09   4.464.46
   query35  4.484.514.48
   query36  0.670.490.50
   query37  0.090.060.06
   query38  0.050.040.03
   query39  0.030.030.02
   query40  0.160.120.13
   query41  0.080.020.02
   query42  0.040.020.02
   query43  0.030.040.03
   Total cold run time: 105.88 s
   Total hot run time: 33.44 s
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]

2024-12-02 Thread via GitHub


doris-robot commented on PR #44857:
URL: https://github.com/apache/doris/pull/44857#issuecomment-2510981058

   
   
   TPC-DS: Total hot run time: 198052 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 33cca52f58895ae7c926c664005eaf65580d55c4, 
data reload: false
   
   query1   1237955 954 954
   query2   6233208720642064
   query3   10942   440944354409
   query4   0   28865   23496   23496
   query5   4905481 457 457
   query6   410 196 178 178
   query7   310 302 302
   query8   330 263 246 246
   query9   8755269526882688
   query10  440 242 240 240
   query11  17386   15400   16082   15400
   query12  145 100 101 100
   query13  1453424 409 409
   query14  10925   763776097609
   query15  218 180 187 180
   query16  7066466 456 456
   query17  1186621 599 599
   query18  1882315 315 315
   query19  212 167 168 167
   query20  121 116 112 112
   query21  221 105 104 104
   query22  4817455245594552
   query23  35109   34261   34365   34261
   query24  6014264425942594
   query25  484 393 382 382
   query26  648 151 152 151
   query27  1952289 287 287
   query28  4256246524642464
   query29  683 438 423 423
   query30  218 157 150 150
   query31  1020833 845 833
   query32  65  55  55  55
   query33  410 355 329 329
   query34  949 518 547 518
   query35  915 785 779 779
   query36  1095971 950 950
   query37  118 66  74  66
   query38  4485455743834383
   query39  1528152214801480
   query40  200 104 101 101
   query41  46  43  42  42
   query42  113 100 101 100
   query43  542 505 506 505
   query44  1182818 821 818
   query45  202 171 178 171
   query46  1199730 777 730
   query47  2060191219361912
   query48  418 308 319 308
   query49  726 407 420 407
   query50  861 397 401 397
   query51  7419721471337133
   query52  98  88  92  88
   query53  254 183 178 178
   query54  522 397 392 392
   query55  79  74  74  74
   query56  241 236 242 236
   query57  1273112111051105
   query58  218 215 236 215
   query59  3250301027952795
   query60  263 234 239 234
   query61  109 106 108 106
   query62  816 691 678 678
   query63  219 201 186 186
   query64  1466707 660 660
   query65  3308323732283228
   query66  717 340 304 304
   query67  16277   15662   15687   15662
   query68  3832578 559 559
   query69  444 249 254 249
   query70  1142113511341134
   query71  360 248 265 248
   query72  6435405140974051
   query73  751 367 365 365
   query74  10376   908392229083
   query75  3358270626552655
   query76  1854102511231025
   query77  511 291 276 276
   query78  10490   948193969396
   query79  1407621 605 605
   query80  889 446 511 446
   query81  486 229 234 229
   query82  1295125 119 119
   query83  253 148 139 139
   query84  278 70  71  70
   query85  889 289 292 289
   query86  333 308 299 299
   query87  4650459046284590
   query88  3720221321742174
   query89  421 311 305 305
   query90  2021193 194 193
   query91  136 100 105 100
   query92  69  56  52  52
   query93  1952535 544 535
   query94  792 291 287 287
   query95  348 249 248 248
   query96  619 275 276 275
   query97  2844264827152648
   query98  222 191 204 191
   query99  1647135413101310
   Total cold run time: 319950 ms
   Total hot run time: 198052 ms
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go 

Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]

2024-12-02 Thread via GitHub


doris-robot commented on PR #44857:
URL: https://github.com/apache/doris/pull/44857#issuecomment-2510954043

   
   
   TPC-H: Total hot run time: 40153 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 33cca52f58895ae7c926c664005eaf65580d55c4, 
data reload: false
   
   -- Round 1 --
   q1   17602   745172747274
   q2   2043188 170 170
   q3   10802   108812221088
   q4   10471   790 676 676
   q5   7608278227422742
   q6   238 144 146 144
   q7   1029635 604 604
   q8   9237184519521845
   q9   6731658265086508
   q10  7022231023442310
   q11  482 267 257 257
   q12  431 231 225 225
   q13  18503   307530573057
   q14  275 222 210 210
   q15  589 534 524 524
   q16  669 595 588 588
   q17  981 544 561 544
   q18  7321676666986698
   q19  1332928 922 922
   q20  458 183 184 183
   q21  4073326533643265
   q22  391 328 319 319
   Total cold run time: 108288 ms
   Total hot run time: 40153 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7387737372697269
   q2   347 232 236 232
   q3   3073314231733142
   q4   2157191719451917
   q5   5852581256915691
   q6   231 144 142 142
   q7   2350182517471747
   q8   3438357235383538
   q9   9024908491559084
   q10  3585354635833546
   q11  617 531 523 523
   q12  850 624 617 617
   q13  16107   324132113211
   q14  308 276 260 260
   q15  586 523 519 519
   q16  696 627 644 627
   q17  1844163616241624
   q18  8365797475637563
   q19  1702142216131422
   q20  2110186519201865
   q21  5587537755075377
   q22  613 551 556 551
   Total cold run time: 76829 ms
   Total hot run time: 60467 ms
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]

2024-12-02 Thread via GitHub


seawinde commented on PR #44857:
URL: https://github.com/apache/doris/pull/44857#issuecomment-2510868834

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org