You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2015/10/09 18:31:28 UTC
[jira] [Updated] (DRILL-3261) Tpch query 4 over hive sf100 fails
with an OOM error. Query runs fine against text and parquet
[ https://issues.apache.org/jira/browse/DRILL-3261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli updated DRILL-3261:
-------------------------------------
Fix Version/s: (was: Future)
1.3.0
> 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
> Fix For: 1.3.0
>
> 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)