Re: [PR] [Fix](nereids) add checkBlockRules() check for create view and alter view [doris]

2024-05-23 Thread via GitHub


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


-- 
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](nereids) add checkBlockRules() check for create view and alter view [doris]

2024-05-22 Thread via GitHub


feiniaofeiafei commented on PR #34104:
URL: https://github.com/apache/doris/pull/34104#issuecomment-2126296983

   run p0


-- 
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](nereids) add checkBlockRules() check for create view and alter view [doris]

2024-05-22 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.36 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 03ea059abea3b3ffc9b7b50f6ab393ade6dc4a9e, 
data reload: false
   
   query1   0.040.030.04
   query2   0.080.050.05
   query3   0.220.060.05
   query4   1.660.080.08
   query5   0.500.480.52
   query6   1.130.720.72
   query7   0.020.020.01
   query8   0.050.040.04
   query9   0.550.500.49
   query10  0.550.550.55
   query11  0.150.110.12
   query12  0.150.120.12
   query13  0.600.590.59
   query14  0.790.760.80
   query15  0.830.820.81
   query16  0.370.370.37
   query17  0.961.031.03
   query18  0.240.230.25
   query19  1.841.741.70
   query20  0.010.010.02
   query21  15.51   0.700.69
   query22  4.447.301.68
   query23  18.32   1.331.24
   query24  1.780.270.21
   query25  0.140.090.09
   query26  0.260.160.17
   query27  0.070.080.08
   query28  13.30   1.021.00
   query29  12.75   3.313.26
   query30  0.240.060.05
   query31  2.870.380.39
   query32  3.270.460.46
   query33  2.882.872.88
   query34  17.20   4.394.42
   query35  4.504.524.58
   query36  0.680.480.46
   query37  0.180.160.15
   query38  0.150.140.14
   query39  0.040.030.03
   query40  0.160.150.15
   query41  0.090.050.04
   query42  0.050.050.04
   query43  0.040.040.04
   Total cold run time: 109.66 s
   Total hot run time: 30.36 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](nereids) add checkBlockRules() check for create view and alter view [doris]

2024-05-22 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 169998 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 03ea059abea3b3ffc9b7b50f6ab393ade6dc4a9e, 
data reload: false
   
   query1   912 386 377 377
   query2   7346250123132313
   query3   6642219 210 210
   query4   20977   17631   17430   17430
   query5   4143416 424 416
   query6   259 162 152 152
   query7   4599305 295 295
   query8   245 189 178 178
   query9   8493238723842384
   query10  457 294 267 267
   query11  10682   10246   10199   10199
   query12  140 97  83  83
   query13  1639359 358 358
   query14  9310708374767083
   query15  220 174 175 174
   query16  7733270 270 270
   query17  1708524 527 524
   query18  1947273 270 270
   query19  214 159 154 154
   query20  95  85  87  85
   query21  198 135 133 133
   query22  4322402738593859
   query23  33846   33258   9   33258
   query24  10804   279029102790
   query25  583 353 369 353
   query26  707 161 160 160
   query27  2220328 328 328
   query28  5455206420662064
   query29  845 616 599 599
   query30  258 170 177 170
   query31  988 782 764 764
   query32  85  54  54  54
   query33  716 285 303 285
   query34  876 477 499 477
   query35  739 623 601 601
   query36  1101898 916 898
   query37  105 72  71  71
   query38  2958276327982763
   query39  875 791 797 791
   query40  192 124 125 124
   query41  45  43  43  43
   query42  108 96  97  96
   query43  602 547 566 547
   query44  1143732 742 732
   query45  182 164 160 160
   query46  1071718 744 718
   query47  1872177017681768
   query48  363 298 302 298
   query49  842 378 390 378
   query50  770 399 390 390
   query51  6854669766806680
   query52  100 91  92  91
   query53  357 287 298 287
   query54  854 427 425 425
   query55  77  74  75  74
   query56  265 234 254 234
   query57  1119104010431040
   query58  234 211 205 205
   query59  3447325332523252
   query60  276 262 275 262
   query61  91  88  93  88
   query62  607 454 488 454
   query63  305 285 294 285
   query64  8469220417251725
   query65  3171305330953053
   query66  772 365 316 316
   query67  15209   14872   14848   14848
   query68  4582543 537 537
   query69  503 277 267 267
   query70  118011401140
   query71  402 271 277 271
   query72  7727275625382538
   query73  732 329 326 326
   query74  6153557855375537
   query75  3411258826102588
   query76  2986101310071007
   query77  592 281 277 277
   query78  10307   10106   96699669
   query79  2072516 505 505
   query80  956 455 453 453
   query81  546 248 253 248
   query82  621 103 99  99
   query83  253 182 178 178
   query84  250 88  90  88
   query85  1495333 256 256
   query86  456 316 301 301
   query87  3265316331253125
   query88  4152234023352335
   query89  468 382 369 369
   query90  2004187 187 187
   query91  125 98  101 98
   query92  57  51  52  51
   query93  2193530 509 509
   query94  1207194 188 188
   query95  400 312 317 312
   query96  604 270 265 265
   query97  3170303630163016
   query98  244 230 207 207
   query99  1147849 838 838
   Total cold run time: 269030 ms
   Total hot run time: 169998 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 s

