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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: v3.1.0, v3.0.1
• Component/s: Query Engine, Storage - HBase
• Assignee: Unassigned
• Reporter: fengwenduo
• Created: 14/Aug/20 06:42
• Updated: 31/Aug/20 07:59

Description

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!