BigQuery: Response too large to return when using GROUP EACH BY -

the table working has 3 fields:

userid, timestamp, version

i running following query:

select  userid, max(version) current_version  my_table group each userid;

the response is:

"errors": [  {   "reason": "responsetoolarge",   "message": "response large return."  }

the size of table 644mb , has 12,279,432 rows.

i thought group each by not have result size restrictions because distributed across multiple nodes. anyway, can it?

according comments, user base on 17 million rows? means query response have @ least 17 million rows, result large handle.

the right query depend on goal is. want 17 million row answer? or care max(version) particular set of users?

for example:

select userid, max(version) current_version my_table userid in('user1', 'user2', ...) group userid;

Brande