Impala Show TABLE STATS Returning Wrong #Rows (Doc ID 2087813.1)

Last updated on DECEMBER 22, 2015

Applies to:

Big Data Appliance Integrated Software - Version 4.2.0 and later
Linux x86-64

Symptoms

SHOW TABLE STATS is returning 0 for #Rows which is incorrect.
Query: show TABLE STATS <tablename>
+-------+-------+--------+------+--------------+-------------------+--------+-------------------+
| b     | #Rows | #Files | Size | Bytes Cached | Cache Replication | Format | Incremental stats |
+-------+-------+--------+------+--------------+-------------------+--------+-------------------+
| 1     | 0     | 2      | 4B   | NOT CACHED   | NOT CACHED        | TEXT   | false             |
| 2     | 0     | 1      | 2B   | NOT CACHED   | NOT CACHED        | TEXT   | false             |
| Total | 3     | 3      | 6B   | 0B           |                   |        |                   |
+-------+-------+--------+------+--------------+-------------------+--------+-------------------+
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms