sijocherian / google-bigquery

Automatically exported from code.google.com/p/google-bigquery
0 stars 0 forks source link

Query returns with success but the data was not created #258

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1.check job ID algous2_usa_201506060200_query_2000_2999_20150606042005_326218 
on project elite-air-91512 this is one of the offending jobs
2. this should create data with lat_index between 2000 and 2999
3. None exist in the output table, although the query was a success

What is the expected output? What do you see instead?
If there was a failure in any step of the query we would like to receive an 
error return code, so we can halt the following process, if the query did 
succeed we would like to see the data

What version of the product are you using? On what operating system?
BigQuery CLI 2.0.22 on ubuntu 14.04 image in GCE

Please provide any additional information below.
This is one of a list of queries that go on, and on occasion we would get 
partial results as some queries fail but the job for those queries is marked as 
success

Original issue reported on code.google.com by am...@breezometer.com on 7 Jun 2015 at 1:11

GoogleCodeExporter commented 8 years ago
I believe the query was executed before the creation of the table that it 
wanted to find data in, but I don't have the detailed logs any longer to 
confirm that.  My apologies for not getting to it sooner.  So I'm going to tag 
this instance as WontFix, but if it happens again, please update and I'll look. 
 Also, if you have logs that would confirm/deny this?

I have a bit more detail about the timing of the job run versus the table 
creation, but let me send to your email since this is a world-readable page.

Original comment by e...@google.com on 1 Jul 2015 at 10:43