キャッシュに保存されているクエリ結果を使用する

import ( 	"context" 	"fmt" 	"io"  	"cloud.google.com/go/bigquery" 	"google.golang.org/api/iterator" )  // queryDisableCache demonstrates issuing a query and requesting that the query cache is bypassed. func queryDisableCache(w io.Writer, projectID string) error { 	// projectID := "my-project-id" 	ctx := context.Background() 	client, err := bigquery.NewClient(ctx, projectID) 	if err != nil { 		return fmt.Errorf("bigquery.NewClient: %v", err) 	} 	defer client.Close()  	q := client.Query( 		"SELECT corpus FROM `bigquery-public-data.samples.shakespeare` GROUP BY corpus;") 	q.DisableQueryCache = true 	// Location must match that of the dataset(s) referenced in the query. 	q.Location = "US"  	// Run the query and print results when the query job is completed. 	job, err := q.Run(ctx) 	if err != nil { 		return err 	} 	status, err := job.Wait(ctx) 	if err != nil { 		return err 	} 	if err := status.Err(); err != nil { 		return err 	} 	it, err := job.Read(ctx) 	for { 		var row []bigquery.Value 		err := it.Next(&row) 		if err == iterator.Done { 			break 		} 		if err != nil { 			return err 		} 		fmt.Fprintln(w, row) 	} 	return nil } 

import com.google.cloud.bigquery.BigQuery; import com.google.cloud.bigquery.BigQueryException; import com.google.cloud.bigquery.BigQueryOptions; import com.google.cloud.bigquery.QueryJobConfiguration; import com.google.cloud.bigquery.TableResult;  // Sample to running a query with the cache disabled. public class QueryDisableCache {    public static void runQueryDisableCache() {     String query = "SELECT corpus FROM `bigquery-public-data.samples.shakespeare` GROUP BY corpus;";     queryDisableCache(query);   }    public static void queryDisableCache(String query) {     try {       // Initialize client that will be used to send requests. This client only needs to be created       // once, and can be reused for multiple requests.       BigQuery bigquery = BigQueryOptions.getDefaultInstance().getService();        QueryJobConfiguration queryConfig =           QueryJobConfiguration.newBuilder(query)               // Disable the query cache to force live query evaluation.               .setUseQueryCache(false)               .build();        TableResult results = bigquery.query(queryConfig);        results           .iterateAll()           .forEach(row -> row.forEach(val -> System.out.printf("%s,", val.toString())));        System.out.println("Query disable cache performed successfully.");     } catch (BigQueryException | InterruptedException e) {       System.out.println("Query not performed \n" + e.toString());     }   } }

// Import the Google Cloud client library const {BigQuery} = require('@google-cloud/bigquery');  async function queryDisableCache() {   // Queries the Shakespeare dataset with the cache disabled.    // Create a client   const bigquery = new BigQuery();    const query = `SELECT corpus     FROM \`bigquery-public-data.samples.shakespeare\`     GROUP BY corpus`;   const options = {     query: query,     // Location must match that of the dataset(s) referenced in the query.     location: 'US',     useQueryCache: false,   };    // Run the query as a job   const [job] = await bigquery.createQueryJob(options);   console.log(`Job ${job.id} started.`);    // Wait for the query to finish   const [rows] = await job.getQueryResults();    // Print the results   console.log('Rows:');   rows.forEach(row => console.log(row)); }

use Google\Cloud\BigQuery\BigQueryClient;  /** Uncomment and populate these variables in your code */ // $projectId = 'The Google project ID'; // $query = 'SELECT id, view_count FROM `bigquery-public-data.stackoverflow.posts_questions`';  // Construct a BigQuery client object. $bigQuery = new BigQueryClient([     'projectId' => $projectId, ]);  // Set job configs $jobConfig = $bigQuery->query($query); $jobConfig->useQueryCache(false);  // Extract query results $queryResults = $bigQuery->runQuery($jobConfig);  $i = 0; foreach ($queryResults as $row) {     printf('--- Row %s ---' . PHP_EOL, ++$i);     foreach ($row as $column => $value) {         printf('%s: %s' . PHP_EOL, $column, json_encode($value));     } } printf('Found %s row(s)' . PHP_EOL, $i);

from google.cloud import bigquery  # Construct a BigQuery client object. client = bigquery.Client()  job_config = bigquery.QueryJobConfig(use_query_cache=False) sql = """     SELECT corpus     FROM `bigquery-public-data.samples.shakespeare`     GROUP BY corpus; """ query_job = client.query(sql, job_config=job_config)  # Make an API request.  for row in query_job:     print(row)