EmmyMiao87 edited a comment on issue #7433:
URL:
https://github.com/apache/incubator-doris/issues/7433#issuecomment-999259695
需求
1. 支持对 where 条件中带多个 range 的 分区列进行裁剪。比如 where a=1 or a=2 则也可以进行分区裁剪。
2. 支持 list 分区的多分区列的更精细化的分区裁剪。比如 list partition (k1, k2) 则支持对 where k1>1 and
k2>1 多列裁剪。
a. 之前的问题在于 多列分区时，不同列之间裁剪出的结果是一个并集。比如 将满足 条件 k1>1 的分区和 k2>1 的分区进行
union。这就导致了裁剪的不够惊喜。语义缺少了 and。
b. 支持了精确的分区裁剪，考虑 同时满足k1>1 and k2>1 的分区。
Requirement
1. Support for trimming the partition columns with multiple ranges in the
where condition. For example, where a=1 or a=2, partition cutting can also be
performed.
2. Support more refined partition tailoring of multi-partition columns of
list partition. For example, list partition (k1, k2) supports multi-column
clipping where k1>1 and k2>1.
a. The previous problem is that when partitioning by multiple columns,
the result of cropping between different columns is a union. For example, the
partition that satisfies the condition k1>1 and the partition of k2>1 are
unioned. This leads to the lack of surprises in tailoring. The semantics are
missing and.
b. Supports precise partition tailoring, consider partitions satisfying
k1>1 and k2>1 at the same time.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
