Return-Path: 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 70315200BC7 for ; Fri, 11 Nov 2016 06:29:04 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 6E4A7160B10; Fri, 11 Nov 2016 05:29:04 +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 B5B43160B01 for ; Fri, 11 Nov 2016 06:29:03 +0100 (CET) Received: (qmail 24463 invoked by uid 500); 11 Nov 2016 05:29:02 -0000 Mailing-List: contact notifications-help@asterixdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.apache.org Delivered-To: mailing list notifications@asterixdb.apache.org Received: (qmail 24450 invoked by uid 99); 11 Nov 2016 05:29:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Nov 2016 05:29:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 94A101A8BFD for ; Fri, 11 Nov 2016 05:29:01 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -7.019 X-Spam-Level: X-Spam-Status: No, score=-7.019 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-2.999] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id jT_Ml4qhns-N for ; Fri, 11 Nov 2016 05:28:59 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with SMTP id 37B0C5FB58 for ; Fri, 11 Nov 2016 05:28:59 +0000 (UTC) Received: (qmail 23861 invoked by uid 99); 11 Nov 2016 05:28:58 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Nov 2016 05:28:58 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 9B9582C0087 for ; Fri, 11 Nov 2016 05:28:58 +0000 (UTC) Date: Fri, 11 Nov 2016 05:28:58 +0000 (UTC) From: "Taewoo Kim (JIRA)" To: notifications@asterixdb.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (ASTERIXDB-1733) Hash Table used by hash-join doesn't conform to the budget. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Fri, 11 Nov 2016 05:29:04 -0000 [ https://issues.apache.org/jira/browse/ASTERIXDB-1733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15656196#comment-15656196 ] Taewoo Kim commented on ASTERIXDB-1733: --------------------------------------- Related to the issue ASTERIXDB-1566, the hash table size is not accounted for the hash join. So, Data Table alone conforms to the budget (join.memory M). So, the chances are high that hash table size (H) + D > M holds true after the build phase. Here is the proposed solution after talking with [~dtabass]. https://docs.google.com/presentation/d/1rb-YJxBQmmtg6cViU5-072NeyNUAXUBM2SIktPeacOU/edit?usp=sharing > Hash Table used by hash-join doesn't conform to the budget. > ----------------------------------------------------------- > > Key: ASTERIXDB-1733 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-1733 > Project: Apache AsterixDB > Issue Type: Bug > Reporter: Taewoo Kim > Assignee: Taewoo Kim > > The hash table in the hash join doesn't conform to the frame limit (join.memory parameter in the configuration file). This is related to ASTERIXDB-1556. -- This message was sent by Atlassian JIRA (v6.3.4#6332)