StarRocks / starrocks

The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
https://starrocks.io
Apache License 2.0
9.27k stars 1.84k forks source link

information_schema.tables returns table_rows as 0 #52883

Open dengliu opened 2 weeks ago

dengliu commented 2 weeks ago

Steps to reproduce the behavior (Required)

+-----------+------------+------------+--------------+----------+
| TableName | IndexName  | Size       | ReplicaCount | RowCount |
+-----------+------------+------------+--------------+----------+
| FILL      | FILL_INDEX | 425.333 GB | 324          | 0        |
|           | Total      | 425.333 GB | 324          |          |
+-----------+------------+------------+--------------+----------+

Expected behavior (Required)

Real behavior (Required)

StarRocks version (Required)

rohitrs1983 commented 1 week ago

@dengliu this update happens as part of background job which runs every 5 min. if you want faster refresh then you can adjust the config item tablet_stat_update_interval_second

dengliu commented 1 week ago

It seems not to be a slow refresh problem. we have a program that query it every minute, the RowCount is always 0