[jira] [Closed] (DRILL-1288) With json data drill is not returning all the columns in the query involving a join

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

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

Rahul Challapalli closed DRILL-1288.
------------------------------------

Verified and added the below testcase

Functional/Passing/tpch0.01/json/jsonbug_DRILL1288.q

> With json data drill is not returning all the columns in the query involving a join
> -----------------------------------------------------------------------------------
>
>                 Key: DRILL-1288
>                 URL: https://issues.apache.org/jira/browse/DRILL-1288
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JSON
>            Reporter: Rahul Challapalli
>            Assignee: Mehant Baid
>            Priority: Critical
>             Fix For: 0.5.0
>
>         Attachments: nation.json, supplier.json
>
>
> git.commit.id.abbrev
> In the below  case drill does not return the 3rd column
> {code}
> select
>       s.s_suppkey,
>       s.s_nationkey,
>       n.n_name
>     from
>       supplier s,
>       nation n
>     where
>       s.s_nationkey = n.n_nationkey limit 1;
> +------------+-------------+
> | s_suppkey  | s_nationkey |
> +------------+-------------+
> | 1          | 17          |
> +------------+-------------+
> {code}
> In the below case drill does not return the second column
> {code}
> select
>       n.n_name,
>       s.s_suppkey
>     from
>       supplier s,
>       nation n
>     where
>       s.s_nationkey = n.n_nationkey limit 1;
> +------------+
> |   n_name   |
> +------------+
> | PERU       |
> +------------+
> {code}
> Looks like drill is only returning the columns from table/file of the first column. If the first column is from nation, drill returns all subsequent columns from nation but does not return anything from supplier.
> However if use a function on columns from the second table, drill does return everything normally
> {code}
> select
>       s.s_suppkey,
>       char_length(n.n_name) as name_length
>     from
>       supplier s,
>       nation n
>     where
>       s.s_nationkey = n.n_nationkey limit 1;
> +------------+-------------+
> | s_suppkey  | name_length |
> +------------+-------------+
> | 1          | 4           |
> +------------+-------------+
> {code}
> This issue is affecting TPCH queries 10, 7, 3 on top of JSON data.
> Data used is provided as an attachement



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)