[jira] [Commented] (DRILL-907) Inner joins that have no results do not return any metadata

["George Chow (JIRA)" <ji...@apache.org>]

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

George Chow commented on DRILL-907:
-----------------------------------

This style of query is used by Tableau when using 'Multiple tables'.


> 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
>            Reporter: Norris Lee
>
> 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)