Impala Show TABLE STATS Returning Wrong #Rows
(Doc ID 2087813.1)
Last updated on NOVEMBER 08, 2022
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
|
To view full details, sign in with your My Oracle Support account. |
| Don't have a My Oracle Support account? Click to get started! |
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.