Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@phoenix.apache.org
Date: Wed, 24 May 2017 18:22:04 +0000 (UTC)
From: "Samarth Jain (JIRA)" <jira@apache.org>
To: dev@phoenix.apache.org
Message-ID: <JIRA.13068393.1493725089000.286197.1495650124139@Atlassian.JIRA>
In-Reply-To: <JIRA.13068393.1493725089000@Atlassian.JIRA>
References: <JIRA.13068393.1493725089000@Atlassian.JIRA> <JIRA.13068393.1493725089780@jira-lw-us.apache.org>
Subject: [jira] [Updated] (PHOENIX-3822) Surface byte and row estimates in a
 machine readable way when doing EXPLAIN PLAN
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Wed, 24 May 2017 18:22:09 -0000


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

Samarth Jain updated PHOENIX-3822:
----------------------------------
    Attachment: PHOENIX-3822_v5.patch

Updated patch.

Changed the interface to reflect that the two methods return null only when the estimate cannot be provided (for example when stats information is not available for queries whose scans are executed in parallel).

{code}
    /**
     * @return estimated number of rows that will be scanned when this statement plan is been executed.
     *         Returns null if the estimate cannot be provided.
     * @throws SQLException
     */
    public Long getEstimatedRowsToScan() throws SQLException;

    /**
     * @return estimated number of bytes that will be scanned when this statement plan is been executed.
     *         Returns null if the estimate cannot be provided.
     */
    public Long getEstimatedBytesToScan() throws SQLException;
{code}

For queries that are executed serially, estimates can still be provided. I have added tests for these scenarios in this patch. Also removed changes in PhoenixStatement where I was previously returning null for the estimates by moving the code to BaseMutationPlan. This removed the need of having a base class with zero estimates for now.

> Surface byte and row estimates in a machine readable way when doing EXPLAIN PLAN
> --------------------------------------------------------------------------------
>
>                 Key: PHOENIX-3822
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3822
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Samarth Jain
>            Assignee: Samarth Jain
>         Attachments: PHOENIX-3822.patch, PHOENIX-3822_v2.patch, PHOENIX-3822_v3.patch, PHOENIX-3822_v4.patch, PHOENIX-3822_v5.patch
>
>


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)