Re: [PR] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-23 Thread via GitHub


morningman merged PR #35139:
URL: https://github.com/apache/doris/pull/35139


-- 
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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-23 Thread via GitHub


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

   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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-23 Thread via GitHub


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

   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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-23 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.5 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit f0033f109808e965c5ba19f651770c28a97a8e64, 
data reload: false
   
   query1   0.040.030.03
   query2   0.080.040.04
   query3   0.230.060.05
   query4   1.660.080.08
   query5   0.510.490.50
   query6   1.130.720.72
   query7   0.020.010.01
   query8   0.060.050.04
   query9   0.540.490.50
   query10  0.540.560.55
   query11  0.150.110.12
   query12  0.140.120.11
   query13  0.590.590.62
   query14  0.770.770.78
   query15  0.830.820.82
   query16  0.360.370.38
   query17  1.031.031.00
   query18  0.220.230.24
   query19  1.881.721.71
   query20  0.010.010.01
   query21  15.58   0.670.64
   query22  4.278.061.76
   query23  18.33   1.391.29
   query24  1.720.290.22
   query25  0.160.090.08
   query26  0.260.170.17
   query27  0.080.080.08
   query28  13.33   1.010.98
   query29  13.09   3.353.30
   query30  0.240.060.06
   query31  2.940.390.38
   query32  3.220.460.46
   query33  2.912.932.85
   query34  17.19   4.444.42
   query35  4.514.574.50
   query36  0.700.490.49
   query37  0.180.150.15
   query38  0.170.150.14
   query39  0.040.030.03
   query40  0.160.150.15
   query41  0.080.040.05
   query42  0.050.050.05
   query43  0.040.040.04
   Total cold run time: 110.04 s
   Total hot run time: 30.5 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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-23 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 172260 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 f0033f109808e965c5ba19f651770c28a97a8e64, 
data reload: false
   
   query1   909 380 370 370
   query2   6430236723042304
   query3   6670204 201 201
   query4   19487   17484   17188   17188
   query5   4192429 412 412
   query6   236 158 159 158
   query7   4595290 285 285
   query8   232 192 182 182
   query9   8459245124422442
   query10  453 291 266 266
   query11  10475   10069   10034   10034
   query12  132 88  85  85
   query13  1664367 381 367
   query14  9286749773727372
   query15  234 173 169 169
   query16  7730259 254 254
   query17  1729543 512 512
   query18  1843271 262 262
   query19  198 154 156 154
   query20  94  81  87  81
   query21  192 125 130 125
   query22  4246385939143859
   query23  33439   32722   32922   32722
   query24  6852284327952795
   query25  569 366 358 358
   query26  709 153 155 153
   query27  2012325 323 323
   query28  3681208120862081
   query29  832 621 586 586
   query30  252 170 171 170
   query31  947 737 738 737
   query32  85  51  53  51
   query33  488 285 260 260
   query34  841 468 477 468
   query35  685 606 595 595
   query36  1022929 893 893
   query37  105 73  69  69
   query38  2890278227342734
   query39  816 789 791 789
   query40  195 125 129 125
   query41  47  43  43  43
   query42  103 93  96  93
   query43  556 540 535 535
   query44  1036710 732 710
   query45  178 165 161 161
   query46  1052720 706 706
   query47  1902173517971735
   query48  365 306 298 298
   query49  856 368 377 368
   query50  763 385 381 381
   query51  6866680066946694
   query52  101 86  88  86
   query53  345 281 279 279
   query54  529 435 421 421
   query55  70  71  72  71
   query56  259 244 244 244
   query57  1135107310061006
   query58  229 204 207 204
   query59  3497321733463217
   query60  270 250 287 250
   query61  88  88  86  86
   query62  573 457 461 457
   query63  308 275 288 275
   query64  8408218917841784
   query65  3125307431153074
   query66  820 350 323 323
   query67  15508   15116   14966   14966
   query68  4567532 530 530
   query69  451 271 271 271
   query70  1080109010901090
   query71  371 270 263 263
   query72  7143569456045604
   query73  721 321 319 319
   query74  6037560356295603
   query75  3307260426422604
   query76  2335102610001000
   query77  407 282 264 264
   query78  10114   963597509635
   query79  2437524 520 520
   query80  1849507 427 427
   query81  539 245 239 239
   query82  129798  94  94
   query83  298 171 171 171
   query84  268 84  86  84
   query85  1274284 264 264
   query86  458 312 297 297
   query87  3276312332223123
   query88  3987241924002400
   query89  470 399 381 381
   query90  2020186 184 184
   query91  120 97  97  97
   query92  56  46  47  46
   query93  2578502 492 492
   query94  1269186 232 186
   query95  391 303 299 299
   query96  598 268 268 268
   query97  3185299930062999
   query98  238 218 216 216
   query99  1157832 858 832
   Total cold run time: 259193 ms
   Total hot run time: 172260 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 

