You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Yukang-Lian (via GitHub)" <gi...@apache.org> on 2024/01/29 09:50:58 UTC
[PR] [Feature](auto-inc) Add start value for auto increment column [doris]
Yukang-Lian opened a new pull request, #30512:
URL: https://github.com/apache/doris/pull/30512
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
```mysql
CREATE TABLE IF NOT EXISTS `test` (
`id` BIGINT NOT NULL AUTO_INCREMENT(100),
`value` int NOT NULL
) ENGINE=OLAP
DUPLICATE KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);
insert into test values(null,1);
select * from test;
+------+-------+
| id | value |
+------+-------+
| 100 | 1 |
+------+-------+
insert into test (value) values(2);
select * from test;
+------+-------+
| id | value |
+------+-------+
| 100 | 1 |
| 101 | 2 |
+------+-------+
```
## 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923299118
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923355177
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 3b9eb9c54bf55f3b612ababa8240df18e47a6d8a with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 14.2 seconds inserted 10000000 Rows, about 704K 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1920653149
<details>
<summary>TPC-DS: <b>Total hot run time: 175528 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 2d1bd12cee0b7fe23d405babc9f0d7a87c9978d4, data reload: false
query1 924 333 331 331
query2 6563 1935 1941 1935
query3 6718 203 196 196
query4 31754 22149 22160 22149
query5 4450 396 424 396
query6 244 157 163 157
query7 4615 264 261 261
query8 249 174 173 173
query9 9014 2274 2273 2273
query10 413 200 195 195
query11 18659 15393 15406 15393
query12 124 68 66 66
query13 1624 386 366 366
query14 9526 7240 7435 7240
query15 218 178 182 178
query16 7307 265 246 246
query17 1848 485 453 453
query18 1921 257 256 256
query19 180 131 135 131
query20 71 71 74 71
query21 205 133 126 126
query22 4982 4807 4753 4753
query23 31786 30198 30332 30198
query24 11740 2765 2799 2765
query25 530 307 300 300
query26 1528 136 138 136
query27 2441 278 279 278
query28 6965 1848 1846 1846
query29 1514 626 626 626
query30 288 133 142 133
query31 914 731 710 710
query32 95 54 50 50
query33 706 213 212 212
query34 1083 445 461 445
query35 847 775 727 727
query36 1335 1202 1210 1202
query37 176 60 56 56
query38 3305 3164 3183 3164
query39 1316 1265 1242 1242
query40 334 83 85 83
query41 37 35 34 34
query42 87 79 79 79
query43 524 472 470 470
query44 1086 701 714 701
query45 196 176 171 171
query46 1048 623 628 623
query47 1551 1441 1523 1441
query48 407 306 298 298
query49 1239 277 270 270
query50 704 303 304 303
query51 5258 5131 5177 5131
query52 97 76 80 76
query53 333 257 251 251
query54 269 189 174 174
query55 81 86 77 77
query56 180 158 166 158
query57 977 909 940 909
query58 181 157 156 156
query59 2443 2480 2360 2360
query60 201 172 169 169
query61 83 83 84 83
query62 617 371 367 367
query63 279 264 257 257
query64 6375 3665 3434 3434
query65 3262 3230 3224 3224
query66 1405 314 307 307
query67 14604 14267 14243 14243
query68 4301 489 494 489
query69 425 308 312 308
query70 1615 1549 1518 1518
query71 290 211 205 205
query72 5446 3097 2850 2850
query73 678 320 318 318
query74 6661 6390 6273 6273
query75 2948 2261 2308 2261
query76 2532 930 1003 930
query77 448 242 226 226
query78 9079 8742 8540 8540
query79 2830 485 486 485
query80 2228 318 316 316
query81 533 194 197 194
query82 812 80 79 79
query83 252 114 123 114
query84 297 72 75 72
query85 2554 320 318 318
query86 502 394 366 366
query87 3484 3260 3294 3260
query88 3954 2183 2181 2181
query89 425 353 356 353
query90 2092 180 174 174
query91 157 118 119 118
query92 64 45 42 42
query93 3561 425 451 425
query94 1494 156 159 156
query95 495 456 447 447
query96 614 313 310 310
query97 4243 4109 4147 4109
query98 207 185 190 185
query99 1087 724 622 622
Total cold run time: 288344 ms
Total hot run time: 175528 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1919084061
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit ccf08aa2d8a6d00d9ef699448d7046e8fd6d4613 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: 13.5 seconds inserted 10000000 Rows, about 740K 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1920640530
<details>
<summary>TPC-H: <b>Total hot run time: 37121 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 2d1bd12cee0b7fe23d405babc9f0d7a87c9978d4, data reload: false
------ Round 1 ----------------------------------
q1 17664 4638 4489 4489
q2 2051 150 136 136
q3 10585 907 916 907
q4 4659 740 717 717
q5 7686 2888 2887 2887
q6 182 120 118 118
q7 1088 716 703 703
q8 9312 2047 1981 1981
q9 7251 6363 6335 6335
q10 8091 2454 2433 2433
q11 416 204 194 194
q12 765 290 276 276
q13 18005 3298 3305 3298
q14 266 261 233 233
q15 544 492 490 490
q16 466 406 406 406
q17 928 521 600 521
q18 6681 6116 5921 5921
q19 1541 1372 1474 1372
q20 617 345 345 345
q21 6620 3163 3065 3065
q22 814 303 294 294
Total cold run time: 106232 ms
Total hot run time: 37121 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4524 4451 4387 4387
q2 335 231 235 231
q3 2996 2885 2786 2786
q4 1827 1651 1635 1635
q5 5158 5243 5238 5238
q6 191 114 114 114
q7 2120 1774 1821 1774
q8 3101 3236 3262 3236
q9 8285 8309 8283 8283
q10 6003 3593 3553 3553
q11 540 451 453 451
q12 756 585 578 578
q13 5333 3167 3089 3089
q14 281 264 258 258
q15 535 502 485 485
q16 516 477 467 467
q17 1864 1641 1724 1641
q18 8038 7690 7500 7500
q19 6792 1513 1479 1479
q20 2148 1918 1933 1918
q21 4665 4611 4481 4481
q22 554 420 448 420
Total cold run time: 66562 ms
Total hot run time: 54004 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921780300
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 9316f73a1214b877fc77344f55a645f67dd91115 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.5 seconds inserted 10000000 Rows, about 740K 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1922749283
<details>
<summary>ClickBench: <b>Total hot run time: 31.19 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 793a212fa8a635eee498c86883d0890f4e70f6c2, data reload: false
query1 0.04 0.03 0.03
query2 0.05 0.02 0.02
query3 0.23 0.06 0.06
query4 1.68 0.10 0.09
query5 0.52 0.51 0.52
query6 1.23 0.64 0.64
query7 0.02 0.01 0.01
query8 0.03 0.03 0.03
query9 0.55 0.50 0.50
query10 0.55 0.56 0.56
query11 0.12 0.08 0.08
query12 0.11 0.09 0.10
query13 0.61 0.61 0.61
query14 0.77 0.81 0.80
query15 0.78 0.76 0.76
query16 0.39 0.38 0.36
query17 1.01 1.01 1.01
query18 0.21 0.29 0.25
query19 1.82 1.78 1.79
query20 0.01 0.01 0.01
query21 15.40 0.59 0.59
query22 2.69 2.18 2.30
query23 17.16 0.78 0.91
query24 2.80 1.16 0.93
query25 0.47 0.09 0.18
query26 0.51 0.13 0.14
query27 0.05 0.04 0.05
query28 11.66 0.85 0.85
query29 12.60 3.15 3.02
query30 0.57 0.55 0.57
query31 2.79 0.34 0.35
query32 3.35 0.48 0.47
query33 3.23 3.22 3.26
query34 15.77 4.32 4.23
query35 4.30 4.26 4.28
query36 1.08 1.07 1.06
query37 0.07 0.05 0.05
query38 0.05 0.02 0.02
query39 0.02 0.01 0.02
query40 0.16 0.13 0.13
query41 0.07 0.01 0.01
query42 0.03 0.01 0.01
query43 0.02 0.02 0.02
Total cold run time: 105.58 s
Total hot run time: 31.19 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923658101
<details>
<summary>ClickBench: <b>Total hot run time: 30.86 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 34a20c4235ed28cfb9d68d137d0f078d6b00ee7f, data reload: false
query1 0.03 0.04 0.03
query2 0.06 0.02 0.02
query3 0.23 0.06 0.06
query4 1.69 0.10 0.10
query5 0.53 0.52 0.52
query6 1.21 0.64 0.65
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.54 0.48 0.50
query10 0.55 0.53 0.57
query11 0.12 0.08 0.09
query12 0.11 0.09 0.09
query13 0.61 0.60 0.60
query14 0.78 0.81 0.81
query15 0.81 0.80 0.78
query16 0.37 0.39 0.39
query17 1.04 1.00 1.04
query18 0.24 0.28 0.23
query19 1.89 1.67 1.77
query20 0.01 0.01 0.01
query21 15.40 0.58 0.58
query22 2.35 2.20 1.61
query23 17.31 0.93 0.84
query24 2.37 1.17 1.07
query25 0.28 0.18 0.07
query26 0.64 0.14 0.14
query27 0.04 0.06 0.05
query28 11.60 0.85 0.82
query29 12.57 3.26 3.24
query30 0.66 0.55 0.55
query31 2.81 0.34 0.34
query32 3.37 0.48 0.49
query33 3.23 3.18 3.22
query34 15.79 4.29 4.26
query35 4.33 4.30 4.26
query36 1.10 1.05 1.06
query37 0.06 0.04 0.05
query38 0.03 0.03 0.03
query39 0.02 0.02 0.01
query40 0.16 0.13 0.13
query41 0.07 0.01 0.02
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 105.12 s
Total hot run time: 30.86 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1922751737
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 793a212fa8a635eee498c86883d0890f4e70f6c2 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: 13.5 seconds inserted 10000000 Rows, about 740K 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923250000
run external
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923638047
TeamCity be ut coverage result:
Function Coverage: 36.18% (8631/23856)
Line Coverage: 28.23% (70562/249935)
Region Coverage: 27.25% (36417/133658)
Branch Coverage: 24.03% (18647/77614)
Coverage Report: http://coverage.selectdb-in.cc/coverage/34a20c4235ed28cfb9d68d137d0f078d6b00ee7f_34a20c4235ed28cfb9d68d137d0f078d6b00ee7f/report/index.html
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921323507
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921511819
TeamCity be ut coverage result:
Function Coverage: 36.18% (8627/23847)
Line Coverage: 28.24% (70523/249740)
Region Coverage: 27.24% (36389/133603)
Branch Coverage: 24.02% (18636/77574)
Coverage Report: http://coverage.selectdb-in.cc/coverage/3eb3d722773e1339f1ed8af550dd52f8b45deeeb_3eb3d722773e1339f1ed8af550dd52f8b45deeeb/report/index.html
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1920610097
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921676009
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923597341
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923523878
run external
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #30512:
URL: https://github.com/apache/doris/pull/30512
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923375783
TeamCity be ut coverage result:
Function Coverage: 36.15% (8625/23856)
Line Coverage: 28.21% (70504/249923)
Region Coverage: 27.22% (36378/133641)
Branch Coverage: 24.01% (18632/77596)
Coverage Report: http://coverage.selectdb-in.cc/coverage/3b9eb9c54bf55f3b612ababa8240df18e47a6d8a_3b9eb9c54bf55f3b612ababa8240df18e47a6d8a/report/index.html
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1925563658
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "zhannngchen (via GitHub)" <gi...@apache.org>.
zhannngchen commented on code in PR #30512:
URL: https://github.com/apache/doris/pull/30512#discussion_r1473745523
##########
fe/fe-core/src/main/java/org/apache/doris/analysis/ColumnDef.java:
##########
@@ -178,77 +178,79 @@ public String getValue() {
private boolean isKey;
private boolean isAllowNull;
private boolean isAutoInc;
+ private long autoIncInitValue;
private DefaultValue defaultValue;
private String comment;
private boolean visible;
private int clusterKeyId = -1;
public ColumnDef(String name, TypeDef typeDef) {
- this(name, typeDef, false, null, false, false, DefaultValue.NOT_SET, "");
+ this(name, typeDef, false, null, false, -1, DefaultValue.NOT_SET, "");
}
public ColumnDef(String name, TypeDef typeDef, boolean isKey, AggregateType aggregateType,
- boolean isAllowNull, boolean isAutoInc, DefaultValue defaultValue, String comment) {
- this(name, typeDef, isKey, aggregateType, isAllowNull, isAutoInc, defaultValue, comment, true);
+ boolean isAllowNull, long autoIncInitValue, DefaultValue defaultValue, String comment) {
+ this(name, typeDef, isKey, aggregateType, isAllowNull, autoIncInitValue, defaultValue, comment, true);
}
public ColumnDef(String name, TypeDef typeDef, boolean isAllowNull) {
this(name, typeDef, false, null, isAllowNull, DefaultValue.NOT_SET, "");
}
public ColumnDef(String name, TypeDef typeDef, boolean isKey, AggregateType aggregateType,
- boolean isAllowNull, DefaultValue defaultValue, String comment) {
- this(name, typeDef, isKey, aggregateType, isAllowNull, false, defaultValue, comment, true);
+ boolean isAllowNull, DefaultValue defaultValue, String comment) {
+ this(name, typeDef, isKey, aggregateType, isAllowNull, -1, defaultValue, comment, true);
}
public ColumnDef(String name, TypeDef typeDef, boolean isKey, AggregateType aggregateType,
- boolean isAllowNull, boolean isAutoInc, DefaultValue defaultValue, String comment, boolean visible) {
+ boolean isAllowNull, long autoIncInitValue, DefaultValue defaultValue, String comment, boolean visible) {
this.name = name;
this.typeDef = typeDef;
this.isKey = isKey;
this.aggregateType = aggregateType;
this.isAllowNull = isAllowNull;
- this.isAutoInc = isAutoInc;
+ this.isAutoInc = autoIncInitValue != 0;
Review Comment:
should be > 0 ?
##########
fe/fe-core/src/main/java/org/apache/doris/analysis/ColumnDef.java:
##########
@@ -560,6 +562,11 @@ public String toSql() {
if (isAutoInc) {
sb.append("AUTO_INCREMENT ");
+ if (autoIncInitValue != 0) {
Review Comment:
ditto
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1920513728
<details>
<summary>TPC-DS: <b>Total hot run time: 174615 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 cb2278c0bae1171771a984489c0770a2c453e736, data reload: false
query1 956 331 330 330
query2 6552 1980 1880 1880
query3 6712 200 197 197
query4 31668 22175 22179 22175
query5 4447 411 403 403
query6 242 155 143 143
query7 4595 258 261 258
query8 240 164 170 164
query9 9094 2314 2287 2287
query10 411 193 196 193
query11 18968 15440 15244 15244
query12 124 66 67 66
query13 1619 378 371 371
query14 9892 7340 7200 7200
query15 219 175 182 175
query16 7041 261 267 261
query17 1863 511 475 475
query18 1788 256 249 249
query19 179 132 129 129
query20 72 69 67 67
query21 208 127 135 127
query22 4866 4668 4550 4550
query23 31224 30445 30173 30173
query24 11969 2752 2727 2727
query25 548 303 301 301
query26 1509 140 143 140
query27 2618 285 281 281
query28 7139 1886 1878 1878
query29 1617 615 600 600
query30 288 131 135 131
query31 930 707 718 707
query32 87 52 50 50
query33 724 203 204 203
query34 1230 449 453 449
query35 869 740 763 740
query36 1233 1238 1170 1170
query37 180 57 56 56
query38 3291 3196 3139 3139
query39 1293 1257 1252 1252
query40 328 88 80 80
query41 36 39 34 34
query42 85 79 89 79
query43 492 466 480 466
query44 1061 701 707 701
query45 197 189 177 177
query46 1057 628 629 628
query47 1582 1519 1454 1454
query48 382 312 295 295
query49 1237 285 272 272
query50 686 307 311 307
query51 5274 5177 5175 5175
query52 99 75 74 74
query53 318 262 259 259
query54 297 174 178 174
query55 76 81 75 75
query56 183 164 167 164
query57 1007 935 915 915
query58 192 150 147 147
query59 2395 2378 2263 2263
query60 196 181 177 177
query61 85 86 83 83
query62 651 355 340 340
query63 280 269 256 256
query64 6460 3658 3480 3480
query65 3267 3231 3240 3231
query66 1409 311 305 305
query67 14681 14228 14099 14099
query68 3885 509 495 495
query69 429 311 296 296
query70 1513 1374 1374 1374
query71 286 208 208 208
query72 5252 3097 2821 2821
query73 690 314 315 314
query74 6580 6320 6196 6196
query75 2964 2315 2263 2263
query76 2548 918 914 914
query77 342 233 222 222
query78 9157 8841 8552 8552
query79 2594 498 492 492
query80 2218 321 312 312
query81 533 199 194 194
query82 753 80 83 80
query83 246 116 116 116
query84 307 84 74 74
query85 2536 332 328 328
query86 521 360 379 360
query87 3485 3218 3313 3218
query88 3819 2181 2157 2157
query89 420 351 350 350
query90 2080 180 177 177
query91 152 138 120 120
query92 56 43 39 39
query93 2678 460 423 423
query94 1470 164 162 162
query95 503 446 455 446
query96 636 317 313 313
query97 4263 4100 4092 4092
query98 217 186 188 186
query99 1166 693 670 670
Total cold run time: 286817 ms
Total hot run time: 174615 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921774925
<details>
<summary>ClickBench: <b>Total hot run time: 30.98 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 9316f73a1214b877fc77344f55a645f67dd91115, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.02 0.03
query3 0.23 0.06 0.06
query4 1.68 0.10 0.10
query5 0.53 0.52 0.52
query6 1.22 0.65 0.65
query7 0.02 0.02 0.01
query8 0.04 0.03 0.02
query9 0.55 0.50 0.50
query10 0.55 0.55 0.55
query11 0.12 0.09 0.08
query12 0.11 0.09 0.09
query13 0.60 0.60 0.60
query14 0.79 0.78 0.81
query15 0.79 0.78 0.76
query16 0.37 0.38 0.38
query17 1.03 1.04 1.05
query18 0.22 0.28 0.23
query19 1.84 1.78 1.80
query20 0.01 0.01 0.01
query21 15.40 0.57 0.57
query22 2.65 2.52 2.00
query23 17.44 0.85 0.80
query24 2.36 0.72 0.91
query25 0.27 0.24 0.15
query26 0.44 0.14 0.14
query27 0.05 0.05 0.05
query28 11.65 0.84 0.83
query29 12.55 3.13 3.21
query30 0.63 0.53 0.52
query31 2.81 0.35 0.34
query32 3.36 0.50 0.48
query33 3.21 3.22 3.24
query34 15.78 4.24 4.34
query35 4.31 4.28 4.29
query36 1.10 1.05 1.06
query37 0.06 0.05 0.05
query38 0.04 0.03 0.02
query39 0.02 0.01 0.02
query40 0.15 0.13 0.13
query41 0.07 0.02 0.01
query42 0.02 0.02 0.01
query43 0.02 0.02 0.02
Total cold run time: 105.19 s
Total hot run time: 30.98 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921341900
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921770770
TeamCity be ut coverage result:
Function Coverage: 36.18% (8627/23847)
Line Coverage: 28.24% (70524/249755)
Region Coverage: 27.24% (36397/133624)
Branch Coverage: 24.02% (18639/77584)
Coverage Report: http://coverage.selectdb-in.cc/coverage/9316f73a1214b877fc77344f55a645f67dd91115_9316f73a1214b877fc77344f55a645f67dd91115/report/index.html
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923650530
<details>
<summary>TPC-DS: <b>Total hot run time: 181062 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 34a20c4235ed28cfb9d68d137d0f078d6b00ee7f, data reload: false
query1 921 343 341 341
query2 6551 1923 1984 1923
query3 6702 205 209 205
query4 31846 22007 22050 22007
query5 4268 359 353 353
query6 252 162 165 162
query7 4603 290 277 277
query8 247 171 204 171
query9 9120 2329 2324 2324
query10 411 220 211 211
query11 18091 15506 15581 15506
query12 131 76 73 73
query13 1620 418 418 418
query14 9588 6802 6607 6607
query15 236 174 174 174
query16 8079 261 240 240
query17 1828 525 501 501
query18 2114 270 259 259
query19 355 140 137 137
query20 83 80 87 80
query21 204 133 116 116
query22 5161 4539 4706 4539
query23 30829 30171 30036 30036
query24 10071 2773 2743 2743
query25 541 344 334 334
query26 706 151 150 150
query27 2157 298 306 298
query28 5903 1897 1877 1877
query29 867 620 602 602
query30 283 130 140 130
query31 895 717 716 716
query32 89 59 50 50
query33 627 219 220 219
query34 846 462 454 454
query35 882 763 758 758
query36 1042 918 903 903
query37 95 54 58 54
query38 3193 3167 3096 3096
query39 1286 1258 1238 1238
query40 178 94 90 90
query41 37 35 34 34
query42 97 95 89 89
query43 505 481 486 481
query44 1009 693 700 693
query45 191 180 173 173
query46 1048 643 657 643
query47 1600 1474 1490 1474
query48 421 348 356 348
query49 1080 285 281 281
query50 778 370 377 370
query51 5247 5088 5188 5088
query52 104 85 86 85
query53 334 273 265 265
query54 282 210 212 210
query55 82 70 76 70
query56 215 192 193 192
query57 979 901 916 901
query58 206 182 183 182
query59 2418 2231 2152 2152
query60 261 213 202 202
query61 80 79 80 79
query62 626 343 344 343
query63 299 280 278 278
query64 4884 3758 3483 3483
query65 3256 3232 3196 3196
query66 806 305 322 305
query67 14582 13839 13875 13839
query68 3962 517 525 517
query69 446 330 332 330
query70 1182 1195 1247 1195
query71 317 240 240 240
query72 6011 2830 2657 2657
query73 708 311 317 311
query74 6581 6252 6148 6148
query75 3065 2368 2349 2349
query76 2565 871 999 871
query77 359 228 228 228
query78 9096 8823 8528 8528
query79 4683 500 492 492
query80 1829 349 345 345
query81 530 199 193 193
query82 1357 82 86 82
query83 290 122 126 122
query84 292 82 84 82
query85 1811 331 325 325
query86 493 306 324 306
query87 3370 3225 3211 3211
query88 4593 2321 2346 2321
query89 459 372 371 371
query90 2030 170 165 165
query91 151 145 124 124
query92 57 43 41 41
query93 5515 507 492 492
query94 1231 177 175 175
query95 7966 7819 7783 7783
query96 598 268 274 268
query97 4219 4096 4130 4096
query98 234 204 192 192
query99 1154 674 676 674
Total cold run time: 291482 ms
Total hot run time: 181062 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923285823
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1919023941
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1919079351
<details>
<summary>ClickBench: <b>Total hot run time: 30.81 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 ccf08aa2d8a6d00d9ef699448d7046e8fd6d4613, data reload: false
query1 0.04 0.03 0.03
query2 0.05 0.02 0.02
query3 0.22 0.06 0.06
query4 1.68 0.10 0.10
query5 0.52 0.52 0.53
query6 1.24 0.63 0.72
query7 0.02 0.01 0.02
query8 0.03 0.02 0.02
query9 0.54 0.49 0.48
query10 0.55 0.54 0.55
query11 0.11 0.08 0.08
query12 0.10 0.09 0.10
query13 0.59 0.61 0.61
query14 0.78 0.79 0.80
query15 0.80 0.78 0.76
query16 0.39 0.39 0.38
query17 1.05 1.02 0.99
query18 0.23 0.25 0.26
query19 1.77 1.78 1.70
query20 0.02 0.01 0.01
query21 15.41 0.58 0.60
query22 2.33 2.32 1.87
query23 17.23 0.84 0.77
query24 2.51 1.23 0.83
query25 0.37 0.19 0.13
query26 0.55 0.14 0.14
query27 0.05 0.04 0.05
query28 11.35 0.85 0.83
query29 12.52 3.14 3.11
query30 0.61 0.54 0.52
query31 2.79 0.34 0.36
query32 3.37 0.49 0.49
query33 3.21 3.23 3.23
query34 15.70 4.34 4.41
query35 4.28 4.30 4.21
query36 1.11 1.05 1.06
query37 0.07 0.05 0.05
query38 0.03 0.02 0.03
query39 0.02 0.02 0.02
query40 0.16 0.13 0.12
query41 0.07 0.02 0.02
query42 0.02 0.01 0.01
query43 0.03 0.02 0.02
Total cold run time: 104.52 s
Total hot run time: 30.81 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1920660302
<details>
<summary>ClickBench: <b>Total hot run time: 31.1 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 2d1bd12cee0b7fe23d405babc9f0d7a87c9978d4, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.03 0.02
query3 0.23 0.06 0.06
query4 1.68 0.10 0.09
query5 0.52 0.50 0.52
query6 1.20 0.64 0.65
query7 0.02 0.02 0.01
query8 0.03 0.02 0.03
query9 0.56 0.49 0.50
query10 0.57 0.55 0.54
query11 0.11 0.09 0.08
query12 0.11 0.09 0.09
query13 0.62 0.60 0.61
query14 0.77 0.81 0.80
query15 0.80 0.80 0.77
query16 0.36 0.39 0.37
query17 1.03 1.00 1.03
query18 0.22 0.28 0.23
query19 1.82 1.74 1.71
query20 0.02 0.01 0.01
query21 15.40 0.56 0.56
query22 2.57 3.15 2.22
query23 17.34 0.87 0.79
query24 2.37 1.43 0.69
query25 0.52 0.11 0.07
query26 0.47 0.14 0.14
query27 0.05 0.06 0.04
query28 11.64 0.83 0.84
query29 12.49 3.16 3.19
query30 0.63 0.52 0.54
query31 2.78 0.34 0.36
query32 3.36 0.49 0.48
query33 3.24 3.24 3.22
query34 15.99 4.32 4.35
query35 4.36 4.34 4.34
query36 1.08 1.07 1.06
query37 0.07 0.05 0.05
query38 0.03 0.03 0.02
query39 0.02 0.02 0.02
query40 0.15 0.12 0.13
query41 0.07 0.02 0.02
query42 0.02 0.02 0.01
query43 0.02 0.02 0.03
Total cold run time: 105.44 s
Total hot run time: 31.1 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1920663728
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 2d1bd12cee0b7fe23d405babc9f0d7a87c9978d4 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: 13.4 seconds inserted 10000000 Rows, about 746K 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921406265
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 3eb3d722773e1339f1ed8af550dd52f8b45deeeb 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.6 seconds inserted 10000000 Rows, about 735K 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1922718055
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923072056
run external
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1922699391
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1926476715
TeamCity be ut coverage result:
Function Coverage: 36.15% (8625/23858)
Line Coverage: 28.21% (70539/250087)
Region Coverage: 27.21% (36402/133789)
Branch Coverage: 24.00% (18647/77690)
Coverage Report: http://coverage.selectdb-in.cc/coverage/6930826235b006f269016c00e8aeca22f84f4fc8_6930826235b006f269016c00e8aeca22f84f4fc8/report/index.html
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1920517964
<details>
<summary>ClickBench: <b>Total hot run time: 31.38 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 cb2278c0bae1171771a984489c0770a2c453e736, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.02 0.02
query3 0.23 0.06 0.06
query4 1.68 0.09 0.10
query5 0.54 0.51 0.52
query6 1.24 0.65 0.62
query7 0.02 0.01 0.02
query8 0.04 0.02 0.02
query9 0.56 0.51 0.50
query10 0.56 0.54 0.56
query11 0.12 0.09 0.09
query12 0.11 0.09 0.10
query13 0.60 0.61 0.60
query14 0.79 0.80 0.78
query15 0.82 0.79 0.77
query16 0.38 0.36 0.38
query17 1.01 1.00 1.02
query18 0.21 0.26 0.25
query19 1.85 1.79 1.80
query20 0.01 0.02 0.02
query21 15.80 0.60 0.58
query22 2.89 2.28 2.16
query23 17.15 0.87 0.76
query24 2.44 1.62 1.09
query25 0.38 0.25 0.14
query26 0.57 0.13 0.14
query27 0.05 0.05 0.06
query28 10.98 0.89 0.83
query29 12.55 3.08 3.11
query30 0.65 0.50 0.53
query31 2.83 0.35 0.35
query32 3.35 0.48 0.48
query33 3.19 3.22 3.22
query34 15.81 4.29 4.26
query35 4.27 4.30 4.33
query36 1.08 1.05 1.05
query37 0.07 0.05 0.05
query38 0.04 0.03 0.02
query39 0.02 0.01 0.02
query40 0.18 0.13 0.13
query41 0.08 0.01 0.02
query42 0.03 0.01 0.02
query43 0.03 0.02 0.02
Total cold run time: 105.3 s
Total hot run time: 31.38 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923584139
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923560214
run external
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1922737145
<details>
<summary>TPC-H: <b>Total hot run time: 36619 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 793a212fa8a635eee498c86883d0890f4e70f6c2, data reload: false
------ Round 1 ----------------------------------
q1 17643 4597 4477 4477
q2 2044 141 135 135
q3 10673 912 898 898
q4 4677 700 688 688
q5 7684 2706 2719 2706
q6 182 120 119 119
q7 1151 722 697 697
q8 9237 1955 1960 1955
q9 7194 6291 6295 6291
q10 8118 2377 2411 2377
q11 414 195 211 195
q12 773 261 287 261
q13 18004 3302 3289 3289
q14 271 248 246 246
q15 522 493 488 488
q16 445 413 400 400
q17 920 489 516 489
q18 6667 5888 6050 5888
q19 1553 1457 1362 1362
q20 603 324 329 324
q21 6533 3043 3068 3043
q22 810 291 300 291
Total cold run time: 106118 ms
Total hot run time: 36619 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4411 4402 4366 4366
q2 328 229 246 229
q3 2977 2833 2797 2797
q4 1871 1587 1623 1587
q5 5114 5196 5216 5196
q6 192 113 112 112
q7 2110 1714 1801 1714
q8 3093 3197 3295 3197
q9 8296 8236 8292 8236
q10 5790 3563 3566 3563
q11 535 470 453 453
q12 716 556 575 556
q13 11068 3081 3094 3081
q14 288 264 252 252
q15 543 491 495 491
q16 513 471 481 471
q17 1842 1690 1746 1690
q18 7998 7618 7480 7480
q19 10940 1559 1554 1554
q20 2149 1911 1902 1902
q21 4859 4643 4561 4561
q22 535 471 448 448
Total cold run time: 76168 ms
Total hot run time: 53936 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1920490818
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1920522828
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit cb2278c0bae1171771a984489c0770a2c453e736 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 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: 13.2 seconds inserted 10000000 Rows, about 757K 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1926413393
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923324868
<details>
<summary>TPC-H: <b>Total hot run time: 37084 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 3b9eb9c54bf55f3b612ababa8240df18e47a6d8a, data reload: false
------ Round 1 ----------------------------------
q1 17683 5107 4465 4465
q2 2034 140 133 133
q3 10597 944 895 895
q4 4650 686 720 686
q5 7704 2806 2903 2806
q6 183 119 120 119
q7 1161 726 721 721
q8 9282 1960 2009 1960
q9 7263 6322 6341 6322
q10 8094 2434 2418 2418
q11 411 213 212 212
q12 778 280 277 277
q13 18238 3355 3339 3339
q14 281 250 252 250
q15 538 494 486 486
q16 506 419 411 411
q17 928 546 471 471
q18 6833 5991 6044 5991
q19 1554 1398 1392 1392
q20 587 349 318 318
q21 7305 3158 3125 3125
q22 810 299 287 287
Total cold run time: 107420 ms
Total hot run time: 37084 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4552 4429 4388 4388
q2 342 226 226 226
q3 2997 2833 2860 2833
q4 1945 1630 1599 1599
q5 5249 5288 5285 5285
q6 194 116 115 115
q7 2162 1731 1774 1731
q8 3097 3237 3271 3237
q9 8643 8523 8619 8523
q10 8391 3702 3627 3627
q11 537 468 460 460
q12 742 582 565 565
q13 18188 3203 3129 3129
q14 273 266 275 266
q15 541 506 514 506
q16 533 485 508 485
q17 1823 1668 1696 1668
q18 7995 7722 7563 7563
q19 8361 1551 1550 1550
q20 2145 1892 1903 1892
q21 4986 4625 4651 4625
q22 540 453 460 453
Total cold run time: 84236 ms
Total hot run time: 54726 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923631676
<details>
<summary>TPC-H: <b>Total hot run time: 37341 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 34a20c4235ed28cfb9d68d137d0f078d6b00ee7f, data reload: false
------ Round 1 ----------------------------------
q1 18480 4507 4400 4400
q2 2046 147 136 136
q3 10587 952 913 913
q4 4645 792 742 742
q5 7890 2899 2889 2889
q6 185 120 123 120
q7 1180 773 744 744
q8 9374 2055 2032 2032
q9 9219 6657 6555 6555
q10 8238 2426 2472 2426
q11 428 219 198 198
q12 838 282 301 282
q13 20048 3408 3318 3318
q14 272 247 259 247
q15 521 487 486 486
q16 529 415 408 408
q17 935 504 496 496
q18 6783 5918 5867 5867
q19 1545 1403 1394 1394
q20 599 353 354 353
q21 6878 3123 3040 3040
q22 801 295 303 295
Total cold run time: 112021 ms
Total hot run time: 37341 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4458 4333 4345 4333
q2 333 231 233 231
q3 2955 2879 2809 2809
q4 1818 1622 1658 1622
q5 5253 5234 5167 5167
q6 190 114 113 113
q7 2154 1745 1759 1745
q8 3122 3236 3212 3212
q9 8297 8264 8321 8264
q10 5767 3532 3501 3501
q11 526 466 471 466
q12 735 587 571 571
q13 14614 3156 3051 3051
q14 281 262 259 259
q15 533 486 495 486
q16 509 473 452 452
q17 1827 1702 1700 1700
q18 7893 7871 7607 7607
q19 9394 1501 1556 1501
q20 2123 1905 1916 1905
q21 4776 4427 4539 4427
q22 560 452 448 448
Total cold run time: 78118 ms
Total hot run time: 53870 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921763534
<details>
<summary>TPC-DS: <b>Total hot run time: 174387 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 9316f73a1214b877fc77344f55a645f67dd91115, data reload: false
query1 919 327 319 319
query2 6625 2003 2010 2003
query3 6689 200 197 197
query4 31408 22089 22044 22044
query5 4454 354 349 349
query6 253 167 151 151
query7 4596 260 257 257
query8 244 171 184 171
query9 9184 2304 2271 2271
query10 405 201 182 182
query11 18387 15292 15310 15292
query12 125 64 62 62
query13 1614 382 372 372
query14 10224 7191 7519 7191
query15 240 175 185 175
query16 7512 267 249 249
query17 1883 484 468 468
query18 1939 250 251 250
query19 342 127 130 127
query20 74 70 71 70
query21 198 135 129 129
query22 4971 4862 4699 4699
query23 31491 30285 30320 30285
query24 10659 2688 2773 2688
query25 515 314 300 300
query26 797 133 136 133
query27 2270 290 281 281
query28 6967 1843 1841 1841
query29 921 605 593 593
query30 278 127 135 127
query31 933 727 709 709
query32 90 51 48 48
query33 697 206 211 206
query34 1064 446 460 446
query35 868 777 755 755
query36 1089 923 909 909
query37 92 56 58 56
query38 3322 3147 3163 3147
query39 1301 1245 1254 1245
query40 196 85 82 82
query41 36 37 37 37
query42 80 82 80 80
query43 492 487 473 473
query44 1093 693 695 693
query45 188 185 177 177
query46 1023 631 627 627
query47 1618 1532 1472 1472
query48 402 311 306 306
query49 1092 292 275 275
query50 690 318 307 307
query51 5254 5181 5118 5118
query52 93 82 73 73
query53 313 255 262 255
query54 272 181 176 176
query55 79 73 74 73
query56 189 157 155 155
query57 985 920 905 905
query58 181 156 149 149
query59 2646 2437 2409 2409
query60 195 173 171 171
query61 81 83 87 83
query62 627 362 346 346
query63 278 265 266 265
query64 5308 3537 3351 3351
query65 3242 3250 3220 3220
query66 935 312 317 312
query67 14302 14169 14344 14169
query68 4409 490 501 490
query69 434 311 297 297
query70 1261 1254 1173 1173
query71 298 212 207 207
query72 5779 3117 2861 2861
query73 686 316 313 313
query74 6706 6271 6239 6239
query75 3066 2318 2286 2286
query76 2952 979 901 901
query77 351 240 227 227
query78 9248 8673 8546 8546
query79 3297 507 500 500
query80 2249 323 312 312
query81 539 196 197 196
query82 1002 93 81 81
query83 372 124 116 116
query84 284 77 69 69
query85 1642 324 330 324
query86 478 297 283 283
query87 3448 3276 3287 3276
query88 4071 2203 2176 2176
query89 424 355 347 347
query90 1899 182 178 178
query91 146 119 115 115
query92 58 41 41 41
query93 3676 457 422 422
query94 1339 156 157 156
query95 492 451 433 433
query96 627 315 307 307
query97 4224 4145 4101 4101
query98 213 195 190 190
query99 1219 668 706 668
Total cold run time: 284419 ms
Total hot run time: 174387 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921695015
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923341976
<details>
<summary>TPC-DS: <b>Total hot run time: 181376 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 3b9eb9c54bf55f3b612ababa8240df18e47a6d8a, data reload: false
query1 928 340 325 325
query2 6555 1966 1954 1954
query3 6700 210 202 202
query4 31490 21944 21957 21944
query5 4328 358 417 358
query6 254 164 168 164
query7 4607 281 283 281
query8 250 170 176 170
query9 9266 2314 2295 2295
query10 438 226 209 209
query11 18581 15298 15150 15150
query12 133 77 72 72
query13 1616 415 419 415
query14 9333 6916 7197 6916
query15 293 173 181 173
query16 8149 279 245 245
query17 2024 550 521 521
query18 2114 274 259 259
query19 350 140 142 140
query20 80 80 79 79
query21 200 124 126 124
query22 4893 4424 4658 4424
query23 31095 30007 30032 30007
query24 10642 2714 2721 2714
query25 565 345 345 345
query26 907 140 150 140
query27 2288 301 298 298
query28 6607 1854 1836 1836
query29 875 623 619 619
query30 279 132 137 132
query31 880 683 684 683
query32 89 51 51 51
query33 745 227 224 224
query34 1094 448 467 448
query35 875 780 786 780
query36 994 876 908 876
query37 99 57 60 57
query38 3229 3114 3086 3086
query39 1294 1250 1250 1250
query40 182 92 90 90
query41 37 35 34 34
query42 104 86 97 86
query43 499 477 484 477
query44 1110 682 711 682
query45 196 188 176 176
query46 1063 652 642 642
query47 1602 1524 1416 1416
query48 429 355 358 355
query49 1071 278 286 278
query50 757 373 377 373
query51 5253 5144 5187 5144
query52 106 81 89 81
query53 336 282 274 274
query54 283 213 222 213
query55 79 77 80 77
query56 215 204 199 199
query57 960 907 929 907
query58 207 173 175 173
query59 2399 2265 2415 2265
query60 238 213 206 206
query61 94 83 86 83
query62 679 351 357 351
query63 299 266 275 266
query64 5116 3408 3627 3408
query65 3263 3231 3214 3214
query66 808 327 308 308
query67 14410 14368 14182 14182
query68 5381 529 539 529
query69 470 341 342 341
query70 1278 1255 1263 1255
query71 323 250 246 246
query72 6447 2850 2706 2706
query73 695 323 320 320
query74 6590 6190 6176 6176
query75 3123 2346 2336 2336
query76 3300 974 899 899
query77 365 227 236 227
query78 9345 8827 8562 8562
query79 3445 494 487 487
query80 2073 348 340 340
query81 549 194 196 194
query82 867 84 87 84
query83 251 132 127 127
query84 281 83 78 78
query85 2187 337 324 324
query86 485 309 295 295
query87 3362 3193 3174 3174
query88 4362 2331 2318 2318
query89 458 379 366 366
query90 1942 168 161 161
query91 168 118 122 118
query92 60 42 48 42
query93 5172 474 456 456
query94 1313 179 175 175
query95 466 7986 7828 7828
query96 596 275 278 275
query97 4235 4100 4119 4100
query98 219 190 198 190
query99 1128 721 722 721
Total cold run time: 287870 ms
Total hot run time: 181376 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923662623
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 34a20c4235ed28cfb9d68d137d0f078d6b00ee7f with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.3 seconds inserted 10000000 Rows, about 751K 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921387621
<details>
<summary>TPC-DS: <b>Total hot run time: 173883 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 3eb3d722773e1339f1ed8af550dd52f8b45deeeb, data reload: false
query1 930 334 330 330
query2 6942 1951 2022 1951
query3 6705 197 195 195
query4 31903 22143 22074 22074
query5 4455 424 352 352
query6 249 149 153 149
query7 4609 266 256 256
query8 250 170 175 170
query9 8927 2306 2296 2296
query10 408 195 196 195
query11 19003 15370 15382 15370
query12 117 63 62 62
query13 1609 375 372 372
query14 9621 6959 7617 6959
query15 243 173 185 173
query16 7515 271 256 256
query17 1862 493 462 462
query18 1950 262 248 248
query19 364 134 136 134
query20 74 70 66 66
query21 195 139 127 127
query22 4897 4693 4547 4547
query23 31196 30325 30188 30188
query24 10887 2750 2746 2746
query25 528 315 315 315
query26 1344 137 138 137
query27 2414 290 282 282
query28 6995 1879 1847 1847
query29 1268 631 604 604
query30 278 132 134 132
query31 923 703 721 703
query32 96 51 48 48
query33 691 215 206 206
query34 1029 453 474 453
query35 936 743 779 743
query36 1020 913 945 913
query37 100 54 57 54
query38 3266 3146 3148 3146
query39 1306 1273 1232 1232
query40 321 84 85 84
query41 36 35 36 35
query42 83 81 84 81
query43 518 494 483 483
query44 1059 701 710 701
query45 193 181 175 175
query46 1049 635 625 625
query47 1512 1499 1462 1462
query48 400 319 317 317
query49 1216 282 278 278
query50 707 310 312 310
query51 5321 5108 5102 5102
query52 86 83 78 78
query53 313 264 268 264
query54 263 185 187 185
query55 80 75 76 75
query56 178 166 160 160
query57 938 907 896 896
query58 184 152 164 152
query59 2520 2436 2481 2436
query60 211 177 183 177
query61 83 87 82 82
query62 648 362 369 362
query63 281 258 257 257
query64 6338 3661 3266 3266
query65 3246 3225 3224 3224
query66 1150 314 313 313
query67 14366 14166 13982 13982
query68 4387 499 511 499
query69 434 305 299 299
query70 1220 1206 1238 1206
query71 300 216 213 213
query72 5687 3156 2845 2845
query73 686 325 313 313
query74 6659 6228 6274 6228
query75 2942 2313 2286 2286
query76 2525 906 1011 906
query77 413 238 224 224
query78 9113 8805 8508 8508
query79 2050 491 492 491
query80 1564 312 306 306
query81 519 197 199 197
query82 883 82 81 81
query83 220 113 119 113
query84 232 70 78 70
query85 2367 337 331 331
query86 474 284 292 284
query87 3429 3262 3238 3238
query88 3813 2183 2173 2173
query89 428 345 354 345
query90 1933 183 179 179
query91 152 117 116 116
query92 60 45 40 40
query93 2419 420 443 420
query94 1389 158 156 156
query95 492 464 445 445
query96 616 315 314 314
query97 4240 4116 4137 4116
query98 210 198 197 197
query99 1098 703 689 689
Total cold run time: 283359 ms
Total hot run time: 173883 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1928656944
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921739094
<details>
<summary>TPC-H: <b>Total hot run time: 36663 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 9316f73a1214b877fc77344f55a645f67dd91115, data reload: false
------ Round 1 ----------------------------------
q1 17700 4558 4394 4394
q2 2032 136 131 131
q3 10608 897 885 885
q4 4677 738 682 682
q5 7668 2781 2736 2736
q6 179 120 120 120
q7 1114 708 695 695
q8 9331 2008 2018 2008
q9 7243 6307 6292 6292
q10 8069 2413 2409 2409
q11 411 196 195 195
q12 758 272 276 272
q13 17990 3301 3284 3284
q14 268 254 239 239
q15 532 485 491 485
q16 481 438 431 431
q17 925 536 551 536
q18 6741 6116 5933 5933
q19 1572 1382 1310 1310
q20 575 360 346 346
q21 6817 3028 2998 2998
q22 805 290 282 282
Total cold run time: 106496 ms
Total hot run time: 36663 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4577 4436 4438 4436
q2 324 239 230 230
q3 2995 2843 2804 2804
q4 1852 1621 1592 1592
q5 5135 5185 5218 5185
q6 194 115 115 115
q7 2172 1756 1737 1737
q8 3105 3218 3300 3218
q9 8279 8269 8317 8269
q10 5864 3540 3502 3502
q11 553 452 468 452
q12 762 569 561 561
q13 14080 3082 3084 3082
q14 281 241 270 241
q15 534 491 488 488
q16 502 454 461 454
q17 1809 1717 1689 1689
q18 7900 7631 7451 7451
q19 7756 1529 1541 1529
q20 2100 1904 1898 1898
q21 4739 4464 4538 4464
q22 571 454 470 454
Total cold run time: 76084 ms
Total hot run time: 53851 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921399532
<details>
<summary>ClickBench: <b>Total hot run time: 31.28 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 3eb3d722773e1339f1ed8af550dd52f8b45deeeb, data reload: false
query1 0.04 0.03 0.02
query2 0.06 0.03 0.02
query3 0.22 0.06 0.06
query4 1.69 0.10 0.11
query5 0.52 0.52 0.52
query6 1.22 0.65 0.63
query7 0.02 0.02 0.01
query8 0.03 0.03 0.02
query9 0.56 0.51 0.51
query10 0.58 0.54 0.54
query11 0.12 0.08 0.08
query12 0.11 0.09 0.09
query13 0.62 0.61 0.61
query14 0.78 0.79 0.80
query15 0.79 0.78 0.77
query16 0.37 0.39 0.38
query17 1.02 1.02 1.03
query18 0.21 0.26 0.24
query19 1.90 1.74 1.78
query20 0.01 0.01 0.01
query21 15.40 0.59 0.56
query22 2.70 2.59 1.94
query23 17.41 0.84 0.75
query24 2.34 1.18 1.35
query25 0.32 0.10 0.24
query26 0.64 0.14 0.15
query27 0.04 0.06 0.05
query28 11.63 0.86 0.82
query29 12.78 3.11 3.18
query30 0.66 0.63 0.57
query31 2.79 0.34 0.35
query32 3.38 0.49 0.49
query33 3.23 3.22 3.21
query34 15.86 4.30 4.29
query35 4.28 4.27 4.31
query36 1.10 1.05 1.06
query37 0.06 0.05 0.05
query38 0.04 0.03 0.03
query39 0.01 0.01 0.02
query40 0.16 0.13 0.12
query41 0.07 0.02 0.01
query42 0.03 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 105.82 s
Total hot run time: 31.28 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1921362790
<details>
<summary>TPC-H: <b>Total hot run time: 37461 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 3eb3d722773e1339f1ed8af550dd52f8b45deeeb, data reload: false
------ Round 1 ----------------------------------
q1 17714 4567 4643 4567
q2 2472 146 137 137
q3 11467 948 931 931
q4 4988 819 752 752
q5 8076 2931 2971 2931
q6 191 127 125 125
q7 1174 743 749 743
q8 9517 2090 2076 2076
q9 7294 6386 6383 6383
q10 8133 2487 2415 2415
q11 416 211 198 198
q12 742 284 273 273
q13 18007 3331 3293 3293
q14 278 243 249 243
q15 527 494 491 491
q16 453 396 411 396
q17 938 523 488 488
q18 6677 6049 5948 5948
q19 1573 1367 1345 1345
q20 591 323 327 323
q21 6656 3165 3102 3102
q22 800 308 301 301
Total cold run time: 108684 ms
Total hot run time: 37461 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4596 4396 4408 4396
q2 326 240 238 238
q3 2980 2844 2808 2808
q4 1863 1713 1667 1667
q5 5199 5247 5220 5220
q6 199 117 119 117
q7 2169 1777 1745 1745
q8 3118 3260 3262 3260
q9 8295 8295 8346 8295
q10 5892 3555 3586 3555
q11 538 450 465 450
q12 733 592 575 575
q13 5467 3109 3089 3089
q14 271 269 261 261
q15 538 488 498 488
q16 536 466 458 458
q17 1852 1720 1698 1698
q18 8087 7787 7437 7437
q19 6739 1552 1604 1552
q20 2158 1928 1888 1888
q21 4799 4690 4561 4561
q22 544 495 487 487
Total cold run time: 66899 ms
Total hot run time: 54245 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1922745589
<details>
<summary>TPC-DS: <b>Total hot run time: 175192 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 793a212fa8a635eee498c86883d0890f4e70f6c2, data reload: false
query1 930 332 326 326
query2 6582 1883 1942 1883
query3 6699 202 201 201
query4 31658 22053 21954 21954
query5 4456 406 348 348
query6 254 158 153 153
query7 4603 269 274 269
query8 245 168 171 168
query9 8929 2296 2268 2268
query10 411 192 201 192
query11 17955 15340 15286 15286
query12 128 67 63 63
query13 1612 375 375 375
query14 9926 7353 7274 7274
query15 220 181 179 179
query16 7310 269 249 249
query17 1843 497 484 484
query18 1940 257 250 250
query19 171 132 132 132
query20 71 68 73 68
query21 205 132 133 132
query22 4941 4601 4599 4599
query23 31603 30255 30230 30230
query24 7845 2738 2740 2738
query25 527 309 305 305
query26 735 136 137 136
query27 2297 291 280 280
query28 5287 1866 1839 1839
query29 911 618 618 618
query30 279 130 135 130
query31 913 689 704 689
query32 86 57 51 51
query33 448 199 207 199
query34 809 443 464 443
query35 848 770 756 756
query36 1058 934 977 934
query37 92 56 57 56
query38 3246 3152 3166 3152
query39 1291 1260 1232 1232
query40 197 89 78 78
query41 38 34 33 33
query42 96 81 83 81
query43 505 477 494 477
query44 1046 689 716 689
query45 189 174 175 174
query46 1037 630 629 629
query47 1600 1440 1435 1435
query48 382 297 297 297
query49 1122 283 285 283
query50 681 307 314 307
query51 5248 5176 5215 5176
query52 93 88 71 71
query53 306 259 264 259
query54 226 185 185 185
query55 76 73 75 73
query56 172 168 165 165
query57 981 896 919 896
query58 178 159 152 152
query59 2283 2363 2376 2363
query60 216 177 168 168
query61 83 83 82 82
query62 618 347 360 347
query63 291 272 270 270
query64 4758 3470 3468 3468
query65 3273 3273 3257 3257
query66 951 318 331 318
query67 14530 14333 14209 14209
query68 4530 505 496 496
query69 487 307 301 301
query70 1266 1254 1186 1186
query71 293 216 220 216
query72 7725 3163 2858 2858
query73 682 319 306 306
query74 6787 6466 6714 6466
query75 3078 2351 2409 2351
query76 2916 1023 955 955
query77 394 231 226 226
query78 9830 9506 8819 8819
query79 2549 525 506 506
query80 2426 328 305 305
query81 536 200 201 200
query82 1013 79 82 79
query83 239 119 115 115
query84 284 75 70 70
query85 2046 341 319 319
query86 493 303 301 301
query87 3481 3355 3294 3294
query88 3745 2173 2184 2173
query89 453 362 359 359
query90 1921 185 183 183
query91 159 117 115 115
query92 55 44 45 44
query93 2790 445 440 440
query94 1220 164 160 160
query95 502 452 453 452
query96 629 316 316 316
query97 4214 4131 4145 4131
query98 213 196 184 184
query99 1188 683 693 683
Total cold run time: 278684 ms
Total hot run time: 175192 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1922740700
TeamCity be ut coverage result:
Function Coverage: 36.17% (8625/23846)
Line Coverage: 28.22% (70523/249896)
Region Coverage: 27.24% (36397/133621)
Branch Coverage: 24.03% (18640/77582)
Coverage Report: http://coverage.selectdb-in.cc/coverage/793a212fa8a635eee498c86883d0890f4e70f6c2_793a212fa8a635eee498c86883d0890f4e70f6c2/report/index.html
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "mymeiyi (via GitHub)" <gi...@apache.org>.
mymeiyi commented on code in PR #30512:
URL: https://github.com/apache/doris/pull/30512#discussion_r1477168640
##########
fe/fe-core/src/main/java/org/apache/doris/nereids/parser/LogicalPlanBuilder.java:
##########
@@ -2495,8 +2495,22 @@ public ColumnDefinition visitColumnDef(ColumnDefContext ctx) {
//comment should remove '\' and '(") at the beginning and end
String comment = ctx.comment != null ? ctx.comment.getText().substring(1, ctx.comment.getText().length() - 1)
.replace("\\", "") : "";
- boolean isAutoInc = ctx.AUTO_INCREMENT() != null;
- return new ColumnDefinition(colName, colType, isKey, aggType, !isNotNull, isAutoInc, defaultValue,
+ long autoIncInitValue = -1;
+ if (ctx.AUTO_INCREMENT() != null) {
+ if (ctx.autoIncInitValue != null) {
+ // AUTO_INCREMENT(Value) Value >= 0.
+ autoIncInitValue = Long.valueOf(ctx.autoIncInitValue.getText());
+ if (autoIncInitValue < 0) {
+ throw new AnalysisException("AUTO_INCREMENT start value can not be negative.");
+ }
+ } else {
+ // AUTO_INCREMENT default 1.
+ autoIncInitValue = Long.valueOf(1);
+ }
+ } else {
+ autoIncInitValue = Long.valueOf(-1);
Review Comment:
The else can be removed
--
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1926401839
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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1923349670
<details>
<summary>ClickBench: <b>Total hot run time: 31.39 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 3b9eb9c54bf55f3b612ababa8240df18e47a6d8a, data reload: false
query1 0.04 0.04 0.03
query2 0.06 0.03 0.03
query3 0.22 0.06 0.06
query4 1.68 0.10 0.09
query5 0.52 0.51 0.52
query6 1.18 0.63 0.64
query7 0.02 0.01 0.02
query8 0.03 0.02 0.03
query9 0.55 0.48 0.49
query10 0.53 0.56 0.55
query11 0.12 0.08 0.09
query12 0.12 0.09 0.09
query13 0.60 0.62 0.60
query14 0.78 0.80 0.79
query15 0.78 0.79 0.77
query16 0.36 0.40 0.39
query17 1.02 1.00 1.02
query18 0.21 0.28 0.24
query19 1.86 1.79 1.78
query20 0.02 0.01 0.01
query21 15.40 0.56 0.57
query22 2.52 2.31 2.62
query23 17.28 0.89 0.71
query24 2.45 1.15 0.92
query25 0.33 0.16 0.15
query26 0.56 0.14 0.14
query27 0.07 0.05 0.05
query28 11.75 0.86 0.83
query29 12.50 3.28 3.27
query30 0.63 0.55 0.47
query31 2.78 0.36 0.35
query32 3.34 0.49 0.48
query33 3.22 3.20 3.23
query34 15.95 4.25 4.28
query35 4.34 4.27 4.25
query36 1.08 1.04 1.06
query37 0.07 0.05 0.06
query38 0.04 0.03 0.03
query39 0.02 0.01 0.01
query40 0.17 0.13 0.12
query41 0.07 0.02 0.01
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 105.32 s
Total hot run time: 31.39 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1920505653
<details>
<summary>TPC-H: <b>Total hot run time: 37044 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 cb2278c0bae1171771a984489c0770a2c453e736, data reload: false
------ Round 1 ----------------------------------
q1 17915 4544 4488 4488
q2 2365 141 145 141
q3 11284 973 917 917
q4 4960 713 747 713
q5 7911 2869 2871 2869
q6 189 119 118 118
q7 1165 726 701 701
q8 9287 2010 1995 1995
q9 7266 6378 6291 6291
q10 8101 2402 2445 2402
q11 411 202 210 202
q12 750 276 284 276
q13 17998 3290 3296 3290
q14 265 248 265 248
q15 529 496 491 491
q16 452 425 395 395
q17 949 535 576 535
q18 6767 5961 5934 5934
q19 1580 1367 1322 1322
q20 604 346 336 336
q21 7271 3081 3093 3081
q22 817 299 302 299
Total cold run time: 108836 ms
Total hot run time: 37044 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4429 4378 4353 4353
q2 324 235 226 226
q3 2919 2885 2878 2878
q4 1896 1653 1697 1653
q5 5152 5256 5240 5240
q6 195 112 113 112
q7 2115 1763 1716 1716
q8 3077 3210 3283 3210
q9 8316 8289 8316 8289
q10 5743 3564 3543 3543
q11 546 455 457 455
q12 763 581 580 580
q13 11688 3119 3079 3079
q14 269 251 251 251
q15 541 485 494 485
q16 568 446 467 446
q17 1844 1685 1659 1659
q18 7947 7670 7625 7625
q19 5977 1535 1488 1488
q20 2139 1928 1908 1908
q21 4709 4637 4535 4535
q22 571 475 473 473
Total cold run time: 71728 ms
Total hot run time: 54204 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1919053103
<details>
<summary>TPC-H: <b>Total hot run time: 36958 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 ccf08aa2d8a6d00d9ef699448d7046e8fd6d4613, data reload: false
------ Round 1 ----------------------------------
q1 17670 4538 4436 4436
q2 2038 139 134 134
q3 10598 926 953 926
q4 4647 759 743 743
q5 7693 2872 2780 2780
q6 184 121 120 120
q7 1138 723 707 707
q8 9294 2021 2022 2021
q9 7291 6369 6309 6309
q10 8099 2418 2468 2418
q11 418 208 207 207
q12 751 276 300 276
q13 18022 3334 3311 3311
q14 273 251 246 246
q15 529 499 488 488
q16 470 437 410 410
q17 949 553 575 553
q18 6779 6100 5847 5847
q19 1559 1377 1395 1377
q20 586 319 342 319
q21 6690 3045 3210 3045
q22 796 308 285 285
Total cold run time: 106474 ms
Total hot run time: 36958 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4529 4475 4480 4475
q2 321 227 236 227
q3 2975 2864 2866 2864
q4 1877 1690 1683 1683
q5 5213 5247 5262 5247
q6 201 116 115 115
q7 2161 1724 1755 1724
q8 3157 3278 3233 3233
q9 8403 8313 8308 8308
q10 5793 3546 3534 3534
q11 544 457 445 445
q12 753 554 584 554
q13 6972 3100 3100 3100
q14 272 258 257 257
q15 528 490 493 490
q16 515 471 468 468
q17 1868 1694 1655 1655
q18 8004 7805 7665 7665
q19 7754 1530 1493 1493
q20 2120 1927 1916 1916
q21 4863 4684 4642 4642
q22 513 472 469 469
Total cold run time: 69336 ms
Total hot run time: 54564 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] [Feature](auto-inc) Add start value for auto increment column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30512:
URL: https://github.com/apache/doris/pull/30512#issuecomment-1919071017
<details>
<summary>TPC-DS: <b>Total hot run time: 174665 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 ccf08aa2d8a6d00d9ef699448d7046e8fd6d4613, data reload: false
query1 928 335 331 331
query2 6559 1934 1895 1895
query3 6696 210 204 204
query4 32340 22253 22121 22121
query5 4455 365 354 354
query6 246 153 153 153
query7 4631 267 261 261
query8 247 164 177 164
query9 9051 2252 2258 2252
query10 410 197 207 197
query11 18242 15409 15511 15409
query12 117 69 63 63
query13 1642 378 390 378
query14 10074 7346 6956 6956
query15 212 175 179 175
query16 7082 271 251 251
query17 2047 507 479 479
query18 1803 256 258 256
query19 175 136 126 126
query20 74 70 69 69
query21 201 132 127 127
query22 4960 4716 4654 4654
query23 31314 30507 30287 30287
query24 11780 2759 2749 2749
query25 533 306 297 297
query26 1566 135 134 134
query27 2548 284 280 280
query28 7201 1839 1815 1815
query29 1621 628 609 609
query30 280 129 137 129
query31 917 690 726 690
query32 89 51 48 48
query33 722 207 209 207
query34 1194 457 463 457
query35 903 744 777 744
query36 1331 1109 1148 1109
query37 178 59 55 55
query38 3264 3169 3178 3169
query39 1310 1235 1233 1233
query40 334 85 77 77
query41 36 36 34 34
query42 97 82 86 82
query43 523 512 488 488
query44 1171 679 695 679
query45 194 178 175 175
query46 1045 633 612 612
query47 1608 1474 1484 1474
query48 409 313 294 294
query49 1236 274 290 274
query50 688 325 308 308
query51 5266 5193 5158 5158
query52 87 86 76 76
query53 316 258 258 258
query54 264 178 190 178
query55 76 80 74 74
query56 172 168 161 161
query57 1010 922 889 889
query58 189 149 151 149
query59 2440 2286 2398 2286
query60 197 173 172 172
query61 83 84 81 81
query62 643 366 357 357
query63 272 255 259 255
query64 6382 3643 3428 3428
query65 3267 3219 3220 3219
query66 1392 320 330 320
query67 14530 14247 14105 14105
query68 3926 500 501 500
query69 427 319 309 309
query70 1600 1514 1539 1514
query71 291 204 213 204
query72 5485 3120 2829 2829
query73 684 323 321 321
query74 6622 6250 6153 6153
query75 2925 2343 2234 2234
query76 2539 938 929 929
query77 437 229 234 229
query78 9053 8748 8447 8447
query79 3028 498 480 480
query80 2204 319 311 311
query81 522 207 198 198
query82 840 83 79 79
query83 253 119 120 119
query84 295 82 68 68
query85 2549 346 341 341
query86 502 383 373 373
query87 3445 3292 3249 3249
query88 4226 2252 2232 2232
query89 429 352 344 344
query90 2080 191 188 188
query91 149 119 120 119
query92 56 43 44 43
query93 4271 453 441 441
query94 1489 157 156 156
query95 519 451 453 451
query96 623 330 323 323
query97 4232 4070 4114 4070
query98 215 189 192 189
query99 1054 672 704 672
Total cold run time: 289840 ms
Total hot run time: 174665 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