You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/07/31 07:53:47 UTC
[jira] [Resolved] (DRILL-657) Selecting all columns with filter
only returns column specified in where clause
[ 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)