Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.incubator.apache.org
Date: Tue, 24 Jun 2014 17:19:25 +0000 (UTC)
From: "Norris Lee (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12718518.1401930077724.38470.1403630365514@arcas>
In-Reply-To: <JIRA.12718518.1401930077724@arcas>
References: <JIRA.12718518.1401930077724@arcas>
Subject: [jira] [Commented] (DRILL-907) Inner joins that have no results do
 not return any metadata
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Norris Lee commented on DRILL-907:
----------------------------------

Fixed with the [https://issues.apache.org/jira/browse/DRILL-884] patch.

> Inner joins that have no results do not return any metadata
> -----------------------------------------------------------
>
>                 Key: DRILL-907
>                 URL: https://issues.apache.org/jira/browse/DRILL-907
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>            Reporter: Norris Lee
>            Assignee: Steven Phillips
>            Priority: Critical
>              Labels: Metadata, Tableau
>             Fix For: 1.0.0-BETA1
>
>
> When executing the query
> {code}
> SELECT `time_table`.`column1` AS `columnB`,
>   `emp`.`date_hire` AS `date_hire`,
>   `emp`.`dept` AS `dept`,
>   `emp`.`emp_id` AS `emp_id`,
>   `emp`.`first_name` AS `first_name`,
>   `emp`.`interests` AS `interests`,
>   `time_table`.`keycolumn` AS `keycolumn`,
>   `emp`.`last_name` AS `last_name`,
>   `emp`.`log_exempt` AS `log_exempt`,
>   `emp`.`num_salary` AS `num_salary`
> FROM `hive43.default`.`emp` `emp`
>   INNER JOIN `hive43.default`.`time_table` `time_table` ON (`emp`.`last_name` = `time_table`.`column1`)
> LIMIT 10000
> {code}
> the expected result is 0 rows. Sqlline returns this:
> {code}
> +--+
> |  |
> +--+
> +--+
> No rows selected (1.868 seconds)
> {code}
> However, the recordbatch coming back has no metadata in them. They should at least come back with the column names and types.


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