[ https://issues.apache.org/jira/browse/DRILL-1101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ramana Inukonda Nagaraj closed DRILL-1101. ------------------------------------------ Closing based on Khurram's last comment. > 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)