You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "sollhui (via GitHub)" <gi...@apache.org> on 2024/07/08 07:04:34 UTC

[PR] [chore](routine-load) optimize out of range error message (#36450) [doris]

sollhui opened a new pull request, #37456:
URL: https://github.com/apache/doris/pull/37456

   pick #36450
   
   before
   ```
   ErrorReason{code=errCode = 105, msg='be 10002 abort task, task id: d846f3d3-7c9e-44a7-bee0-3eff8cd11c6f job id: 11310 with reason: [INTERNAL_ERROR]Offset out of range,
   
           0#  doris::Status doris::Status::Error<6, true>(std::basic_string_view<char, std::char_traits<char> >) at /mnt/disk1/laihui/doris/be/src/common/status.h:422
           1#  doris::Status doris::Status::InternalError<true>(std::basic_string_view<char, std::char_traits<char> >) at /mnt/disk1/laihui/doris/be/src/common/status.h:468
           2#  doris::KafkaDataConsumer::group_consume(doris::BlockingQueue<RdKafka::Message*>*, long) at /mnt/disk1/laihui/doris/be/src/runtime/routine_load/data_consumer.cpp:226
           3#  doris::KafkaDataConsumerGroup::actual_consume(std::shared_ptr<doris::DataConsumer>, doris::BlockingQueue<RdKafka::Message*>*, long, std::function<void (doris::Status const&)>) at /mnt/disk1/laihui/doris/be/src/runtime/routine_load/data_consumer_group.cpp:200
           4#  void std::__invoke_impl<void, void (doris::KafkaDataConsumerGroup::*&)(std::shared_ptr<doris::DataConsumer>, doris::BlockingQueue<RdKafka::Message*>*, long, std::function<void (doris::Status const&)>), doris::KafkaDataConsumerGroup*&, std::shared_ptr<doris::DataConsumer>&, doris::BlockingQueue<RdKafka::Message*>*&, long&, doris::KafkaDataConsumerGroup::start_all(std::shared_ptr<doris::StreamLoadContext>, std::shared_ptr<doris::io::KafkaConsumerPipe>)::$_0&>(std::__invoke_memfun_deref, void (doris::KafkaDataConsumerGroup::*&)(std::shared_ptr<doris::DataConsumer>, doris::BlockingQueue<RdKafka::Message*>*, long, std::function<void (doris::Status const&)>), doris::KafkaDataConsumerGroup*&, std::shared_ptr<doris::DataConsumer>&, doris::BlockingQueue<RdKafka::Message*>*&, long&, doris::KafkaDataConsumerGroup::start_all(std::shared_ptr<doris::StreamLoadContext>, std::shared_ptr<doris::io::KafkaConsumerPipe>)::$_0&) at /mnt/disk1/laihui/build/ldb_toolchain/bin/../lib/gcc/x86_6
 4-linux-gnu/11/../../../../include/c++/11/bits/invoke.h:74
   ...
   ```
   
   now
   ```
   ErrorReason{code=errCode = 105, msg='be 10002 abort task, task id: 3ba0c0f4-d13c-4dfa-90ce-3df922fd9340 job id: 11310 with reason: [INTERNAL_ERROR]Offset out of range, consume partition 0, consume offset 100, the offset used by job does not exist in kafka, please check the offset, using the Alter ROUTINE LOAD command to modify it, and resume the job'}
   ```
   
   


-- 
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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "liaoxin01 (via GitHub)" <gi...@apache.org>.
liaoxin01 merged PR #37456:
URL: https://github.com/apache/doris/pull/37456


-- 
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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "sollhui (via GitHub)" <gi...@apache.org>.
sollhui commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2217948006

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2214175466

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 22b11bd86fc65c8da3ac5df1586b743546dd3bcf with default session variables
   Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 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:       20.9 seconds inserted 10000000 Rows, about 478K 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "sollhui (via GitHub)" <gi...@apache.org>.
sollhui commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2213197270

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2218042245

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit b40db4560de04d5017f873813e5f036c95406cad with default session variables
   Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 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:       21.5 seconds inserted 10000000 Rows, about 465K 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "sollhui (via GitHub)" <gi...@apache.org>.
sollhui commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2219456401

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2213270965

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.57 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 f7d7f30bae82c02b48f01f2bf86d4e8957c61187, data reload: false
   
   query1	0.02	0.02	0.03
   query2	0.07	0.02	0.02
   query3	0.24	0.05	0.05
   query4	1.80	0.06	0.06
   query5	0.53	0.52	0.51
   query6	1.24	0.64	0.69
   query7	0.01	0.01	0.01
   query8	0.04	0.03	0.03
   query9	0.51	0.50	0.50
   query10	0.53	0.53	0.54
   query11	0.12	0.09	0.09
   query12	0.11	0.10	0.08
   query13	0.62	0.62	0.61
   query14	0.78	0.80	0.79
   query15	0.78	0.78	0.76
   query16	0.38	0.36	0.36
   query17	1.01	1.00	1.00
   query18	0.24	0.25	0.25
   query19	1.91	1.89	1.86
   query20	0.01	0.01	0.00
   query21	15.50	0.54	0.56
   query22	1.94	2.15	1.48
   query23	17.26	0.98	1.04
   query24	5.56	0.84	0.98
   query25	0.33	0.13	0.06
   query26	0.61	0.15	0.15
   query27	0.04	0.04	0.04
   query28	7.76	0.72	0.72
   query29	12.62	2.27	2.31
   query30	0.58	0.53	0.54
   query31	2.81	0.39	0.37
   query32	3.38	0.50	0.49
   query33	3.10	3.10	3.07
   query34	15.23	4.78	4.81
   query35	4.85	4.83	4.87
   query36	1.05	1.00	1.02
   query37	0.06	0.04	0.04
   query38	0.03	0.02	0.02
   query39	0.02	0.01	0.01
   query40	0.16	0.14	0.14
   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: 103.95 s
   Total hot run time: 30.57 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2213261414

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 204001 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 f7d7f30bae82c02b48f01f2bf86d4e8957c61187, data reload: false
   
   query1	932	421	380	380
   query2	6533	2997	2633	2633
   query3	6913	210	200	200
   query4	21386	18074	18128	18074
   query5	19729	6534	6415	6415
   query6	278	225	234	225
   query7	4161	296	310	296
   query8	456	428	430	428
   query9	3144	2681	2614	2614
   query10	411	312	310	310
   query11	11428	10941	10861	10861
   query12	126	78	77	77
   query13	5612	703	684	684
   query14	17781	13562	13447	13447
   query15	364	250	242	242
   query16	6463	300	261	261
   query17	1695	1448	861	861
   query18	2336	417	430	417
   query19	217	153	154	153
   query20	81	80	79	79
   query21	200	95	94	94
   query22	5324	5102	5115	5102
   query23	32426	32060	31814	31814
   query24	6965	6504	6465	6465
   query25	523	434	425	425
   query26	530	159	160	159
   query27	1862	294	289	289
   query28	6139	2386	2325	2325
   query29	3010	2845	2795	2795
   query30	247	167	170	167
   query31	894	758	749	749
   query32	68	61	64	61
   query33	385	288	257	257
   query34	853	486	476	476
   query35	1118	942	937	937
   query36	1414	1187	1138	1138
   query37	89	62	61	61
   query38	3172	2899	2919	2899
   query39	1383	1319	1322	1319
   query40	206	95	97	95
   query41	54	46	45	45
   query42	82	86	86	86
   query43	734	673	721	673
   query44	1141	703	711	703
   query45	247	236	236	236
   query46	1220	972	1005	972
   query47	1784	1762	1676	1676
   query48	1044	724	708	708
   query49	609	394	364	364
   query50	865	615	583	583
   query51	4765	4656	4748	4656
   query52	94	70	85	70
   query53	448	324	311	311
   query54	2666	2445	2480	2445
   query55	83	80	82	80
   query56	225	195	199	195
   query57	1183	1125	1271	1125
   query58	222	200	206	200
   query59	4065	4172	4087	4087
   query60	214	190	216	190
   query61	99	94	94	94
   query62	871	441	450	441
   query63	484	345	346	345
   query64	2638	1549	1511	1511
   query65	3677	3566	3554	3554
   query66	807	386	370	370
   query67	16311	15211	15706	15211
   query68	8521	645	658	645
   query69	580	379	362	362
   query70	1679	1405	1410	1405
   query71	407	311	313	311
   query72	6512	3482	3462	3462
   query73	740	324	318	318
   query74	6377	5893	5887	5887
   query75	4794	3733	3776	3733
   query76	4851	1173	1207	1173
   query77	674	250	245	245
   query78	12686	11531	12185	11531
   query79	9734	651	645	645
   query80	1220	398	414	398
   query81	503	238	232	232
   query82	1624	100	97	97
   query83	167	134	126	126
   query84	264	74	71	71
   query85	890	335	325	325
   query86	329	288	292	288
   query87	3224	3016	3053	3016
   query88	4667	2302	2283	2283
   query89	470	304	294	294
   query90	1909	213	202	202
   query91	185	139	143	139
   query92	61	53	53	53
   query93	6196	572	580	572
   query94	767	205	212	205
   query95	1098	1083	1036	1036
   query96	643	321	324	321
   query97	6492	6362	6458	6362
   query98	176	175	167	167
   query99	2962	986	882	882
   Total cold run time: 314888 ms
   Total hot run time: 204001 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "sollhui (via GitHub)" <gi...@apache.org>.
sollhui commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2217735365

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2214086858

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2217852451

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 203878 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 57e26f718993e428e08ca383c66e29a75a01439c, data reload: false
   
   query1	937	421	389	389
   query2	6526	2743	2742	2742
   query3	6927	203	203	203
   query4	20606	18177	18124	18124
   query5	19730	6545	6672	6545
   query6	354	244	269	244
   query7	4523	311	327	311
   query8	444	416	407	407
   query9	3134	2738	2656	2656
   query10	446	333	329	329
   query11	12097	11092	11123	11092
   query12	124	77	77	77
   query13	6294	708	709	708
   query14	20267	13181	13663	13181
   query15	363	252	245	245
   query16	6456	292	264	264
   query17	1690	1468	901	901
   query18	2285	414	404	404
   query19	213	147	154	147
   query20	76	78	82	78
   query21	198	93	92	92
   query22	5257	4962	5132	4962
   query23	32417	31945	32098	31945
   query24	6747	6665	6604	6604
   query25	535	440	413	413
   query26	529	164	162	162
   query27	1791	293	295	293
   query28	6118	2347	2313	2313
   query29	2924	2600	2838	2600
   query30	242	170	169	169
   query31	925	705	745	705
   query32	74	67	64	64
   query33	420	263	263	263
   query34	837	483	477	477
   query35	1120	926	903	903
   query36	1397	1259	1121	1121
   query37	92	61	61	61
   query38	3074	2926	2952	2926
   query39	1371	1327	1302	1302
   query40	214	96	96	96
   query41	46	44	45	44
   query42	84	90	84	84
   query43	687	692	642	642
   query44	1123	724	724	724
   query45	246	239	230	230
   query46	1228	982	977	977
   query47	1741	1626	1793	1626
   query48	1002	711	686	686
   query49	617	376	380	376
   query50	851	621	594	594
   query51	4728	4641	4699	4641
   query52	90	83	93	83
   query53	442	317	320	317
   query54	2638	2432	2483	2432
   query55	92	84	84	84
   query56	247	223	211	211
   query57	1206	1128	1145	1128
   query58	215	219	178	178
   query59	4142	3809	4094	3809
   query60	222	191	208	191
   query61	100	99	98	98
   query62	846	512	505	505
   query63	484	346	341	341
   query64	2565	1538	1454	1454
   query65	3653	3542	3623	3542
   query66	782	382	383	382
   query67	15479	17326	15341	15341
   query68	9367	637	647	637
   query69	598	345	355	345
   query70	1710	1299	1356	1299
   query71	424	293	315	293
   query72	6525	3498	3498	3498
   query73	730	325	315	315
   query74	6346	5896	5872	5872
   query75	5524	3741	3661	3661
   query76	5597	1118	1209	1118
   query77	996	258	258	258
   query78	12890	11666	12203	11666
   query79	8916	627	627	627
   query80	1002	395	411	395
   query81	486	237	235	235
   query82	1075	107	94	94
   query83	178	133	129	129
   query84	256	70	73	70
   query85	891	344	349	344
   query86	342	293	289	289
   query87	3275	3034	3016	3016
   query88	4485	2329	2323	2323
   query89	477	276	272	272
   query90	2108	202	208	202
   query91	180	139	143	139
   query92	61	54	54	54
   query93	6992	579	586	579
   query94	742	210	209	209
   query95	1082	1056	1075	1056
   query96	645	329	309	309
   query97	6569	6448	6373	6373
   query98	191	169	173	169
   query99	2909	886	794	794
   Total cold run time: 318899 ms
   Total hot run time: 203878 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2217865021

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.6 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 57e26f718993e428e08ca383c66e29a75a01439c, data reload: false
   
   query1	0.02	0.03	0.02
   query2	0.07	0.02	0.02
   query3	0.24	0.03	0.04
   query4	1.81	0.07	0.07
   query5	0.53	0.53	0.53
   query6	1.23	0.62	0.62
   query7	0.01	0.00	0.01
   query8	0.04	0.03	0.02
   query9	0.52	0.49	0.48
   query10	0.53	0.54	0.54
   query11	0.12	0.08	0.09
   query12	0.11	0.10	0.09
   query13	0.62	0.62	0.61
   query14	0.78	0.80	0.81
   query15	0.79	0.76	0.76
   query16	0.36	0.36	0.38
   query17	1.03	1.04	1.01
   query18	0.22	0.24	0.25
   query19	1.93	1.87	1.84
   query20	0.01	0.01	0.02
   query21	15.47	0.56	0.56
   query22	1.88	1.72	1.73
   query23	17.39	0.96	1.18
   query24	6.92	1.25	0.70
   query25	0.41	0.09	0.06
   query26	0.66	0.16	0.15
   query27	0.05	0.03	0.05
   query28	6.32	0.80	0.73
   query29	12.62	2.24	2.18
   query30	0.63	0.59	0.54
   query31	2.81	0.40	0.37
   query32	3.36	0.50	0.50
   query33	3.07	3.09	3.04
   query34	15.26	4.84	4.82
   query35	4.86	4.86	4.87
   query36	1.07	1.02	1.00
   query37	0.06	0.05	0.04
   query38	0.04	0.02	0.02
   query39	0.02	0.02	0.01
   query40	0.15	0.14	0.15
   query41	0.07	0.02	0.01
   query42	0.02	0.01	0.02
   query43	0.02	0.02	0.02
   Total cold run time: 104.13 s
   Total hot run time: 30.6 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "sollhui (via GitHub)" <gi...@apache.org>.
sollhui commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2214051860

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2213208283

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2213238981

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 50107 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 f7d7f30bae82c02b48f01f2bf86d4e8957c61187, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17536	4355	4330	4330
   q2	2070	155	149	149
   q3	10267	1896	1924	1896
   q4	10112	1234	1323	1234
   q5	8404	3958	3884	3884
   q6	230	122	125	122
   q7	2056	1597	1607	1597
   q8	9283	2769	2719	2719
   q9	10568	10966	10600	10600
   q10	8653	3542	3556	3542
   q11	419	255	246	246
   q12	469	308	307	307
   q13	18383	3947	4058	3947
   q14	345	325	331	325
   q15	523	454	466	454
   q16	678	574	580	574
   q17	1136	953	970	953
   q18	7189	6743	6882	6743
   q19	1772	1639	1619	1619
   q20	539	321	322	321
   q21	4451	4107	4103	4103
   q22	535	444	442	442
   Total cold run time: 115618 ms
   Total hot run time: 50107 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4300	4286	4307	4286
   q2	321	227	230	227
   q3	4154	4157	4137	4137
   q4	2742	2753	2752	2752
   q5	7181	7199	7214	7199
   q6	234	120	117	117
   q7	3233	2887	2853	2853
   q8	4374	4483	4489	4483
   q9	16895	16870	16759	16759
   q10	4265	4296	4302	4296
   q11	754	683	655	655
   q12	1038	842	857	842
   q13	6985	3744	3737	3737
   q14	456	422	423	422
   q15	509	464	449	449
   q16	729	684	666	666
   q17	3868	3808	3893	3808
   q18	8868	8774	8815	8774
   q19	1743	1726	1658	1658
   q20	2366	2157	2120	2120
   q21	8550	8440	8530	8440
   q22	1076	975	1001	975
   Total cold run time: 84641 ms
   Total hot run time: 79655 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2219462476

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2219635740

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2219496258

   TeamCity be ut coverage result:
    Function Coverage: 37.88% (8113/21419) 
    Line Coverage: 29.55% (66495/225013)
    Region Coverage: 29.01% (34262/118088)
    Branch Coverage: 24.89% (17601/70718)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/e2d930f696e251cc9ee845ff120b0eacfe285d5c_e2d930f696e251cc9ee845ff120b0eacfe285d5c/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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2217800393

   TeamCity be ut coverage result:
    Function Coverage: 37.89% (8115/21419) 
    Line Coverage: 29.56% (66506/225013)
    Region Coverage: 29.02% (34268/118088)
    Branch Coverage: 24.89% (17602/70718)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/57e26f718993e428e08ca383c66e29a75a01439c_57e26f718993e428e08ca383c66e29a75a01439c/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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2218023844

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 203842 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 b40db4560de04d5017f873813e5f036c95406cad, data reload: false
   
   query1	931	420	377	377
   query2	6545	2801	2683	2683
   query3	6920	204	202	202
   query4	21240	17981	18054	17981
   query5	19724	6568	6517	6517
   query6	280	222	232	222
   query7	4149	295	311	295
   query8	399	406	385	385
   query9	3092	2644	2583	2583
   query10	402	310	298	298
   query11	11374	10629	10656	10629
   query12	118	78	74	74
   query13	5609	691	686	686
   query14	17827	13315	13236	13236
   query15	363	244	232	232
   query16	6482	291	262	262
   query17	1706	1432	899	899
   query18	2307	417	417	417
   query19	211	151	153	151
   query20	74	80	81	80
   query21	197	100	98	98
   query22	5279	5037	5070	5037
   query23	32582	32011	32129	32011
   query24	6975	6566	6510	6510
   query25	522	422	433	422
   query26	529	165	160	160
   query27	1885	303	291	291
   query28	6110	2361	2308	2308
   query29	2907	2616	2783	2616
   query30	243	161	166	161
   query31	921	734	756	734
   query32	68	66	59	59
   query33	392	247	242	242
   query34	839	490	490	490
   query35	1128	952	814	814
   query36	1419	1161	1138	1138
   query37	90	61	63	61
   query38	3073	2897	2915	2897
   query39	1374	1337	1320	1320
   query40	200	93	96	93
   query41	47	43	43	43
   query42	91	86	89	86
   query43	713	755	720	720
   query44	1142	725	735	725
   query45	247	236	238	236
   query46	1218	955	964	955
   query47	1942	1656	1716	1656
   query48	1016	722	710	710
   query49	623	375	384	375
   query50	853	596	639	596
   query51	4771	4656	4639	4639
   query52	90	79	79	79
   query53	450	321	321	321
   query54	2683	2512	2489	2489
   query55	89	83	84	83
   query56	239	226	209	209
   query57	1256	1179	1095	1095
   query58	226	208	191	191
   query59	4332	4153	3768	3768
   query60	204	196	219	196
   query61	98	93	96	93
   query62	782	461	490	461
   query63	491	346	339	339
   query64	2356	1529	1487	1487
   query65	3644	3569	3574	3569
   query66	761	374	389	374
   query67	15306	15176	16728	15176
   query68	10531	655	656	655
   query69	573	333	336	333
   query70	2119	1373	1372	1372
   query71	427	298	296	296
   query72	6536	3498	3497	3497
   query73	734	316	321	316
   query74	6423	5808	5831	5808
   query75	5525	3729	3775	3729
   query76	6851	1176	1220	1176
   query77	1186	259	254	254
   query78	12880	12181	12975	12181
   query79	10376	653	629	629
   query80	816	393	400	393
   query81	458	241	231	231
   query82	677	98	101	98
   query83	165	132	129	129
   query84	257	72	74	72
   query85	889	333	349	333
   query86	321	336	294	294
   query87	3234	3054	3066	3054
   query88	4167	2329	2322	2322
   query89	482	306	300	300
   query90	1876	216	216	216
   query91	172	148	136	136
   query92	59	56	50	50
   query93	6165	603	560	560
   query94	659	210	210	210
   query95	1129	1067	1053	1053
   query96	639	337	330	330
   query97	6389	6443	6511	6443
   query98	206	177	174	174
   query99	2800	856	918	856
   Total cold run time: 317877 ms
   Total hot run time: 203842 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2219485929

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 203533 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 e2d930f696e251cc9ee845ff120b0eacfe285d5c, data reload: false
   
   query1	916	422	385	385
   query2	6557	2809	2894	2809
   query3	6926	210	207	207
   query4	20033	18048	18084	18048
   query5	19741	6546	6565	6546
   query6	300	221	224	221
   query7	4162	297	308	297
   query8	485	394	375	375
   query9	3069	2663	2579	2579
   query10	403	309	303	303
   query11	11275	10708	10668	10668
   query12	126	81	78	78
   query13	5604	715	714	714
   query14	17384	13430	13191	13191
   query15	403	243	250	243
   query16	6474	294	265	265
   query17	1706	1441	883	883
   query18	2324	428	415	415
   query19	218	153	155	153
   query20	84	78	79	78
   query21	193	100	98	98
   query22	5221	4914	4945	4914
   query23	32554	31966	31819	31819
   query24	7017	6612	6510	6510
   query25	521	450	428	428
   query26	542	169	160	160
   query27	1884	298	295	295
   query28	6204	2367	2313	2313
   query29	2847	2638	2701	2638
   query30	245	167	169	167
   query31	894	720	758	720
   query32	70	69	64	64
   query33	392	265	260	260
   query34	881	483	497	483
   query35	1108	956	936	936
   query36	1382	1115	1084	1084
   query37	95	63	60	60
   query38	3081	2938	2920	2920
   query39	1389	1335	1316	1316
   query40	205	93	97	93
   query41	46	44	44	44
   query42	85	87	81	81
   query43	690	775	759	759
   query44	1162	738	733	733
   query45	250	241	232	232
   query46	1245	965	980	965
   query47	1829	1789	1696	1696
   query48	1030	729	718	718
   query49	633	379	367	367
   query50	884	626	623	623
   query51	4723	4669	4702	4669
   query52	90	92	90	90
   query53	444	323	331	323
   query54	2651	2483	2490	2483
   query55	96	81	85	81
   query56	244	218	204	204
   query57	1311	1132	1050	1050
   query58	201	211	199	199
   query59	4079	3926	4177	3926
   query60	220	201	211	201
   query61	99	94	97	94
   query62	796	524	470	470
   query63	486	345	345	345
   query64	2568	1513	1456	1456
   query65	3622	3582	3558	3558
   query66	791	375	387	375
   query67	15335	16094	15244	15244
   query68	9425	663	648	648
   query69	567	344	351	344
   query70	1569	1433	1488	1433
   query71	415	315	336	315
   query72	6606	3533	3478	3478
   query73	727	325	316	316
   query74	6353	5832	5816	5816
   query75	5345	3744	3783	3744
   query76	6006	1161	1185	1161
   query77	1003	274	256	256
   query78	12627	11671	11754	11671
   query79	8436	639	648	639
   query80	1320	405	417	405
   query81	494	231	237	231
   query82	1696	106	97	97
   query83	171	135	135	135
   query84	267	74	73	73
   query85	895	336	343	336
   query86	342	299	280	280
   query87	3283	3003	3011	3003
   query88	4932	2338	2345	2338
   query89	383	289	285	285
   query90	1935	215	196	196
   query91	170	137	154	137
   query92	60	55	59	55
   query93	6582	573	576	573
   query94	702	213	218	213
   query95	1089	1065	1052	1052
   query96	664	338	326	326
   query97	6505	6294	6447	6294
   query98	206	179	174	174
   query99	2850	787	930	787
   Total cold run time: 314150 ms
   Total hot run time: 203533 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2214154670

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 204191 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 22b11bd86fc65c8da3ac5df1586b743546dd3bcf, data reload: false
   
   query1	933	422	370	370
   query2	6544	2862	2852	2852
   query3	6917	217	207	207
   query4	21378	18121	18070	18070
   query5	19741	6518	6547	6518
   query6	301	224	240	224
   query7	4157	305	305	305
   query8	448	419	462	419
   query9	3170	2721	2651	2651
   query10	420	306	295	295
   query11	11337	10759	10753	10753
   query12	118	81	70	70
   query13	5595	701	720	701
   query14	17878	13547	13832	13547
   query15	360	253	243	243
   query16	6463	287	275	275
   query17	1681	1440	891	891
   query18	2309	422	409	409
   query19	217	152	151	151
   query20	79	77	81	77
   query21	191	94	94	94
   query22	5032	4921	4885	4885
   query23	32623	31886	31987	31886
   query24	6963	6554	6508	6508
   query25	539	429	427	427
   query26	532	162	159	159
   query27	1897	306	301	301
   query28	6218	2378	2295	2295
   query29	2864	2838	2712	2712
   query30	240	169	165	165
   query31	950	735	761	735
   query32	70	66	62	62
   query33	405	269	253	253
   query34	873	491	490	490
   query35	1120	942	931	931
   query36	1348	1074	1433	1074
   query37	89	62	59	59
   query38	3081	2917	2883	2883
   query39	1363	1329	1311	1311
   query40	210	98	97	97
   query41	55	45	45	45
   query42	79	90	85	85
   query43	674	785	636	636
   query44	1147	720	740	720
   query45	244	228	237	228
   query46	1231	983	966	966
   query47	1989	1814	1693	1693
   query48	1028	722	739	722
   query49	622	387	384	384
   query50	881	639	619	619
   query51	4789	4654	4623	4623
   query52	103	85	89	85
   query53	451	325	324	324
   query54	2669	2493	2471	2471
   query55	93	84	87	84
   query56	223	219	214	214
   query57	1269	1124	1231	1124
   query58	224	201	203	201
   query59	4275	3877	3783	3783
   query60	210	214	202	202
   query61	99	96	99	96
   query62	761	447	480	447
   query63	486	354	348	348
   query64	2520	1551	1498	1498
   query65	3686	3598	3582	3582
   query66	816	379	389	379
   query67	16141	15299	15912	15299
   query68	10427	660	680	660
   query69	577	352	352	352
   query70	2274	1409	1331	1331
   query71	418	313	313	313
   query72	6623	3511	3460	3460
   query73	761	339	322	322
   query74	6417	5810	5821	5810
   query75	5462	3681	3700	3681
   query76	6856	1190	1222	1190
   query77	1189	256	261	256
   query78	12610	11858	14230	11858
   query79	9669	641	660	641
   query80	946	404	427	404
   query81	488	233	232	232
   query82	503	98	102	98
   query83	172	132	131	131
   query84	259	72	70	70
   query85	875	329	330	329
   query86	340	288	288	288
   query87	3234	3006	2977	2977
   query88	4474	2396	2390	2390
   query89	397	303	307	303
   query90	1984	198	207	198
   query91	180	140	156	140
   query92	59	55	53	53
   query93	3425	552	592	552
   query94	716	213	212	212
   query95	1142	1052	1060	1052
   query96	649	343	334	334
   query97	6471	6327	6500	6327
   query98	187	173	177	173
   query99	2991	912	841	841
   Total cold run time: 316194 ms
   Total hot run time: 204191 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2217964836

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2217872470

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 57e26f718993e428e08ca383c66e29a75a01439c with default session variables
   Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 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:       21.8 seconds inserted 10000000 Rows, about 458K 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2217993261

   TeamCity be ut coverage result:
    Function Coverage: 37.89% (8115/21419) 
    Line Coverage: 29.56% (66511/225013)
    Region Coverage: 29.02% (34271/118088)
    Branch Coverage: 24.89% (17600/70718)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/b40db4560de04d5017f873813e5f036c95406cad_b40db4560de04d5017f873813e5f036c95406cad/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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2217996587

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 50031 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 b40db4560de04d5017f873813e5f036c95406cad, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17894	4418	4366	4366
   q2	2089	157	152	152
   q3	10263	1908	1937	1908
   q4	10109	1228	1317	1228
   q5	8853	4026	3928	3928
   q6	228	152	128	128
   q7	2050	1609	1573	1573
   q8	9583	2742	2957	2742
   q9	12907	10491	10509	10491
   q10	8657	3474	3505	3474
   q11	421	241	255	241
   q12	473	302	299	299
   q13	18334	3975	3999	3975
   q14	343	339	331	331
   q15	498	480	466	466
   q16	653	581	590	581
   q17	1155	955	900	900
   q18	7223	6843	6844	6843
   q19	1760	1647	1595	1595
   q20	543	315	295	295
   q21	4419	4119	4083	4083
   q22	539	454	432	432
   Total cold run time: 118994 ms
   Total hot run time: 50031 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4325	4285	4263	4263
   q2	314	226	221	221
   q3	4170	4116	4110	4110
   q4	2775	2768	2739	2739
   q5	7246	7111	7111	7111
   q6	245	120	120	120
   q7	3239	2904	2841	2841
   q8	4414	4423	4523	4423
   q9	17370	16940	17203	16940
   q10	4221	4262	4258	4258
   q11	794	679	650	650
   q12	1048	869	864	864
   q13	6643	3794	3750	3750
   q14	443	425	435	425
   q15	504	458	451	451
   q16	729	680	671	671
   q17	3839	3829	3852	3829
   q18	8809	8662	8753	8662
   q19	1712	1643	1674	1643
   q20	2367	2138	2105	2105
   q21	8641	8396	8569	8396
   q22	1027	988	991	988
   Total cold run time: 84875 ms
   Total hot run time: 79460 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2219490457

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.55 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 e2d930f696e251cc9ee845ff120b0eacfe285d5c, data reload: false
   
   query1	0.03	0.02	0.02
   query2	0.07	0.03	0.02
   query3	0.24	0.04	0.04
   query4	1.79	0.07	0.06
   query5	0.55	0.53	0.52
   query6	1.31	0.63	0.62
   query7	0.02	0.01	0.00
   query8	0.03	0.03	0.02
   query9	0.53	0.48	0.47
   query10	0.54	0.53	0.54
   query11	0.11	0.09	0.08
   query12	0.12	0.09	0.09
   query13	0.62	0.61	0.61
   query14	0.78	0.79	0.80
   query15	0.78	0.77	0.77
   query16	0.37	0.37	0.36
   query17	1.01	1.01	1.02
   query18	0.23	0.26	0.22
   query19	1.95	1.82	1.85
   query20	0.01	0.00	0.01
   query21	15.48	0.57	0.56
   query22	2.28	2.80	1.42
   query23	17.15	1.08	0.94
   query24	4.33	0.96	1.17
   query25	0.35	0.11	0.06
   query26	0.48	0.16	0.17
   query27	0.04	0.04	0.04
   query28	8.65	0.77	0.73
   query29	12.62	2.33	2.29
   query30	0.66	0.60	0.53
   query31	2.81	0.39	0.38
   query32	3.37	0.49	0.50
   query33	3.08	3.05	3.07
   query34	15.24	4.79	4.79
   query35	4.88	4.84	4.85
   query36	1.05	1.00	1.03
   query37	0.06	0.04	0.05
   query38	0.03	0.03	0.03
   query39	0.03	0.01	0.01
   query40	0.16	0.14	0.14
   query41	0.06	0.01	0.02
   query42	0.02	0.02	0.01
   query43	0.02	0.02	0.02
   Total cold run time: 103.94 s
   Total hot run time: 30.55 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2219635700

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2217752198

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2213256087

   TeamCity be ut coverage result:
    Function Coverage: 37.89% (8114/21417) 
    Line Coverage: 29.56% (66489/224940)
    Region Coverage: 29.02% (34265/118058)
    Branch Coverage: 24.90% (17600/70694)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/f7d7f30bae82c02b48f01f2bf86d4e8957c61187_f7d7f30bae82c02b48f01f2bf86d4e8957c61187/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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2219493434

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit e2d930f696e251cc9ee845ff120b0eacfe285d5c with default session variables
   Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 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:       21.3 seconds inserted 10000000 Rows, about 469K 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2214065370

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "sollhui (via GitHub)" <gi...@apache.org>.
sollhui commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2214070554

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2214114620

   TeamCity be ut coverage result:
    Function Coverage: 37.89% (8115/21417) 
    Line Coverage: 29.56% (66508/224958)
    Region Coverage: 29.03% (34272/118065)
    Branch Coverage: 24.90% (17603/70702)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/22b11bd86fc65c8da3ac5df1586b743546dd3bcf_22b11bd86fc65c8da3ac5df1586b743546dd3bcf/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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2214167497

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.12 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 22b11bd86fc65c8da3ac5df1586b743546dd3bcf, data reload: false
   
   query1	0.03	0.02	0.02
   query2	0.07	0.02	0.02
   query3	0.25	0.05	0.04
   query4	1.78	0.07	0.07
   query5	0.54	0.52	0.51
   query6	1.24	0.60	0.61
   query7	0.02	0.01	0.01
   query8	0.03	0.03	0.02
   query9	0.54	0.48	0.48
   query10	0.54	0.54	0.53
   query11	0.12	0.08	0.09
   query12	0.11	0.09	0.09
   query13	0.62	0.62	0.61
   query14	0.79	0.79	0.78
   query15	0.79	0.76	0.76
   query16	0.38	0.38	0.37
   query17	1.01	1.03	1.00
   query18	0.23	0.25	0.22
   query19	1.95	1.86	1.84
   query20	0.02	0.01	0.01
   query21	15.47	0.56	0.55
   query22	2.20	2.40	1.45
   query23	17.29	1.05	0.95
   query24	4.43	3.10	1.51
   query25	0.39	0.11	0.04
   query26	0.77	0.16	0.16
   query27	0.05	0.04	0.04
   query28	6.18	0.76	0.76
   query29	12.61	2.34	2.28
   query30	0.61	0.55	0.53
   query31	2.80	0.38	0.37
   query32	3.37	0.50	0.49
   query33	3.09	3.07	3.08
   query34	15.26	4.80	4.77
   query35	4.86	4.84	4.84
   query36	1.05	1.01	1.02
   query37	0.06	0.05	0.05
   query38	0.03	0.02	0.02
   query39	0.02	0.02	0.01
   query40	0.16	0.14	0.13
   query41	0.06	0.02	0.01
   query42	0.02	0.02	0.01
   query43	0.03	0.02	0.01
   Total cold run time: 101.87 s
   Total hot run time: 31.12 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2213197223

   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
   
   Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
   See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).


