You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zy-kkk (via GitHub)" <gi...@apache.org> on 2024/03/13 09:58:16 UTC
[PR] [fix](jdbc catalog) fix get doris column info when lower case [doris]
zy-kkk opened a new pull request, #32190:
URL: https://github.com/apache/doris/pull/32190
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](jdbc catalog) fix get doris column info when lower case [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32190:
URL: https://github.com/apache/doris/pull/32190#issuecomment-1994087181
<details>
<summary>TPC-DS: <b>Total hot run time: 186308 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 54ba60e40a0ba5dbae0299d3c99e5ff75793dc2b, data reload: false
query1 908 362 336 336
query2 7901 1996 1982 1982
query3 6698 205 208 205
query4 31055 20610 20716 20610
query5 4425 404 389 389
query6 262 175 164 164
query7 4626 301 285 285
query8 223 172 164 164
query9 9915 2296 2271 2271
query10 453 236 245 236
query11 17134 14232 14240 14232
query12 136 87 83 83
query13 1634 413 445 413
query14 11053 10423 10822 10423
query15 283 202 194 194
query16 8150 255 253 253
query17 1994 556 532 532
query18 2121 271 277 271
query19 341 156 153 153
query20 100 88 87 87
query21 203 130 127 127
query22 4696 4431 4497 4431
query23 31776 31124 31011 31011
query24 10813 2876 2736 2736
query25 628 371 373 371
query26 1292 154 153 153
query27 3021 349 347 347
query28 8079 1899 1873 1873
query29 906 640 607 607
query30 313 146 145 145
query31 943 717 712 712
query32 90 59 53 53
query33 767 278 252 252
query34 1028 474 474 474
query35 824 627 583 583
query36 1007 892 857 857
query37 131 76 78 76
query38 3309 3135 3204 3135
query39 1407 1374 1372 1372
query40 216 112 112 112
query41 51 45 48 45
query42 104 94 95 94
query43 471 449 465 449
query44 1354 735 711 711
query45 263 253 254 253
query46 1100 685 674 674
query47 1665 1603 1609 1603
query48 438 365 344 344
query49 1110 336 336 336
query50 751 376 373 373
query51 6615 6603 6611 6603
query52 104 92 93 92
query53 337 274 273 273
query54 290 235 228 228
query55 83 79 84 79
query56 238 227 245 227
query57 1107 1020 1011 1011
query58 231 207 220 207
query59 2789 2754 2547 2547
query60 271 251 275 251
query61 113 110 113 110
query62 610 402 410 402
query63 302 265 278 265
query64 5478 3958 3807 3807
query65 3081 2971 2995 2971
query66 837 320 320 320
query67 14958 14354 14194 14194
query68 7148 513 507 507
query69 623 373 376 373
query70 1178 1161 1143 1143
query71 520 274 269 269
query72 6851 2629 2479 2479
query73 712 312 313 312
query74 7218 6552 6570 6552
query75 9641 7985 8029 7985
query76 5551 888 862 862
query77 750 264 252 252
query78 10392 9736 9603 9603
query79 6948 515 515 515
query80 1284 477 374 374
query81 535 208 214 208
query82 1217 201 197 197
query83 208 146 139 139
query84 288 78 75 75
query85 1579 322 311 311
query86 470 284 310 284
query87 3414 3286 3256 3256
query88 4802 2268 2296 2268
query89 537 361 371 361
query90 2133 170 167 167
query91 159 125 131 125
query92 65 45 46 45
query93 6722 506 486 486
query94 1351 172 170 170
query95 430 324 321 321
query96 616 276 273 273
query97 4422 4264 4268 4264
query98 213 210 209 209
query99 1112 744 757 744
Total cold run time: 314701 ms
Total hot run time: 186308 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](jdbc catalog) fix get doris column info when lower case [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32190:
URL: https://github.com/apache/doris/pull/32190#issuecomment-1994096801
<details>
<summary>ClickBench: <b>Total hot run time: 29.58 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 54ba60e40a0ba5dbae0299d3c99e5ff75793dc2b, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.03 0.02
query3 0.22 0.06 0.06
query4 1.69 0.10 0.10
query5 0.51 0.51 0.51
query6 1.18 0.62 0.64
query7 0.02 0.02 0.01
query8 0.03 0.02 0.02
query9 0.55 0.48 0.49
query10 0.55 0.54 0.54
query11 0.12 0.08 0.09
query12 0.11 0.08 0.09
query13 0.57 0.56 0.56
query14 0.75 0.76 0.75
query15 0.81 0.80 0.79
query16 0.42 0.38 0.40
query17 1.02 1.00 0.95
query18 0.18 0.25 0.25
query19 1.91 1.72 1.69
query20 0.01 0.02 0.02
query21 15.41 0.57 0.57
query22 2.66 1.97 1.72
query23 17.15 0.88 0.75
query24 3.19 1.57 0.52
query25 0.22 0.05 0.06
query26 0.68 0.13 0.12
query27 0.04 0.03 0.02
query28 11.52 0.85 0.85
query29 12.50 3.11 3.28
query30 0.68 0.53 0.57
query31 2.80 0.35 0.33
query32 3.38 0.44 0.44
query33 2.77 2.84 2.80
query34 16.03 4.27 4.33
query35 4.32 4.29 4.32
query36 1.09 0.99 1.01
query37 0.06 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.01 0.02
query40 0.17 0.14 0.13
query41 0.07 0.02 0.02
query42 0.02 0.02 0.02
query43 0.03 0.02 0.02
Total cold run time: 105.6 s
Total hot run time: 29.58 s
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](jdbc catalog) fix get doris column info when lower case [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32190:
URL: https://github.com/apache/doris/pull/32190#issuecomment-1994557078
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](jdbc catalog) fix get doris column info when lower case [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32190:
URL: https://github.com/apache/doris/pull/32190#issuecomment-1993995282
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)
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](jdbc catalog) fix get doris column info when lower case [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32190:
URL: https://github.com/apache/doris/pull/32190#issuecomment-1994102223
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 54ba60e40a0ba5dbae0299d3c99e5ff75793dc2b with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 14.0 seconds inserted 10000000 Rows, about 714K ops/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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](jdbc catalog) fix get doris column info when lower case [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32190:
URL: https://github.com/apache/doris/pull/32190#issuecomment-1994557000
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](jdbc catalog) fix get doris column info when lower case [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on PR #32190:
URL: https://github.com/apache/doris/pull/32190#issuecomment-1993996861
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](jdbc catalog) fix get doris column info when lower case [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32190:
URL: https://github.com/apache/doris/pull/32190#issuecomment-1994064025
<details>
<summary>TPC-H: <b>Total hot run time: 36355 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 54ba60e40a0ba5dbae0299d3c99e5ff75793dc2b, data reload: false
------ Round 1 ----------------------------------
q1 17626 4241 4087 4087
q2 2014 155 147 147
q3 10569 935 900 900
q4 4652 697 714 697
q5 7599 2680 2693 2680
q6 183 122 129 122
q7 1201 830 796 796
q8 9469 2022 2035 2022
q9 7361 6394 6419 6394
q10 8130 2478 2465 2465
q11 419 214 222 214
q12 759 303 290 290
q13 17959 3037 3033 3033
q14 285 251 251 251
q15 484 442 467 442
q16 470 387 400 387
q17 942 487 506 487
q18 6556 5797 5804 5797
q19 1556 1415 1390 1390
q20 528 278 273 273
q21 7380 3196 3269 3196
q22 809 285 310 285
Total cold run time: 106951 ms
Total hot run time: 36355 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4095 4077 4048 4048
q2 326 221 227 221
q3 2954 2828 2790 2790
q4 1799 1541 1511 1511
q5 5190 5289 5277 5277
q6 195 115 117 115
q7 2307 1860 1876 1860
q8 3196 3306 3314 3306
q9 8541 8614 8602 8602
q10 7548 3682 3683 3682
q11 542 444 451 444
q12 722 580 537 537
q13 12642 2889 2883 2883
q14 273 246 252 246
q15 472 461 454 454
q16 456 416 428 416
q17 1720 1501 1439 1439
q18 7532 7681 7903 7681
q19 7811 1593 1525 1525
q20 1969 1791 1789 1789
q21 5102 5046 4879 4879
q22 520 450 449 449
Total cold run time: 75912 ms
Total hot run time: 54154 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](jdbc catalog) fix get doris column info when lower case [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk merged PR #32190:
URL: https://github.com/apache/doris/pull/32190
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org