drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1317) Query fails when it has a large number of AND/OR conditions
Date Tue, 19 Aug 2014 23:41:19 GMT
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)

Mime
View raw message