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 04:31:31 UTC

[PR] [fix](Nereids) support variant column with index when create table [doris]

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

   ## 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] [fix](Nereids) support variant column with index when create table [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 182166 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 947216aef74762f1c91036d13ee72e74e7e1642b, data reload: false
   
   query1	929	385	352	352
   query2	6550	2094	2054	2054
   query3	6706	214	224	214
   query4	31841	21321	21318	21318
   query5	4334	399	386	386
   query6	263	180	194	180
   query7	4638	294	308	294
   query8	237	171	182	171
   query9	9268	2365	2326	2326
   query10	607	256	278	256
   query11	15452	14235	14318	14235
   query12	138	97	90	90
   query13	1630	426	414	414
   query14	10074	7957	7950	7950
   query15	345	206	194	194
   query16	8252	264	265	264
   query17	2106	581	555	555
   query18	2127	290	292	290
   query19	371	153	160	153
   query20	98	91	94	91
   query21	204	130	125	125
   query22	4930	4787	4819	4787
   query23	33862	32602	32889	32602
   query24	11730	2833	2849	2833
   query25	648	392	389	389
   query26	1792	161	162	161
   query27	3043	358	362	358
   query28	7766	1906	1897	1897
   query29	1058	652	637	637
   query30	311	156	150	150
   query31	968	730	739	730
   query32	107	58	59	58
   query33	784	263	267	263
   query34	1077	491	486	486
   query35	837	612	614	612
   query36	1040	870	878	870
   query37	278	65	67	65
   query38	3640	3433	3437	3433
   query39	1472	1466	1439	1439
   query40	292	115	117	115
   query41	54	48	49	48
   query42	110	99	96	96
   query43	519	443	461	443
   query44	1110	740	736	736
   query45	310	273	270	270
   query46	1116	707	702	702
   query47	1908	1833	1831	1831
   query48	458	362	363	362
   query49	1258	352	337	337
   query50	755	378	370	370
   query51	6745	6612	6626	6612
   query52	110	97	98	97
   query53	350	280	277	277
   query54	321	251	263	251
   query55	90	79	79	79
   query56	256	240	229	229
   query57	1209	1146	1154	1146
   query58	243	215	221	215
   query59	2810	2744	2537	2537
   query60	271	253	253	253
   query61	115	115	117	115
   query62	653	452	464	452
   query63	316	283	277	277
   query64	6858	4065	3892	3892
   query65	3137	3069	3042	3042
   query66	1421	375	355	355
   query67	15618	14868	15087	14868
   query68	9322	526	540	526
   query69	676	394	397	394
   query70	1350	1103	1160	1103
   query71	521	266	262	262
   query72	7000	2724	2533	2533
   query73	1620	318	321	318
   query74	8453	6381	6512	6381
   query75	3935	2202	2261	2202
   query76	5780	908	927	908
   query77	639	266	260	260
   query78	11158	10208	10166	10166
   query79	11375	535	526	526
   query80	1872	376	376	376
   query81	510	221	209	209
   query82	395	88	89	88
   query83	230	143	144	143
   query84	283	80	77	77
   query85	1100	318	318	318
   query86	353	287	293	287
   query87	3782	3612	3474	3474
   query88	4805	2300	2302	2300
   query89	496	383	378	378
   query90	2050	180	177	177
   query91	201	143	140	140
   query92	59	52	49	49
   query93	6813	505	484	484
   query94	1320	182	181	181
   query95	440	335	337	335
   query96	616	268	273	268
   query97	2627	2528	2502	2502
   query98	238	220	212	212
   query99	1171	900	926	900
   Total cold run time: 321116 ms
   Total hot run time: 182166 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](Nereids) support variant column with index when create table [doris]

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

   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] [fix](Nereids) support variant column with index when create table [doris]

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

   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](Nereids) support variant column with index when create table [doris]

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

   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](Nereids) support variant column with index when create table [doris]

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

   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] [fix](Nereids) support variant column with index when create table [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 947216aef74762f1c91036d13ee72e74e7e1642b with default session variables
   Stream load json:         18 seconds loaded 2358488459 Bytes, about 124 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      32 seconds loaded 861443392 Bytes, about 25 MB/s
   Insert into select:       13.7 seconds inserted 10000000 Rows, about 729K 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] [fix](Nereids) support variant column with index when create table [doris]

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

   run feut


-- 
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](Nereids) support variant column with index when create table [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38351 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 947216aef74762f1c91036d13ee72e74e7e1642b, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17662	4182	4141	4141
   q2	2124	170	167	167
   q3	10567	1169	1195	1169
   q4	10239	775	799	775
   q5	7472	3030	2985	2985
   q6	207	133	128	128
   q7	1071	632	586	586
   q8	9360	2053	1992	1992
   q9	7235	6601	6608	6601
   q10	8438	3551	3576	3551
   q11	445	244	222	222
   q12	382	214	200	200
   q13	17797	2881	2863	2863
   q14	241	205	205	205
   q15	512	469	485	469
   q16	502	374	377	374
   q17	951	551	592	551
   q18	7329	6529	6492	6492
   q19	1533	1448	1495	1448
   q20	558	264	250	250
   q21	3641	2923	2876	2876
   q22	359	306	316	306
   Total cold run time: 108625 ms
   Total hot run time: 38351 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4122	4102	4128	4102
   q2	323	226	230	226
   q3	2958	2865	2914	2865
   q4	1846	1508	1540	1508
   q5	5343	5355	5346	5346
   q6	193	117	120	117
   q7	2278	1902	1841	1841
   q8	3155	3277	3263	3263
   q9	8755	8686	8755	8686
   q10	3788	3846	3798	3798
   q11	549	447	443	443
   q12	707	535	525	525
   q13	16926	2893	2838	2838
   q14	283	250	255	250
   q15	496	477	467	467
   q16	489	419	441	419
   q17	1724	1495	1466	1466
   q18	7394	7135	7151	7135
   q19	1607	1519	1555	1519
   q20	1933	1770	1735	1735
   q21	4819	4704	4684	4684
   q22	549	452	453	452
   Total cold run time: 70237 ms
   Total hot run time: 53685 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](Nereids) support variant column with index when create table [doris]

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


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