Re: [PR] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-23 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41616 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit f0033f109808e965c5ba19f651770c28a97a8e64, 
data reload: false
   
   -- Round 1 --
   q1   17603   442142374237
   q2   2036183 186 183
   q3   10456   128512021202
   q4   10194   799 784 784
   q5   7480279126092609
   q6   233 134 135 134
   q7   974 601 598 598
   q8   9211211120702070
   q9   9344669666546654
   q10  9682383939343839
   q11  445 249 248 248
   q12  485 216 234 216
   q13  18145   319832333198
   q14  247 213 208 208
   q15  504 471 465 465
   q16  507 409 403 403
   q17  959 629 607 607
   q18  8524794978267826
   q19  6835159415591559
   q20  652 320 322 320
   q21  5190398439823982
   q22  381 292 274 274
   Total cold run time: 120087 ms
   Total hot run time: 41616 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4452438943774377
   q2   391 278 277 277
   q3   3118293727142714
   q4   1863159816401598
   q5   5461545954935459
   q6   217 121 123 121
   q7   2166184517821782
   q8   3231339233513351
   q9   8570861085458545
   q10  3872374738223747
   q11  581 494 497 494
   q12  784 615 621 615
   q13  15953   319031303130
   q14  286 265 265 265
   q15  547 475 487 475
   q16  493 435 433 433
   q17  1814149014571457
   q18  7667759474147414
   q19  1644155715241524
   q20  1999180717871787
   q21  8445466146874661
   q22  587 501 483 483
   Total cold run time: 74141 ms
   Total hot run time: 54709 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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-23 Thread via GitHub


BePPPower commented on PR #35139:
URL: https://github.com/apache/doris/pull/35139#issuecomment-2126667020

   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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-23 Thread via GitHub


BePPPower commented on PR #35139:
URL: https://github.com/apache/doris/pull/35139#issuecomment-2126560445

   run external 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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-22 Thread via GitHub


BePPPower commented on code in PR #35139:
URL: https://github.com/apache/doris/pull/35139#discussion_r1610933365


