[
https://issues.apache.org/jira/browse/DRILL-1295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14100799#comment-14100799
]
Jacques Nadeau commented on DRILL-1295:
---------------------------------------
resolved by 654c879 or earlier.
> Select returns null for non pivot fields with a nested select
> -------------------------------------------------------------
>
> Key: DRILL-1295
> URL: https://issues.apache.org/jira/browse/DRILL-1295
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Reporter: Hanifi Gunes
> Assignee: DrillCommitter
> Fix For: 0.5.0
>
> Attachments: DRILL-1295.patch
>
>
> Take two simple csv files:
> t1.csv:
> ID,Name,Lastname
> 9711942,name0,last0
> 9707867,name1,last1
> t2.csv
> ID,Case Number
> 9711942,HX362083
> 9707867,HX357851
> The following queries return:
> select columns[0], columns[1], columns[2]
> FROM dfs.`/path/to/t1.csv`;
> +------------+------------+------------+
> | ID | Name | Lastname |
> | 9711942 | name0 | last0 |
> | 9707867 | name1 | last1 |
> +------------+------------+------------+
> SELECT columns[0], columns[1] FROM dfs.`/path/to/t2.csv`;
> +------------+------------+
> | ID | Case Number |
> | 9711942 | HX362083 |
> | 9707867 | HX357851 |
> +------------+------------+
> This one returns all the fields null except the pivot field
> select columns[0], columns[1], columns[2]
> FROM dfs.`/path/to/t1.csv`
> where columns[0] in
> (SELECT columns[0] FROM dfs.`/path/to/t2.csv`);
> +------------+------------+------------+
> | ID | null | null |
> | 9711942 | null | null |
> | 9707867 | null | null |
> +------------+------------+------------+
--
This message was sent by Atlassian JIRA
(v6.2#6252)
