You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Mryange (via GitHub)" <gi...@apache.org> on 2024/06/03 15:15:00 UTC

[PR] [feature](join) add hash table build type check [doris]

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

   ## Proposed changes
   
   ```
   ERROR 1105 (HY000): errCode = 2, detailMessage = (127.0.0.1)[INTERNAL_ERROR]build hash table failed , build type = (UInt32) , insert type = (Nullable, (UInt32), (UInt8))
   ```
   
   <!--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] [feature](join) add hash table build type check [doris]

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

   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](join) add hash table build type check [doris]

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

   TeamCity be ut coverage result:
    Function Coverage: 36.23% (9240/25502) 
    Line Coverage: 27.57% (75847/275119)
    Region Coverage: 26.81% (39287/146517)
    Branch Coverage: 23.55% (19903/84530)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/70d135d43da43118cc6a2f284614c163c1195b15_70d135d43da43118cc6a2f284614c163c1195b15/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](join) add hash table build type check [doris]

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

   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](join) add hash table build type check [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.3 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 7380f125a1c086a6af79c8f17f5ef5ea3f370a99, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.08	0.04	0.04
   query3	0.23	0.05	0.04
   query4	1.67	0.08	0.08
   query5	0.52	0.50	0.51
   query6	1.13	0.73	0.73
   query7	0.02	0.01	0.01
   query8	0.06	0.04	0.05
   query9	0.56	0.48	0.50
   query10	0.54	0.56	0.55
   query11	0.16	0.12	0.12
   query12	0.14	0.12	0.12
   query13	0.59	0.59	0.61
   query14	0.77	0.77	0.77
   query15	0.83	0.81	0.81
   query16	0.36	0.37	0.35
   query17	1.00	1.03	1.02
   query18	0.21	0.26	0.22
   query19	1.85	1.70	1.76
   query20	0.02	0.01	0.02
   query21	15.73	0.66	0.65
   query22	3.58	6.99	2.59
   query23	18.29	1.36	1.24
   query24	1.88	0.26	0.21
   query25	0.15	0.08	0.08
   query26	0.29	0.17	0.17
   query27	0.07	0.07	0.09
   query28	13.31	1.08	1.08
   query29	13.17	3.31	3.28
   query30	0.25	0.06	0.05
   query31	2.85	0.38	0.38
   query32	3.27	0.47	0.46
   query33	2.91	2.86	2.93
   query34	17.16	4.42	4.44
   query35	4.45	4.61	4.48
   query36	0.65	0.46	0.45
   query37	0.18	0.15	0.15
   query38	0.15	0.14	0.14
   query39	0.05	0.04	0.04
   query40	0.16	0.15	0.15
   query41	0.09	0.06	0.05
   query42	0.05	0.05	0.05
   query43	0.05	0.04	0.04
   Total cold run time: 109.52 s
   Total hot run time: 31.3 s
   ```
   </details>
   


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

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

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


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


Re: [PR] [feature](join) add hash table build type check [doris]

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

   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](join) add hash table build type check [doris]

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

   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] [feature](join) add hash table build type check [doris]

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

   TeamCity be ut coverage result:
    Function Coverage: 36.24% (9242/25503) 
    Line Coverage: 27.57% (75865/275132)
    Region Coverage: 26.82% (39292/146525)
    Branch Coverage: 23.56% (19914/84538)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/7380f125a1c086a6af79c8f17f5ef5ea3f370a99_7380f125a1c086a6af79c8f17f5ef5ea3f370a99/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](join) add hash table build type check [doris]

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

   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](join) add hash table build type check [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 170876 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 7380f125a1c086a6af79c8f17f5ef5ea3f370a99, data reload: false
   
   query1	917	379	364	364
   query2	6436	2538	2444	2444
   query3	6643	207	207	207
   query4	21986	17269	17372	17269
   query5	4169	471	456	456
   query6	263	163	164	163
   query7	4581	301	296	296
   query8	304	287	286	286
   query9	8529	2370	2381	2370
   query10	453	295	289	289
   query11	10552	9899	9960	9899
   query12	139	90	90	90
   query13	1650	375	381	375
   query14	9941	7856	7565	7565
   query15	242	191	188	188
   query16	7816	273	265	265
   query17	1399	567	571	567
   query18	1898	267	276	267
   query19	199	157	154	154
   query20	93	89	92	89
   query21	203	133	127	127
   query22	4325	4007	4089	4007
   query23	33924	33070	33086	33070
   query24	11018	2820	2833	2820
   query25	610	354	361	354
   query26	1049	157	155	155
   query27	2301	324	330	324
   query28	6175	2066	2057	2057
   query29	892	602	607	602
   query30	286	148	152	148
   query31	950	749	721	721
   query32	99	54	55	54
   query33	780	286	278	278
   query34	954	468	473	468
   query35	759	625	619	619
   query36	1092	935	920	920
   query37	132	66	66	66
   query38	2872	2713	2715	2713
   query39	877	789	779	779
   query40	211	126	126	126
   query41	54	51	52	51
   query42	127	98	99	98
   query43	578	530	564	530
   query44	1285	749	750	749
   query45	202	163	165	163
   query46	1088	735	737	735
   query47	1830	1785	1776	1776
   query48	380	295	295	295
   query49	995	421	420	420
   query50	785	389	383	383
   query51	6961	6858	6692	6692
   query52	104	92	97	92
   query53	353	285	297	285
   query54	880	457	463	457
   query55	75	71	73	71
   query56	284	250	284	250
   query57	1104	1079	1098	1079
   query58	248	252	279	252
   query59	3418	3098	3163	3098
   query60	296	268	274	268
   query61	91	90	85	85
   query62	655	449	441	441
   query63	325	291	293	291
   query64	8745	2235	1779	1779
   query65	3293	3102	3109	3102
   query66	857	318	337	318
   query67	15518	15032	15037	15032
   query68	5357	555	559	555
   query69	591	473	435	435
   query70	1136	1132	1145	1132
   query71	442	288	290	288
   query72	8298	5360	2701	2701
   query73	764	327	328	327
   query74	5861	5466	5513	5466
   query75	3816	2643	2684	2643
   query76	3153	879	886	879
   query77	635	301	298	298
   query78	10268	9860	9627	9627
   query79	2246	523	510	510
   query80	1316	537	457	457
   query81	580	221	221	221
   query82	758	109	100	100
   query83	205	171	171	171
   query84	272	91	84	84
   query85	1273	289	271	271
   query86	457	313	328	313
   query87	3267	3097	3086	3086
   query88	3843	2443	2456	2443
   query89	464	387	393	387
   query90	1803	189	187	187
   query91	125	151	99	99
   query92	63	49	51	49
   query93	2230	510	503	503
   query94	1161	197	187	187
   query95	413	310	310	310
   query96	595	273	272	272
   query97	3248	3024	3022	3022
   query98	261	223	218	218
   query99	1298	832	842	832
   Total cold run time: 274449 ms
   Total hot run time: 170876 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](join) add hash table build type check [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41844 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 7380f125a1c086a6af79c8f17f5ef5ea3f370a99, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17615	4319	4296	4296
   q2	2033	184	189	184
   q3	10482	1168	1191	1168
   q4	10180	816	802	802
   q5	7483	2699	2826	2699
   q6	226	140	145	140
   q7	969	604	611	604
   q8	9215	2129	2099	2099
   q9	9010	6690	6690	6690
   q10	10096	3958	3848	3848
   q11	442	247	250	247
   q12	504	249	241	241
   q13	17474	3212	3287	3212
   q14	271	228	220	220
   q15	516	470	481	470
   q16	500	399	385	385
   q17	986	671	617	617
   q18	8399	7747	7723	7723
   q19	6691	1581	1543	1543
   q20	636	320	319	319
   q21	5341	3999	4052	3999
   q22	402	345	338	338
   Total cold run time: 119471 ms
   Total hot run time: 41844 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4662	4392	4352	4352
   q2	393	272	267	267
   q3	3161	2982	2922	2922
   q4	1877	1616	1600	1600
   q5	5445	5511	5527	5511
   q6	231	125	131	125
   q7	2194	1789	1780	1780
   q8	3232	3397	3386	3386
   q9	8643	8545	8726	8545
   q10	4056	3876	3807	3807
   q11	605	492	483	483
   q12	772	576	595	576
   q13	17033	3136	3111	3111
   q14	309	258	278	258
   q15	516	481	499	481
   q16	479	438	431	431
   q17	1810	1508	1488	1488
   q18	8088	7471	7476	7471
   q19	1775	1566	1554	1554
   q20	3040	1788	1750	1750
   q21	8692	4733	4868	4733
   q22	626	547	561	547
   Total cold run time: 77639 ms
   Total hot run time: 55178 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](join) add hash table build type check [doris]

Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange closed pull request #35825: [feature](join) add hash table build type check
URL: https://github.com/apache/doris/pull/35825


-- 
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