fengYu created KYLIN-1833:
-----------------------------

             Summary: 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.5.2, v1.3.0
            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

I will work with it and upload my patch later.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to