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] [Created] (PHOENIX-4017) Stats - Expected bytes/rows return null for index tables
Date Wed, 12 Jul 2017 21:46:00 GMT
Mujtaba Chohan created PHOENIX-4017:
---------------------------------------

             Summary: 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
            Priority: Minor


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