[
https://issues.apache.org/jira/browse/KYLIN-4969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17324550#comment-17324550
]
zhimin wu commented on KYLIN-4969:
----------------------------------
*Dev Design*
Filtering conditions that cannot be converted precisely have been defined as
loosened in Kylin and the columns involved have been added to the Group
Dimension of QueryRequest. But two things need to be added here.
1. For some filter conditions of derived dimensions that cannot be translated
directly from the value in Snapshot to the filter conditions of ordinary
dimensions (such as two columns are equal or contain some functions whose
results cannot be directly determined).
2. When the filter condition is OR operated with other filter conditions
defined as loosened.
> Query results may be incorrect if the query filter condition contains derived
> dimensions
> ----------------------------------------------------------------------------------------
>
> Key: KYLIN-4969
> URL: https://issues.apache.org/jira/browse/KYLIN-4969
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v3.1.1
> Reporter: zhimin wu
> Assignee: zhimin wu
> Priority: Major
> Fix For: v3.2.0
>
> Attachments: image-2021-04-11-16-11-03-058.png,
> image-2021-04-11-16-14-10-698.png, image-2021-04-11-16-15-52-352.png,
> image-2021-04-11-16-17-45-890.png, image-2021-04-11-16-21-53-243.png
>
> Original Estimate: 48h
> Remaining Estimate: 48h
>
> There are three tables.
> !image-2021-04-11-16-11-03-058.png|width=431,height=280!
> Model as follows
> !image-2021-04-11-16-14-10-698.png|width=824,height=328!
> Cube as follows
> !image-2021-04-11-16-15-52-352.png|width=765,height=425!
> the query result on kylin
> !image-2021-04-11-16-17-45-890.png|width=762,height=450!
> resule on hive
> !image-2021-04-11-16-21-53-243.png|width=1207,height=913!
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
