[
https://issues.apache.org/jira/browse/DRILL-1336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14109887#comment-14109887
]
Krystal commented on DRILL-1336:
--------------------------------
The following query with 73 nested AND/OR clauses ran successfully:
SELECT IT_S_185_9642_O.ATTR_VALUE,
TABLE_9642_1.S_16775_KEY,
TABLE_9642_1.S_16774_KEY,
TABLE_9642_1.S_16772_KEY,
TABLE_9642_1.S_16768_KEY,
TABLE_9642_1.S_16793_KEY,
TABLE_9642_1.S_143839_KEY,
TABLE_9642_1.S_143840_KEY,
TABLE_9642_1.S_143957_KEY,
TABLE_9642_1.S_86899_KEY,
TABLE_9642_1.S_57419,
TABLE_9642_1.S_16764_KEY
FROM TABLE_9642_1,
IT_S_185_9642_O
WHERE (TABLE_9642_1.S_185_KEY = IT_S_185_9642_O.AVP_KEY) AND
((TABLE_9642_1.S_148225_KEY = 7053254) AND
(((TABLE_9642_1.S_16764_KEY = 4527492) AND
(TABLE_9642_1.S_16775_KEY = 3506999) AND
(TABLE_9642_1.S_16774_KEY = 3506930) AND
(TABLE_9642_1.S_16772_KEY = 3507035) AND
(TABLE_9642_1.S_16793_KEY = 6124377) AND
(TABLE_9642_1.S_16768_KEY = 3506872) AND
(TABLE_9642_1.S_143839_KEY = 6748469)) OR
((TABLE_9642_1.S_16764_KEY = 4527492) AND
(TABLE_9642_1.S_16775_KEY = 3506999) AND
(TABLE_9642_1.S_16774_KEY = 3506930) AND
(TABLE_9642_1.S_16772_KEY = 3507035) AND
(TABLE_9642_1.S_16793_KEY = 6124377) AND
(TABLE_9642_1.S_16768_KEY = 3506872) AND
(TABLE_9642_1.S_143839_KEY = 6762219)) OR
((TABLE_9642_1.S_16764_KEY = 4527492) AND
(TABLE_9642_1.S_16775_KEY = 3506999) AND
(TABLE_9642_1.S_16774_KEY = 3506930) AND
(TABLE_9642_1.S_16772_KEY = 3507035) AND
(TABLE_9642_1.S_16793_KEY = 6124377) AND
(TABLE_9642_1.S_143839_KEY = 6739956) AND
(TABLE_9642_1.S_143840_KEY = 6776403) AND
(TABLE_9642_1.S_16768_KEY = 3506872)) OR
((TABLE_9642_1.S_16764_KEY = 4527492) AND
(TABLE_9642_1.S_16775_KEY = 3506999) AND
(TABLE_9642_1.S_16774_KEY = 3506930) AND
(TABLE_9642_1.S_16772_KEY = 3507035) AND
(TABLE_9642_1.S_16793_KEY = 6124377) AND
(TABLE_9642_1.S_143839_KEY = 6759687) AND
(TABLE_9642_1.S_143840_KEY = 22740942) AND
(TABLE_9642_1.S_16768_KEY = 3506872)) OR
((TABLE_9642_1.S_16764_KEY = 4527492) AND
(TABLE_9642_1.S_16775_KEY = 3506999) AND
(TABLE_9642_1.S_16774_KEY = 3506930) AND
(TABLE_9642_1.S_16772_KEY = 3507035) AND
(TABLE_9642_1.S_16768_KEY = 3506872) AND
(TABLE_9642_1.S_16793_KEY = 6124377) AND
(TABLE_9642_1.S_143839_KEY = 6765507) AND
(TABLE_9642_1.S_143840_KEY = 6802826) AND
(TABLE_9642_1.S_86899_KEY = 7101840)) OR
((TABLE_9642_1.S_16764_KEY = 4527492) AND
(TABLE_9642_1.S_16775_KEY = 3506999) AND
(TABLE_9642_1.S_16774_KEY = 3506930) AND
(TABLE_9642_1.S_16772_KEY = 3507035) AND
(TABLE_9642_1.S_16768_KEY = 3506872) AND
(TABLE_9642_1.S_16793_KEY = 6124377) AND
(TABLE_9642_1.S_143839_KEY = 9865669) AND
(TABLE_9642_1.S_143840_KEY = 9438003) AND
(TABLE_9642_1.S_86899_KEY = 4560583)) OR
((TABLE_9642_1.S_16764_KEY = 4527492) AND
(TABLE_9642_1.S_16775_KEY = 3506999) AND
(TABLE_9642_1.S_16774_KEY = 3506930) AND
(TABLE_9642_1.S_16772_KEY = 3507035) AND
(TABLE_9642_1.S_16768_KEY = 3506872) AND
(TABLE_9642_1.S_16793_KEY = 6124377) AND
(TABLE_9642_1.S_143839_KEY = 9865669) AND
(TABLE_9642_1.S_143840_KEY = 9438003) AND
(TABLE_9642_1.S_86899_KEY = 22642197)) OR
((TABLE_9642_1.S_16764_KEY = 4527492) AND
(TABLE_9642_1.S_16775_KEY = 3506999) AND
(TABLE_9642_1.S_16774_KEY = 3506930) AND
(TABLE_9642_1.S_16772_KEY = 3507035) AND
(TABLE_9642_1.S_16768_KEY = 3506872) AND
(TABLE_9642_1.S_16793_KEY = 6124377) AND
(TABLE_9642_1.S_143839_KEY = 9865669) AND
(TABLE_9642_1.S_143840_KEY = 9438003) AND
(TABLE_9642_1.S_86899_KEY = 4560261)) OR
((TABLE_9642_1.S_16764_KEY = 4527492) AND
(TABLE_9642_1.S_16775_KEY = 3506999) AND
(TABLE_9642_1.S_16774_KEY = 3506930) AND
(TABLE_9642_1.S_16772_KEY = 3507035) AND
(TABLE_9642_1.S_16768_KEY = 3506872) AND
(TABLE_9642_1.S_16793_KEY = 6124377) AND
(TABLE_9642_1.S_143839_KEY = 9865669))));
However, if I add another AND or OR clause; the query would fail with the
following error:
Query failed: Failure while running fragment. You tried to do a batch data read
operation when you were in a state of STOP. You can only do this type of
operation when you are in a state of OK or OK_NEW_SCHEMA.
> Support for large number of AND/OR predicates
> ---------------------------------------------
>
> Key: DRILL-1336
> URL: https://issues.apache.org/jira/browse/DRILL-1336
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 0.4.0
> Reporter: Neeraja
> Assignee: Krystal
> Priority: Critical
>
> This is a tracking bug for supporting large number of (100s) AND/OR
> predicates/clauses in the WHERE clause for Drill queries.
> Currently beyond a certain limit, it fails with the error below.
> Query failed: Failure while running fragment. You tried to do a batch data
> read operation when you were in a state of STOP. You can only do this type
> of operation when you are in a state of OK or OK_NEW_SCHEMA.
> Krystal, can you please add a repro for this issue.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
