[jira] [Created] (DRILL-1101) Cannot plan exception- Union all

["Ramana Inukonda Nagaraj (JIRA)" <ji...@apache.org>]

Ramana Inukonda Nagaraj created DRILL-1101:
----------------------------------------------

             Summary: Cannot plan exception- Union all
                 Key: DRILL-1101
                 URL: https://issues.apache.org/jira/browse/DRILL-1101
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
            Reporter: Ramana Inukonda Nagaraj
            Priority: Blocker


Following query results in a CannotPlanException

select   emails.technology_type , emails.organization,
emails.metric_no, emails.metric_name, emails.metric_value
from(
        select 'emails' as technology_type ,
        b1.organization as organization,
        1 as metric_no, 'email_count' as metric_name, 2*count(distinct message_id) as metric_value
        from emails a1
        left outer join employee_table b1 
        on (a1.sender_address = b1.emailid)
        where a1.event_id = 'RECEIVE'
        group by b1.organization

        union all
        select 'emails' as technology_type,   
        b2.organization as organization,
        2 as metric_no, 'email_active_employee_count' as metric_name, count(*) as metric_value
        from employee_table b2
        where b2.status = 'A'
        group by b2.organization
) emails;



--
This message was sent by Atlassian JIRA
(v6.2#6252)