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

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

     [ https://issues.apache.org/jira/browse/DRILL-1101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramana Inukonda Nagaraj reassigned DRILL-1101:
----------------------------------------------

    Assignee: Ramana Inukonda Nagaraj  (was: DrillCommitter)

> 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
>            Assignee: Ramana Inukonda Nagaraj
>            Priority: Blocker
>             Fix For: 0.4.0
>
>         Attachments: 0001-DRILL-1101-For-Union-All-allow-strings-of-different-.patch
>
>
> 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.3.4#6332)