Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-10 Thread via GitHub
yiguolei merged PR #38945: URL: https://github.com/apache/doris/pull/38945 -- 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-unsubscr...@doris.apa

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-10 Thread via GitHub
github-actions[bot] commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2282300605 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 GitHu

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-10 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2282227883 ClickBench: Total hot run time: 30.35 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-10 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2282226192 TPC-DS: Total hot run time: 200069 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-10 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-228513 TPC-H: Total hot run time: 39611 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-10 Thread via GitHub
zhiqiang- commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2282193526 run performance -- 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.

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2273819369 TPC-H: Total hot run time: 39861 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
zclllyybb commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2273741130 run performance -- 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

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2273668933 TPC-H: Total hot run time: 41073 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
Mryange commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2273500669 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 unsu

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2273115450 ClickBench: Total hot run time: 30.03 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2273105093 TPC-DS: Total hot run time: 168347 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2273084354 TPC-H: Total hot run time: 41635 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
Mryange commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2273046376 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 unsu

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
github-actions[bot] commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2273028582 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 UR

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
Mryange commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2273014579 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 unsu

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2272979150 ClickBench: Total hot run time: 30.37 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2272967988 TPC-DS: Total hot run time: 168995 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2272946855 TPC-H: Total hot run time: 41873 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
zclllyybb commented on code in PR #38945: URL: https://github.com/apache/doris/pull/38945#discussion_r1706592475 ## fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/executable/DateTimeArithmetic.java: ## @@ -210,14 +210,6 @@ public static Expression

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-07 Thread via GitHub
Mryange commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2272799412 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 unsu

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2271137578 ClickBench: Total hot run time: 29.71 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2271127406 TPC-DS: Total hot run time: 169904 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2271107983 TPC-H: Total hot run time: 41018 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub
zclllyybb commented on code in PR #38945: URL: https://github.com/apache/doris/pull/38945#discussion_r1705360754 ## regression-test/suites/correctness/test_from_millisecond_microsecond.groovy: ## Review Comment: please also add some testcase from table. and some with scale

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub
Mryange commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2271034046 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 unsu

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub
zclllyybb commented on code in PR #38945: URL: https://github.com/apache/doris/pull/38945#discussion_r1705187571 ## fe/fe-core/src/main/java/org/apache/doris/nereids/types/DateTimeV2Type.java: ## @@ -39,6 +39,10 @@ public class DateTimeV2Type extends DateLikeType { public s

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2270661679 ClickBench: Total hot run time: 30.03 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2270650440 TPC-DS: Total hot run time: 168125 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2270629451 TPC-H: Total hot run time: 41543 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub
doris-robot commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2270574857 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+y

Re: [PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub
Mryange commented on PR #38945: URL: https://github.com/apache/doris/pull/38945#issuecomment-2270575319 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 unsu

[PR] [fix](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub
Mryange opened a new pull request, #38945: URL: https://github.com/apache/doris/pull/38945 ## Proposed changes before ``` mysql> SELECT MICROSECONDS_SUB('2010-11-30 23:50:50', 2); +---+ | microseconds_sub(cast('201