drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-657) Selecting all columns with filter only returns column specified in where clause
Date Thu, 31 Jul 2014 05:53:47 GMT

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

Jacques Nadeau resolved DRILL-657.
----------------------------------

    Resolution: Fixed

> Selecting all columns with filter only returns column specified in where clause
> -------------------------------------------------------------------------------
>
>                 Key: DRILL-657
>                 URL: https://issues.apache.org/jira/browse/DRILL-657
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: SQL Parser
>    Affects Versions: m1
>            Reporter: Krystal
>            Assignee: Jacques Nadeau
>             Fix For: 0.4.0
>
>
> In the latest drill merge, select all columns with filters does not return all columns
from table. Instead it returns only columns specified in the where clause.
> select * from voter where age < 19;
> +------------+
> |    age     |
> +------------+
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> | 18         |
> +------------+
> select * from voter where name like '%van%' and age < 30;
> +------------+------------+
> |    age     |    name    |
> +------------+------------+
> | 19         | [B@52aadf7b |
> | 25         | [B@50362ea3 |
> +------------+------------+



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

Mime
View raw message