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

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development