Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-24 Thread via GitHub
github-actions[bot] commented on PR #28956: URL: https://github.com/apache/doris/pull/28956#issuecomment-1868729559 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

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-24 Thread via GitHub
zzzxl1993 commented on PR #28956: URL: https://github.com/apache/doris/pull/28956#issuecomment-1868727025 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

[PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-24 Thread via GitHub
zzzxl1993 opened a new pull request, #28956: URL: https://github.com/apache/doris/pull/28956 ## Proposed changes https://github.com/apache/doris/pull/28494 ## Further comments If this is a relatively large or complex change, kick off the discussion at

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-21 Thread via GitHub
doris-robot commented on PR #28494: URL: https://github.com/apache/doris/pull/28494#issuecomment-1865870287 TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Tpch sf100 test result on commit 703686d86e42c66438e23c8309b40ca4ae975edd, data reload: false run

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-21 Thread via GitHub
xiaokang commented on code in PR #28494: URL: https://github.com/apache/doris/pull/28494#discussion_r1433730282 ## be/src/olap/rowset/segment_v2/segment_iterator.cpp: ## @@ -2570,5 +2573,64 @@ void SegmentIterator::_calculate_pred_in_remaining_conjunct_root( } } +bool

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-20 Thread via GitHub
doris-robot commented on PR #28494: URL: https://github.com/apache/doris/pull/28494#issuecomment-1865816946 (From new machine)TeamCity pipeline, clickbench performance test result: the sum of best hot time: 44.71 seconds stream load tsv: 572 seconds loaded 74807831229 Bytes,

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-20 Thread via GitHub
zzzxl1993 commented on PR #28494: URL: https://github.com/apache/doris/pull/28494#issuecomment-1865742025 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

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-19 Thread via GitHub
doris-robot commented on PR #28494: URL: https://github.com/apache/doris/pull/28494#issuecomment-1863804150 (From new machine)TeamCity pipeline, clickbench performance test result: the sum of best hot time: 43.8 seconds stream load tsv: 582 seconds loaded 74807831229 Bytes,

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-19 Thread via GitHub
doris-robot commented on PR #28494: URL: https://github.com/apache/doris/pull/28494#issuecomment-1863800860 TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Tpch sf100 test result on commit b647375d2377d6276fd3f0b498effe44d3db00a3, data reload: false run

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-19 Thread via GitHub
zzzxl1993 commented on PR #28494: URL: https://github.com/apache/doris/pull/28494#issuecomment-1863751505 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

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-17 Thread via GitHub
doris-robot commented on PR #28494: URL: https://github.com/apache/doris/pull/28494#issuecomment-1859503925 (From new machine)TeamCity pipeline, clickbench performance test result: the sum of best hot time: 43.97 seconds stream load tsv: 585 seconds loaded 74807831229 Bytes,

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-17 Thread via GitHub
doris-robot commented on PR #28494: URL: https://github.com/apache/doris/pull/28494#issuecomment-1859501579 TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Tpch sf100 test result on commit adedb25d9f637367a9ededef2d0f9b82b412c8d3, data reload: false

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-17 Thread via GitHub
zzzxl1993 commented on PR #28494: URL: https://github.com/apache/doris/pull/28494#issuecomment-1859479034 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

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-17 Thread via GitHub
xiaokang commented on code in PR #28494: URL: https://github.com/apache/doris/pull/28494#discussion_r1429322807 ## be/src/olap/rowset/segment_v2/segment_iterator.cpp: ## @@ -2570,5 +2573,64 @@ void SegmentIterator::_calculate_pred_in_remaining_conjunct_root( } } +bool

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-15 Thread via GitHub
airborne12 commented on code in PR #28494: URL: https://github.com/apache/doris/pull/28494#discussion_r1428712086 ## be/src/olap/rowset/segment_v2/segment_iterator.cpp: ## @@ -2570,5 +2573,64 @@ void SegmentIterator::_calculate_pred_in_remaining_conjunct_root( } }

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-15 Thread via GitHub
doris-robot commented on PR #28494: URL: https://github.com/apache/doris/pull/28494#issuecomment-1857778985 (From new machine)TeamCity pipeline, clickbench performance test result: the sum of best hot time: 44.45 seconds stream load tsv: 592 seconds loaded 74807831229 Bytes,

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-15 Thread via GitHub
doris-robot commented on PR #28494: URL: https://github.com/apache/doris/pull/28494#issuecomment-1857768050 TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Tpch sf100 test result on commit 7b7168d441efc704607e6baffad246da3a9af0a7, data reload: false

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-15 Thread via GitHub
github-actions[bot] commented on code in PR #28494: URL: https://github.com/apache/doris/pull/28494#discussion_r1427878952 ## be/src/olap/rowset/segment_v2/segment_iterator.cpp: ## @@ -2570,5 +2573,64 @@ void SegmentIterator::_calculate_pred_in_remaining_conjunct_root( }

Re: [PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-15 Thread via GitHub
zzzxl1993 commented on PR #28494: URL: https://github.com/apache/doris/pull/28494#issuecomment-1857730993 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

[PR] [optimize](count) optimize pk exact query without reading data [doris]

2023-12-15 Thread via GitHub
zzzxl1993 opened a new pull request, #28494: URL: https://github.com/apache/doris/pull/28494 ## Proposed changes 1. If the primary key is used for an exact query, the count will be obtained without reading data ## Further comments If this is a relatively large