max_rows setting defines the maximum number of rows allowed in a table. When you reach the limit, the oldest fragment is removed. This can be helpful when executing operations that insert and retrieve records based on insertion order. The default value for
max_rows is 2^62.
max_rows is set when creating the table in the "with" clause