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 01D8917FC1 for ; Sat, 12 Sep 2015 01:19:46 +0000 (UTC) Received: (qmail 14455 invoked by uid 500); 12 Sep 2015 01:19:45 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 14426 invoked by uid 500); 12 Sep 2015 01:19:45 -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 14416 invoked by uid 99); 12 Sep 2015 01:19:45 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 12 Sep 2015 01:19:45 +0000 Date: Sat, 12 Sep 2015 01:19:45 +0000 (UTC) From: "Abhishek Girish (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DRILL-3770) Query with window function having just ORDER BY clause runs out of memory on large datasets 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-3770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-3770: ----------------------------------- Attachment: drillbit.log.txt > Query with window function having just ORDER BY clause runs out of memory on large datasets > ------------------------------------------------------------------------------------------- > > Key: DRILL-3770 > URL: https://issues.apache.org/jira/browse/DRILL-3770 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Flow > Affects Versions: 1.2.0 > Environment: 10 Performance Nodes > DRILL_MAX_DIRECT_MEMORY=100g > DRILL_INIT_HEAP="8g" > DRILL_MAX_HEAP="8g" > planner.memory.query_max_memory_per_node bumped up to 20 GB > TPC-DS SF 1000 dataset (Parquet) > Reporter: Abhishek Girish > Assignee: Deneche A. Hakim > Labels: window_function > Attachments: drillbit.log.txt > > > The following query runs out of memory: > {code:sql} > SELECT SUM(ss.ss_net_paid_inc_tax) OVER (ORDER BY ss.ss_store_sk) FROM store_sales ss LIMIT 20; > java.lang.RuntimeException: java.sql.SQLException: RESOURCE ERROR: One or more nodes ran out of memory while executing the query. > Fragment 0:0 > [Error Id: 9c441211-65ec-4206-9e6b-d6ae9c2903be on ucs-node6.perf.lab:31010] > at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73) > at sqlline.TableOutputFormat$ResizingRowsProvider.next(TableOutputFormat.java:87) > at sqlline.TableOutputFormat.print(TableOutputFormat.java:118) > at sqlline.SqlLine.print(SqlLine.java:1583) > at sqlline.Commands.execute(Commands.java:852) > at sqlline.Commands.sql(Commands.java:751) > at sqlline.SqlLine.dispatch(SqlLine.java:738) > at sqlline.SqlLine.begin(SqlLine.java:612) > at sqlline.SqlLine.start(SqlLine.java:366) > at sqlline.SqlLine.main(SqlLine.java:259) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)