Re: [PR] [Fix](nereids) add checkBlockRules() check for create view and alter view [doris]

2024-05-22 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 42049 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 03ea059abea3b3ffc9b7b50f6ab393ade6dc4a9e, 
data reload: false
   
   -- Round 1 --
   q1   17609   433642464246
   q2   2024190 188 188
   q3   10506   128311911191
   q4   10190   777 858 777
   q5   7465273327882733
   q6   222 130 133 130
   q7   989 613 616 613
   q8   9216218821232123
   q9   9197676167696761
   q10  9680386838843868
   q11  436 253 231 231
   q12  470 221 230 221
   q13  17196   315532973155
   q14  264 246 229 229
   q15  522 471 489 471
   q16  490 389 399 389
   q17  987 683 700 683
   q18  8550805178197819
   q19  7082157415531553
   q20  668 312 318 312
   q21  5111419640844084
   q22  360 272 292 272
   Total cold run time: 119234 ms
   Total hot run time: 42049 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4548444344744443
   q2   389 280 274 274
   q3   3158300927392739
   q4   1870157816941578
   q5   5487548855195488
   q6   220 127 127 127
   q7   2177184318331833
   q8   3247339633973396
   q9   8730878987198719
   q10  3967378738423787
   q11  592 504 493 493
   q12  797 642 652 642
   q13  15987   320131473147
   q14  297 293 275 275
   q15  529 480 480 480
   q16  504 420 416 416
   q17  1799146814931468
   q18  7599762573717371
   q19  1662158115711571
   q20  2004178018131780
   q21  9028476746414641
   q22  574 489 492 489
   Total cold run time: 75165 ms
   Total hot run time: 55157 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](nereids) add checkBlockRules() check for create view and alter view [doris]

2024-05-22 Thread via GitHub


feiniaofeiafei commented on PR #34104:
URL: https://github.com/apache/doris/pull/34104#issuecomment-2126167825

   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](nereids) add checkBlockRules() check for create view and alter view [doris]

2024-05-22 Thread via GitHub


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

   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](nereids) add checkBlockRules() check for create view and alter view [doris]

2024-05-22 Thread via GitHub


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

   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](nereids) add checkBlockRules() check for create view and alter view [doris]

2024-05-22 Thread via GitHub


morrySnow commented on PR #34104:
URL: https://github.com/apache/doris/pull/34104#issuecomment-2126156025

   run performance


-- 
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](nereids) add checkBlockRules() check for create view and alter view [doris]

2024-04-24 Thread via GitHub


feiniaofeiafei commented on PR #34104:
URL: https://github.com/apache/doris/pull/34104#issuecomment-2076441417

   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](nereids) add checkBlockRules() check for create view and alter view [doris]

2024-04-24 Thread via GitHub


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

   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your 
PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
   
   Since 2024-03-18, the Document has been moved to 
[doris-website](https://github.com/apache/doris-website).
   See [Doris 
Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).


-- 
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