Apache Drill
  1. Apache Drill
  2. DRILL-907

Inner joins that have no results do not return any metadata

    Details

      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.

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Steven Phillips
            Reporter:
            Norris Lee
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development