-- 
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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2217824414

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 50044 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 57e26f718993e428e08ca383c66e29a75a01439c, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17617	4390	4367	4367
   q2	2065	157	147	147
   q3	10268	1926	1916	1916
   q4	10337	1254	1320	1254
   q5	8580	3860	3881	3860
   q6	225	146	126	126
   q7	2035	1599	1601	1599
   q8	9290	2729	2708	2708
   q9	10850	10700	10460	10460
   q10	8655	3504	3537	3504
   q11	425	245	252	245
   q12	468	307	305	305
   q13	18317	3945	4065	3945
   q14	363	326	333	326
   q15	527	465	470	465
   q16	679	565	572	565
   q17	1125	950	946	946
   q18	7369	6898	6893	6893
   q19	1761	1614	1598	1598
   q20	523	302	289	289
   q21	4448	4081	4120	4081
   q22	528	445	446	445
   Total cold run time: 116455 ms
   Total hot run time: 50044 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4277	4282	4274	4274
   q2	321	224	225	224
   q3	4186	4159	4146	4146
   q4	2738	2739	2761	2739
   q5	7244	7112	7200	7112
   q6	236	121	119	119
   q7	3225	2885	2798	2798
   q8	4363	4515	4523	4515
   q9	17398	17117	16968	16968
   q10	4269	4219	4267	4219
   q11	765	707	676	676
   q12	1042	837	881	837
   q13	6794	3778	3748	3748
   q14	452	452	425	425
   q15	509	459	452	452
   q16	730	686	673	673
   q17	3785	3827	4003	3827
   q18	8824	8838	8834	8834
   q19	1699	1719	1670	1670
   q20	2404	2176	2131	2131
   q21	8605	8557	8498	8498
   q22	1075	994	977	977
   Total cold run time: 84941 ms
   Total hot run time: 79862 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2218035687

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.08 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 b40db4560de04d5017f873813e5f036c95406cad, data reload: false
   
   query1	0.01	0.02	0.02
   query2	0.06	0.02	0.02
   query3	0.24	0.04	0.04
   query4	1.79	0.06	0.06
   query5	0.52	0.52	0.52
   query6	1.23	0.65	0.67
   query7	0.02	0.01	0.02
   query8	0.03	0.02	0.02
   query9	0.53	0.49	0.48
   query10	0.54	0.54	0.54
   query11	0.12	0.09	0.09
   query12	0.12	0.09	0.09
   query13	0.61	0.60	0.60
   query14	0.78	0.79	0.78
   query15	0.76	0.76	0.75
   query16	0.36	0.39	0.36
   query17	1.01	1.00	1.01
   query18	0.23	0.24	0.24
   query19	1.92	1.78	1.79
   query20	0.01	0.01	0.00
   query21	15.51	0.56	0.58
   query22	2.04	2.15	1.58
   query23	17.41	1.01	1.03
   query24	6.89	1.27	1.33
   query25	0.37	0.10	0.06
   query26	0.81	0.17	0.15
   query27	0.04	0.03	0.03
   query28	5.66	0.77	0.74
   query29	12.62	2.35	2.31
   query30	0.64	0.53	0.51
   query31	2.81	0.40	0.37
   query32	3.37	0.50	0.49
   query33	3.09	3.11	3.03
   query34	15.27	4.83	4.79
   query35	4.90	4.87	4.87
   query36	1.05	1.01	1.03
   query37	0.06	0.04	0.04
   query38	0.03	0.03	0.03
   query39	0.02	0.01	0.01
   query40	0.16	0.14	0.13
   query41	0.07	0.02	0.02
   query42	0.02	0.01	0.02
   query43	0.02	0.02	0.01
   Total cold run time: 103.75 s
   Total hot run time: 31.08 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2217751395

   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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2219476084

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 50095 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 e2d930f696e251cc9ee845ff120b0eacfe285d5c, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17870	4443	4363	4363
   q2	2086	159	150	150
   q3	10412	1920	1988	1920
   q4	10291	1261	1345	1261
   q5	8664	3910	3951	3910
   q6	264	127	128	127
   q7	2053	1618	1608	1608
   q8	9317	2751	2720	2720
   q9	10698	10412	10276	10276
   q10	8617	3533	3509	3509
   q11	426	252	247	247
   q12	479	312	305	305
   q13	18349	3950	4088	3950
   q14	354	328	325	325
   q15	525	461	470	461
   q16	680	578	589	578
   q17	1142	982	986	982
   q18	7374	6860	6911	6860
   q19	1767	1705	1674	1674
   q20	524	326	315	315
   q21	4438	4147	4111	4111
   q22	549	443	448	443
   Total cold run time: 116879 ms
   Total hot run time: 50095 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4294	4282	4318	4282
   q2	329	226	223	223
   q3	4228	4157	4125	4125
   q4	2775	2745	2766	2745
   q5	7176	7189	7143	7143
   q6	236	121	118	118
   q7	3283	2877	2854	2854
   q8	4365	4509	4547	4509
   q9	16967	16867	16868	16867
   q10	4269	4331	4311	4311
   q11	761	691	680	680
   q12	1048	862	886	862
   q13	6698	3758	3717	3717
   q14	451	430	433	430
   q15	510	468	465	465
   q16	737	684	681	681
   q17	3790	3836	3796	3796
   q18	8834	8926	8869	8869
   q19	1734	1749	1657	1657
   q20	2429	2121	2127	2121
   q21	8496	8607	8588	8588
   q22	1008	955	953	953
   Total cold run time: 84418 ms
   Total hot run time: 79996 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2213276633

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit f7d7f30bae82c02b48f01f2bf86d4e8957c61187 with default session variables
   Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 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:       21.1 seconds inserted 10000000 Rows, about 473K 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] [chore](routine-load) optimize out of range error message (#36450) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37456:
URL: https://github.com/apache/doris/pull/37456#issuecomment-2214119631

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 49872 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 22b11bd86fc65c8da3ac5df1586b743546dd3bcf, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17750	4366	4332	4332
   q2	2069	153	158	153
   q3	10270	1906	1930	1906
   q4	10113	1234	1343	1234
   q5	8393	4004	3872	3872
   q6	256	125	127	125
   q7	2046	1601	1597	1597
   q8	9521	2736	2706	2706
   q9	13852	10264	10218	10218
   q10	8632	3563	3536	3536
   q11	405	260	236	236
   q12	472	306	303	303
   q13	18358	3971	4024	3971
   q14	356	340	323	323
   q15	499	453	454	453
   q16	675	580	575	575
   q17	1134	937	878	878
   q18	7347	7007	7021	7007
   q19	1795	1617	1615	1615
   q20	546	315	299	299
   q21	4436	4146	4095	4095
   q22	533	438	465	438
   Total cold run time: 119458 ms
   Total hot run time: 49872 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4368	4315	4283	4283
   q2	318	235	223	223
   q3	4174	4109	4141	4109
   q4	2763	2730	2747	2730
   q5	7150	7130	7106	7106
   q6	238	120	121	120
   q7	3143	2818	2831	2818
   q8	4393	4504	4508	4504
   q9	16938	16813	16889	16813
   q10	4209	4218	4256	4218
   q11	752	680	737	680
   q12	1011	846	849	846
   q13	6915	3685	3694	3685
   q14	450	428	427	427
   q15	494	459	446	446
   q16	729	670	688	670
   q17	3769	3893	3841	3841
   q18	8793	8720	8787	8720
   q19	1728	1665	1682	1665
   q20	2376	2126	2125	2125
   q21	8449	8537	8473	8473
   q22	999	953	1007	953
   Total cold run time: 84159 ms
   Total hot run time: 79455 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