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

3 way join over text files (no views) fails

    XMLWordPrintableJSON

    Details

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

      Description

      git.commit.id.abbrev=1ce7c93

      The below query which joins 2 text files work

      select r.columns[1] from rankings r, uservisits u where r.columns[1]=u.columns[1];
      

      However the below query with a 3-way join over text files just hangs in sql line without throwing any error

      select r.columns[1] from rankings r, uservisits u, `temp.tbl` t where r.columns[1]=u.columns[1] and r.columns[1] = t.columns[0];
      

      Attached the error from the log file along with the data files

        Attachments

        1. 0002-DRILL-1421-Add-unit-tests-and-data.-Bump-up-drill-op.patch
          1.51 MB
          Aman Sinha
        2. error.txt
          19 kB
          Rahul Kumar Challapalli
        3. rankings.tbl
          296 kB
          Rahul Kumar Challapalli
        4. temp.tbl
          0.0 kB
          Rahul Kumar Challapalli
        5. uservisits.tbl
          1.20 MB
          Rahul Kumar Challapalli

          Activity

            People

            • Assignee:
              DrillCommitter DrillCommitter
              Reporter:
              rkins Rahul Kumar Challapalli
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: