Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-789

Left outer join returns "null" values for columns from the right table

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: Execution - Flow
    • Labels:
      None

      Description

      git.commit.id.abbrev=5d7e3d3

      0: jdbc:drill:schema=dfs> select voter.name voter_name, voter.registration registration, student.name student_name, student.gpa gpa from voter left outer join student on (student.name = voter.name) where voter.age < 30;
      ----------------------------------------------+

      voter_name registration student_name gpa

      ----------------------------------------------+

      [B@6ca2652 [B@4199d4f9 null null
      [B@5a6d4914 [B@3cd8ee6d null null
      [B@460d5550 [B@155c1b1e null null
      [B@51f85986 [B@7bd9675 null null
      [B@2fe0df4b [B@5463cd7b null null
      [B@64477185 [B@e6e0632 null null

        Attachments

        1. DRILL-789.patch
          5 kB
          Steven Phillips

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              knguyen Krystal
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: