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 19DB817605 for ; Tue, 7 Apr 2015 21:04:49 +0000 (UTC) Received: (qmail 14534 invoked by uid 500); 7 Apr 2015 21:04:14 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 14117 invoked by uid 500); 7 Apr 2015 21:04:14 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 14050 invoked by uid 99); 7 Apr 2015 21:04:14 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Apr 2015 21:04:14 +0000 Date: Tue, 7 Apr 2015 21:04:14 +0000 (UTC) From: "Chris Westin (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DRILL-2707) Projecting a required varchar column after a Full Outer Join results in an IOOBException MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DRILL-2707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chris Westin updated DRILL-2707: -------------------------------- Assignee: Sudheesh Katkam (was: Chris Westin) > Projecting a required varchar column after a Full Outer Join results in an IOOBException > ----------------------------------------------------------------------------------------- > > Key: DRILL-2707 > URL: https://issues.apache.org/jira/browse/DRILL-2707 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Data Types, Execution - Relational Operators > Affects Versions: 0.8.0 > Reporter: Rahul Challapalli > Assignee: Sudheesh Katkam > Attachments: fewtypes.parquet, fewtypes_null.json > > > git.commit.id.abbrev=a53e123 > I tried to project a required varchar column after a FOJ. Below is what I see > {code} > 0: jdbc:drill:schema=dfs_eea> select > . . . . . . . . . . . . . . > p.varchar_col > . . . . . . . . . . . . . . > from dfs.`cross-sources`.`fewtypes.parquet` p > . . . . . . . . . . . . . . > full outer join dfs.`cross-sources`.`fewtypes_null.json` o > . . . . . . . . . . . . . . > on p.int_col=o.int_col; > +-------------+ > | varchar_col | > +-------------+ > java.lang.IndexOutOfBoundsException: index: 180, length: 10 (expected: range(0, 180)) > at io.netty.buffer.AbstractByteBuf.checkIndex(AbstractByteBuf.java:1143) > at io.netty.buffer.PooledUnsafeDirectByteBuf.getBytes(PooledUnsafeDirectByteBuf.java:136) > at io.netty.buffer.WrappedByteBuf.getBytes(WrappedByteBuf.java:289) > at io.netty.buffer.UnsafeDirectLittleEndian.getBytes(UnsafeDirectLittleEndian.java:25) > at io.netty.buffer.DrillBuf.getBytes(DrillBuf.java:596) > at io.netty.buffer.DrillBuf.getBytes(DrillBuf.java:596) > at io.netty.buffer.DrillBuf.getBytes(DrillBuf.java:596) > at io.netty.buffer.DrillBuf.getBytes(DrillBuf.java:596) > at org.apache.drill.exec.vector.VarCharVector$Accessor.get(VarCharVector.java:387) > at org.apache.drill.exec.vector.VarCharVector$Accessor.getObject(VarCharVector.java:411) > at org.apache.drill.exec.vector.accessor.VarCharAccessor.getObject(VarCharAccessor.java:108) > at org.apache.drill.exec.vector.accessor.BoundCheckingAccessor.getObject(BoundCheckingAccessor.java:137) > at org.apache.drill.jdbc.AvaticaDrillSqlAccessor.getObject(AvaticaDrillSqlAccessor.java:165) > at net.hydromatic.avatica.AvaticaResultSet.getObject(AvaticaResultSet.java:351) > at sqlline.SqlLine$Rows$Row.(SqlLine.java:2388) > at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2504) > 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) > {code} > Not sure if this is a client-specific issue as there is no exception from the drillbit log files > However if I project a varchar column (nullable) from a json file after a FOJ, there seems to be no issues > {code} > 0: jdbc:drill:schema=dfs_eea> select > . . . . . . . . . . . . . . > o.varchar_col > . . . . . . . . . . . . . . > from dfs.`cross-sources`.`fewtypes.parquet` p > . . . . . . . . . . . . . . > full outer join dfs.`cross-sources`.`fewtypes_null.json` o > . . . . . . . . . . . . . . > on p.int_col=o.int_col; > +-------------+ > | varchar_col | > +-------------+ > | jllkjsdhfg | > | null | > | gfdstweopiu | > | gjklhsdfgkjhkASDF | > | oieoiutriotureWERTgwgEWRg | > | gjkdfkjglfd | > | ioerutklsdfASDgerGWEr | > | lkjgfiurtoUYFHfahui | > | IOUfiuodsfIUfjkh | > | iweuoHUIhUwer | > | null | > | dfgoiuert | > | uitreo | > | uigoMnvjjkdf | > | NvvdfHVG | > | null | > | null | > | uiuikjk | > | null | > | hjiwgh | > | null | > | jhgduitweriuoert | > | KfijUIwre | > | Nhkhuivb | > | null | > | null | > +-------------+ > 26 rows selected (0.212 seconds) > {code} > I attached the parquet and json files used. Let me know if you need anything more. -- This message was sent by Atlassian JIRA (v6.3.4#6332)