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 75AB617A78 for ; Mon, 13 Apr 2015 17:05:12 +0000 (UTC) Received: (qmail 17137 invoked by uid 500); 13 Apr 2015 17:05:12 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 17105 invoked by uid 500); 13 Apr 2015 17:05:12 -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 17095 invoked by uid 99); 13 Apr 2015 17:05:12 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Apr 2015 17:05:12 +0000 Date: Mon, 13 Apr 2015 17:05:12 +0000 (UTC) From: "Jacques Nadeau (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Assigned] (DRILL-2723) Inaccurate row count estimate for text files results in BroadcastExchange 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-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Nadeau reassigned DRILL-2723: ------------------------------------- Assignee: Jacques Nadeau (was: Jinfeng Ni) > Inaccurate row count estimate for text files results in BroadcastExchange > ------------------------------------------------------------------------- > > Key: DRILL-2723 > URL: https://issues.apache.org/jira/browse/DRILL-2723 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Reporter: Steven Phillips > Assignee: Jacques Nadeau > Fix For: 0.9.0 > > > The current method for estimating row count in text files is to divide the size of the file in bytes by 1024. This row count estimate is used by optimizer to decide if BroadcastExchange should be used. > This results in massive memory consumption when using BroadCast exchange on a large table. > We need a better way of estimating row count, or use a different metric when deciding to use BroadcastExchange. -- This message was sent by Atlassian JIRA (v6.3.4#6332)