Apache Drill
  1. Apache Drill
  2. DRILL-789

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

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major 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
      1. DRILL-789.patch
        5 kB
        Steven Phillips

        Activity

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development