You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@kylin.apache.org by "fengwenduo (Jira)" <ji...@apache.org> on 2020/08/14 06:43:00 UTC

[jira] [Created] (KYLIN-4696) The result is wrong when using multiple dimension with in filter which including multiple filter value

fengwenduo created KYLIN-4696:
---------------------------------

             Summary: The result is wrong when using multiple dimension with in filter which including multiple filter value
                 Key: KYLIN-4696
                 URL: https://issues.apache.org/jira/browse/KYLIN-4696
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine, Storage - HBase
    Affects Versions: v3.0.1, v3.1.0
            Reporter: fengwenduo
         Attachments: correct01.png, correct02.png, wrong.png

I have a cube with 17 dimensions, when I query from the cube using multiple dimension with in filter which including multiple filter value, the result is not correct. 

But if i query the cube first, then filter outside the result in another query, the result is correct.

Or if i add trim on the dimension when query the cube directly, the result is correct too.

Till now, I do not find other cube have this question. I do not know why?

I attach the snapshot of the query and result.

Thank you!



--
This message was sent by Atlassian Jira
(v8.3.4#803005)