[ https://issues.apache.org/jira/browse/KYLIN-1833?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15354387#comment-15354387 ]
fengYu commented on KYLIN-1833: ------------------------------- the result is error. In kylin-2.x, the result is : a 1987 b 5844 c 5844 and the right result is : a 2021 b 7987 c 5946 in kylin-1.x, the id of OLAPContext is incorrect because for every subquery, kylin allocate a OLAPRel.OLAPImplementor and OLAPContext.id always equals to 0, which cause the generated code has some error. I move OLAPRel.OLAPImplementor to ThreadLocal virable and get right result. However, in kylin-2.x, there are seems more effects, I am trying to find the reason in kylin-2.x > union operation will cause error result > --------------------------------------- > > Key: KYLIN-1833 > URL: https://issues.apache.org/jira/browse/KYLIN-1833 > Project: Kylin > Issue Type: Improvement > Components: Query Engine > Affects Versions: v1.3.0, v1.5.2 > Reporter: fengYu > Assignee: fengYu > > query like this will get error result : > select * from ( > select 'b', count(1) from kylin_sales where lstg_format_name >= 'Auction' > union all > select 'a', count(1) from kylin_sales where lstg_format_name >= 'Others' > union all > select 'c', count(1) from kylin_sales where lstg_format_name >= 'FP-GTC' > ) order by 1 -- This message was sent by Atlassian JIRA (v6.3.4#6332)