title: How to query for data in streaming buffer ONLY in BigQuery?
body: <p>We have a table partitioned by day in BigQuery, which is updated by streaming inserts. </p>
  
  <p>The <a href="https://cloud.google.com/bigquery/streaming-data-into-bigquery" rel="noreferrer">doc</a> says that: "when streaming to a partitioned table, data in the streaming buffer has a NULL value for the _PARTITIONTIME pseudo column"</p>
  
  <p>But if I query for <code>select count(*) from table where _PARTITIONTIME is NULL</code> it always returns 0, even though <code>bq show</code> tells me that there are a lot of rows in the streaming buffer.</p>
  
  <p>Does this mean that the pseudo column is not present at all for rows in streaming buffer? In any case, how can I query for the data ONLY in the streaming buffer without it becoming a full table scan?</p>
  
  <p>Thanks in advance</p>