bigquery表分区以编程方式使用php

Question

I am trying to create partition on big-query when load data using php script but not getting right solution.

<?php
require_once '/v/vv/vv/common.php';
require_once '/vv/vv/vv/vendor/autoload.php';

use Google\Cloud\BigQuery\BigQueryClient;
use Google\Cloud\Core\ExponentialBackoff;
/** Uncomment and populate these variables in your code */
$projectId  = 'id';
$datasetId  = 'ids';

$bigQuery = new BigQueryClient([
   'projectId' => $projectId,
]);
$dataset = $bigQuery->dataset($datasetId);
$table_id='test_table';
$table = $dataset->table($table_id);
// create the import job
$schema = [
  'fields' => [
        ['name' => 'date', 'type' => 'Date','mode'=>'required'],
        ['name' => 'name', 'type' => 'string'],
        ['name' => 'post_abbr', 'type' => 'string']
  ],
 'timePartitioning'=>['type'=>'DAY','filed'=>'date']
]

Answer 1

You are mixing the schema definition with timePartitioning. Here is a snippet of code:

use Google\Cloud\BigQuery\BigQueryClient;

$source = 'miData.csv';
$datasetId  = 'miDataset';
$table_id='miTable';

$bigQuery = new BigQueryClient();
$dataset = $bigQuery->dataset($datasetId);
$table = $dataset->table($table_id);

$loadConfig = $table->load(fopen($source, 'r'));

$loadConfig->sourceFormat('CSV');

// create the import job
$schema = [
  'fields' => [
        ['name' => 'miDate', 'type' => 'DATE','mode'=>'required'],
        ['name' => 'name', 'type' => 'STRING'],
        ['name' => 'post_abbr', 'type' => 'STRING']
  ]
];

$loadConfig->schema($schema);

$timePartitioning = ['type'=>'DAY','filed'=>'miDate'];
$loadConfig->timePartitioning($timePartitioning);

$loadConfig->createDisposition('CREATE_IF_NEEDED');
$loadConfig->writeDisposition('WRITE_TRUNCATE');


$job = $table->runJob($loadConfig);

For more information about the available options for load jobs check the API documentation and the PHP loadJobConfiguration.