You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "xiaojin.wy (Jira)" <ji...@apache.org> on 2020/02/04 08:48:00 UTC

[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&focusedCommentId=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)