Norris Lee created DRILL-907:
--------------------------------
Summary: 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)
