[PHOENIX-4017] Stats - Expected bytes/rows return null for index tables

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 4.11.0
• Assignee: Samarth Jain
• Reporter: Mujtaba Chohan
• Created: 12/Jul/17 21:45
• Updated: 12/Jul/17 21:46

Description

Machine readable estimated row count and bytes read return null for explain plan that uses index.

+-------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
|                                                       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           |
+-------------------------------------------------------------------------------------------------------------------+-----------------+----------------+

Estimated row count and bytes read works fine if NO_INDEX hint is used for base table stats.