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)

Reply via email to