public void TestAsyncQuery() { Job job = BigQuery.Util.AsyncQuery(_bigquery, _projectId, _countUniqueWordsQuery, false); var request = new JobsResource.GetRequest(_bigquery, _projectId, job.JobReference.JobId); job = BigQuery.Util.PollJob(request, 2000); var rows = BigQuery.Util.GetRows(_bigquery, job.JobReference); Assert.IsTrue(IsShakespeare(rows)); }
// [END async_query] /// <summary> /// Polls the job for completion. /// </summary> /// <param name="request">The bigquery request to poll for completion /// </param> /// <param name="interval">Number of milliseconds between each poll /// </param> /// <returns>The finished job</returns> // [START poll_job] public Job PollJob(JobsResource.GetRequest request, int interval) { Job job = request.Execute(); while (job.Status.State != "DONE") { Thread.Sleep(interval); job = request.Execute(); } return(job); }
public void TestAsyncQuery() { Job job = s_util.AsyncQuery(s_projectId, s_countUniqueWordsQuery, false); var request = new JobsResource.GetRequest(s_bigquery, s_projectId, job.JobReference.JobId); job = s_util.PollJob(request, 2000); var rows = s_util.GetRows(job.JobReference); Assert.IsTrue(IsShakespeare(rows)); }
/// <summary> /// Tries to refresh job. /// </summary> public void RefreshJob() { JobsResource.GetRequest jobItem = new JobsResource.GetRequest(new BigqueryService(), this.ProjectId, this.JobId); jobItem.Oauth_token = BigQueryConnectionManager.GetToken(); jobItem.Fields = BQFields.FieldsMask_Id + "," + BQFields.FieldsMask_Status + "," + BQFields.FieldsMask_Statistics + "," + BQFields.FieldsMask_JobReference + "," + BQFields.FieldsMask_Configuration; Job job = jobItem.Fetch(); this.jobData = job; this.jobJsonData = JsonConvert.SerializeObject(job); }