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/07/15 16:29:52 UTC

[PR] [Feature](Variant) support export csv format [doris]

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

   ## 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] [Feature](Variant) support export csv format [doris]

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

   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](Variant) support export csv format [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.1 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 cbb46d7d42ad24d994c732a269c3aac06fa27f50, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.08	0.04	0.04
   query3	0.22	0.06	0.06
   query4	1.66	0.07	0.08
   query5	0.47	0.47	0.48
   query6	1.14	0.72	0.77
   query7	0.02	0.01	0.01
   query8	0.04	0.05	0.05
   query9	0.56	0.49	0.49
   query10	0.55	0.54	0.54
   query11	0.15	0.12	0.11
   query12	0.15	0.12	0.13
   query13	0.60	0.59	0.58
   query14	0.77	0.78	0.78
   query15	0.86	0.82	0.81
   query16	0.38	0.35	0.36
   query17	0.98	0.97	0.99
   query18	0.22	0.21	0.21
   query19	1.77	1.67	1.70
   query20	0.01	0.01	0.01
   query21	15.39	0.75	0.68
   query22	4.12	7.79	2.28
   query23	18.30	1.44	1.30
   query24	2.09	0.24	0.23
   query25	0.17	0.10	0.08
   query26	0.30	0.22	0.21
   query27	0.45	0.24	0.23
   query28	13.28	1.04	1.00
   query29	12.61	3.32	3.31
   query30	0.26	0.06	0.06
   query31	2.87	0.40	0.39
   query32	3.25	0.48	0.47
   query33	2.86	2.92	2.91
   query34	17.06	4.41	4.37
   query35	4.45	4.43	4.42
   query36	0.65	0.46	0.46
   query37	0.19	0.16	0.16
   query38	0.16	0.15	0.15
   query39	0.05	0.04	0.04
   query40	0.14	0.12	0.13
   query41	0.09	0.05	0.05
   query42	0.06	0.05	0.05
   query43	0.05	0.04	0.04
   Total cold run time: 109.52 s
   Total hot run time: 31.1 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](Variant) support export csv format [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 40160 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 cbb46d7d42ad24d994c732a269c3aac06fa27f50, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17652	4520	4318	4318
   q2	2023	193	189	189
   q3	10537	1235	1153	1153
   q4	10238	787	746	746
   q5	7557	2736	2693	2693
   q6	222	139	135	135
   q7	973	603	603	603
   q8	9211	2129	2069	2069
   q9	8725	6583	6625	6583
   q10	8868	3813	3798	3798
   q11	457	241	237	237
   q12	393	217	218	217
   q13	17781	2988	3007	2988
   q14	274	233	239	233
   q15	528	481	485	481
   q16	506	378	388	378
   q17	987	617	702	617
   q18	8230	7649	7488	7488
   q19	4816	1436	1399	1399
   q20	661	325	328	325
   q21	5098	3225	3920	3225
   q22	353	298	285	285
   Total cold run time: 116090 ms
   Total hot run time: 40160 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4638	4288	4246	4246
   q2	373	273	275	273
   q3	3044	2923	2922	2922
   q4	2057	1711	1776	1711
   q5	5693	5548	5513	5513
   q6	230	143	129	129
   q7	2195	1918	1841	1841
   q8	3285	3403	3459	3403
   q9	8792	8802	8898	8802
   q10	4139	3953	3831	3831
   q11	605	513	518	513
   q12	847	619	637	619
   q13	16057	3143	3206	3143
   q14	320	287	275	275
   q15	531	495	492	492
   q16	490	432	427	427
   q17	1835	1540	1498	1498
   q18	8127	7963	7771	7771
   q19	1796	1615	1475	1475
   q20	2115	1877	1851	1851
   q21	5011	4931	4723	4723
   q22	592	517	492	492
   Total cold run time: 72772 ms
   Total hot run time: 55950 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](Variant) support export csv format [doris]

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

   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] [Feature](Variant) support export csv format [doris]

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

   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] [Feature](Variant) support export csv format [doris]

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

   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](Variant) support export csv format [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 174240 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 cbb46d7d42ad24d994c732a269c3aac06fa27f50, data reload: false
   
   query1	919	376	380	376
   query2	6428	1928	1835	1835
   query3	6644	210	222	210
   query4	28261	17577	17475	17475
   query5	3632	481	507	481
   query6	280	195	164	164
   query7	4585	300	286	286
   query8	235	198	201	198
   query9	8629	2432	2417	2417
   query10	437	289	271	271
   query11	11583	9997	9985	9985
   query12	116	83	88	83
   query13	1662	364	366	364
   query14	8519	7947	8723	7947
   query15	241	168	171	168
   query16	8016	314	312	312
   query17	1854	529	532	529
   query18	1767	273	290	273
   query19	189	145	147	145
   query20	90	84	82	82
   query21	204	124	127	124
   query22	4297	4386	4002	4002
   query23	34167	33745	33482	33482
   query24	10571	2933	2870	2870
   query25	576	421	380	380
   query26	827	152	152	152
   query27	2195	276	282	276
   query28	6270	2101	2095	2095
   query29	908	636	640	636
   query30	263	147	149	147
   query31	976	772	739	739
   query32	90	54	52	52
   query33	761	300	292	292
   query34	1045	504	503	503
   query35	689	590	591	590
   query36	1120	964	997	964
   query37	145	83	83	83
   query38	2955	2925	2827	2827
   query39	920	884	864	864
   query40	216	128	128	128
   query41	45	45	41	41
   query42	120	98	98	98
   query43	512	471	465	465
   query44	1262	742	750	742
   query45	186	159	163	159
   query46	1092	762	730	730
   query47	1879	1785	1788	1785
   query48	356	296	296	296
   query49	842	403	412	403
   query50	788	391	394	391
   query51	7028	6814	6811	6811
   query52	105	94	98	94
   query53	363	291	295	291
   query54	917	441	437	437
   query55	76	73	73	73
   query56	301	260	265	260
   query57	1106	1073	1066	1066
   query58	256	253	263	253
   query59	2771	2564	2710	2564
   query60	316	278	272	272
   query61	97	100	94	94
   query62	784	661	661	661
   query63	324	291	293	291
   query64	9123	2226	1676	1676
   query65	3164	3158	3137	3137
   query66	763	327	328	327
   query67	15659	14980	14882	14882
   query68	4406	526	536	526
   query69	518	386	349	349
   query70	1172	1120	1138	1120
   query71	366	273	275	273
   query72	6740	5686	5712	5686
   query73	759	323	321	321
   query74	6020	5710	5704	5704
   query75	3397	2692	2731	2692
   query76	2232	902	920	902
   query77	447	303	296	296
   query78	9675	9070	9237	9070
   query79	2602	516	523	516
   query80	1816	468	471	468
   query81	606	221	222	221
   query82	1426	144	134	134
   query83	263	174	173	173
   query84	277	87	95	87
   query85	1446	321	304	304
   query86	468	328	326	326
   query87	3278	3107	3118	3107
   query88	4226	2398	2413	2398
   query89	464	381	377	377
   query90	1758	193	194	193
   query91	129	98	100	98
   query92	60	49	48	48
   query93	2323	489	498	489
   query94	1154	212	209	209
   query95	402	318	324	318
   query96	601	275	277	275
   query97	3199	3023	3020	3020
   query98	221	203	191	191
   query99	1550	1243	1274	1243
   Total cold run time: 277518 ms
   Total hot run time: 174240 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](Variant) support export csv format [doris]

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


-- 
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](Variant) support export csv format [doris]

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

   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