[jira] [Updated] (IMPALA-8021) Add estimated cardinality to EXPLAIN output

["Gabor Kaszab (JIRA)" <ji...@apache.org>]

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

Gabor Kaszab updated IMPALA-8021:
---------------------------------
    Fix Version/s: Impala 3.2.0

> Add estimated cardinality to EXPLAIN output
> -------------------------------------------
>
>                 Key: IMPALA-8021
>                 URL: https://issues.apache.org/jira/browse/IMPALA-8021
>             Project: IMPALA
>          Issue Type: Improvement
>          Components: Frontend
>    Affects Versions: Impala 3.1.0
>            Reporter: Paul Rogers
>            Assignee: Paul Rogers
>            Priority: Minor
>             Fix For: Impala 3.2.0
>
>
> The EXPLAIN output provides much useful information in the plan tree. All our planning decisions are based on cardinality; but it appears in the EXPLAIN output only for the EXTENDED level. The profile only contains the plan from the STANDARD level. This change proposes to include row size and cardinality even in the STANDARD level.
> The nodes that have the information call it "cardinality", so continue to use that term.
> Add cardinality to each node so it appears something like this:
> {noformat}
> HASH JOIN [INNER JOIN, BROADCAST]
> |  row-size=89B cardinality=1.23G
> |
> |--SCAN HDFS [db.table]
> |     partitions=2/123 files=2 size=4.56MB row-size=89B cardinality=7.89M
> {noformat}
> Cardinality should appear in all levels above MINIMAL. Cardinality is not needed for EXCHANGE since it can be inferred from other nodes.
> Also, the existing code prints large cardinalities in detail: 1234567890, which is hard to read. Use the abbreviated output, using metric (power of 1000) units, so 1.23G instead.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org