As a test, I am trying to load streaming data into a table that I created using max_rows as 1000. When I am looking at the count of the rows for the table it is changing like 925,800,500,925,62,900 etc (during the streaming period).
Shouldn’t the number of rows be like 1000(approx) and any data into the table will delete that many rows from the beginning. I do have a column time stamp in the data. Can anyone help me understand how the max_rows in creating a table works? Looks like all the rows are deleted and then new ones are entered.