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

        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12863662 ] Drill workflow [ 12934205 ]
        Jacques Nadeau made changes -
        Fix Version/s 0.4.0 [ 12324963 ]
        Jacques Nadeau made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Mehant Baid made changes -
        Component/s Execution - Flow [ 12322690 ]
        Component/s Functions - Drill [ 12322695 ]
        Steven Phillips made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Steven Phillips made changes -
        Field Original Value New Value
        Attachment DRILL-789.patch [ 12646145 ]
        Krystal created issue -

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development