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

[PR] [Bug](Variant) forbit variant column with filter, group by or order by [doris]

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

   ## 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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]

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

   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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38200 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 a3e91b71e9205f1a46e969f09cb50cb3a85fcb0c, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17614	4198	4141	4141
   q2	2111	153	155	153
   q3	10637	1179	1218	1179
   q4	10229	756	771	756
   q5	7463	3001	2976	2976
   q6	207	125	124	124
   q7	1047	598	577	577
   q8	9350	2007	2016	2007
   q9	7226	6614	6592	6592
   q10	8360	3469	3577	3469
   q11	420	238	221	221
   q12	361	199	196	196
   q13	17791	2868	2893	2868
   q14	242	204	205	204
   q15	492	467	462	462
   q16	477	372	372	372
   q17	950	523	627	523
   q18	7062	6508	6536	6508
   q19	1553	1477	1414	1414
   q20	541	254	250	250
   q21	3682	2988	2899	2899
   q22	349	319	309	309
   Total cold run time: 108164 ms
   Total hot run time: 38200 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4064	4183	4132	4132
   q2	322	231	225	225
   q3	2972	2889	2856	2856
   q4	1851	1507	1550	1507
   q5	5339	5336	5351	5336
   q6	196	117	116	116
   q7	2283	1844	1865	1844
   q8	3159	3273	3262	3262
   q9	8708	8705	8729	8705
   q10	3766	3815	3737	3737
   q11	566	443	446	443
   q12	747	567	552	552
   q13	16909	2932	2879	2879
   q14	280	256	266	256
   q15	494	452	465	452
   q16	472	433	432	432
   q17	1740	1509	1479	1479
   q18	7380	7174	7122	7122
   q19	1610	1554	1528	1528
   q20	1902	1718	1709	1709
   q21	4896	4724	4763	4724
   q22	542	472	483	472
   Total cold run time: 70198 ms
   Total hot run time: 53768 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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]

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


-- 
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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]

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

   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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 181786 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 a3e91b71e9205f1a46e969f09cb50cb3a85fcb0c, data reload: false
   
   query1	930	376	355	355
   query2	6763	1885	1890	1885
   query3	6701	215	219	215
   query4	31779	21425	21358	21358
   query5	4310	395	407	395
   query6	267	171	182	171
   query7	4640	298	300	298
   query8	233	176	185	176
   query9	9331	2277	2262	2262
   query10	561	251	259	251
   query11	14650	14291	14212	14212
   query12	139	92	87	87
   query13	1633	430	417	417
   query14	9530	8036	7940	7940
   query15	263	194	201	194
   query16	8242	260	275	260
   query17	1971	567	562	562
   query18	2108	291	287	287
   query19	334	162	166	162
   query20	94	90	92	90
   query21	210	128	125	125
   query22	4958	4842	4802	4802
   query23	33784	32446	32966	32446
   query24	11846	2885	2837	2837
   query25	654	392	379	379
   query26	1773	158	158	158
   query27	3087	357	362	357
   query28	7793	1874	1916	1874
   query29	1041	660	623	623
   query30	306	149	148	148
   query31	954	718	734	718
   query32	102	57	57	57
   query33	774	257	260	257
   query34	1131	487	488	487
   query35	848	611	609	609
   query36	998	874	895	874
   query37	276	66	65	65
   query38	3582	3456	3463	3456
   query39	1489	1470	1449	1449
   query40	292	116	113	113
   query41	53	48	49	48
   query42	105	99	104	99
   query43	497	473	457	457
   query44	1144	746	736	736
   query45	279	249	262	249
   query46	1109	709	702	702
   query47	1924	1847	1842	1842
   query48	453	362	359	359
   query49	1240	335	345	335
   query50	771	371	378	371
   query51	6649	6610	6594	6594
   query52	109	95	92	92
   query53	351	276	274	274
   query54	324	253	236	236
   query55	87	77	79	77
   query56	240	235	227	227
   query57	1205	1141	1159	1141
   query58	238	211	210	210
   query59	2759	2654	2479	2479
   query60	274	245	254	245
   query61	134	108	122	108
   query62	663	463	453	453
   query63	301	281	275	275
   query64	6332	4031	4077	4031
   query65	3112	3026	3034	3026
   query66	1433	388	353	353
   query67	15534	15158	14916	14916
   query68	9117	553	539	539
   query69	654	383	378	378
   query70	1402	1096	1102	1096
   query71	522	262	257	257
   query72	6401	2718	2551	2551
   query73	1648	326	316	316
   query74	6890	6448	6393	6393
   query75	3774	2218	2226	2218
   query76	5449	878	901	878
   query77	648	259	255	255
   query78	10928	10280	10084	10084
   query79	10932	539	533	533
   query80	1417	371	366	366
   query81	501	223	214	214
   query82	234	87	83	83
   query83	208	146	150	146
   query84	295	76	78	76
   query85	1083	313	311	311
   query86	347	309	292	292
   query87	3794	3525	3521	3521
   query88	5599	2402	2375	2375
   query89	489	365	377	365
   query90	2080	180	174	174
   query91	165	139	138	138
   query92	65	46	47	46
   query93	6226	509	496	496
   query94	1320	172	173	172
   query95	420	333	330	330
   query96	618	270	275	270
   query97	2652	2477	2470	2470
   query98	226	221	210	210
   query99	1072	906	887	887
   Total cold run time: 314873 ms
   Total hot run time: 181786 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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]

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

   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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]

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

   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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit a3e91b71e9205f1a46e969f09cb50cb3a85fcb0c 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:       14.1 seconds inserted 10000000 Rows, about 709K 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