Inquiry SELECT COUNT(*) FROM [table.click] WHERE time >= DATE_ADD('2015-03-25 06:00:00', -9, 'HOUR') AND time < DATE_ADD('2015-03-25 07:00:00', -9, 'HOUR')
I wanted to get records with a time from 6 to 7.
[07:25:57] $ bq query "SELECT COUNT(*) FROM [table.click] WHERE time >= DATE_ADD('2015-03-25 06:00:00', -9, 'HOUR') AND time < DATE_ADD('2015-03-25 07:00:00', -9, 'HOUR')"
Waiting on bqjob_r5e92dc9eca9622ed_0000014c4de50d59_1 ... (0s) Current status: DONE
+-----+
| f0_ |
+-----+
| 0 |
+-----+`
But my data import process worked for a long time, and I confirmed that this process is not a problem (= stream import between 6 and 7 worked well).
After 10 minutes, I executed the exact same request.
[07:35:15]$ bq query "SELECT COUNT(*) FROM [table.click] WHERE time >= DATE_ADD('2015-03-25 06:00:00', -9, 'HOUR') AND time < DATE_ADD('2015-03-25 07:00:00', -9, 'HOUR')"
Waiting on bqjob_r338acff11f068b44_0000014c4ded45c5_1 ... (2s) Current status: DONE
+------+
| f0_ |
+------+
| 1954 |
+------+`
This time everything turned out well! And after that, BigQuery continued to return 1954 records as shown below.
[10:49:59]$ bq query "SELECT COUNT(*) FROM [table.click] WHERE time >= DATE_ADD('2015-03-25 06:00:00', -9, 'HOUR') AND time < DATE_ADD('2015-03-25 07:00:00', -9, 'HOUR')"
Waiting on bqjob_r5693edc7523c1ca2_0000014c4e9f4f52_1 ... (0s) Current status: DONE
+------+
| f0_ |
+------+
| 1954 |
+------+`
Google BigQuery the same queries give different results - this is a similar question, but the BigQuery teammade the answer that the problem is resolved, so I decided to post this question post.
This problem has occurred twice. The first time 2015-03-24 22:00:00 JST ~ 2015-03-24 23:00:00 JST, and the second time 2015-03-25 06:00:00 JST ~ 2015-03-25 07:00:00 JST.
Google Cloud Status at the time that happened, BigQuery .
