You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/08/25 06:04:45 UTC
[GitHub] [incubator-doris] Astralidea opened a new issue #4444: Doris Implicit conversion affects query performance
Astralidea opened a new issue #4444:
URL: https://github.com/apache/incubator-doris/issues/4444
**Describe the bug**
A clear and concise description of what the bug is.
按如下步骤进行操作：
Follow the steps below：
**To Reproduce**
Steps to reproduce the behavior:
1.
CREATE TABLE app_rt_flow_poi_intent_uv_price_v2 (
datekey int(11) NULL COMMENT "datekey",
poi_id bigint(20) NULL COMMENT "poi_id",
area_id int(11) NULL COMMENT "area_id",
device_id_hll hll HLL_UNION NULL COMMENT "uv"
) ENGINE=OLAP
AGGREGATE KEY(datekey, poi_id, area_id)
COMMENT "OLAP"
PARTITION BY RANGE(datekey)
(PARTITION p20191110 VALUES [("-2147483648"), ("20200726")),
PARTITION p20200727 VALUES [("20200726"), ("20200727")),
PARTITION p20200728 VALUES [("20200727"), ("20200728")),
PARTITION p20200729 VALUES [("20200728"), ("20200729")),
PARTITION p20200730 VALUES [("20200729"), ("20200730")),
PARTITION p20200731 VALUES [("20200730"), ("20200731")),
PARTITION p20200801 VALUES [("20200731"), ("20200801")),
PARTITION p20200802 VALUES [("20200801"), ("20200802")),
PARTITION p20200803 VALUES [("20200802"), ("20200803")),
PARTITION p20200804 VALUES [("20200803"), ("20200804")),
PARTITION p20200805 VALUES [("20200804"), ("20200805")))
DISTRIBUTED BY HASH(poi_id) BUCKETS 20
PROPERTIES (
"storage_type" = "COLUMN",
"replication_num" = "1"
);
2.
insert into app_rt_flow_poi_intent_uv_price_v2 values (20200725, 123, 456, hll_hash(789))
insert into app_rt_flow_poi_intent_uv_price_v2 values (20200726, 123, 456, hll_hash(789))
insert into app_rt_flow_poi_intent_uv_price_v2 values (20200727, 123, 456, hll_hash(789))
insert into app_rt_flow_poi_intent_uv_price_v2 values (20200728, 123, 456, hll_hash(789))
insert into app_rt_flow_poi_intent_uv_price_v2 values (20200729, 123, 456, hll_hash(789))
insert into app_rt_flow_poi_intent_uv_price_v2 values (20200730, 123, 456, hll_hash(789))
insert into app_rt_flow_poi_intent_uv_price_v2 values (20200801, 123, 456, hll_hash(789))
insert into app_rt_flow_poi_intent_uv_price_v2 values (20200802, 123, 456, hll_hash(789))
insert into app_rt_flow_poi_intent_uv_price_v2 values (20200803, 123, 456, hll_hash(789))
insert into app_rt_flow_poi_intent_uv_price_v2 values (20200804, 123, 456, hll_hash(789))
3.
explain select count(*)
from app_rt_flow_poi_intent_uv_price_v2
where datekey='20200730'
4.
explain select count(*)
from app_rt_flow_poi_intent_uv_price_v2
where datekey=20200730
**Expected behavior**
A clear and concise description of what you expected to happen.
希望的是一样的性能，但是从执行计划来看，字符串'20200730'被转换成了double，从而导致要查询所有的分区。
当这些分区数据量比较大的时候，从而影响性能。
The desired performance is the same, but from the execution plan, the string '20200730' is converted to double, which leads to querying all partitions.
**Screenshots**
If applicable, add screenshots to help explain your problem.
**Desktop (please complete the following information):**
- OS: [e.g. iOS]
- Browser [e.g. chrome, safari]
- Version [e.g. 22]
**Smartphone (please complete the following information):**
- Device: [e.g. iPhone6]
- OS: [e.g. iOS8.1]
- Browser [e.g. stock browser, safari]
- Version [e.g. 22]
**Additional context**
Add any other context about the problem here.
----------------------------------------------------------------
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.
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
[GitHub] [incubator-doris] morningman closed issue #4444: Doris Implicit conversion affects query performance
Posted by GitBox <gi...@apache.org>.
morningman closed issue #4444:
URL: https://github.com/apache/incubator-doris/issues/4444
----------------------------------------------------------------
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.
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