Problem with partitioned table in BigQuery and streaming buffer from Datastream

[ionchiciuc]

Hello,

I have created a datastream from MySql to BigQuery, a made table in Bigquery partitioned.

It looks like inserting data works fine with partitions.

But when I try to make a query, while there are still some data in the streaming buffer, it doesn't use partitions and read data from the whole table.

When there are no more data in streaming buffer, it works fine.

Why it has to read whole table? Shouldn't it read only the required partitions + streaming buffer?