[
https://issues.apache.org/jira/browse/PHOENIX-4017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mujtaba Chohan updated PHOENIX-4017:
------------------------------------
Description:
Machine readable estimated row count and bytes read return null for explain
plan that uses index.
{noformat}
+-------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
| PLAN
| EST_BYTES_READ | EST_ROWS_READ |
+-------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
| CLIENT 48-CHUNK 407739 ROWS 470002889 BYTES PARALLEL 1-WAY FULL SCAN OVER
T.IDX | null | null |
| SERVER FILTER BY FIRST KEY ONLY
| null | null |
| SERVER AGGREGATE INTO SINGLE ROW
| null | null |
+-------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
{noformat}
Estimated row count and bytes read works fine if NO_INDEX hint is used for base
table stats.
was:
Estimated row count and bytes read return null for explain plan that uses
index.
{noformat}
+-------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
| PLAN
| EST_BYTES_READ | EST_ROWS_READ |
+-------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
| CLIENT 48-CHUNK 407739 ROWS 470002889 BYTES PARALLEL 1-WAY FULL SCAN OVER
T.IDX | null | null |
| SERVER FILTER BY FIRST KEY ONLY
| null | null |
| SERVER AGGREGATE INTO SINGLE ROW
| null | null |
+-------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
{noformat}
Estimated row count and bytes read works fine if NO_INDEX hint is used for base
table stats.
> Stats - Expected bytes/rows return null for index tables
> --------------------------------------------------------
>
> Key: PHOENIX-4017
> URL: https://issues.apache.org/jira/browse/PHOENIX-4017
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.11.0
> Reporter: Mujtaba Chohan
> Assignee: Samarth Jain
> Priority: Minor
>
> Machine readable estimated row count and bytes read return null for explain
> plan that uses index.
> {noformat}
> +-------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
> | PLAN
> | EST_BYTES_READ | EST_ROWS_READ |
> +-------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
> | CLIENT 48-CHUNK 407739 ROWS 470002889 BYTES PARALLEL 1-WAY FULL SCAN OVER
> T.IDX | null | null |
> | SERVER FILTER BY FIRST KEY ONLY
> | null | null |
> | SERVER AGGREGATE INTO SINGLE ROW
> | null | null |
> +-------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
> {noformat}
> Estimated row count and bytes read works fine if NO_INDEX hint is used for
> base table stats.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
