You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Mujtaba Chohan (JIRA)" <ji...@apache.org> on 2017/07/12 21:47:00 UTC
[jira] [Updated] (PHOENIX-4017) Stats - Expected bytes/rows return
null for index tables
[ 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)