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

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.16.0
    • 1.18.0
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: