[
https://issues.apache.org/jira/browse/DRILL-1101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14527312#comment-14527312
]
Ramana Inukonda Nagaraj commented on DRILL-1101:
------------------------------------------------
[~khfaraaz]
Can you please close this out and add a test case.
> 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)
