row_number rank doesn't work.

GoogleCodeExporter commented 8 years ago

I am simply trying to apply a rank to event_ids.  

The SQL query is simply: 

SELECT
  pub_store_id,
  ad_store_id,
  camp_id,
  create_id,
  ROW_NUMBER() OVER (PARTITION BY event_id) AS rank
FROM
  [tablename];

Error message: 

Error: Resources exceeded during query execution.

I have checked the box for "Allow unlimited" billing tier.  But the query still 
fails.  It is not clear to me why this doesn't complete, it seems to be a 
fairly simple query.  Any help? 

Thanks, 
Matt

Original issue reported on code.google.com by matt.ben...@vungle.com on 25 Mar 2016 at 10:02

GoogleCodeExporter commented 8 years ago

Can you provide a job ID? Feel free to email jcondit@google.com if you would 
rather not post here.

Original comment by jcon...@google.com on 25 Mar 2016 at 10:30

Changed state: Accepted

GoogleCodeExporter commented 8 years ago

We're in the process of rolling out dynamic optimization for PARTITION BY, 
which should address the problem. We've opted your project in already. Let us 
know if you still see problems.

Original comment by jcon...@google.com on 8 Apr 2016 at 4:01

Changed state: Fixed

GoogleCodeExporter commented 8 years ago

Thanks for the update. I'll give the query a try tomorrow.

Original comment by matt.ben...@vungle.com on 8 Apr 2016 at 4:13

runt18 / google-bigquery

row_number rank doesn't work. #480