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

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

              Dates

                Created:
                Updated:
                Resolved: