@Kuke 

Have you checked whether the partitioning is configured correctly?
If disabling partitioning (creating a single partition) allows you to retrieve 100,000 rows, but enabling partitioning results in only 99,000 rows, it is likely that the partition settings are the cause.

In particular, you should verify that options like "min_value" and "max_value" are set correctly.
For example, if the specified range for "partitionColumn" is narrower than the actual minimum and maximum values, any rows outside that range will not be retrieved.