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 2023/11/16 10:59:21 UTC
[PR] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
zy-kkk opened a new pull request, #27124:
URL: https://github.com/apache/doris/pull/27124
## Proposed changes
Issue Number: close #xxx
This PR adds the processing of lowercase Column names in Oracle Jdbc Catalog. In the previous behavior, we changed all Oracle columns to uppercase queries by default, but could not handle the lowercase case. This PR can solve this situation and improve All Jdbc Catalog works
## 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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1815719140
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1814288916
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.26 seconds
stream load tsv: 573 seconds loaded 74807831229 Bytes, about 124 MB/s
stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 29.1 seconds inserted 10000000 Rows, about 343K ops/s
storage size: 17099361297 Bytes
--
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1816019856
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1814980068
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit f7de5a3e445ae48d72a560a0e5c3ee7fd3578baf, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4933 4662 4662 4662
q2 362 162 156 156
q3 2032 1962 1949 1949
q4 1408 1225 1216 1216
q5 3971 3947 4054 3947
q6 245 132 134 132
q7 1398 876 890 876
q8 2775 2785 2770 2770
q9 9697 9565 9673 9565
q10 3464 3533 3519 3519
q11 376 247 234 234
q12 447 291 298 291
q13 4549 3791 3827 3791
q14 312 288 292 288
q15 585 525 522 522
q16 673 577 592 577
q17 1135 975 943 943
q18 7810 7438 7419 7419
q19 1694 1688 1691 1688
q20 535 304 292 292
q21 4383 3973 3948 3948
q22 484 385 380 380
Total cold run time: 53268 ms
Total hot run time: 49165 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4595 4566 4543 4543
q2 340 241 266 241
q3 4025 4006 4001 4001
q4 2705 2695 2701 2695
q5 9647 9613 9590 9590
q6 241 125 123 123
q7 2609 2276 2245 2245
q8 4416 4468 4488 4468
q9 13215 13119 13203 13119
q10 4110 4175 4163 4163
q11 803 699 654 654
q12 981 823 820 820
q13 4268 3598 3597 3597
q14 384 357 357 357
q15 582 521 526 521
q16 738 661 673 661
q17 3883 3907 3880 3880
q18 9628 8930 9243 8930
q19 1855 1800 1778 1778
q20 2427 2089 2066 2066
q21 8813 8416 8520 8416
q22 923 788 804 788
Total cold run time: 81188 ms
Total hot run time: 77656 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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1815740586
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 9f95a4d21d2953169e3e7fb5c05bb74b748f0f4d, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4940 4653 4668 4653
q2 375 151 176 151
q3 2070 1960 1919 1919
q4 1398 1259 1201 1201
q5 3950 3943 4080 3943
q6 250 126 133 126
q7 1393 889 877 877
q8 2744 2792 2783 2783
q9 9765 9678 9612 9612
q10 3484 3523 3530 3523
q11 376 232 250 232
q12 447 302 290 290
q13 4584 3796 3804 3796
q14 325 292 290 290
q15 591 535 546 535
q16 664 584 579 579
q17 1136 972 914 914
q18 7853 7387 7470 7387
q19 1676 1671 1704 1671
q20 529 316 326 316
q21 4385 3945 4001 3945
q22 476 369 372 369
Total cold run time: 53411 ms
Total hot run time: 49112 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4578 4579 4589 4579
q2 338 234 272 234
q3 4032 4018 4001 4001
q4 2717 2694 2702 2694
q5 9722 9734 9769 9734
q6 248 123 124 123
q7 2572 2277 2317 2277
q8 4411 4469 4488 4469
q9 13182 13144 13057 13057
q10 4107 4170 4168 4168
q11 751 643 689 643
q12 987 822 834 822
q13 4296 3577 3735 3577
q14 378 343 342 342
q15 589 511 522 511
q16 736 678 698 678
q17 3914 3895 3886 3886
q18 9611 8945 9168 8945
q19 1785 1765 1792 1765
q20 2428 2099 2030 2030
q21 8827 8487 8508 8487
q22 920 823 785 785
Total cold run time: 81129 ms
Total hot run time: 77807 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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1814223288
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman merged PR #27124:
URL: https://github.com/apache/doris/pull/27124
--
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1815903759
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.98 seconds
stream load tsv: 562 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 28.3 seconds inserted 10000000 Rows, about 353K ops/s
storage size: 17099374158 Bytes
--
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1814760637
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1814587144
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 672d4ff18b7ca974ce36daa279b5951fa0e5155c, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4911 4686 4658 4658
q2 358 169 161 161
q3 2055 1919 1942 1919
q4 1415 1327 1248 1248
q5 3974 3961 4033 3961
q6 252 136 133 133
q7 1403 879 887 879
q8 2786 2821 2795 2795
q9 9833 9664 9671 9664
q10 3497 3539 3563 3539
q11 369 251 252 251
q12 443 302 303 302
q13 4567 3843 3784 3784
q14 327 301 291 291
q15 588 545 534 534
q16 668 577 578 577
q17 1144 998 939 939
q18 7894 7357 7469 7357
q19 1691 1682 1685 1682
q20 524 324 309 309
q21 4475 3989 4042 3989
q22 482 369 380 369
Total cold run time: 53656 ms
Total hot run time: 49341 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4584 4585 4598 4585
q2 343 232 250 232
q3 4024 4011 4013 4011
q4 2714 2694 2700 2694
q5 9596 9686 9704 9686
q6 249 124 127 124
q7 2602 2235 2235 2235
q8 4466 4460 4509 4460
q9 13314 13122 13201 13122
q10 4099 4194 4182 4182
q11 794 720 662 662
q12 987 815 829 815
q13 4308 3640 3595 3595
q14 379 348 370 348
q15 569 520 518 518
q16 724 654 666 654
q17 3909 3911 3839 3839
q18 9708 9000 9104 9000
q19 1821 1794 1787 1787
q20 2385 2076 2077 2076
q21 8868 8619 8903 8619
q22 894 834 817 817
Total cold run time: 81337 ms
Total hot run time: 78061 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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1814225156
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1814984675
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.69 seconds
stream load tsv: 565 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.7 seconds inserted 10000000 Rows, about 348K ops/s
storage size: 17099746683 Bytes
--
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1814275891
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 672d4ff18b7ca974ce36daa279b5951fa0e5155c, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4949 4651 4680 4651
q2 353 163 160 160
q3 2042 1958 1871 1871
q4 1379 1250 1212 1212
q5 3948 3931 4038 3931
q6 251 130 135 130
q7 1405 858 887 858
q8 2755 2780 2771 2771
q9 9869 9764 9598 9598
q10 3474 3535 3544 3535
q11 376 251 246 246
q12 437 289 301 289
q13 4604 3831 3838 3831
q14 326 291 288 288
q15 593 535 526 526
q16 671 587 579 579
q17 1134 964 941 941
q18 7908 7335 7494 7335
q19 1677 1695 1683 1683
q20 554 313 288 288
q21 4416 3959 3952 3952
q22 478 381 376 376
Total cold run time: 53599 ms
Total hot run time: 49051 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4591 4576 4599 4576
q2 351 232 249 232
q3 4022 4011 3999 3999
q4 2695 2707 2697 2697
q5 9653 9629 9628 9628
q6 245 122 123 122
q7 2630 2301 2286 2286
q8 4435 4418 4427 4418
q9 13178 13177 13036 13036
q10 4102 4182 4156 4156
q11 779 671 650 650
q12 977 816 811 811
q13 4301 3584 3587 3584
q14 380 352 341 341
q15 581 530 526 526
q16 733 690 679 679
q17 3901 3907 3828 3828
q18 9607 9221 8897 8897
q19 1833 1769 1788 1769
q20 2406 2079 2047 2047
q21 8817 8439 8691 8439
q22 927 822 814 814
Total cold run time: 81144 ms
Total hot run time: 77535 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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1815899344
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit a24bf9c324e0e8bd127b2211c11379d7a7229048, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4939 4677 4658 4658
q2 361 154 165 154
q3 2029 1905 1928 1905
q4 1370 1232 1244 1232
q5 3996 3990 4019 3990
q6 248 128 126 126
q7 1401 875 900 875
q8 2753 2811 2772 2772
q9 9850 9705 9524 9524
q10 3483 3555 3557 3555
q11 379 239 250 239
q12 437 293 295 293
q13 4610 3804 3844 3804
q14 311 289 285 285
q15 592 533 521 521
q16 663 586 577 577
q17 1145 960 930 930
q18 7916 7457 7423 7423
q19 1675 1699 1662 1662
q20 528 337 307 307
q21 4410 4053 3998 3998
q22 476 380 373 373
Total cold run time: 53572 ms
Total hot run time: 49203 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4579 4641 4601 4601
q2 348 252 240 240
q3 4047 4017 4013 4013
q4 2712 2719 2717 2717
q5 9724 9715 9745 9715
q6 241 125 127 125
q7 2621 2335 2248 2248
q8 4489 4460 4453 4453
q9 13242 13135 13086 13086
q10 4071 4212 4212 4212
q11 791 655 689 655
q12 975 810 813 810
q13 4310 3573 3518 3518
q14 386 347 358 347
q15 577 512 530 512
q16 726 678 680 678
q17 3923 3871 3929 3871
q18 9510 9137 9040 9040
q19 1810 1808 1786 1786
q20 2399 2082 2061 2061
q21 8974 8637 8725 8637
q22 893 815 793 793
Total cold run time: 81348 ms
Total hot run time: 78118 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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1815827752
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1814463131
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1816672293
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1815743477
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.07 seconds
stream load tsv: 562 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.7 seconds inserted 10000000 Rows, about 348K ops/s
storage size: 17098019540 Bytes
--
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1814219831
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1814400233
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.03 seconds
stream load tsv: 568 seconds loaded 74807831229 Bytes, about 125 MB/s
stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.9 seconds inserted 10000000 Rows, about 346K ops/s
storage size: 17099470852 Bytes
--
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] [enhancement](jdbc catalog) Add lowercase column name mapping to Jdbc data source & optimize database and table mapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27124:
URL: https://github.com/apache/doris/pull/27124#issuecomment-1814595710
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.81 seconds
stream load tsv: 566 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 27.8 seconds inserted 10000000 Rows, about 359K ops/s
storage size: 17099332244 Bytes
--
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