drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Norris Lee (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-907) Inner joins that have no results do not return any metadata
Date Tue, 24 Jun 2014 17:19:25 GMT

    [ 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)

Mime
View raw message