[
https://issues.apache.org/jira/browse/DRILL-1317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mehant Baid reassigned DRILL-1317:
----------------------------------
Assignee: Mehant Baid
> Query fails when it has a large number of AND/OR conditions
> -----------------------------------------------------------
>
> Key: DRILL-1317
> URL: https://issues.apache.org/jira/browse/DRILL-1317
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Krystal
> Assignee: Mehant Baid
>
> git.commit.id.abbrev=654c879
> The following query with 73 nested AND/OR clauses ran successfully:
> SELECT IRI_IT_S_185_9642_O.ATTR_VALUE,
> IT_DIM_IRI_9642_1.S_16775_KEY,
> IT_DIM_IRI_9642_1.S_16774_KEY,
> IT_DIM_IRI_9642_1.S_16772_KEY,
> IT_DIM_IRI_9642_1.S_16768_KEY,
> IT_DIM_IRI_9642_1.S_16793_KEY,
> IT_DIM_IRI_9642_1.S_143839_KEY,
> IT_DIM_IRI_9642_1.S_143840_KEY,
> IT_DIM_IRI_9642_1.S_143957_KEY,
> IT_DIM_IRI_9642_1.S_86899_KEY,
> IT_DIM_IRI_9642_1.S_57419,
> IT_DIM_IRI_9642_1.S_16764_KEY
> FROM IT_DIM_IRI_9642_1,
> IRI_IT_S_185_9642_O
> WHERE (IT_DIM_IRI_9642_1.S_185_KEY = IRI_IT_S_185_9642_O.AVP_KEY) AND
> ((IT_DIM_IRI_9642_1.S_148225_KEY = 7053254) AND
> (((IT_DIM_IRI_9642_1.S_16764_KEY = 4527492) AND
> (IT_DIM_IRI_9642_1.S_16775_KEY = 3506999) AND
> (IT_DIM_IRI_9642_1.S_16774_KEY = 3506930) AND
> (IT_DIM_IRI_9642_1.S_16772_KEY = 3507035) AND
> (IT_DIM_IRI_9642_1.S_16793_KEY = 6124377) AND
> (IT_DIM_IRI_9642_1.S_16768_KEY = 3506872) AND
> (IT_DIM_IRI_9642_1.S_143839_KEY = 6748469)) OR
> ((IT_DIM_IRI_9642_1.S_16764_KEY = 4527492) AND
> (IT_DIM_IRI_9642_1.S_16775_KEY = 3506999) AND
> (IT_DIM_IRI_9642_1.S_16774_KEY = 3506930) AND
> (IT_DIM_IRI_9642_1.S_16772_KEY = 3507035) AND
> (IT_DIM_IRI_9642_1.S_16793_KEY = 6124377) AND
> (IT_DIM_IRI_9642_1.S_16768_KEY = 3506872) AND
> (IT_DIM_IRI_9642_1.S_143839_KEY = 6762219)) OR
> ((IT_DIM_IRI_9642_1.S_16764_KEY = 4527492) AND
> (IT_DIM_IRI_9642_1.S_16775_KEY = 3506999) AND
> (IT_DIM_IRI_9642_1.S_16774_KEY = 3506930) AND
> (IT_DIM_IRI_9642_1.S_16772_KEY = 3507035) AND
> (IT_DIM_IRI_9642_1.S_16793_KEY = 6124377) AND
> (IT_DIM_IRI_9642_1.S_143839_KEY = 6739956) AND
> (IT_DIM_IRI_9642_1.S_143840_KEY = 6776403) AND
> (IT_DIM_IRI_9642_1.S_16768_KEY = 3506872)) OR
> ((IT_DIM_IRI_9642_1.S_16764_KEY = 4527492) AND
> (IT_DIM_IRI_9642_1.S_16775_KEY = 3506999) AND
> (IT_DIM_IRI_9642_1.S_16774_KEY = 3506930) AND
> (IT_DIM_IRI_9642_1.S_16772_KEY = 3507035) AND
> (IT_DIM_IRI_9642_1.S_16793_KEY = 6124377) AND
> (IT_DIM_IRI_9642_1.S_143839_KEY = 6759687) AND
> (IT_DIM_IRI_9642_1.S_143840_KEY = 22740942) AND
> (IT_DIM_IRI_9642_1.S_16768_KEY = 3506872)) OR
> ((IT_DIM_IRI_9642_1.S_16764_KEY = 4527492) AND
> (IT_DIM_IRI_9642_1.S_16775_KEY = 3506999) AND
> (IT_DIM_IRI_9642_1.S_16774_KEY = 3506930) AND
> (IT_DIM_IRI_9642_1.S_16772_KEY = 3507035) AND
> (IT_DIM_IRI_9642_1.S_16768_KEY = 3506872) AND
> (IT_DIM_IRI_9642_1.S_16793_KEY = 6124377) AND
> (IT_DIM_IRI_9642_1.S_143839_KEY = 6765507) AND
> (IT_DIM_IRI_9642_1.S_143840_KEY = 6802826) AND
> (IT_DIM_IRI_9642_1.S_86899_KEY = 7101840)) OR
> ((IT_DIM_IRI_9642_1.S_16764_KEY = 4527492) AND
> (IT_DIM_IRI_9642_1.S_16775_KEY = 3506999) AND
> (IT_DIM_IRI_9642_1.S_16774_KEY = 3506930) AND
> (IT_DIM_IRI_9642_1.S_16772_KEY = 3507035) AND
> (IT_DIM_IRI_9642_1.S_16768_KEY = 3506872) AND
> (IT_DIM_IRI_9642_1.S_16793_KEY = 6124377) AND
> (IT_DIM_IRI_9642_1.S_143839_KEY = 9865669) AND
> (IT_DIM_IRI_9642_1.S_143840_KEY = 9438003) AND
> (IT_DIM_IRI_9642_1.S_86899_KEY = 4560583)) OR
> ((IT_DIM_IRI_9642_1.S_16764_KEY = 4527492) AND
> (IT_DIM_IRI_9642_1.S_16775_KEY = 3506999) AND
> (IT_DIM_IRI_9642_1.S_16774_KEY = 3506930) AND
> (IT_DIM_IRI_9642_1.S_16772_KEY = 3507035) AND
> (IT_DIM_IRI_9642_1.S_16768_KEY = 3506872) AND
> (IT_DIM_IRI_9642_1.S_16793_KEY = 6124377) AND
> (IT_DIM_IRI_9642_1.S_143839_KEY = 9865669) AND
> (IT_DIM_IRI_9642_1.S_143840_KEY = 9438003) AND
> (IT_DIM_IRI_9642_1.S_86899_KEY = 22642197)) OR
> ((IT_DIM_IRI_9642_1.S_16764_KEY = 4527492) AND
> (IT_DIM_IRI_9642_1.S_16775_KEY = 3506999) AND
> (IT_DIM_IRI_9642_1.S_16774_KEY = 3506930) AND
> (IT_DIM_IRI_9642_1.S_16772_KEY = 3507035) AND
> (IT_DIM_IRI_9642_1.S_16768_KEY = 3506872) AND
> (IT_DIM_IRI_9642_1.S_16793_KEY = 6124377) AND
> (IT_DIM_IRI_9642_1.S_143839_KEY = 9865669) AND
> (IT_DIM_IRI_9642_1.S_143840_KEY = 9438003) AND
> (IT_DIM_IRI_9642_1.S_86899_KEY = 4560261)) OR
> ((IT_DIM_IRI_9642_1.S_16764_KEY = 4527492) AND
> (IT_DIM_IRI_9642_1.S_16775_KEY = 3506999) AND
> (IT_DIM_IRI_9642_1.S_16774_KEY = 3506930) AND
> (IT_DIM_IRI_9642_1.S_16772_KEY = 3507035) AND
> (IT_DIM_IRI_9642_1.S_16768_KEY = 3506872) AND
> (IT_DIM_IRI_9642_1.S_16793_KEY = 6124377) AND
> (IT_DIM_IRI_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.
>
--
This message was sent by Atlassian JIRA
(v6.2#6252)
