[
https://issues.apache.org/jira/browse/DRILL-4971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Robert Hou updated DRILL-4971:
--
Description:
This query returns an error. The stack trace suggests it might be a schema
change issue, but there is no schema change in this table. Many other queries
are succeeding.
select count(\*) from test where ((int_id > 3060 and int_id < 6002) or (int_id
> 9025 and int_id < 11976)) and ((int_id > 9025 and int_id < 11976) or (int_id
> 3060 and int_id < 6002)) and (int_id > 3060 and int_id < 6002);
Error: SYSTEM ERROR: CompileException: Line 232, Column 30: Statement "break
AndOP3" is not enclosed by a breakable statement with label "AndOP3"
[Error Id: 254d093b-79a1-4425-802c-ade08db293e4 on qa-node211:31010]^M
^M
(org.apache.drill.exec.exception.SchemaChangeException) Failure while
attempting to load generated class^M
org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.generateSV2Filterer():198^M
org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.setupNewSchema():107^M
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():78^M
There are two partitions to the test table. One covers the range 3061 - 6001
and the other covers the range 9026 - 11975.
This second query returns a different, but possibly related, error.
select count(\*) from orders_parts where (((int_id > -3025 and int_id < -4) or
(int_id > -5 and int_id < 3061) or (int_id > 3060 and int_id < 6002)) and
(int_id > -5 and int_id < 3061)) and (((int_id > -5 and int_id < 3061) or
(int_id > 9025 and int_id < 11976)) and (int_id > -5 and int_id < 3061))^M
Failed with exception^M
java.sql.SQLException: SYSTEM ERROR: CompileException: Line 447, Column 30:
Statement "break AndOP6" is not enclosed by a breakable statement with label
"AndOP6"^M
^M
Fragment 0:0^M
^M
[Error Id: ac09187e-d3a2-41a7-a659-b287aca6039c on qa-node209:31010]^M
^M
(org.apache.drill.exec.exception.SchemaChangeException) Failure while
attempting to load generated class^M
org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.generateSV2Filterer():198^M
org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.setupNewSchema():107^M
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():78^M
was:
This query returns an error:
select count(\*) from test where ((int_id > 3060 and int_id < 6002) or (int_id
> 9025 and int_id < 11976)) and ((int_id > 9025 and int_id < 11976) or (int_id
> 3060 and int_id < 6002)) and (int_id > 3060 and int_id < 6002);
Error: SYSTEM ERROR: CompileException: Line 232, Column 30: Statement "break
AndOP3" is not enclosed by a breakable statement with label "AndOP3"
There are two partitions to the test table. One covers the range 3061 - 6001
and the other covers the range 9026 - 11975.
> query encounters system error: Statement "break AndOP3" is not enclosed by a
> breakable statement with label "AndOP3"
>
>
> Key: DRILL-4971
> URL: https://issues.apache.org/jira/browse/DRILL-4971
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
>Reporter: Robert Hou
> Attachments: low_table, medium_table
>
>
> This query returns an error. The stack trace suggests it might be a schema
> change issue, but there is no schema change in this table. Many other
> queries are succeeding.
> select count(\*) from test where ((int_id > 3060 and int_id < 6002) or
> (int_id > 9025 and int_id < 11976)) and ((int_id > 9025 and int_id < 11976)
> or (int_id > 3060 and int_id < 6002)) and (int_id > 3060 and int_id < 6002);
> Error: SYSTEM ERROR: CompileException: Line 232, Column 30: Statement "break
> AndOP3" is not enclosed by a breakable statement with label "AndOP3"
> [Error Id: 254d093b-79a1-4425-802c-ade08db293e4 on qa-node211:31010]^M
> ^M
> (org.apache.drill.exec.exception.SchemaChangeException) Failure while
> attempting to load generated class^M
>
> org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.generateSV2Filterer():198^M
>
> org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.setupNewSchema():107^M
> org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():78^M
> There are two partitions to the test table. One covers the range 3061 - 6001
> and the other covers the range 9026 - 11975.
> This second query returns a different, but possibly related, error.
> select count(\*) from orders_parts where (((int_id > -3025 and int_id < -4)
> or (int_id > -5 and int_id < 3061) or (int_id > 3060 and int_id < 6002)) and
> (int_id > -5 and int_id < 3061)) and (((int_id > -5 and int_id < 3061) or
> (int_id > 9025 and int_id < 11976)) and (int_id > -5 and int_id < 3061))^M
> Failed with exception^M