[jira] [Commented] (FLINK-15613) execute sql appear "java.lang.IndexOutOfBoundsException"
[ https://issues.apache.org/jira/browse/FLINK-15613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17031555#comment-17031555 ] Danny Chen commented on FLINK-15613: Duplicated with FLINK-15399 > execute sql appear "java.lang.IndexOutOfBoundsException" > > > Key: FLINK-15613 > URL: https://issues.apache.org/jira/browse/FLINK-15613 > Project: Flink > Issue Type: Bug > Components: Table SQL / Client >Affects Versions: 1.10.0 > Environment: *The input data is:* > 0.0 > 1004.30 > -34.84 > 1.2345678901234E200 > 1.2345678901234E-200 > *The sql-client conf is:* > execution: > planner: blink > type: batch >Reporter: xiaojin.wy >Priority: Major > Fix For: 1.10.0 > > > *The sql is* : > CREATE TABLE `int8_tbl` ( > q1 bigint, q2 bigint > ) WITH ( > 'connector.path'='/test_join/sources/int8_tbl.csv', > 'format.empty-column-as-null'='true', > 'format.field-delimiter'='|', > 'connector.type'='filesystem', > 'format.derive-schema'='true', > 'format.type'='csv' > ); > select * from int8_tbl i1 left join (select * from int8_tbl i2 join (select > 123 as x) ss on i2.q1 = x) as i3 on i1.q2 = i3.q2 order by 1, 2; > > *The output after exciting the sql is :* > [ERROR] Could not execute SQL statement. Reason: > Caused by: java.lang.IndexOutOfBoundsException: Index: 1, Size: 1 at > java.util.ArrayList.rangeCheck(ArrayList.java:653) at > java.util.ArrayList.get(ArrayList.java:429) at > org.apache.calcite.sql2rel.SqlToRelConverter$LookupContext.findRel(SqlToRelConverter.java:5300) > at > org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.lookup(SqlToRelConverter.java:4424) > at > org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.lookupExp(SqlToRelConverter.java:4369) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertIdentifier(SqlToRelConverter.java:3720) > at > org.apache.calcite.sql2rel.SqlToRelConverter.access$2200(SqlToRelConverter.java:217) > at > org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:4796) > at > org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:4092) > at org.apache.calcite.sql.SqlIdentifier.accept(SqlIdentifier.java:317) at > org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.convertExpression(SqlToRelConverter.java:4656) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectList(SqlToRelConverter.java:3939) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:670) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:627) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:3181) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2124) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2005) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2085) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:646) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:627) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:3181) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:563) > at > org.apache.flink.table.planner.calcite.FlinkPlannerImpl.rel(FlinkPlannerImpl.scala:148) > at > org.apache.flink.table.planner.calcite.FlinkPlannerImpl.rel(FlinkPlannerImpl.scala:135) > at > org.apache.flink.table.planner.operations.SqlToOperationConverter.toQueryOperation(SqlToOperationConverter.java:522) > at > org.apache.flink.table.planner.operations.SqlToOperationConverter.convertSqlQuery(SqlToOperationConverter.java:436) > at > org.apache.flink.table.planner.operations.SqlToOperationConverter.convert(SqlToOperationConverter.java:154) > at > org.apache.flink.table.planner.delegation.ParserImpl.parse(ParserImpl.java:66) > at > org.apache.flink.table.api.internal.TableEnvironmentImpl.sqlQuery(TableEnvironmentImpl.java:464) > at > org.apache.flink.table.client.gateway.local.LocalExecutor.lambda$createTable$16(LocalExecutor.java:783) > at > org.apache.flink.table.client.gateway.local.ExecutionContext.wrapClassLoader(ExecutionContext.java:231) > at > org.apache.flink.table.client.gateway.local.LocalExecutor.createTable(LocalExecutor.java:783) > ... 9 more -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (FLINK-15613) execute sql appear "java.lang.IndexOutOfBoundsException"
[ https://issues.apache.org/jira/browse/FLINK-15613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17029650#comment-17029650 ] xiaojin.wy commented on FLINK-15613: [~ykt836], could you assign someone to fix it? > execute sql appear "java.lang.IndexOutOfBoundsException" > > > Key: FLINK-15613 > URL: https://issues.apache.org/jira/browse/FLINK-15613 > Project: Flink > Issue Type: Bug > Components: Table SQL / Client >Affects Versions: 1.10.0 > Environment: *The input data is:* > 0.0 > 1004.30 > -34.84 > 1.2345678901234E200 > 1.2345678901234E-200 > *The sql-client conf is:* > execution: > planner: blink > type: batch >Reporter: xiaojin.wy >Priority: Major > Fix For: 1.10.0 > > > *The sql is* : > CREATE TABLE `int8_tbl` ( > q1 bigint, q2 bigint > ) WITH ( > 'connector.path'='/test_join/sources/int8_tbl.csv', > 'format.empty-column-as-null'='true', > 'format.field-delimiter'='|', > 'connector.type'='filesystem', > 'format.derive-schema'='true', > 'format.type'='csv' > ); > select * from int8_tbl i1 left join (select * from int8_tbl i2 join (select > 123 as x) ss on i2.q1 = x) as i3 on i1.q2 = i3.q2 order by 1, 2; > > *The output after exciting the sql is :* > [ERROR] Could not execute SQL statement. Reason: > java.lang.IndexOutOfBoundsException: Index: 1, Size: 1 > -- This message was sent by Atlassian Jira (v8.3.4#803005)
