You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morningman (via GitHub)" <gi...@apache.org> on 2023/11/26 12:20:51 UTC

[PR] [feature](sql-dialect) support convert sql use sql convertor service [doris]

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

   ## Proposed changes
   
   Add a new FE Config `sql_convertor_service`.
   If this config is set, and the session variable `sql_dialect` is set,
   Doris will try to use a standalone sql converter service to convert user input sql to
   specified sql dialect. eg:
   
   ```
   mysql> set sql_dialect="presto";
   Query OK, 0 rows affected (0.02 sec)
   
   Database changed
   mysql> select * from db1.tbl1 where "k1" = 1; 
   +------+------+
   | k1   | k2   |
   +------+------+
   |    1 |    2 |
   +------+------+
   1 row in set (0.08 sec)
   ```
   
   The sql converter service should be a http service.
   
   ## 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] [feature](sql-dialect) support convert sql use sql convertor service [doris]

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

   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](sql-dialect) support convert sql use sql convertor service [doris]

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

   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](sql-dialect) support convert sql use sql convertor service [doris]

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

   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](sql-dialect) support convert sql use sql convertor service [doris]

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

   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](sql-dialect) support convert sql use sql convertor service [doris]

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

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit a3621b35dcb1d9990132b6a34ed652df90ee136e, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4928	4658	4661	4658
   q2	365	171	155	155
   q3	2083	1955	1924	1924
   q4	1391	1253	1275	1253
   q5	3933	3928	4028	3928
   q6	254	132	135	132
   q7	1411	878	877	877
   q8	2791	2778	2771	2771
   q9	9585	9471	9398	9398
   q10	3444	3510	3497	3497
   q11	374	255	242	242
   q12	434	284	293	284
   q13	4556	3827	3772	3772
   q14	324	285	299	285
   q15	572	528	529	528
   q16	664	581	591	581
   q17	1145	964	919	919
   q18	7956	7552	7505	7505
   q19	1665	1649	1658	1649
   q20	562	295	288	288
   q21	4407	4011	3981	3981
   q22	491	374	371	371
   Total cold run time: 53335 ms
   Total hot run time: 48998 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4573	4535	4557	4535
   q2	340	238	251	238
   q3	4031	4014	4028	4014
   q4	2718	2715	2705	2705
   q5	9713	9683	9740	9683
   q6	245	123	123	123
   q7	3032	2514	2483	2483
   q8	4448	4436	4475	4436
   q9	13040	12827	12813	12813
   q10	4039	4143	4116	4116
   q11	846	724	663	663
   q12	968	813	801	801
   q13	4262	3590	3589	3589
   q14	372	345	357	345
   q15	569	528	517	517
   q16	734	665	682	665
   q17	3903	3845	3880	3845
   q18	9547	9154	9178	9154
   q19	1816	1750	1757	1750
   q20	2381	2074	2036	2036
   q21	8917	8554	8659	8554
   q22	895	790	814	790
   Total cold run time: 81389 ms
   Total hot run time: 77855 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](sql-dialect) support convert sql use sql convertor service [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Tpch sf100 test result on commit ce9bb524dc2f8a16fe269b9fc06c3d92296c915a, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4751	4457	4502	4457
   q2	373	181	158	158
   q3	1459	1195	1239	1195
   q4	1108	906	893	893
   q5	3155	3111	3136	3111
   q6	249	128	128	128
   q7	986	482	478	478
   q8	2207	2207	2153	2153
   q9	6725	6645	6658	6645
   q10	3211	3295	3246	3246
   q11	315	194	207	194
   q12	351	209	206	206
   q13	4566	3810	3791	3791
   q14	238	217	219	217
   q15	560	531	522	522
   q16	440	379	379	379
   q17	1019	585	555	555
   q18	7235	7002	6855	6855
   q19	1524	1441	1365	1365
   q20	519	299	285	285
   q21	3053	2607	2658	2607
   q22	349	281	291	281
   Total cold run time: 44393 ms
   Total hot run time: 39721 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4452	4420	4400	4400
   q2	264	163	170	163
   q3	3536	3530	3526	3526
   q4	2382	2363	2364	2363
   q5	5747	5723	5729	5723
   q6	243	120	122	120
   q7	2394	1870	1878	1870
   q8	3506	3531	3519	3519
   q9	9043	9060	9058	9058
   q10	3913	3990	3961	3961
   q11	501	393	388	388
   q12	768	580	618	580
   q13	4255	3583	3561	3561
   q14	276	257	252	252
   q15	565	526	520	520
   q16	505	483	453	453
   q17	1869	1840	1826	1826
   q18	8583	8319	8296	8296
   q19	1726	1742	1749	1742
   q20	2261	1938	1934	1934
   q21	6514	6194	6182	6182
   q22	504	418	428	418
   Total cold run time: 63807 ms
   Total hot run time: 60855 ms
   ```
   


-- 
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](sql-dialect) support convert sql use sql convertor service [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 45.77 seconds
    stream load tsv:          564 seconds loaded 74807831229 Bytes, about 126 MB/s
    stream load json:         24 seconds loaded 2358488459 Bytes, about 93 MB/s
    stream load orc:          72 seconds loaded 1101869774 Bytes, about 14 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          28.5 seconds inserted 10000000 Rows, about 350K ops/s
    storage size: 17098135632 Bytes


-- 
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](sql-dialect) support convert sql use sql convertor service [doris]

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

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit b1b28f204e14098863ff4d9be5e76852099385f3, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4656	4434	4450	4434
   q2	363	153	158	153
   q3	1444	1214	1205	1205
   q4	1117	905	881	881
   q5	3142	3164	3123	3123
   q6	248	125	127	125
   q7	999	532	519	519
   q8	2176	2222	2185	2185
   q9	6633	6687	6639	6639
   q10	3179	3273	3276	3273
   q11	325	207	207	207
   q12	345	204	204	204
   q13	4558	3780	4205	3780
   q14	253	212	213	212
   q15	563	520	530	520
   q16	431	388	385	385
   q17	1005	565	505	505
   q18	7611	7123	7388	7123
   q19	1537	1298	1429	1298
   q20	541	297	299	297
   q21	3121	2653	2687	2653
   q22	351	280	284	280
   Total cold run time: 44598 ms
   Total hot run time: 40001 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4391	4365	4371	4365
   q2	265	162	175	162
   q3	3554	3549	3532	3532
   q4	2398	2383	2376	2376
   q5	5744	5771	5738	5738
   q6	241	119	118	118
   q7	2386	1846	1852	1846
   q8	3522	3514	3539	3514
   q9	9100	9005	8996	8996
   q10	3908	3968	4000	3968
   q11	498	390	367	367
   q12	766	602	609	602
   q13	4292	3546	3543	3543
   q14	274	255	251	251
   q15	571	520	510	510
   q16	504	458	468	458
   q17	1880	1848	1829	1829
   q18	8774	9370	8944	8944
   q19	1741	1746	1757	1746
   q20	2253	1937	1936	1936
   q21	6512	6196	6166	6166
   q22	494	435	431	431
   Total cold run time: 64068 ms
   Total hot run time: 61398 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](sql-dialect) support convert sql use sql convertor service [doris]

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


-- 
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](sql-dialect) support convert sql use sql convertor service [doris]

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

   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](sql-dialect) support convert sql use sql convertor service [doris]

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

   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](sql-dialect) support convert sql use sql convertor service [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 44.54 seconds
    stream load tsv:          592 seconds loaded 74807831229 Bytes, about 120 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          67 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          31 seconds loaded 861443392 Bytes, about 26 MB/s
    insert into select:          29.1 seconds inserted 10000000 Rows, about 343K ops/s
    storage size: 17219494664 Bytes


-- 
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](sql-dialect) support convert sql use sql convertor service [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 44.71 seconds
    stream load tsv:          599 seconds loaded 74807831229 Bytes, about 119 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          67 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          33 seconds loaded 861443392 Bytes, about 24 MB/s
    insert into select:          28.5 seconds inserted 10000000 Rows, about 350K ops/s
    storage size: 17219357511 Bytes


-- 
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](sql-dialect) support convert sql use sql convertor service [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 45.89 seconds
    stream load tsv:          582 seconds loaded 74807831229 Bytes, about 122 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          35 seconds loaded 861443392 Bytes, about 23 MB/s
    insert into select:          29.5 seconds inserted 10000000 Rows, about 338K ops/s
    storage size: 17219856294 Bytes


-- 
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](sql-dialect) support convert sql use sql convertor service [doris]

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

   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](sql-dialect) support convert sql use sql convertor service [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Tpch sf100 test result on commit edf0e3cd5d91c29d0fd603a8be85f2f1c067d1f1, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4735	4466	4496	4466
   q2	361	153	168	153
   q3	1448	1257	1211	1211
   q4	1116	864	888	864
   q5	3182	3154	3161	3154
   q6	243	127	129	127
   q7	991	490	481	481
   q8	2208	2227	2194	2194
   q9	6709	6687	6676	6676
   q10	3206	3270	3268	3268
   q11	329	200	203	200
   q12	348	206	204	204
   q13	4550	3810	3807	3807
   q14	244	211	216	211
   q15	565	529	528	528
   q16	442	388	384	384
   q17	1020	711	561	561
   q18	7167	6961	6930	6930
   q19	1543	1448	1399	1399
   q20	500	298	289	289
   q21	3028	2640	2615	2615
   q22	353	280	285	280
   Total cold run time: 44288 ms
   Total hot run time: 40002 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4429	4415	4409	4409
   q2	266	166	169	166
   q3	3531	3521	3518	3518
   q4	2384	2365	2372	2365
   q5	5721	5733	5719	5719
   q6	243	123	120	120
   q7	2368	1878	1889	1878
   q8	3515	3533	3530	3530
   q9	8994	9000	8953	8953
   q10	3883	3990	3977	3977
   q11	500	402	388	388
   q12	767	624	599	599
   q13	4286	3552	3558	3552
   q14	292	260	262	260
   q15	556	516	519	516
   q16	511	476	460	460
   q17	1881	1866	1838	1838
   q18	8743	8256	8221	8221
   q19	1735	1761	1758	1758
   q20	2267	1943	1935	1935
   q21	6512	6154	6153	6153
   q22	509	425	422	422
   Total cold run time: 63893 ms
   Total hot run time: 60737 ms
   ```
   


-- 
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](sql-dialect) support convert sql use sql convertor service [doris]

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

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit 2e23c4e7879c1bfc5d55d5fc633424d522f43a27, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	49963	31844	31835	31835
   q2	395	138	140	138
   q3	1562	1257	1204	1204
   q4	1099	946	920	920
   q5	3196	3181	3216	3181
   q6	264	140	143	140
   q7	988	499	478	478
   q8	2161	2222	2193	2193
   q9	7314	6886	6920	6886
   q10	3251	3327	3296	3296
   q11	346	210	208	208
   q12	348	205	203	203
   q13	4548	3807	3807	3807
   q14	368	318	315	315
   q15	835	1296	1335	1296
   q16	435	384	380	380
   q17	1026	575	562	562
   q18	7877	7063	7219	7063
   q19	1523	1348	1421	1348
   q20	598	1011	313	313
   q21	3060	2617	2654	2617
   q22	349	273	283	273
   Total cold run time: 91506 ms
   Total hot run time: 68656 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	30814	31857	31813	31813
   q2	286	167	174	167
   q3	3648	3662	3600	3600
   q4	2381	2363	2356	2356
   q5	5783	5786	5792	5786
   q6	241	130	131	130
   q7	3046	3409	3359	3359
   q8	3522	3533	3544	3533
   q9	9168	9110	9122	9110
   q10	3965	4043	4059	4043
   q11	810	908	1367	908
   q12	757	600	601	600
   q13	4318	3560	3545	3545
   q14	462	425	430	425
   q15	1184	1352	1320	1320
   q16	491	454	513	454
   q17	1869	1835	1836	1835
   q18	8794	8458	9166	8458
   q19	1718	1753	1763	1753
   q20	2915	2575	2645	2575
   q21	6505	6148	6184	6148
   q22	491	423	425	423
   Total cold run time: 93168 ms
   Total hot run time: 92341 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