You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Jibing-Li (via GitHub)" <gi...@apache.org> on 2023/11/21 03:13:28 UTC
[PR] [Fix](statistics)Fix analyze sql including key word bug. [doris]
Jibing-Li opened a new pull request, #27321:
URL: https://github.com/apache/doris/pull/27321
Fix analyze sql including key word bug. Need use ` to wrap column names.
<!--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](statistics)Fix analyze sql including key word bug. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27321:
URL: https://github.com/apache/doris/pull/27321#issuecomment-1820250488
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.76 seconds
stream load tsv: 570 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.5 seconds inserted 10000000 Rows, about 350K ops/s
storage size: 17099032560 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] [Fix](statistics)Fix analyze sql including key word bug. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #27321:
URL: https://github.com/apache/doris/pull/27321#issuecomment-1820146322
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](statistics)Fix analyze sql including key word bug. [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman merged PR #27321:
URL: https://github.com/apache/doris/pull/27321
--
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](statistics)Fix analyze sql including key word bug. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27321:
URL: https://github.com/apache/doris/pull/27321#issuecomment-1820156335
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](statistics)Fix analyze sql including key word bug. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27321:
URL: https://github.com/apache/doris/pull/27321#issuecomment-1820149015
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](statistics)Fix analyze sql including key word bug. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27321:
URL: https://github.com/apache/doris/pull/27321#issuecomment-1820247979
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit e761efba6f73b496dd5bf38b80029b286cd682d2, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4948 4654 4640 4640
q2 376 142 140 140
q3 2025 1899 1876 1876
q4 1400 1253 1219 1219
q5 3966 3972 4054 3972
q6 249 130 135 130
q7 1419 878 888 878
q8 2754 2802 2789 2789
q9 9803 9887 9612 9612
q10 3481 3550 3542 3542
q11 385 259 257 257
q12 448 296 295 295
q13 4546 3844 3817 3817
q14 313 281 292 281
q15 589 552 524 524
q16 670 587 585 585
q17 1141 973 948 948
q18 7864 7398 7379 7379
q19 1668 1698 1678 1678
q20 541 311 294 294
q21 4382 3995 3980 3980
q22 480 375 380 375
Total cold run time: 53448 ms
Total hot run time: 49211 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4604 4585 4596 4585
q2 338 236 266 236
q3 4022 3979 3986 3979
q4 2706 2683 2684 2683
q5 9591 9720 9734 9720
q6 242 122 125 122
q7 3013 2488 2470 2470
q8 4425 4425 4448 4425
q9 13294 13155 13147 13147
q10 4125 4196 4193 4193
q11 769 635 716 635
q12 987 812 835 812
q13 4304 3587 3596 3587
q14 380 339 343 339
q15 584 524 523 523
q16 744 684 672 672
q17 3888 3839 3801 3801
q18 9495 8866 9011 8866
q19 1831 1780 1767 1767
q20 2397 2080 2031 2031
q21 8814 8672 8629 8629
q22 958 791 784 784
Total cold run time: 81511 ms
Total hot run time: 78006 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