##
fe/fe-core/src/main/java/org/apache/doris/tablefunction/ExternalFileTableValuedFunction.java:
##
@@ -174,9 +175,18 @@ protected void parseFile() throws AnalysisException {
 
 //The keys in properties map need to be lowercase.
 protected Map parseCommonProperties(Map 
properties) throws AnalysisException {
+Map mergedProperties = Maps.newHashMap();
+if (properties.containsKey("resource")) {
+Resource resource = 
Env.getCurrentEnv().getResourceMgr().getResource(properties.get("resource"));
+if (resource == null) {
+throw new AnalysisException("Can not find resource: " + 
properties.containsKey("resource"));

Review Comment:
   done



-- 
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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-22 Thread via GitHub


BePPPower commented on PR #35139:
URL: https://github.com/apache/doris/pull/35139#issuecomment-2126186673

   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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-22 Thread via GitHub


morningman commented on code in PR #35139:
URL: https://github.com/apache/doris/pull/35139#discussion_r1609473889


##
fe/fe-core/src/main/java/org/apache/doris/tablefunction/ExternalFileTableValuedFunction.java:
##
@@ -174,9 +175,18 @@ protected void parseFile() throws AnalysisException {
 
 //The keys in properties map need to be lowercase.
 protected Map parseCommonProperties(Map 
properties) throws AnalysisException {
+Map mergedProperties = Maps.newHashMap();
+if (properties.containsKey("resource")) {
+Resource resource = 
Env.getCurrentEnv().getResourceMgr().getResource(properties.get("resource"));
+if (resource == null) {
+throw new AnalysisException("Can not find resource: " + 
properties.containsKey("resource"));

Review Comment:
   ```suggestion
   throw new AnalysisException("Can not find resource: " + 
properties.get("resource"));
   ```



-- 
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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-21 Thread via GitHub


BePPPower commented on PR #35139:
URL: https://github.com/apache/doris/pull/35139#issuecomment-2122631521

   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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-21 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.8 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 259b52f8c9823c792bb6340ef0bd5649c5f86aa0, 
data reload: false
   
   query1   0.040.040.03
   query2   0.080.040.04
   query3   0.220.050.05
   query4   1.680.070.07
   query5   0.500.480.51
   query6   1.130.730.73
   query7   0.020.010.01
   query8   0.050.040.04
   query9   0.530.500.49
   query10  0.550.540.53
   query11  0.160.120.12
   query12  0.150.120.12
   query13  0.580.580.61
   query14  0.790.790.79
   query15  0.840.820.82
   query16  0.360.360.37
   query17  1.040.961.00
   query18  0.240.250.24
   query19  1.821.711.71
   query20  0.020.010.01
   query21  15.51   0.690.68
   query22  5.126.482.17
   query23  18.25   1.321.19
   query24  1.760.220.22
   query25  0.150.080.08
   query26  0.260.170.18
   query27  0.090.070.08
   query28  13.46   1.030.99
   query29  13.22   3.243.24
   query30  0.240.060.05
   query31  2.870.400.39
   query32  3.270.480.47
   query33  2.902.882.88
   query34  17.21   4.484.48
   query35  4.504.524.72
   query36  0.660.460.47
   query37  0.180.160.15
   query38  0.150.150.14
   query39  0.050.030.04
   query40  0.160.130.14
   query41  0.090.050.04
   query42  0.050.050.04
   query43  0.040.030.04
   Total cold run time: 110.99 s
   Total hot run time: 30.8 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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-21 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 181396 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 259b52f8c9823c792bb6340ef0bd5649c5f86aa0, 
data reload: false
   
   query1   906 405 369 369
   query2   6434240924002400
   query3   6654225 213 213
   query4   22941   21368   21352   21352
   query5   4142431 420 420
   query6   257 182 189 182
   query7   4590296 284 284
   query8   242 186 187 186
   query9   8662236823382338
   query10  431 246 240 240
   query11  14737   14250   14408   14250
   query12  137 92  90  90
   query13  1644377 369 369
   query14  9668869269496949
   query15  254 164 173 164
   query16  8037275 254 254
   query17  1803548 555 548
   query18  2031302 280 280
   query19  202 147 152 147
   query20  91  87  84  84
   query21  192 128 126 126
   query22  5134492148944894
   query23  34089   33497   33586   33497
   query24  6706297528402840
   query25  542 366 363 363
   query26  700 160 156 156
   query27  1886319 310 310
   query28  3800203020192019
   query29  863 627 604 604
   query30  255 177 174 174
   query31  937 761 732 732
   query32  89  52  56  52
   query33  482 254 242 242
   query34  846 478 472 472
   query35  763 668 686 668
   query36  1052922 919 919
   query37  104 70  70  70
   query38  2898282827542754
   query39  1636154915331533
   query40  193 125 151 125
   query41  45  44  41  41
   query42  103 94  94  94
   query43  569 552 524 524
   query44  1061729 740 729
   query45  269 249 252 249
   query46  1058748 696 696
   query47  1943189418781878
   query48  374 298 285 285
   query49  769 391 411 391
   query50  768 384 377 377
   query51  6866674668666746
   query52  111 88  92  88
   query53  350 280 287 280
   query54  540 422 430 422
   query55  74  73  75  73
   query56  252 215 222 215
   query57  1222118411321132
   query58  218 203 210 203
   query59  3394297731932977
   query60  252 243 232 232
   query61  88  105 94  94
   query62  601 452 487 452
   query63  311 284 285 284
   query64  8404225218081808
   query65  3151311030813081
   query66  805 353 347 347
   query67  15259   15402   15333   15333
   query68  4580531 525 525
   query69  480 302 368 302
   query70  1109116111051105
   query71  389 270 281 270
   query72  7360261223332333
   query73  724 317 317 317
   query74  6632624662906246
   query75  3424265726722657
   query76  2238104110101010
   query77  388 263 265 263
   query78  10694   10120   10381   10120
   query79  2382519 510 510
   query80  947 436 427 427
   query81  525 240 245 240
   query82  733 97  92  92
   query83  247 168 176 168
   query84  246 91  86  86
   query85  1098314 262 262
   query86  471 276 313 276
   query87  3298316231223122
   query88  4077231823242318
   query89  469 381 381 381
   query90  2037186 184 184
   query91  123 96  94  94
   query92  62  49  48  48
   query93  1462494 477 477
   query94  1137179 178 178
   query95  396 304 302 302
   query96  586 271 269 269
   query97  3150301430413014
   query98  244 230 223 223
   query99  1207877 921 877
   Total cold run time: 268802 ms
   Total hot run time: 181396 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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-21 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41661 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 259b52f8c9823c792bb6340ef0bd5649c5f86aa0, 
data reload: false
   
   -- Round 1 --
   q1   17598   436042274227
   q2   2013200 191 191
   q3   10436   124512601245
   q4   10208   887 718 718
   q5   7469273027202720
   q6   219 131 135 131
   q7   1046607 604 604
   q8   9252214120782078
   q9   10543   732973367329
   q10  9711395039083908
   q11  460 258 233 233
   q12  454 217 215 215
   q13  17258   318032413180
   q14  265 237 226 226
   q15  518 478 475 475
   q16  498 398 381 381
   q17  973 643 696 643
   q18  8281781478097809
   q19  2149154415571544
   q20  626 320 299 299
   q21  5312323342233233
   q22  357 272 290 272
   Total cold run time: 115646 ms
   Total hot run time: 41661 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4535446444064406
   q2   394 274 277 274
   q3   3178295829572957
   q4   1928160516151605
   q5   5453552554965496
   q6   218 128 128 128
   q7   2330199620071996
   q8   3238343334043404
   q9   9332943994319431
   q10  3934380339113803
   q11  587 524 526 524
   q12  771 621 650 621
   q13  16230   313832113138
   q14  300 281 269 269
   q15  515 474 477 474
   q16  510 441 430 430
   q17  1755150714461446
   q18  7865769374027402
   q19  1958153516031535
   q20  2032180517821782
   q21  9194497248904890
   q22  601 485 494 485
   Total cold run time: 76858 ms
   Total hot run time: 56496 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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-21 Thread via GitHub


BePPPower commented on PR #35139:
URL: https://github.com/apache/doris/pull/35139#issuecomment-2122472404

   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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-21 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.69 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 0073863dbe4d6c813e0a370804952113d52ae9ca, 
data reload: false
   
   query1   0.040.030.04
   query2   0.080.040.04
   query3   0.230.050.06
   query4   1.680.070.07
   query5   0.500.490.52
   query6   1.120.720.72
   query7   0.020.010.01
   query8   0.050.050.04
   query9   0.550.480.49
   query10  0.550.540.53
   query11  0.150.110.11
   query12  0.150.120.12
   query13  0.600.590.58
   query14  0.780.770.77
   query15  0.830.800.80
   query16  0.360.360.37
   query17  0.950.960.96
   query18  0.230.240.21
   query19  1.751.671.68
   query20  0.020.010.02
   query21  15.48   0.710.69
   query22  3.977.302.16
   query23  18.31   1.361.27
   query24  1.290.480.20
   query25  0.140.090.08
   query26  0.270.170.18
   query27  0.080.070.08
   query28  13.28   1.031.00
   query29  12.70   3.303.27
   query30  0.250.060.06
   query31  2.860.390.38
   query32  3.310.480.46
   query33  2.912.902.83
   query34  17.02   4.514.47
   query35  4.594.484.50
   query36  0.660.460.46
   query37  0.180.170.15
   query38  0.160.150.15
   query39  0.040.030.04
   query40  0.160.140.14
   query41  0.090.040.05
   query42  0.060.050.05
   query43  0.040.030.04
   Total cold run time: 108.49 s
   Total hot run time: 30.69 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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-21 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 181762 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 0073863dbe4d6c813e0a370804952113d52ae9ca, 
data reload: false
   
   query1   907 382 370 370
   query2   6457250223382338
   query3   6649221 217 217
   query4   23835   21337   21258   21258
   query5   4144408 438 408
   query6   260 175 172 172
   query7   4592286 292 286
   query8   236 182 187 182
   query9   8481242623732373
   query10  445 246 263 246
   query11  14917   14253   14330   14253
   query12  131 91  88  88
   query13  1639367 359 359
   query14  10078   851884208420
   query15  247 167 169 167
   query16  8133264 250 250
   query17  1855546 538 538
   query18  2055275 265 265
   query19  206 144 165 144
   query20  92  86  87  86
   query21  190 132 125 125
   query22  4970480648534806
   query23  34149   33516   33397   33397
   query24  11043   284028922840
   query25  614 395 365 365
   query26  1150156 154 154
   query27  2833315 326 315
   query28  7306203520352035
   query29  855 602 594 594
   query30  309 173 178 173
   query31  990 771 757 757
   query32  99  52  52  52
   query33  742 267 242 242
   query34  1033473 472 472
   query35  842 676 703 676
   query36  1056945 897 897
   query37  138 74  70  70
   query38  2883278727572757
   query39  1632155515701555
   query40  198 123 124 123
   query41  45  41  40  40
   query42  103 98  94  94
   query43  592 540 551 540
   query44  1220723 739 723
   query45  272 254 260 254
   query46  1079694 721 694
   query47  1942187818771877
   query48  367 293 286 286
   query49  1087385 393 385
   query50  762 397 385 385
   query51  6957679268146792
   query52  103 95  90  90
   query53  350 275 276 275
   query54  908 428 418 418
   query55  75  74  76  74
   query56  250 233 229 229
   query57  1242111511361115
   query58  223 197 195 195
   query59  3359301031213010
   query60  260 229 235 229
   query61  91  86  93  86
   query62  668 477 466 466
   query63  306 280 278 278
   query64  9220225016991699
   query65  3175315231003100
   query66  1417350 354 350
   query67  15259   14757   15125   14757
   query68  4594513 519 513
   query69  465 306 312 306
   query70  1136108210461046
   query71  414 260 264 260
   query72  8116255823812381
   query73  705 314 313 313
   query74  6600621663816216
   query75  3308263326252625
   query76  2455995 1005995
   query77  430 268 262 262
   query78  10568   994810054   9948
   query79  2502507 506 506
   query80  1019427 432 427
   query81  519 242 238 238
   query82  737 98  96  96
   query83  240 169 166 166
   query84  237 87  86  86
   query85  1612276 274 274
   query86  502 298 322 298
   query87  3254317431323132
   query88  4219235023462346
   query89  458 377 388 377
   query90  1935193 184 184
   query91  127 112 107 107
   query92  58  52  52  52
   query93  1872497 486 486
   query94  1181182 186 182
   query95  400 300 301 300
   query96  586 265 268 265
   query97  3183300330043003
   query98  234 223 217 217
   query99  1130889 925 889
   Total cold run time: 284519 ms
   Total hot run time: 181762 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 

[PR] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-21 Thread via GitHub


BePPPower opened a new pull request, #35139:
URL: https://github.com/apache/doris/pull/35139

   ## Proposed changes
   
   Issue Number: close #xxx
   
   
   
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at 
[d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you 
chose the solution you did and what alternatives you considered, etc...
   
   


-- 
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] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-21 Thread via GitHub


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

   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



Re: [PR] [Enhencement](tvf) select tvf supports using resource [doris]

2024-05-21 Thread via GitHub


BePPPower commented on PR #35139:
URL: https://github.com/apache/doris/pull/35139#issuecomment-2122265137

   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