Return-Path: <issues-return-35059-archive-asf-public=cust-asf.ponee.io@drill.apache.org>
X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io
Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io
Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183])
	by cust-asf2.ponee.io (Postfix) with ESMTP id B524F200BDE
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Mon,  7 Nov 2016 23:04:00 +0100 (CET)
Received: by cust-asf.ponee.io (Postfix)
	id B3D37160B10; Mon,  7 Nov 2016 22:04:00 +0000 (UTC)
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by cust-asf.ponee.io (Postfix) with SMTP id 11FEF160AF9
	for <archive-asf-public@cust-asf.ponee.io>; Mon,  7 Nov 2016 23:03:59 +0100 (CET)
Received: (qmail 34615 invoked by uid 500); 7 Nov 2016 22:03:59 -0000
Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@drill.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@drill.apache.org>
List-Post: <mailto:issues@drill.apache.org>
List-Id: <issues.drill.apache.org>
Reply-To: dev@drill.apache.org
Delivered-To: mailing list issues@drill.apache.org
Received: (qmail 34461 invoked by uid 99); 7 Nov 2016 22:03:59 -0000
Received: from arcas.apache.org (HELO arcas) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Nov 2016 22:03:58 +0000
Received: from arcas.apache.org (localhost [127.0.0.1])
	by arcas (Postfix) with ESMTP id A58322C2A66
	for <issues@drill.apache.org>; Mon,  7 Nov 2016 22:03:58 +0000 (UTC)
Date: Mon, 7 Nov 2016 22:03:58 +0000 (UTC)
From: "Abhishek Girish (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.13019013.1478555866000.214920.1478556238674@Atlassian.JIRA>
In-Reply-To: <JIRA.13019013.1478555866000@Atlassian.JIRA>
References: <JIRA.13019013.1478555866000@Atlassian.JIRA> <JIRA.13019013.1478555866597@arcas>
Subject: [jira] [Commented] (DRILL-5009) Query with a simple join fails on
 Hive generated parquet
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
archived-at: Mon, 07 Nov 2016 22:04:00 -0000


    [ https://issues.apache.org/jira/browse/DRILL-5009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15645606#comment-15645606 ] 

Abhishek Girish commented on DRILL-5009:
----------------------------------------

Dataset: https://s3-us-west-1.amazonaws.com/drill-public/bugs/DRILL-5009.tar.gz

> Query with a simple join fails on Hive generated parquet
> --------------------------------------------------------
>
>                 Key: DRILL-5009
>                 URL: https://issues.apache.org/jira/browse/DRILL-5009
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Parquet
>    Affects Versions: 1.9.0
>         Environment: Commit ID: 5a439424594eb10d113163eaa1fdf8034f387235c
> 1.9.0 SNAPSHOT - Nov 5 2016
>            Reporter: Abhishek Girish
>
> Query: 
> {code}
> SELECT *
> FROM store_sales ss, customer c
> WHERE  ss.ss_customer_sk = c.c_customer_sk 
> LIMIT 1; 
> {code}
> Error:
> {code}
> Error: SYSTEM ERROR: IOException: End of stream reached while initializing buffered reader.
> Fragment 2:0
> [Error Id: 93726aea-1d62-4e7c-a2bf-1d7cc1e834e4 on abhi1:31010]
>   (org.apache.drill.common.exceptions.DrillRuntimeException) Error in parquet record reader.
> ...
> ...
>  Caused By (org.apache.drill.common.exceptions.ExecutionSetupException) Error opening or reading metadata for parquet file at location: customer.parquet
>     org.apache.drill.exec.store.parquet.columnreaders.PageReader.<init>():145
>     org.apache.drill.exec.store.parquet.columnreaders.AsyncPageReader.<init>():59
>     org.apache.drill.exec.store.parquet.columnreaders.ColumnReader.<init>():96
>     org.apache.drill.exec.store.parquet.columnreaders.NullableColumnReader.<init>():39
>     org.apache.drill.exec.store.parquet.columnreaders.NullableFixedByteAlignedReaders$NullableFixedByteAlignedReader.<init>():58
>     org.apache.drill.exec.store.parquet.columnreaders.ColumnReaderFactory.getNullableColumnReader():252
>     org.apache.drill.exec.store.parquet.columnreaders.ColumnReaderFactory.createFixedColumnReader():186
>     org.apache.drill.exec.store.parquet.columnreaders.ParquetRecordReader.setup():402
>     org.apache.drill.exec.physical.impl.ScanBatch.next():212
>     org.apache.drill.exec.record.AbstractRecordBatch.next():119
>     org.apache.drill.exec.record.AbstractRecordBatch.next():109
>     org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():51
>     org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():135
>     org.apache.drill.exec.record.AbstractRecordBatch.next():162
>     org.apache.drill.exec.physical.impl.BaseRootExec.next():104
>     org.apache.drill.exec.physical.impl.broadcastsender.BroadcastSenderRootExec.innerNext():95
>     org.apache.drill.exec.physical.impl.BaseRootExec.next():94
>     org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():232
>     org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():226
>     java.security.AccessController.doPrivileged():-2
>     javax.security.auth.Subject.doAs():415
>     org.apache.hadoop.security.UserGroupInformation.doAs():1595
>     org.apache.drill.exec.work.fragment.FragmentExecutor.run():226
>     org.apache.drill.common.SelfCleaningRunnable.run():38
>     java.util.concurrent.ThreadPoolExecutor.runWorker():1145
>     java.util.concurrent.ThreadPoolExecutor$Worker.run():615
>     java.lang.Thread.run():745
> ...
> {code}
> Log attached. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)