You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2014/08/20 01:41:19 UTC
[jira] [Created] (DRILL-1317) Query fails when it has a large
number of AND/OR conditions
Krystal created DRILL-1317:
------------------------------
Summary: 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
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)