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

[PR] [fix](readconsistency) avoid table not exist error #37593 [doris]

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

   pick #37593
   
   ## Proposed changes
   
   Issue Number: close #xxx
   
   <!--Describe your changes.-->
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](readconsistency) avoid table not exist error #37593 [doris]

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


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](readconsistency) avoid table not exist error #37593 [doris]

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

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](readconsistency) avoid table not exist error #37593 [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.54 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 95484dafcd789b546708b4898770c4e55784cbe0, data reload: false
   
   query1	0.02	0.02	0.02
   query2	0.07	0.03	0.02
   query3	0.25	0.05	0.05
   query4	1.79	0.07	0.07
   query5	0.54	0.52	0.51
   query6	1.25	0.61	0.60
   query7	0.02	0.01	0.01
   query8	0.04	0.03	0.03
   query9	0.52	0.50	0.47
   query10	0.56	0.55	0.54
   query11	0.11	0.08	0.08
   query12	0.12	0.10	0.09
   query13	0.62	0.61	0.62
   query14	0.78	0.79	0.80
   query15	0.79	0.76	0.76
   query16	0.39	0.36	0.38
   query17	1.03	1.00	1.03
   query18	0.21	0.28	0.24
   query19	1.91	1.84	1.80
   query20	0.01	0.01	0.01
   query21	15.45	0.54	0.54
   query22	2.30	2.16	1.50
   query23	16.96	0.87	0.82
   query24	5.56	1.04	1.19
   query25	0.41	0.09	0.05
   query26	0.61	0.16	0.15
   query27	0.04	0.05	0.04
   query28	7.38	0.76	0.74
   query29	12.71	2.36	2.31
   query30	0.63	0.56	0.54
   query31	2.81	0.40	0.36
   query32	3.35	0.50	0.50
   query33	3.09	3.06	3.05
   query34	15.24	4.76	4.80
   query35	4.85	4.85	4.82
   query36	1.06	1.02	1.01
   query37	0.06	0.05	0.05
   query38	0.04	0.02	0.02
   query39	0.02	0.02	0.01
   query40	0.16	0.14	0.14
   query41	0.06	0.01	0.02
   query42	0.02	0.01	0.01
   query43	0.02	0.01	0.02
   Total cold run time: 103.86 s
   Total hot run time: 30.54 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] [fix](readconsistency) avoid table not exist error #37593 [doris]

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

   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] [fix](readconsistency) avoid table not exist error #37593 [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 49647 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 95484dafcd789b546708b4898770c4e55784cbe0, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17814	4363	4296	4296
   q2	2073	158	146	146
   q3	10272	1885	1932	1885
   q4	10348	1235	1314	1235
   q5	8839	3853	3843	3843
   q6	248	124	122	122
   q7	2024	1594	1619	1594
   q8	9305	2720	2686	2686
   q9	10560	10267	10255	10255
   q10	8658	3460	3455	3455
   q11	419	248	251	248
   q12	472	303	315	303
   q13	18353	3953	3968	3953
   q14	351	327	333	327
   q15	514	462	470	462
   q16	673	567	582	567
   q17	1139	946	976	946
   q18	7188	6865	6841	6841
   q19	1764	1663	1641	1641
   q20	521	300	297	297
   q21	4442	4130	4097	4097
   q22	521	458	448	448
   Total cold run time: 116498 ms
   Total hot run time: 49647 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4320	4276	4278	4276
   q2	321	232	225	225
   q3	4186	4116	4131	4116
   q4	2747	2747	2729	2729
   q5	7103	7172	7107	7107
   q6	236	121	119	119
   q7	3237	2916	2812	2812
   q8	4353	4454	4522	4454
   q9	16851	16675	16652	16652
   q10	4249	4225	4235	4225
   q11	766	684	694	684
   q12	1048	850	876	850
   q13	7059	3760	3768	3760
   q14	475	431	434	431
   q15	511	462	466	462
   q16	730	690	682	682
   q17	3844	3848	3879	3848
   q18	8672	8780	8832	8780
   q19	1741	1691	1663	1663
   q20	2360	2198	2096	2096
   q21	8581	8459	8425	8425
   q22	1026	948	979	948
   Total cold run time: 84416 ms
   Total hot run time: 79344 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] [fix](readconsistency) avoid table not exist error #37593 [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 202999 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 95484dafcd789b546708b4898770c4e55784cbe0, data reload: false
   
   query1	926	424	383	383
   query2	6529	2851	2624	2624
   query3	6917	211	201	201
   query4	20116	18025	17911	17911
   query5	19740	6511	6520	6511
   query6	296	230	232	230
   query7	4162	305	334	305
   query8	483	425	442	425
   query9	3076	2654	2616	2616
   query10	410	292	308	292
   query11	11380	10801	10815	10801
   query12	130	85	75	75
   query13	5606	706	720	706
   query14	17572	13368	13811	13368
   query15	372	244	244	244
   query16	6467	295	266	266
   query17	1733	1439	890	890
   query18	2306	418	420	418
   query19	211	154	148	148
   query20	80	79	81	79
   query21	190	98	92	92
   query22	5181	4999	4970	4970
   query23	32563	31813	31809	31809
   query24	6949	6636	6491	6491
   query25	538	421	425	421
   query26	526	168	162	162
   query27	1883	308	302	302
   query28	6167	2360	2335	2335
   query29	2833	2808	2855	2808
   query30	245	161	169	161
   query31	906	735	759	735
   query32	71	63	62	62
   query33	412	263	267	263
   query34	842	476	460	460
   query35	1128	942	930	930
   query36	1335	1120	1127	1120
   query37	91	60	61	60
   query38	3088	2934	2904	2904
   query39	1387	1325	1323	1323
   query40	209	95	97	95
   query41	47	45	44	44
   query42	85	88	83	83
   query43	930	631	616	616
   query44	1108	735	736	735
   query45	246	235	234	234
   query46	1238	990	997	990
   query47	1936	1738	1640	1640
   query48	1035	735	730	730
   query49	615	368	376	368
   query50	859	613	647	613
   query51	4724	4660	4714	4660
   query52	90	81	76	76
   query53	481	341	325	325
   query54	2642	2449	2464	2449
   query55	94	82	80	80
   query56	211	225	194	194
   query57	1107	1008	1154	1008
   query58	209	197	201	197
   query59	4212	3914	3813	3813
   query60	212	221	213	213
   query61	100	96	94	94
   query62	871	450	512	450
   query63	482	354	346	346
   query64	2598	1530	1486	1486
   query65	3660	3525	3558	3525
   query66	778	371	380	371
   query67	16643	15175	15279	15175
   query68	8922	669	669	669
   query69	577	352	367	352
   query70	1614	1313	1392	1313
   query71	423	310	331	310
   query72	6517	3500	3547	3500
   query73	734	328	321	321
   query74	6287	5841	5851	5841
   query75	5339	3677	3715	3677
   query76	5451	1186	1211	1186
   query77	907	271	260	260
   query78	12664	11421	11784	11421
   query79	9038	649	632	632
   query80	1419	409	400	400
   query81	489	238	240	238
   query82	1629	105	99	99
   query83	183	139	137	137
   query84	263	70	71	70
   query85	878	342	335	335
   query86	335	295	287	287
   query87	3227	3021	2993	2993
   query88	4702	2346	2336	2336
   query89	480	311	294	294
   query90	1936	210	204	204
   query91	174	155	140	140
   query92	60	55	55	55
   query93	6579	583	560	560
   query94	690	213	215	213
   query95	1132	1069	1046	1046
   query96	646	332	329	329
   query97	6453	6307	6426	6307
   query98	200	175	171	171
   query99	3009	857	792	792
   Total cold run time: 315226 ms
   Total hot run time: 202999 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] [fix](readconsistency) avoid table not exist error #37593 [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 95484dafcd789b546708b4898770c4e55784cbe0 with default session variables
   Stream load json:         21 seconds loaded 2358488459 Bytes, about 107 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:       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