drill-issues mailing list archives

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

    [ https://issues.apache.org/jira/browse/DRILL-1317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14103044#comment-14103044
] 

Krystal commented on DRILL-1317:
--------------------------------

Server Error:
ava.lang.IllegalStateException: 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.
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.validateReadState(IteratorValidatorBatchIterator.java:54)
~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.iterator(IteratorValidatorBatchIterator.java:64)
~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.test.generated.HashJoinProbeGen134.executeProbePhase(HashJoinProbeTemplate.java:116)
~[na:na]
org.apache.drill.exec.test.generated.HashJoinProbeGen134.probeAndProject(HashJoinProbeTemplate.java:246)
~[na:na]
org.apache.drill.exec.physical.impl.join.HashJoinBatch.innerNext(HashJoinBatch.java:212) ~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:95) ~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:116)
~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:75) ~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:65) ~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:45)
~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:120)
~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:95) ~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:116)
~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:75) ~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:65) ~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:45)
~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:120)
~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:95) ~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:116)
~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:59) ~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:98)
~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:49) ~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:105) ~[drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:250) [drill-java-exec-0.5.0-incubating-SNAPSHOT-rebuffed.jar:0.5.0-incubating-SNAPSHOT]
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_51]
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1

> 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