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

[PR] [fix](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   ## Proposed changes
   
   #30119
   
   <!--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](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   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] [fix](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   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] [fix](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.51 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 1727476f6c7ea4352cbe3433fa61c4cdd3ab4739, data reload: false
   
   query1	0.03	0.02	0.02
   query2	0.07	0.02	0.02
   query3	0.25	0.05	0.04
   query4	1.82	0.06	0.07
   query5	0.52	0.52	0.52
   query6	1.26	0.62	0.62
   query7	0.02	0.01	0.02
   query8	0.04	0.03	0.02
   query9	0.53	0.48	0.48
   query10	0.53	0.54	0.54
   query11	0.12	0.09	0.08
   query12	0.12	0.09	0.09
   query13	0.61	0.61	0.61
   query14	0.79	0.78	0.79
   query15	0.78	0.76	0.76
   query16	0.38	0.38	0.35
   query17	1.02	1.02	1.02
   query18	0.23	0.26	0.26
   query19	1.86	1.87	1.87
   query20	0.01	0.01	0.01
   query21	15.54	0.56	0.54
   query22	2.02	1.84	1.08
   query23	17.30	0.93	0.98
   query24	6.56	2.36	1.03
   query25	2.22	0.16	0.15
   query26	0.16	0.13	0.15
   query27	0.14	0.16	0.14
   query28	5.82	0.76	0.72
   query29	12.78	2.31	2.30
   query30	0.58	0.50	0.52
   query31	2.82	0.38	0.38
   query32	3.41	0.51	0.48
   query33	3.08	3.11	3.04
   query34	15.26	4.82	4.82
   query35	4.87	4.86	4.87
   query36	1.04	1.02	1.00
   query37	0.05	0.05	0.04
   query38	0.04	0.02	0.02
   query39	0.01	0.01	0.01
   query40	0.16	0.14	0.14
   query41	0.07	0.01	0.01
   query42	0.02	0.01	0.02
   query43	0.03	0.02	0.02
   Total cold run time: 104.97 s
   Total hot run time: 30.51 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] [fix](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 241067 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 1727476f6c7ea4352cbe3433fa61c4cdd3ab4739, data reload: false
   
   query1	931	395	378	378
   query2	6536	2273	2144	2144
   query3	6909	198	195	195
   query4	19905	18051	18153	18051
   query5	19740	6265	6241	6241
   query6	288	219	219	219
   query7	4158	303	308	303
   query8	253	282	231	231
   query9	3110	2674	2597	2597
   query10	415	295	309	295
   query11	11272	10691	10695	10691
   query12	122	71	73	71
   query13	5638	652	642	642
   query14	17836	13605	13549	13549
   query15	367	228	234	228
   query16	6452	261	265	261
   query17	3237	898	883	883
   query18	2271	404	400	400
   query19	199	150	151	150
   query20	77	77	77	77
   query21	190	98	95	95
   query22	5319	5074	5139	5074
   query23	32526	31814	31947	31814
   query24	6868	6570	6458	6458
   query25	528	428	404	404
   query26	520	164	161	161
   query27	1782	288	297	288
   query28	6200	2229	2198	2198
   query29	2877	2837	2864	2837
   query30	251	158	163	158
   query31	885	755	721	721
   query32	60	58	57	57
   query33	373	241	245	241
   query34	838	469	461	461
   query35	1130	977	922	922
   query36	1468	1590	1734	1590
   query37	87	59	59	59
   query38	3028	2968	2908	2908
   query39	1365	1302	1319	1302
   query40	202	98	94	94
   query41	35	32	32	32
   query42	88	81	86	81
   query43	677	629	594	594
   query44	1124	709	707	707
   query45	240	228	230	228
   query46	1244	976	979	976
   query47	2080	1577	1769	1577
   query48	956	676	655	655
   query49	607	380	370	370
   query50	856	591	579	579
   query51	5645	5542	5490	5490
   query52	82	77	86	77
   query53	439	332	316	316
   query54	2409	2272	2277	2272
   query55	79	79	77	77
   query56	203	197	200	197
   query57	1173	1052	1151	1052
   query58	209	198	200	198
   query59	3489	3198	3353	3198
   query60	211	191	199	191
   query61	87	88	91	88
   query62	812	484	468	468
   query63	470	333	336	333
   query64	1955	1306	1315	1306
   query65	3723	3636	3600	3600
   query66	807	371	374	371
   query67	15520	14971	15439	14971
   query68	9052	680	656	656
   query69	557	325	343	325
   query70	1995	1703	1574	1574
   query71	415	299	305	299
   query72	4518	3423	3374	3374
   query73	725	316	318	316
   query74	6279	5864	5853	5853
   query75	4982	3559	3494	3494
   query76	5594	1190	1205	1190
   query77	888	240	245	240
   query78	32395	50497	53843	50497
   query79	15187	649	633	633
   query80	4435	398	377	377
   query81	565	228	232	228
   query82	1543	102	98	98
   query83	329	142	129	129
   query84	253	68	69	68
   query85	1696	288	280	280
   query86	467	386	414	386
   query87	3218	3015	2971	2971
   query88	7096	2327	2321	2321
   query89	419	280	281	280
   query90	2511	201	210	201
   query91	157	122	123	122
   query92	64	52	50	50
   query93	5567	596	583	583
   query94	1674	211	210	210
   query95	1088	1063	1051	1051
   query96	643	330	323	323
   query97	6548	6398	6452	6398
   query98	194	172	169	169
   query99	3657	947	919	919
   Total cold run time: 346144 ms
   Total hot run time: 241067 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](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   TeamCity be ut coverage result:
    Function Coverage: 37.84% (8032/21227) 
    Line Coverage: 29.50% (65306/221358)
    Region Coverage: 28.96% (33597/116022)
    Branch Coverage: 24.81% (17239/69472)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/1727476f6c7ea4352cbe3433fa61c4cdd3ab4739_1727476f6c7ea4352cbe3433fa61c4cdd3ab4739/report/index.html


-- 
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](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 241032 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 3054ae2917fcd790f8d4e179bfce22757c1eae75, data reload: false
   
   query1	934	387	376	376
   query2	6518	2214	2184	2184
   query3	6915	202	198	198
   query4	20456	17843	17932	17843
   query5	19722	6228	6218	6218
   query6	279	212	219	212
   query7	4149	290	299	290
   query8	263	282	223	223
   query9	3066	2658	2594	2594
   query10	417	292	291	291
   query11	11377	10847	10848	10847
   query12	123	78	70	70
   query13	5635	623	609	609
   query14	17784	13213	13284	13213
   query15	391	226	234	226
   query16	6455	261	266	261
   query17	4707	895	881	881
   query18	2335	399	399	399
   query19	205	148	141	141
   query20	70	78	73	73
   query21	185	94	92	92
   query22	5326	5186	5157	5157
   query23	33179	32770	31914	31914
   query24	9259	6484	6459	6459
   query25	507	416	423	416
   query26	524	165	154	154
   query27	1872	291	290	290
   query28	6118	2216	2197	2197
   query29	2912	2736	2701	2701
   query30	240	162	164	162
   query31	891	727	738	727
   query32	63	59	61	59
   query33	386	251	247	247
   query34	832	471	479	471
   query35	1105	884	897	884
   query36	1457	1721	1496	1496
   query37	86	59	56	56
   query38	3110	2905	2862	2862
   query39	1348	1327	1306	1306
   query40	197	95	90	90
   query41	36	32	30	30
   query42	87	82	82	82
   query43	641	549	599	549
   query44	1091	713	708	708
   query45	247	229	226	226
   query46	1237	984	980	980
   query47	1844	1796	1811	1796
   query48	1002	693	672	672
   query49	632	379	367	367
   query50	887	663	592	592
   query51	5714	5534	5541	5534
   query52	99	76	81	76
   query53	432	319	307	307
   query54	2408	2236	2237	2236
   query55	82	83	81	81
   query56	218	205	198	198
   query57	1232	1028	1113	1028
   query58	214	196	188	188
   query59	3431	3083	3324	3083
   query60	192	203	197	197
   query61	86	81	86	81
   query62	822	475	493	475
   query63	473	324	341	324
   query64	2001	1278	1295	1278
   query65	3667	3654	3593	3593
   query66	798	364	355	355
   query67	15275	15667	15803	15667
   query68	9865	651	682	651
   query69	571	338	339	338
   query70	2082	1911	1779	1779
   query71	416	304	302	302
   query72	4508	3367	3373	3367
   query73	725	313	305	305
   query74	6331	5919	5847	5847
   query75	5023	3569	3473	3473
   query76	6059	1167	1191	1167
   query77	1014	246	245	245
   query78	31632	50224	53555	50224
   query79	14786	628	629	628
   query80	4327	384	382	382
   query81	561	229	226	226
   query82	1171	90	93	90
   query83	327	133	132	132
   query84	252	70	70	70
   query85	1815	277	278	277
   query86	457	394	376	376
   query87	3234	3020	2981	2981
   query88	6916	2335	2296	2296
   query89	400	302	277	277
   query90	2507	209	207	207
   query91	156	125	115	115
   query92	66	49	51	49
   query93	5228	597	611	597
   query94	1660	205	207	205
   query95	1130	1075	1067	1067
   query96	642	337	334	334
   query97	6453	6386	6384	6384
   query98	187	178	175	175
   query99	3668	895	874	874
   Total cold run time: 350415 ms
   Total hot run time: 241032 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](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   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](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   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](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.74 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 3054ae2917fcd790f8d4e179bfce22757c1eae75, data reload: false
   
   query1	0.03	0.02	0.02
   query2	0.07	0.02	0.02
   query3	0.24	0.04	0.05
   query4	1.83	0.06	0.07
   query5	0.53	0.53	0.52
   query6	1.24	0.62	0.63
   query7	0.02	0.02	0.01
   query8	0.04	0.02	0.02
   query9	0.53	0.48	0.48
   query10	0.54	0.54	0.54
   query11	0.11	0.09	0.08
   query12	0.11	0.09	0.09
   query13	0.62	0.62	0.61
   query14	0.78	0.79	0.78
   query15	0.77	0.76	0.76
   query16	0.36	0.36	0.37
   query17	1.01	1.01	1.04
   query18	0.23	0.25	0.24
   query19	1.93	1.86	1.79
   query20	0.01	0.01	0.01
   query21	15.45	0.56	0.55
   query22	1.91	1.98	1.59
   query23	17.35	0.87	0.93
   query24	4.63	1.02	0.90
   query25	2.12	0.16	0.14
   query26	0.15	0.13	0.15
   query27	0.15	0.16	0.14
   query28	8.11	0.74	0.74
   query29	12.63	2.24	2.32
   query30	0.60	0.53	0.52
   query31	2.81	0.38	0.37
   query32	3.42	0.51	0.50
   query33	3.09	3.09	3.09
   query34	15.26	4.81	4.80
   query35	4.85	4.84	4.84
   query36	1.06	1.01	1.02
   query37	0.06	0.05	0.04
   query38	0.03	0.02	0.02
   query39	0.02	0.02	0.01
   query40	0.15	0.14	0.14
   query41	0.06	0.01	0.01
   query42	0.02	0.01	0.01
   query43	0.02	0.02	0.02
   Total cold run time: 104.95 s
   Total hot run time: 30.74 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] [fix](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 1727476f6c7ea4352cbe3433fa61c4cdd3ab4739 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:       21.4 seconds inserted 10000000 Rows, about 467K 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](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 3054ae2917fcd790f8d4e179bfce22757c1eae75 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:       21.4 seconds inserted 10000000 Rows, about 467K 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](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   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](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 49626 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 3054ae2917fcd790f8d4e179bfce22757c1eae75, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	18394	4359	4316	4316
   q2	2024	153	134	134
   q3	10465	1875	1928	1875
   q4	10307	1207	1286	1207
   q5	8522	3921	3995	3921
   q6	228	124	124	124
   q7	2021	1589	1607	1589
   q8	9551	2704	2708	2704
   q9	10577	10554	10418	10418
   q10	8681	3525	3505	3505
   q11	415	226	235	226
   q12	464	300	298	298
   q13	18345	3959	4058	3959
   q14	361	327	324	324
   q15	516	451	457	451
   q16	702	589	588	588
   q17	1127	942	940	940
   q18	7274	6921	6777	6777
   q19	1661	1531	1488	1488
   q20	501	292	302	292
   q21	4440	4120	4102	4102
   q22	486	388	401	388
   Total cold run time: 117062 ms
   Total hot run time: 49626 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4285	4321	4331	4321
   q2	316	218	221	218
   q3	4194	4137	4182	4137
   q4	2747	2747	2744	2744
   q5	7260	7173	7204	7173
   q6	232	119	119	119
   q7	3267	2832	2864	2832
   q8	4402	4456	4669	4456
   q9	17090	17143	16957	16957
   q10	4234	4279	4254	4254
   q11	771	733	683	683
   q12	1028	862	835	835
   q13	6779	3765	3728	3728
   q14	461	423	424	423
   q15	500	459	452	452
   q16	757	695	689	689
   q17	3844	3878	3887	3878
   q18	8851	8674	8873	8674
   q19	1702	1708	1613	1613
   q20	2343	2102	2111	2102
   q21	8573	8577	8537	8537
   q22	1045	1025	934	934
   Total cold run time: 84681 ms
   Total hot run time: 79759 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](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 50381 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 1727476f6c7ea4352cbe3433fa61c4cdd3ab4739, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	18832	4468	4398	4398
   q2	2051	155	141	141
   q3	10526	1930	1923	1923
   q4	10296	1226	1305	1226
   q5	8664	4030	4126	4030
   q6	233	127	124	124
   q7	2097	1675	1662	1662
   q8	10364	2769	2764	2764
   q9	11500	11233	10623	10623
   q10	8806	3483	3550	3483
   q11	976	242	238	238
   q12	471	305	299	299
   q13	18339	3961	4071	3961
   q14	353	331	333	331
   q15	513	460	462	460
   q16	717	601	585	585
   q17	1118	999	969	969
   q18	7293	6845	6995	6845
   q19	1685	1570	1558	1558
   q20	537	318	296	296
   q21	4436	4157	4065	4065
   q22	507	406	400	400
   Total cold run time: 120314 ms
   Total hot run time: 50381 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4286	4287	4312	4287
   q2	324	223	221	221
   q3	4152	4155	4109	4109
   q4	2754	2762	2731	2731
   q5	7286	7172	7141	7141
   q6	234	118	115	115
   q7	3250	2857	2906	2857
   q8	4376	4450	4480	4450
   q9	17583	17273	17080	17080
   q10	4236	4249	4289	4249
   q11	774	673	672	672
   q12	1026	839	859	839
   q13	6551	3741	3756	3741
   q14	457	416	423	416
   q15	507	462	460	460
   q16	733	710	697	697
   q17	3879	3861	3821	3821
   q18	8973	9045	8880	8880
   q19	1689	1648	1638	1638
   q20	2397	2142	2133	2133
   q21	8595	8530	8514	8514
   q22	1037	973	972	972
   Total cold run time: 85099 ms
   Total hot run time: 80023 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](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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


-- 
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](paimon)set timestamp's scale for parquet which has no logical type for 2.0 [doris]

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

   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