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

Drill fails with OOM for the case of large filter conditions

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.16.0
    • Fix Version/s: 1.18.0
    • Component/s: None
    • Labels:
      None

      Description

      Drill fails with OOM for the following query:

      SELECT * FROM (SELECT n.n_name AS name, n.n_nationkey AS  n_nationkey, cast(n.n_regionkey AS FLOAT) AS regionkey FROM cp.`/tpch/nation.parquet` n) WHERE ((name = 'A' AND ((regionkey >= 0.0 AND regionkey <= 120.0 AND  n_nationkey = 0.005))) OR (name = 'B' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'C' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'D' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'E' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'F' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'G' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'I' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'J' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'K' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'L' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'M' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'N' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'O' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'P' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))) OR (name = 'Q' AND ((regionkey >= 0.0  AND regionkey <= 120.0  AND  n_nationkey = 0.005))))
      

        Attachments

          Activity

            People

            • Assignee:
              volodymyr Vova Vysotskyi
              Reporter:
              volodymyr Vova Vysotskyi
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: