Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 572AC1003C for ; Fri, 30 May 2014 23:12:26 +0000 (UTC) Received: (qmail 28263 invoked by uid 500); 30 May 2014 23:12:26 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 28231 invoked by uid 500); 30 May 2014 23:12:26 -0000 Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.incubator.apache.org Delivered-To: mailing list issues@drill.incubator.apache.org Received: (qmail 28217 invoked by uid 99); 30 May 2014 23:12:26 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 May 2014 23:12:26 +0000 X-ASF-Spam-Status: No, hits=-2000.7 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 30 May 2014 23:12:22 +0000 Received: (qmail 27468 invoked by uid 99); 30 May 2014 23:12:01 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 May 2014 23:12:01 +0000 Date: Fri, 30 May 2014 23:12:01 +0000 (UTC) From: "Krystal (JIRA)" To: issues@drill.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DRILL-874) Select that include cast of binary char column fails with IndexOutOfBoundsException MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DRILL-874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krystal updated DRILL-874: -------------------------- Attachment: time_dim.parquet time_dim parquet data file > 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: 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)