phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mujtaba Chohan (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-4017) Stats - Expected bytes/rows return null for index tables
Date Wed, 12 Jul 2017 21:47:00 GMT

     [ 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)

Mime
View raw message