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

Wrong result when doing left outer join on CSV table

    XMLWordPrintableJSON

    Details

      Description

      The following query shows 1 row that is incorrect. For the non-null rows, both columns should have the same value. This is on CSV sample data (I will attach the files).

      apache drill (dfs.tmp)> select tt5.columns[0], tt6.columns[0] from tt5 left outer join tt6  on tt5.columns[0] = tt6.columns[0];
      +--------+--------+
      | EXPR$0 | EXPR$1 |
      +--------+--------+
      | 455    | null   |
      | 455    | null   |
      | 555    | null   |
      | 1414   | 1414   |
      | 455    | null   |
      | 580    | null   |
      | 1111   | null   |
      | 555    | null   |
      | 455    | null   |
      | 455    | null   |
      | 455    | null   |
      | 455    | null   |
      | 455    | null   |
      | 555    | null   |
      | 455    | null   |
      | 455    | null   |
      | 455    | null   |
      | 580    | null   |
      | 6767   | null   |
      | 455    | null   |
      | 555    | null   |
      | 455    | null   |
      | 555    | null   |
      | 555    | null   |
      | 555    | null   |
      | 455    | null   |
      | 555    | null   |
      | 455    | null   |
      | 455    | null   |
      | 455    | null   |
      | 6767   | null   |
      | 555    | null   |
      | 555    | null   |
      | 455    | null   |
      | 555    | null   |
      | 555    | null   |
      | 1414   | 1414   |
      | 455    | null   |
      | 555    | null   |
      | 555    | null   |
      | 455    | null   |
      | 455    | null   |
      | 555    | null   |
      | 455    | null   |
      | 555    | null   |
      | 555    | null   |
      | 455    | null   |
      | 455    | null   |
      | 9669   | 1414   |          <--- Wrong result
      | 555    | null   |
      | 455    | null   |
      | 455    | null   |
      | 455    | null   |
      | 555    | null   |
      | 580    | null   |
      | 455    | null   |
      | 555    | null   |
      | 455    | null   |
      | 555    | null   |
      | 455    | null   |
      | 455    | null   |
      | 409    | null   |
      | 455    | null   |
      | 555    | null   |
      | 555    | null   |
      | 455    | null   |
      | 455    | null   |
      | 555    | null   |
      | 455    | null   |
      | 555    | null   |
      | 1414   | 1414   |
      | 455    | null   |
      | 555    | null   |
      | 555    | null   |
      | 555    | null   |
      +--------+--------+
      75 rows selected 
      

        Attachments

        1. tt5.tar.gz
          0.2 kB
          Aman Sinha
        2. tt6.tar.gz
          0.3 kB
          Aman Sinha

          Issue Links

            Activity

              People

              • Assignee:
                volodymyr Vova Vysotskyi
                Reporter:
                amansinha100 Aman Sinha
                Reviewer:
                Igor Guzenko
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: