You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Nitin-Kashyap (via GitHub)" <gi...@apache.org> on 2023/12/18 17:04:13 UTC
[PR] [fix](ut) fixed test cases failure for show analyze statement [doris]
Nitin-Kashyap opened a new pull request, #28601:
URL: https://github.com/apache/doris/pull/28601
## Proposed changes
added UT cases for ShowAnalyzeStmt.
--
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] [test](ut) added testcases for show analyze statement [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1866571092
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] [test](ut) added testcases for show analyze statement [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1909489604
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 131415fe1021cc1ef866f56cf0aa48a3d0d2b228 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 14.5 seconds inserted 10000000 Rows, about 689K 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] [test](ut) added testcases for show analyze statement [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1972830777
<details>
<summary>ClickBench: <b>Total hot run time: 26.83 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 a8a282fe663159e391768c305a5820bd0bb9b187, data reload: false
query1 0.05 0.03 0.04
query2 0.10 0.04 0.04
query3 0.27 0.07 0.06
query4 1.60 0.09 0.08
query5 0.51 0.49 0.51
query6 1.53 0.97 0.98
query7 0.03 0.02 0.02
query8 0.07 0.04 0.04
query9 0.68 0.65 0.63
query10 0.69 0.70 0.71
query11 0.21 0.14 0.15
query12 0.18 0.15 0.15
query13 0.49 0.47 0.49
query14 0.75 0.71 0.73
query15 0.94 0.89 0.87
query16 0.41 0.40 0.41
query17 1.19 1.30 1.29
query18 0.33 0.31 0.30
query19 2.17 2.15 2.07
query20 0.02 0.02 0.02
query21 15.37 1.02 0.94
query22 0.57 0.58 0.57
query23 13.68 0.63 0.58
query24 0.79 0.22 0.18
query25 0.06 0.05 0.05
query26 0.20 0.20 0.20
query27 0.05 0.04 0.04
query28 1.45 0.74 0.74
query29 13.02 4.78 4.56
query30 0.86 0.79 0.79
query31 0.85 0.40 0.41
query32 3.23 0.39 0.40
query33 2.43 2.18 2.26
query34 2.26 2.23 2.23
query35 2.23 2.20 2.20
query36 1.00 0.92 0.98
query37 0.09 0.06 0.06
query38 0.06 0.04 0.05
query39 0.03 0.03 0.03
query40 0.19 0.22 0.17
query41 0.08 0.04 0.02
query42 0.04 0.02 0.03
query43 0.04 0.04 0.04
Total cold run time: 70.8 s
Total hot run time: 26.83 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] [test](ut) added testcases for show analyze statement [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1888538351
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] [test](ut) added testcases for show analyze statement [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on code in PR #28601:
URL: https://github.com/apache/doris/pull/28601#discussion_r1449940185
##########
fe/fe-core/src/test/java/org/apache/doris/analysis/ShowAnalyzeStmtTest.java:
##########
@@ -0,0 +1,166 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.analysis;
+
+import org.apache.doris.analysis.LikePredicate.Operator;
+import org.apache.doris.catalog.ScalarType;
+import org.apache.doris.common.AnalysisException;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.ErrorReport;
+import org.apache.doris.common.UserException;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.SessionVariable;
+import org.apache.doris.qe.ShowResultSetMetaData;
+
+import mockit.Mock;
Review Comment:
The import order is wrong.
http://43.132.222.7:8111/buildConfiguration/Doris_DorisCompile_Compile/325463?
you can refer to
https://doris.apache.org/community/developer-guide/java-format-code
--
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] [test](ut) added testcases for show analyze statement [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1972805777
<details>
<summary>TPC-H: <b>Total hot run time: 32066 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 a8a282fe663159e391768c305a5820bd0bb9b187, data reload: false
------ Round 1 ----------------------------------
q1 17802 4636 4501 4501
q2 2165 224 219 219
q3 10387 1127 1064 1064
q4 4699 1152 1158 1152
q5 7758 2080 2047 2047
q6 161 108 105 105
q7 1126 1062 1026 1026
q8 9528 1068 1112 1068
q9 6201 4876 4897 4876
q10 7865 1972 1984 1972
q11 519 315 309 309
q12 792 416 409 409
q13 18048 2966 2884 2884
q14 316 289 295 289
q15 373 364 358 358
q16 533 498 508 498
q17 778 316 321 316
q18 5452 4832 4840 4832
q19 1181 413 427 413
q20 598 463 421 421
q21 6090 2864 2848 2848
q22 494 459 474 459
Total cold run time: 102866 ms
Total hot run time: 32066 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4669 4640 4637 4637
q2 305 228 231 228
q3 2218 1857 1905 1857
q4 1613 1308 1311 1308
q5 3240 2899 3018 2899
q6 162 97 111 97
q7 1839 1912 1853 1853
q8 1777 1665 1666 1665
q9 5379 5240 5207 5207
q10 2663 2277 2271 2271
q11 489 408 405 405
q12 745 641 632 632
q13 3053 2680 2723 2680
q14 277 287 278 278
q15 359 350 343 343
q16 512 482 484 482
q17 1149 824 827 824
q18 5792 5524 5301 5301
q19 1102 707 665 665
q20 1514 1418 1487 1418
q21 4796 4423 4359 4359
q22 651 619 615 615
Total cold run time: 44304 ms
Total hot run time: 40024 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] [test](ut) added testcases for show analyze statement [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1909486370
<details>
<summary>ClickBench: <b>Total hot run time: 30.3 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 131415fe1021cc1ef866f56cf0aa48a3d0d2b228, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.02 0.02
query3 0.22 0.04 0.05
query4 1.70 0.07 0.07
query5 0.53 0.52 0.52
query6 1.25 0.62 0.64
query7 0.02 0.01 0.02
query8 0.04 0.03 0.03
query9 0.55 0.51 0.50
query10 0.57 0.57 0.55
query11 0.12 0.09 0.09
query12 0.11 0.09 0.09
query13 0.61 0.62 0.60
query14 0.78 0.78 0.82
query15 0.80 0.77 0.77
query16 0.39 0.36 0.40
query17 1.04 1.03 0.99
query18 0.23 0.26 0.24
query19 1.83 1.78 1.82
query20 0.00 0.01 0.01
query21 15.41 0.57 0.58
query22 2.78 2.01 1.36
query23 17.52 0.86 0.82
query24 2.31 1.67 0.91
query25 0.42 0.18 0.28
query26 0.54 0.13 0.14
query27 0.06 0.05 0.05
query28 11.95 0.77 0.76
query29 12.51 3.16 3.16
query30 0.56 0.48 0.53
query31 2.77 0.34 0.35
query32 3.39 0.49 0.48
query33 3.23 3.26 3.22
query34 15.82 4.27 4.21
query35 4.34 4.21 4.26
query36 1.10 1.06 1.08
query37 0.06 0.05 0.05
query38 0.03 0.03 0.03
query39 0.03 0.01 0.02
query40 0.14 0.12 0.13
query41 0.07 0.02 0.02
query42 0.02 0.01 0.02
query43 0.02 0.02 0.03
Total cold run time: 105.96 s
Total hot run time: 30.3 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] [test](ut) added testcases for show analyze statement [doris]
Posted by "Nitin-Kashyap (via GitHub)" <gi...@apache.org>.
Nitin-Kashyap commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1899784337
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] [test](ut) added testcases for show analyze statement [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-2316464364
We're closing this PR because it hasn't been updated in a while.
This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable.
If you'd like to revive this PR, please reopen it and feel free a maintainer to remove the Stale tag!
--
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] [test](ut) added testcases for show analyze statement [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed pull request #28601: [test](ut) added testcases for show analyze statement
URL: https://github.com/apache/doris/pull/28601
--
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] [test](ut) added testcases for show analyze statement [doris]
Posted by "Nitin-Kashyap (via GitHub)" <gi...@apache.org>.
Nitin-Kashyap commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1877745901
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] [test](ut) added testcases for show analyze statement [doris]
Posted by "Nitin-Kashyap (via GitHub)" <gi...@apache.org>.
Nitin-Kashyap commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1972750981
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] [test](ut) added testcases for show analyze statement [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1909467692
<details>
<summary>TPC-H: <b>Total hot run time: 38561 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 131415fe1021cc1ef866f56cf0aa48a3d0d2b228, data reload: false
------ Round 1 ----------------------------------
q1 17695 5187 5069 5069
q2 2045 138 123 123
q3 10776 1164 1171 1164
q4 10337 764 807 764
q5 7739 3163 3120 3120
q6 206 120 121 120
q7 873 495 478 478
q8 9223 1934 1954 1934
q9 7262 6378 6313 6313
q10 8168 3055 3040 3040
q11 407 202 195 195
q12 355 188 187 187
q13 17987 3351 3370 3351
q14 244 207 220 207
q15 543 525 507 507
q16 419 366 382 366
q17 924 493 529 493
q18 7593 6963 6804 6804
q19 1535 1335 1389 1335
q20 612 294 294 294
q21 2732 2413 2400 2400
q22 348 297 298 297
Total cold run time: 108023 ms
Total hot run time: 38561 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5267 5045 5228 5045
q2 321 217 210 210
q3 3326 3242 3253 3242
q4 2063 2096 2088 2088
q5 6052 5907 5978 5907
q6 207 119 118 118
q7 2262 1862 1913 1862
q8 3229 3395 3416 3395
q9 8944 8903 8827 8827
q10 3965 3865 3887 3865
q11 558 446 452 446
q12 791 635 603 603
q13 17091 3247 3190 3190
q14 288 255 274 255
q15 562 512 509 509
q16 532 479 473 473
q17 1852 1845 1817 1817
q18 10194 20066 10099 10099
q19 25141 1680 1592 1592
q20 7056 2021 2040 2021
q21 14874 5559 5350 5350
q22 998 541 553 541
Total cold run time: 115573 ms
Total hot run time: 61455 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] [test](ut) added testcases for show analyze statement [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1888538393
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] [test](ut) added testcases for show analyze statement [doris]
Posted by "Nitin-Kashyap (via GitHub)" <gi...@apache.org>.
Nitin-Kashyap commented on code in PR #28601:
URL: https://github.com/apache/doris/pull/28601#discussion_r1458353882
##########
fe/fe-core/src/test/java/org/apache/doris/analysis/ShowAnalyzeStmtTest.java:
##########
@@ -0,0 +1,166 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.analysis;
+
+import org.apache.doris.analysis.LikePredicate.Operator;
+import org.apache.doris.catalog.ScalarType;
+import org.apache.doris.common.AnalysisException;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.ErrorReport;
+import org.apache.doris.common.UserException;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.SessionVariable;
+import org.apache.doris.qe.ShowResultSetMetaData;
+
+import mockit.Mock;
Review Comment:
fixed
--
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] [test](ut) added testcases for show analyze statement [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1899805923
<details>
<summary>TPC-H: <b>Total hot run time: 39207 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 d41b01bedd3d46f1f9fbb4e07d18a615e56973bb, data reload: false
------ Round 1 ----------------------------------
q1 19811 5373 5444 5373
q2 2388 145 139 139
q3 10636 1170 1122 1122
q4 10226 783 844 783
q5 7757 3168 3146 3146
q6 202 122 124 122
q7 862 503 489 489
q8 9230 1903 1963 1903
q9 7279 6394 6347 6347
q10 8205 3088 3084 3084
q11 425 223 218 218
q12 359 198 201 198
q13 17992 3391 3361 3361
q14 239 222 220 220
q15 538 510 502 502
q16 433 370 381 370
q17 955 535 544 535
q18 7501 6873 6970 6873
q19 1581 1298 1387 1298
q20 579 309 318 309
q21 2799 2508 2501 2501
q22 361 333 314 314
Total cold run time: 110358 ms
Total hot run time: 39207 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5355 5203 5339 5203
q2 330 224 215 215
q3 3349 3222 3185 3185
q4 2105 2036 2049 2036
q5 5931 6009 5960 5960
q6 195 119 132 119
q7 2349 1841 1928 1841
q8 3228 3396 3406 3396
q9 8995 8696 8930 8696
q10 3911 3856 3840 3840
q11 570 453 450 450
q12 793 651 644 644
q13 16914 3160 3134 3134
q14 280 258 275 258
q15 547 502 500 500
q16 508 481 475 475
q17 1910 1854 1833 1833
q18 9742 19841 9461 9461
q19 23766 1619 1537 1537
q20 4631 1942 1908 1908
q21 14507 5470 5292 5292
q22 969 533 536 533
Total cold run time: 110885 ms
Total hot run time: 60516 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] [test](ut) added testcases for show analyze statement [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1899813479
<details>
<summary>TPC-DS: <b>Total hot run time: 176553 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 d41b01bedd3d46f1f9fbb4e07d18a615e56973bb, data reload: false
query1 942 336 326 326
query2 6561 2158 1968 1968
query3 6742 204 205 204
query4 33836 22117 22166 22117
query5 6875 544 541 541
query6 254 167 154 154
query7 4604 269 259 259
query8 225 179 176 176
query9 8359 2537 2522 2522
query10 409 226 250 226
query11 16678 15509 15478 15478
query12 123 68 64 64
query13 1708 371 391 371
query14 10486 6992 6983 6983
query15 212 183 184 183
query16 4599 229 224 224
query17 1004 463 469 463
query18 1789 256 260 256
query19 175 132 146 132
query20 70 74 72 72
query21 182 138 137 137
query22 4844 4767 4503 4503
query23 31706 30947 30906 30906
query24 12759 2778 2794 2778
query25 563 308 313 308
query26 1828 145 146 145
query27 3527 269 269 269
query28 7225 1820 1813 1813
query29 2135 616 625 616
query30 283 136 139 136
query31 918 736 717 717
query32 78 50 50 50
query33 715 217 220 217
query34 1271 449 449 449
query35 880 753 720 720
query36 1429 1234 1274 1234
query37 171 60 58 58
query38 3343 3248 3243 3243
query39 1328 1268 1269 1268
query40 347 84 85 84
query41 40 36 35 35
query42 97 85 83 83
query43 546 473 512 473
query44 1119 689 682 682
query45 196 174 175 174
query46 1065 657 666 657
query47 1640 1547 1551 1547
query48 397 318 311 311
query49 1216 292 292 292
query50 681 312 318 312
query51 5297 5181 5179 5179
query52 93 74 79 74
query53 315 254 255 254
query54 463 303 283 283
query55 82 73 78 73
query56 183 167 164 164
query57 975 919 939 919
query58 192 176 164 164
query59 2982 2816 2699 2699
query60 221 189 187 187
query61 81 81 79 79
query62 633 369 355 355
query63 288 255 279 255
query64 6136 1763 1760 1760
query65 3340 3243 3247 3243
query66 1429 323 301 301
query67 15592 14983 15258 14983
query68 10614 537 531 531
query69 598 311 300 300
query70 1703 1510 1476 1476
query71 529 217 210 210
query72 4680 2824 2826 2824
query73 2106 322 313 313
query74 7040 6391 6444 6391
query75 4733 2355 2332 2332
query76 6631 1082 1044 1044
query77 640 230 243 230
query78 9073 8872 8475 8475
query79 5881 492 512 492
query80 729 320 327 320
query81 446 208 199 199
query82 250 81 79 79
query83 143 117 122 117
query84 277 68 76 68
query85 1065 325 323 323
query86 389 388 373 373
query87 3509 3323 3272 3272
query88 4036 2201 2198 2198
query89 435 356 349 349
query90 1997 193 188 188
query91 155 120 127 120
query92 53 43 45 43
query93 4537 454 431 431
query94 1200 162 159 159
query95 502 471 457 457
query96 630 319 325 319
query97 4252 4129 4121 4121
query98 204 189 180 180
query99 1069 711 721 711
Total cold run time: 306588 ms
Total hot run time: 176553 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] [test](ut) added testcases for show analyze statement [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1899817259
<details>
<summary>ClickBench: <b>Total hot run time: 30.26 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 d41b01bedd3d46f1f9fbb4e07d18a615e56973bb, data reload: false
query1 0.03 0.02 0.02
query2 0.06 0.02 0.03
query3 0.23 0.05 0.05
query4 1.71 0.06 0.07
query5 0.53 0.52 0.52
query6 1.31 0.64 0.65
query7 0.01 0.02 0.01
query8 0.05 0.03 0.03
query9 0.55 0.51 0.51
query10 0.55 0.55 0.56
query11 0.11 0.09 0.08
query12 0.11 0.10 0.09
query13 0.61 0.60 0.60
query14 0.77 0.81 0.80
query15 0.78 0.78 0.78
query16 0.36 0.36 0.38
query17 1.00 1.01 1.02
query18 0.23 0.25 0.25
query19 1.79 1.76 1.79
query20 0.01 0.02 0.02
query21 15.42 0.58 0.58
query22 2.73 2.68 1.65
query23 17.43 0.80 0.71
query24 2.55 1.23 0.46
query25 0.42 0.23 0.18
query26 0.45 0.13 0.14
query27 0.05 0.05 0.05
query28 11.53 0.77 0.74
query29 12.51 3.22 3.26
query30 0.57 0.62 0.50
query31 2.78 0.33 0.34
query32 3.39 0.49 0.49
query33 3.20 3.21 3.22
query34 15.79 4.31 4.25
query35 4.30 4.36 4.27
query36 1.13 1.07 1.07
query37 0.07 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.02 0.01
query40 0.16 0.13 0.13
query41 0.06 0.01 0.02
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 105.45 s
Total hot run time: 30.26 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] [test](ut) added testcases for show analyze statement [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1899819530
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit d41b01bedd3d46f1f9fbb4e07d18a615e56973bb with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 14.9 seconds inserted 10000000 Rows, about 671K 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] [test](ut) added testcases for show analyze statement [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1972823534
<details>
<summary>TPC-DS: <b>Total hot run time: 187998 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 a8a282fe663159e391768c305a5820bd0bb9b187, data reload: false
query1 1049 400 398 398
query2 7960 2386 2435 2386
query3 6737 298 296 296
query4 22697 22852 23174 22852
query5 5707 836 786 786
query6 375 274 313 274
query7 5069 447 434 434
query8 301 242 248 242
query9 8747 3435 3376 3376
query10 578 339 352 339
query11 18327 18485 18975 18485
query12 344 294 170 170
query13 1670 661 655 655
query14 11689 8278 7516 7516
query15 325 245 250 245
query16 8329 434 393 393
query17 2091 700 701 700
query18 2199 393 401 393
query19 492 250 240 240
query20 136 128 131 128
query21 236 166 162 162
query22 5311 5165 4931 4931
query23 24469 24351 24391 24351
query24 6807 2072 2106 2072
query25 601 514 520 514
query26 792 231 232 231
query27 2344 490 514 490
query28 3269 2835 2821 2821
query29 939 748 763 748
query30 336 202 194 194
query31 1395 833 846 833
query32 136 95 94 94
query33 636 378 381 378
query34 882 683 686 683
query35 981 896 914 896
query36 1269 1142 1168 1142
query37 138 104 111 104
query38 3230 2994 3121 2994
query39 1144 1129 1088 1088
query40 255 168 166 166
query41 85 87 83 83
query42 153 165 225 165
query43 598 594 573 573
query44 1268 1061 1068 1061
query45 220 219 212 212
query46 899 800 793 793
query47 1709 1681 1718 1681
query48 606 534 529 529
query49 761 525 472 472
query50 652 545 552 545
query51 9831 9979 9850 9850
query52 155 148 150 148
query53 339 336 335 335
query54 387 364 360 360
query55 168 128 125 125
query56 341 349 367 349
query57 1105 1054 1040 1040
query58 339 341 325 325
query59 3558 3389 3396 3389
query60 491 465 377 377
query61 168 166 167 166
query62 491 412 421 412
query63 327 324 334 324
query64 4217 1856 1875 1856
query65 2384 2348 2370 2348
query66 881 391 385 385
query67 15356 14991 15455 14991
query68 4169 728 715 715
query69 654 541 571 541
query70 1598 1597 1626 1597
query71 464 422 413 413
query72 2822 2434 2415 2415
query73 667 473 482 473
query74 7047 7040 7326 7040
query75 3054 2780 2755 2755
query76 2033 645 656 645
query77 505 405 409 405
query78 6802 6535 6482 6482
query79 1083 766 753 753
query80 635 611 582 582
query81 491 249 252 249
query82 169 136 136 136
query83 242 242 239 239
query84 273 129 126 126
query85 856 531 524 524
query86 440 406 459 406
query87 3416 3133 3145 3133
query88 3706 3450 3474 3450
query89 436 428 415 415
query90 904 220 219 219
query91 208 204 205 204
query92 85 83 80 80
query93 1049 720 699 699
query94 471 280 272 272
query95 589 521 587 521
query96 639 387 386 386
query97 3043 2954 2949 2949
query98 306 328 327 327
query99 861 774 753 753
Total cold run time: 257198 ms
Total hot run time: 187998 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] [test](ut) added testcases for show analyze statement [doris]
Posted by "Nitin-Kashyap (via GitHub)" <gi...@apache.org>.
Nitin-Kashyap commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1909441776
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] [test](ut) added testcases for show analyze statement [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28601:
URL: https://github.com/apache/doris/pull/28601#issuecomment-1909480766
<details>
<summary>TPC-DS: <b>Total hot run time: 186783 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 131415fe1021cc1ef866f56cf0aa48a3d0d2b228, data reload: false
query1 957 334 324 324
query2 6558 1968 1905 1905
query3 6714 205 201 201
query4 31779 22131 22185 22131
query5 4446 371 376 371
query6 251 152 151 151
query7 4598 267 253 253
query8 231 180 181 180
query9 8356 2608 2616 2608
query10 416 231 233 231
query11 17214 15677 15408 15408
query12 120 71 67 67
query13 1678 380 383 380
query14 10517 6954 7022 6954
query15 211 180 181 180
query16 5793 263 253 253
query17 947 466 478 466
query18 1795 251 258 251
query19 166 129 128 128
query20 70 70 67 67
query21 193 129 126 126
query22 4918 4737 4693 4693
query23 31826 31003 30977 30977
query24 11785 2846 2856 2846
query25 573 307 303 303
query26 1404 141 141 141
query27 3201 290 285 285
query28 7266 1837 1825 1825
query29 1235 631 623 623
query30 277 137 140 137
query31 934 736 760 736
query32 71 57 50 50
query33 693 212 212 212
query34 1149 464 476 464
query35 903 804 760 760
query36 1327 1210 1220 1210
query37 96 55 59 55
query38 3368 3242 3219 3219
query39 1309 1259 1265 1259
query40 201 88 84 84
query41 36 34 34 34
query42 91 77 79 77
query43 500 473 466 466
query44 1077 683 702 683
query45 194 181 177 177
query46 1065 651 659 651
query47 1576 1576 1517 1517
query48 375 306 312 306
query49 1138 297 279 279
query50 683 321 321 321
query51 5271 5166 5203 5166
query52 81 85 73 73
query53 323 252 260 252
query54 242 184 194 184
query55 85 74 76 74
query56 174 158 166 158
query57 996 920 921 920
query58 183 155 164 155
query59 2910 2556 2691 2556
query60 211 178 178 178
query61 85 87 84 84
query62 587 369 374 369
query63 273 253 257 253
query64 4982 1820 1803 1803
query65 3373 3269 3243 3243
query66 1186 319 303 303
query67 15657 15036 15412 15036
query68 10724 526 510 510
query69 610 294 294 294
query70 1696 1560 1496 1496
query71 10483 10200 10207 10200
query72 4872 2841 2837 2837
query73 2126 326 313 313
query74 7040 6494 6425 6425
query75 4786 2300 2279 2279
query76 6758 1038 1008 1008
query77 664 225 230 225
query78 9233 8924 8820 8820
query79 1004 493 504 493
query80 554 324 312 312
query81 471 200 198 198
query82 201 79 79 79
query83 143 118 115 115
query84 274 67 66 66
query85 1061 334 342 334
query86 379 410 376 376
query87 3478 3364 3326 3326
query88 2730 2204 2192 2192
query89 460 365 359 359
query90 1991 189 189 189
query91 158 119 133 119
query92 56 45 45 45
query93 1001 432 418 418
query94 1236 156 156 156
query95 495 461 441 441
query96 602 325 321 321
query97 4325 4169 4145 4145
query98 215 189 179 179
query99 1005 709 681 681
Total cold run time: 299731 ms
Total hot run time: 186783 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