You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2020/06/30 20:30:00 UTC
[jira] [Commented] (DRILL-7761) Drill fails with OOM for the case
of large filter conditions
[ https://issues.apache.org/jira/browse/DRILL-7761?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17148945#comment-17148945 ]
ASF GitHub Bot commented on DRILL-7761:
---------------------------------------
vvysotskyi opened a new pull request #2091:
URL: https://github.com/apache/drill/pull/2091
# [DRILL-7761](https://issues.apache.org/jira/browse/DRILL-7761): Drill fails with OOM for the case of large filter conditions
## Description
Added threshold for the number of nodes that can be created out of the conversion to avoid OOM.
## Documentation
NA
## Testing
Added unit test.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
> Drill fails with OOM for the case of large filter conditions
> ------------------------------------------------------------
>
> Key: DRILL-7761
> URL: https://issues.apache.org/jira/browse/DRILL-7761
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.16.0
> Reporter: Vova Vysotskyi
> Assignee: Vova Vysotskyi
> Priority: Major
> Fix For: 1.18.0
>
>
> Drill fails with OOM for the following query:
> {code:sql}
> 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))))
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)