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

Random IOBException when doing an inner join on a table with wide strings

    XMLWordPrintableJSON

Details

    Description

      git.commit.id.abbrev=462e50c

      When I ran the below query along with similar such queries in parallel, I have seen it fail randomly. Did not see this failure from sqlline when I ran this query alone.

      select ws1.* from widestrings ws1 INNER JOIN (select str_var_null_empty from widestrings where str_var_null_empty is not null and length(str_var_null_empty) <> 0 )ws2 on ws1.str_empty_null=ws2.str_var_null_empty where ws1.str_empty_null is not null and length(ws1.str_empty_null) <> 0 and length(ws1.str_var_null_empty) > 4995 and length(ws2.str_var_null_empty) > 4800;
      

      I attached the error log. Since the data is large, I did not attach it here

      Attachments

        1. error.log
          7 kB
          Rahul Kumar Challapalli

        Issue Links

          Activity

            People

              Unassigned Unassigned
              rkins Rahul Kumar Challapalli
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: