Member since
07-16-2020
6
Posts
0
Kudos Received
0
Solutions
07-24-2020
08:22 AM
Hi, I'm using the Impala function "show table stats": show table stats table1; I get following results business_date tec_execution_date #Rows #Files Size Bytes Cached Cache Replication Format 13/05/2020 13/05/2020 20:08 0 0 0B NOT CACHED NOT CACHED PARQUET 14/07/2020 15/07/2020 16:39 6 1 16.08KB NOT CACHED NOT CACHED PARQUET 15/07/2020 16/07/2020 16:07 770 2 114.68KB NOT CACHED NOT CACHED PARQUET 16/07/2020 20/07/2020 16:50 272 1 41.88KB NOT CACHED NOT CACHED PARQUET 17/07/2020 21/07/2020 12:38 290 1 45.33KB NOT CACHED NOT CACHED PARQUET 20/07/2020 20/07/2020 12:16 379 1 51.10KB NOT CACHED NOT CACHED PARQUET 21/07/2020 22/07/2020 12:45 156 1 31.50KB NOT CACHED NOT CACHED PARQUET 24/07/2020 24/07/2020 15:15 278 1 40.26KB NOT CACHED NOT CACHED PARQUET Total 2431 8 340.84KB 0B However if I sum up the rows in column "#Rows" I get 2151...! Am I'm missing something? How is that possible? Thanks Thanks
... View more
Labels:
- Labels:
-
Apache Impala