Google BigQuery same queries produce different results

Question

I have run 2 very similar queries. The only difference is that one of them is grouped by field name, and the other is grouped by number of fields (i.e. 1,2,3).

These 2 queries should give exactly the same result, since there is no counter in the queries. However, it is not. One request gets 5 records, and the other only 1 record.

I am wondering if anyone can help.

Here are the identifiers and job requests:

Job ID 1: 631095067040: job_0NLPcGFK_umGVdyY0fuFnemkos0

select Identifier, channel
  from my.dataset
  where Id in ('aaa', 'bbb', 'ccc', 'ddd', 'eee')
  group each by Id, Channel;

Job ID 2: 631095067040: job_NlWyxr0N4fi5ZnVKYDAVFr7qcew

select Identifier, channel
  from my.dataset
  where Id in ('aaa', 'bbb', 'ccc', 'ddd', 'eee')
  group each at 1.2

Thank!

Answer 1

We (the BigQuery team) track the issue when some queries return obsolete results (i.e., return results based on obsolete data).

This problem has been resolved, please submit this thread or open another problem if you continue to see problems.