EXCEPTION_HANDLER, serviceOptions.getClock()); TableSchema schemaPb = results.getSchema(); if (results.getErrors() != null) { for (ErrorProto error : results.getErrors()) { errors.add(BigQueryError.fromPb(error)); .setCompleted(results.getJobComplete()) .setSchema(schemaPb == null ? null : Schema.fromPb(schemaPb)) .setTotalRows(results.getTotalRows() == null ? 0 : results.getTotalRows().longValue()) .setErrors(errors.build()) .build();
JobId completeJobId = JobId.fromPb(results.getJobReference()); builder.jobId(completeJobId); builder.etag(results.getEtag()); builder.jobCompleted(results.getJobComplete()); List<TableRow> rowsPb = results.getRows(); if (results.getJobComplete()) { QueryResult.Builder resultBuilder = transformQueryResults(completeJobId, rowsPb, results.getPageToken(), serviceOptions, ImmutableMap.<BigQueryRpc.Option, Object>of()); resultBuilder.totalBytesProcessed(results.getTotalBytesProcessed()); resultBuilder.cacheHit(results.getCacheHit()); if (results.getSchema() != null) { resultBuilder.schema(Schema.fromPb(results.getSchema())); if (results.getTotalRows() != null) { resultBuilder.totalRows(results.getTotalRows().longValue()); if (results.getErrors() != null) { builder.executionErrors( Lists.transform(results.getErrors(), BigQueryError.FROM_PB_FUNCTION));
.execute(); } while (!qResponse.getJobComplete()); final TableSchema schema = qResponse.getSchema(); final List<TableRow> rows = qResponse.getRows(); deleteDataset(projectId, temporaryDatasetId); return !typed
/** * Makes an API call to the BigQuery API * * @param bigquery an authorized BigQuery client * @param projectId a string containing the current project ID * @param completedJob to the completed Job * @throws IOException */ private static void displayQueryResults(Bigquery bigquery, String projectId, Job completedJob) throws IOException { GetQueryResultsResponse queryResult = bigquery.jobs() .getQueryResults( projectId, completedJob .getJobReference() .getJobId() ).execute(); List<TableRow> rows = queryResult.getRows(); System.out.print("\nQuery Results:\n------------\n"); for (TableRow row : rows) { for (TableCell field : row.getF()) { System.out.printf("%-50s", field.getV()); } System.out.println(); } } // [END display_result]
JobId completeJobId = JobId.fromPb(results.getJobReference()); builder.jobId(completeJobId); builder.etag(results.getEtag()); builder.jobCompleted(results.getJobComplete()); List<TableRow> rowsPb = results.getRows(); if (results.getJobComplete()) { QueryResult.Builder resultBuilder = transformQueryResults(completeJobId, rowsPb, results.getPageToken(), serviceOptions, ImmutableMap.<BigQueryRpc.Option, Object>of()); resultBuilder.totalBytesProcessed(results.getTotalBytesProcessed()); resultBuilder.cacheHit(results.getCacheHit()); if (results.getSchema() != null) { resultBuilder.schema(Schema.fromPb(results.getSchema())); if (results.getTotalRows() != null) { resultBuilder.totalRows(results.getTotalRows().longValue()); if (results.getErrors() != null) { builder.executionErrors( Lists.transform(results.getErrors(), BigQueryError.FROM_PB_FUNCTION));
EXCEPTION_HANDLER, serviceOptions.getClock()); TableSchema schemaPb = results.getSchema(); if (results.getErrors() != null) { for (ErrorProto error : results.getErrors()) { errors.add(BigQueryError.fromPb(error)); .setCompleted(results.getJobComplete()) .setSchema(schemaPb == null ? null : Schema.fromPb(schemaPb)) .setTotalRows(results.getTotalRows() == null ? 0 : results.getTotalRows().longValue()) .setErrors(errors.build()) .build();