drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1101) Cannot plan exception- Union all
Date Tue, 05 May 2015 00:50:06 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14527680#comment-14527680
] 

Khurram Faraaz commented on DRILL-1101:
---------------------------------------

Verified on 10833d2cae9f5312cf0e31f8c9f3f8a9dcdc0c45 | Commit 0.9.0 release version. | 03.05.2015
@ 14:56:56 EDT
test will be added into union_all tests.

{code}
0: jdbc:drill:> select 'abcdef' from `testWindow.csv` union all select 'xyz' from `employee.csv`;
+------------+
|   EXPR$0   |
+------------+
| abcdef     |
| abcdef     |
| abcdef     |
| abcdef     |
| abcdef     |
| abcdef     |
| abcdef     |
| abcdef     |
| abcdef     |
| abcdef     |
| abcdef     |
| xyz        |
+------------+
12 rows selected (0.185 seconds)
{code}

{code}
0: jdbc:drill:> explain plan for select 'abcdef' from `testWindow.csv` union all select
'xyz' from `employee.csv`;
+------------+------------+
|    text    |    json    |
+------------+------------+
| 00-00    Screen
00-01      UnionAll(all=[true])
00-03        Project(EXPR$0=['abcdef'])
00-05          Scan(groupscan=[EasyGroupScan [selectionRoot=/tmp/testWindow.csv, numFiles=1,
columns=[`*`], files=[maprfs:/tmp/testWindow.csv]]])
00-02        Project(EXPR$0=['xyz'])
00-04          Scan(groupscan=[EasyGroupScan [selectionRoot=/tmp/employee.csv, numFiles=1,
columns=[`*`], files=[maprfs:/tmp/employee.csv]]])
{code}

> 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)

Mime
View raw message