Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Sun, 4 Dec 2016 11:11:58 +0000 (UTC)
From: "Rajesh Balamohan (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13025037.1480672668000.433430.1480849918317@Atlassian.JIRA>
In-Reply-To: <JIRA.13025037.1480672668000@Atlassian.JIRA>
References: <JIRA.13025037.1480672668000@Atlassian.JIRA> <JIRA.13025037.1480672668999@arcas>
Subject: [jira] [Updated] (HIVE-15339) Prefetch column stats for fields
 needed in FilterSelectivityEstimator
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Sun, 04 Dec 2016 11:12:00 -0000


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

Rajesh Balamohan updated HIVE-15339:
------------------------------------
    Status: Patch Available  (was: Open)

> Prefetch column stats for fields needed in FilterSelectivityEstimator
> ---------------------------------------------------------------------
>
>                 Key: HIVE-15339
>                 URL: https://issues.apache.org/jira/browse/HIVE-15339
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Rajesh Balamohan
>            Priority: Minor
>         Attachments: HIVE-15339.1.patch
>
>
> Based on query pattern, {{FilterSelectivityEstimator}} gets column statistics from metastore in multiple calls. For instance, in the following query, it ends up getting individual column statistics for for flights multiple number of times.
> When the table has large number of partitions, getting statistics for columns via multiple calls can be very expensive. This would adversely impact the overall compilation time. The following query took 14 seconds to compile.
> {noformat}
> SELECT COUNT(`flights`.`flightnum`) AS `cnt_flightnum_ok`,
> YEAR(`flights`.`dateofflight`) AS `yr_flightdate_ok`
> FROM `flights` as `flights`
> JOIN `airlines` ON (`flights`.`uniquecarrier` = `airlines`.`code`)
> JOIN `airports` as `source_airport` ON (`flights`.`origin` = `source_airport`.`iata`)
> JOIN `airports` as `dest_airport` ON (`flights`.`dest` = `dest_airport`.`iata`)
> GROUP BY YEAR(`flights`.`dateofflight`);
> {noformat}
> It may be helpful to club all columns that need statistics and fetch these details in single remote call.


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