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

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Execution - Flow
• Labels: Metadata Tableau
• Assignee: Steven Phillips
• Reporter: Norris Lee
• Created: 05/Jun/14 01:01
• Updated: 24/Jun/14 17:23
• Resolved: 24/Jun/14 17:23

Description

When executing the query

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

the expected result is 0 rows. Sqlline returns this:

+--+
|  |
+--+
+--+
No rows selected (1.868 seconds)

However, the recordbatch coming back has no metadata in them. They should at least come back with the column names and types.