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

[PR] [opt](Nereids) support create table with variant type [doris]

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

   ## Proposed changes
   
   Issue Number: close #xxx
   
   <!--Describe your changes.-->
   
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
   
   


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

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

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


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


Re: [PR] [opt](Nereids) support create table with variant type [doris]

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

   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] [opt](Nereids) support create table with variant type [doris]

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

   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] [opt](Nereids) support create table with variant type [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 183087 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 e99c7dc118af5670b110ffde28461baa5870383b, data reload: false
   
   query1	939	379	358	358
   query2	6563	1913	1878	1878
   query3	6700	212	210	210
   query4	31849	21406	21405	21405
   query5	4331	436	429	429
   query6	271	187	177	177
   query7	4633	306	314	306
   query8	236	177	178	177
   query9	9334	2372	2333	2333
   query10	574	248	265	248
   query11	17331	14361	14312	14312
   query12	148	90	89	89
   query13	1626	409	418	409
   query14	10455	7657	7767	7657
   query15	243	207	203	203
   query16	8151	260	260	260
   query17	1950	603	574	574
   query18	2095	297	290	290
   query19	317	159	161	159
   query20	100	92	88	88
   query21	200	135	132	132
   query22	5048	4788	4755	4755
   query23	33465	32831	32652	32652
   query24	10828	3009	3035	3009
   query25	644	411	410	410
   query26	1205	164	163	163
   query27	2764	349	362	349
   query28	7432	1934	1887	1887
   query29	940	651	639	639
   query30	304	154	154	154
   query31	994	758	739	739
   query32	95	58	60	58
   query33	776	260	258	258
   query34	1086	509	523	509
   query35	848	653	622	622
   query36	1057	876	888	876
   query37	131	68	67	67
   query38	3549	3421	3435	3421
   query39	1468	1476	1439	1439
   query40	220	122	120	120
   query41	52	50	51	50
   query42	106	100	101	100
   query43	513	466	465	465
   query44	1201	739	729	729
   query45	287	269	268	268
   query46	1212	749	740	740
   query47	1948	1822	1904	1822
   query48	462	354	375	354
   query49	1132	353	365	353
   query50	827	383	376	376
   query51	6838	6696	6600	6600
   query52	111	92	91	91
   query53	376	285	285	285
   query54	312	246	250	246
   query55	85	82	84	82
   query56	260	237	236	236
   query57	1239	1134	1160	1134
   query58	243	222	219	219
   query59	2908	2648	2604	2604
   query60	285	255	265	255
   query61	120	112	124	112
   query62	687	462	460	460
   query63	316	285	282	282
   query64	5944	4263	4273	4263
   query65	3138	3058	3090	3058
   query66	988	382	356	356
   query67	15513	14849	14852	14849
   query68	7372	516	526	516
   query69	644	384	379	379
   query70	1253	1148	1122	1122
   query71	523	268	266	266
   query72	6360	2790	2594	2594
   query73	774	318	313	313
   query74	7972	6508	6381	6381
   query75	3633	2334	2357	2334
   query76	5035	933	967	933
   query77	669	263	266	263
   query78	11108	10204	10200	10200
   query79	10148	553	551	551
   query80	1594	395	387	387
   query81	543	226	226	226
   query82	891	90	87	87
   query83	212	148	150	148
   query84	284	77	82	77
   query85	1503	336	323	323
   query86	476	289	307	289
   query87	3809	3613	3547	3547
   query88	5105	2302	2303	2302
   query89	527	391	386	386
   query90	1998	176	183	176
   query91	182	134	142	134
   query92	59	51	52	51
   query93	7080	505	496	496
   query94	1244	183	183	183
   query95	427	338	333	333
   query96	674	277	268	268
   query97	2657	2476	2485	2476
   query98	238	234	222	222
   query99	1282	917	914	914
   Total cold run time: 314279 ms
   Total hot run time: 183087 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] [opt](Nereids) support create table with variant type [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37790 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 e99c7dc118af5670b110ffde28461baa5870383b, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17627	4283	4092	4092
   q2	2110	155	147	147
   q3	10591	1122	1210	1122
   q4	10229	729	821	729
   q5	7469	3018	2975	2975
   q6	207	127	121	121
   q7	1022	591	572	572
   q8	9345	2010	1991	1991
   q9	7587	6563	6547	6547
   q10	8421	3496	3599	3496
   q11	443	218	215	215
   q12	416	198	200	198
   q13	17797	2832	2841	2832
   q14	229	198	202	198
   q15	507	478	466	466
   q16	507	375	370	370
   q17	944	530	610	530
   q18	7061	6379	6388	6379
   q19	2043	1422	1478	1422
   q20	533	283	243	243
   q21	3544	2947	2856	2856
   q22	332	295	289	289
   Total cold run time: 108964 ms
   Total hot run time: 37790 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4149	4119	4080	4080
   q2	322	230	231	230
   q3	2967	2811	2829	2811
   q4	1817	1544	1507	1507
   q5	5260	5299	5296	5296
   q6	190	115	114	114
   q7	2226	1834	1851	1834
   q8	3153	3302	3261	3261
   q9	8706	8669	8637	8637
   q10	3824	3794	3788	3788
   q11	550	446	443	443
   q12	729	564	519	519
   q13	16928	2880	2866	2866
   q14	274	256	256	256
   q15	503	462	461	461
   q16	473	418	438	418
   q17	1698	1496	1467	1467
   q18	7322	6998	7087	6998
   q19	1590	1480	1536	1480
   q20	1907	1721	1695	1695
   q21	4747	4489	4635	4489
   q22	511	465	451	451
   Total cold run time: 69846 ms
   Total hot run time: 53101 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] [opt](Nereids) support create table with variant type [doris]

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


-- 
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] [opt](Nereids) support create table with variant type [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit e99c7dc118af5670b110ffde28461baa5870383b 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:       13.8 seconds inserted 10000000 Rows, about 724K 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] [opt](Nereids) support create table with variant type [doris]

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

   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] [opt](Nereids) support create table with variant type [doris]

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

   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