BigQuery 中的 SQL 簡介

 using Google.Cloud.BigQuery.V2; using System;  public class BigQueryQueryLegacy {     public void QueryLegacy(         string projectId = "your-project-id"     )     {         BigQueryClient client = BigQueryClient.Create(projectId);         string query = @"             SELECT name FROM [bigquery-public-data:usa_names.usa_1910_2013]             WHERE state = 'TX'             LIMIT 100";         BigQueryJob job = client.CreateQueryJob(             sql: query,             parameters: null,             options: new QueryOptions { UseLegacySql = true });         // Wait for the job to complete.         job = job.PollUntilCompleted().ThrowOnAnyError();         // Display the results         foreach (BigQueryRow row in client.GetQueryResults(job.Reference))         {             Console.WriteLine($"{row["name"]}");         }     } }

import ( 	"context" 	"fmt" 	"io"  	"cloud.google.com/go/bigquery" 	"google.golang.org/api/iterator" )  // queryLegacy demonstrates running a query using Legacy SQL. func queryLegacy(w io.Writer, projectID, sqlString string) error { 	// projectID := "my-project-id" 	// sqlString = "SELECT 3 as somenum" 	ctx := context.Background() 	client, err := bigquery.NewClient(ctx, projectID) 	if err != nil { 		return fmt.Errorf("bigquery.NewClient: %w", err) 	} 	defer client.Close()  	q := client.Query(sqlString) 	q.UseLegacySQL = true  	// Run the query and process the returned row iterator. 	it, err := q.Read(ctx) 	if err != nil { 		return fmt.Errorf("query.Read(): %w", err) 	} 	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;  public class RunLegacyQuery {    public static void main(String[] args) {     runLegacyQuery();   }    public static void runLegacyQuery() {     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();        // To use legacy SQL syntax, set useLegacySql to true.       String query =           "SELECT corpus FROM [bigquery-public-data:samples.shakespeare] GROUP BY corpus;";       QueryJobConfiguration queryConfig =           QueryJobConfiguration.newBuilder(query).setUseLegacySql(true).build();        // Execute the query.       TableResult result = bigquery.query(queryConfig);        // Print the results.       result.iterateAll().forEach(rows -> rows.forEach(row -> System.out.println(row.getValue())));        System.out.println("Legacy query ran successfully");     } catch (BigQueryException | InterruptedException e) {       System.out.println("Legacy query did not run \n" + e.toString());     }   } }

// Import the Google Cloud client library const {BigQuery} = require('@google-cloud/bigquery'); const bigquery = new BigQuery();  async function queryLegacy() {   // Queries the U.S. given names dataset for the state of Texas using legacy SQL.    const query =     'SELECT word FROM [bigquery-public-data:samples.shakespeare] LIMIT 10;';    // For all options, see https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs/query   const options = {     query: query,     // Location must match that of the dataset(s) referenced in the query.     location: 'US',     useLegacySql: true,   };    // 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;  /**  * Query using legacy sql  *  * @param string $projectId The project Id of your Google Cloud Project.  */ function query_legacy(string $projectId): void {     $query = 'SELECT corpus FROM [bigquery-public-data:samples.shakespeare] GROUP BY corpus';      $bigQuery = new BigQueryClient([       'projectId' => $projectId,     ]);     $jobConfig = $bigQuery->query($query)->useLegacySql(true);      $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()  query = (     "SELECT name FROM [bigquery-public-data:usa_names.usa_1910_2013] "     'WHERE state = "TX" '     "LIMIT 100" )  # Set use_legacy_sql to True to use legacy SQL syntax. job_config = bigquery.QueryJobConfig(use_legacy_sql=True)  # Start the query and waits for query job to complete, passing in the extra configuration. results = client.query_and_wait(     query, job_config=job_config )  # Make an API request.  print("The query data:") for row in results:     print(row)

require "google/cloud/bigquery"  def query_legacy   bigquery = Google::Cloud::Bigquery.new   sql = "SELECT name FROM [bigquery-public-data:usa_names.usa_1910_2013] " \         "WHERE state = 'TX' " \         "LIMIT 100"    results = bigquery.query sql, legacy_sql: true do |config|     # Location must match that of the dataset(s) referenced in the query.     config.location = "US"   end    results.each do |row|     puts row.inspect   end end