drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-874) Select that include cast of binary char column fails with IndexOutOfBoundsException
Date Sun, 01 Jun 2014 18:11:01 GMT

     [ https://issues.apache.org/jira/browse/DRILL-874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jinfeng Ni updated DRILL-874:
-----------------------------

    Attachment: DRILL-874.1.patch

> Select that include cast of binary char column fails with IndexOutOfBoundsException
> -----------------------------------------------------------------------------------
>
>                 Key: DRILL-874
>                 URL: https://issues.apache.org/jira/browse/DRILL-874
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Operators
>            Reporter: Krystal
>            Assignee: Jinfeng Ni
>         Attachments: DRILL-874.1.patch, time_dim.dat, time_dim.parquet
>
>
> git.commit.id.abbrev=e1e5ea0
> git.build.time=29.05.2014 @ 17\:11\:32 PDT
> Ran a query against a tpcds table that included an int column, and a character column.
 If there is no casting on the varchar column, the query runs successfully.  Also, if the
the query only included the cast varchar column, then it runs successfully.  The error occurs
when selecting some other columns plus casting of varchar columns.  For example:
> 0: jdbc:drill:schema=dfs.tpcds> select t_time_sk, cast(t_time_id as varchar(16)) from
time_dim limit 5;
> +------------+------------+
> | t_time_sk  |   EXPR$1   |
> +------------+------------+
> | 0          | AAAAAAAABAAAAAAA |
> | 1          | AAAAAAAACAAAAAAA |
> | 2          | AAAAAAAADAAAAAAA |
> | 3          | AAAAAAAAEAAAAAAA |
> | 4          | AAAAAAAAFAAAAAAA |
> error_type: 0
> message: "Failure while running fragment. < IndexOutOfBoundsException:[ index: 4096
(expected: range(0, 4096)) ]"
> ]
> java.lang.RuntimeException: java.sql.SQLException: Failure while trying to get next result
batch.
> 	at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> 	at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
> 	at sqlline.SqlLine.print(SqlLine.java:1809)
> 	at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
> 	at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
> 	at sqlline.SqlLine.dispatch(SqlLine.java:889)
> 	at sqlline.SqlLine.begin(SqlLine.java:763)
> 	at sqlline.SqlLine.start(SqlLine.java:498)
> 	at sqlline.SqlLine.main(SqlLine.java:460)



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message