googleBigQuery：可捕获的致命错误：参数1传递给Google \ Cloud \ BigQuery \ BigQueryClient :: runQuery（）

Question

I am stuck with this error, let me know if there is any workarounds:

googleBigQuery: Catchable fatal error: Argument 1 passed to

Google\Cloud\BigQuery\BigQueryClient::runQuery() must be an instance

of Google\Cloud\BigQuery\JobConfigurationInterface, string given

Code sample:

<?php

require __DIR__ . '/vendor/autoload.php';

use Google\Cloud\BigQuery\BigQueryClient;

// get the project ID as the first argument    
$projectId = 'bigquery-public-data';

$bigQuery = new BigQueryClient([
    'projectId' => $projectId,
]);

$query = 'SELECT TOP(corpus, 10) as title, COUNT(*) as unique_words ' .
         'FROM [bigquery-public-data:samples.shakespeare]';

$options = ['useLegacySql' => true];
$queryResults = $bigQuery->runQuery($query, $options);

if ($queryResults->isComplete()) {
    $i = 0;
    $rows = $queryResults->rows();
    foreach ($rows as $row) {
        printf('--- Row %s ---' . PHP_EOL, ++$i);
        foreach ($row as $column => $value) {
            printf('%s: %s' . PHP_EOL, $column, $value);
        }
    }
    printf('Found %s row(s)' . PHP_EOL, $i);
} else {
    throw new Exception('The query failed to complete');
}

Answer 1

Resolved by using below code..

<?php
# Includes the autoloader for libraries installed with composer
require __DIR__ . '/vendor/autoload.php';

# Imports the Google Cloud client library
use Google\Cloud\BigQuery\BigQueryClient;
use Google\Cloud\Core\ServiceBuilder;


// Authenticate using a keyfile path
$cloud = new ServiceBuilder([
    'keyFilePath' => 'keyfile.json'
]);

$bigQuery = $cloud->bigQuery();

//$query = 'SELECT commit FROM `bigquery-public-data.github_repos.commits` WHERE message = ? LIMIT 100';

$queryJobConfig = $bigQuery->query($query)
    ->parameters(['A commit message.']);
$queryResults = $bigQuery->runQuery($queryJobConfig);