Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Tue, 28 Jun 2016 22:39:57 +0000 (UTC)
From: "Zelaine Fong (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12836232.1433786626000.11188.1467153597184@Atlassian.JIRA>
In-Reply-To: <JIRA.12836232.1433786626000@Atlassian.JIRA>
References: <JIRA.12836232.1433786626000@Atlassian.JIRA> <JIRA.12836232.1433786626496@arcas>
Subject: [jira] [Updated] (DRILL-3261) Tpch query 4 over hive sf100 fails
 with an OOM error. Query runs fine against text and parquet
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 28 Jun 2016 22:39:59 -0000


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

Zelaine Fong updated DRILL-3261:
--------------------------------
    Assignee: Padma Penumarthy

> Tpch query 4 over hive sf100 fails with an OOM error. Query runs fine against text and parquet
> ----------------------------------------------------------------------------------------------
>
>                 Key: DRILL-3261
>                 URL: https://issues.apache.org/jira/browse/DRILL-3261
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow, Storage - Hive
>            Reporter: Rahul Challapalli
>            Assignee: Padma Penumarthy
>             Fix For: Future
>
>         Attachments: error.log, tpch100_hive.ddl
>
>
> git.commit.id.abbrev=5f26b8b
> I have a 2 node cluster with the below memory allocation for the drillbits
> {code}
> DRILL_MAX_DIRECT_MEMORY="32G"
> DRILL_MAX_HEAP="4G"
> {code}
> The below query never returned
> {code}
> select
>   o.o_orderpriority,
>   count(*) as order_count
> from
>   orders o
> where
>   o.o_orderdate >= date '1996-10-01'
>   and o.o_orderdate < date '1996-10-01' + interval '3' month
>   and
>   exists (
>     select
>       *
>     from
>       lineitem l
>     where
>       l.l_orderkey = o.o_orderkey
>       and l.l_commitdate < l.l_receiptdate
>   )
> group by
>   o.o_orderpriority
> order by
>   o.o_orderpriority;
> {code}
> I attached the hive DDL and the error logs. Let me know if you need anything else


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