com.google.api.services.bigquery.model.JobConfiguration.setQuery()方法的使用及代码示例

x33g5p2x  于2022-01-22 转载在 其他  
字(8.0k)|赞(0)|评价(0)|浏览(92)

本文整理了Java中com.google.api.services.bigquery.model.JobConfiguration.setQuery()方法的一些代码示例，展示了JobConfiguration.setQuery()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。JobConfiguration.setQuery()方法的具体详情如下：
包路径：com.google.api.services.bigquery.model.JobConfiguration
类名称：JobConfiguration
方法名：setQuery

JobConfiguration.setQuery介绍

[英][Pick one] Configures a query job.
[中][选择一个]配置查询作业。

代码示例

代码示例来源：origin: googleapis/google-cloud-java

private static com.google.api.services.bigquery.model.Job newJobPb() {
 return new com.google.api.services.bigquery.model.Job()
   .setConfiguration(
     new com.google.api.services.bigquery.model.JobConfiguration()
       .setQuery(new JobConfigurationQuery().setQuery("FOO")));
}

代码示例来源：origin: googleapis/google-cloud-java

queryConfigurationPb.setClustering(clustering.toPb());
return configurationPb.setQuery(queryConfigurationPb);

代码示例来源：origin: googleapis/google-cloud-java

@Test
public void testIncomplete() {
 // https://github.com/googleapis/google-cloud-java/issues/2357
 com.google.api.services.bigquery.model.Job job =
   new com.google.api.services.bigquery.model.Job()
     .setStatistics(
       new com.google.api.services.bigquery.model.JobStatistics()
         .setCreationTime(1234L)
         .setStartTime(5678L));
 job.setConfiguration(
   new com.google.api.services.bigquery.model.JobConfiguration()
     .setCopy(new com.google.api.services.bigquery.model.JobConfigurationTableCopy()));
 assertThat(JobStatistics.fromPb(job)).isInstanceOf(CopyStatistics.class);
 job.setConfiguration(
   new com.google.api.services.bigquery.model.JobConfiguration()
     .setLoad(new com.google.api.services.bigquery.model.JobConfigurationLoad()));
 assertThat(JobStatistics.fromPb(job)).isInstanceOf(LoadStatistics.class);
 job.setConfiguration(
   new com.google.api.services.bigquery.model.JobConfiguration()
     .setExtract(new com.google.api.services.bigquery.model.JobConfigurationExtract()));
 assertThat(JobStatistics.fromPb(job)).isInstanceOf(ExtractStatistics.class);
 job.setConfiguration(
   new com.google.api.services.bigquery.model.JobConfiguration()
     .setQuery(new com.google.api.services.bigquery.model.JobConfigurationQuery()));
 assertThat(JobStatistics.fromPb(job)).isInstanceOf(QueryStatistics.class);
}

代码示例来源：origin: stackoverflow.com

JobConfiguration config = new JobConfiguration();
JobConfigurationQuery queryConfig = new JobConfigurationQuery();
config.setQuery(queryConfig);

代码示例来源：origin: stackoverflow.com

Job content = new Job();
JobConfiguration cfg = new JobConfiguration();
JobConfigurationQuery jobConfigurationQuery = new JobConfigurationQuery();
UserDefinedFunctionResource userDefinedFunctionResource = new UserDefinedFunctionResource();
userDefinedFunctionResource.setResourceUri("gs://mybucket/udf.js");
jobConfigurationQuery.setUserDefinedFunctionResources(Lists.newArrayList(
  userDefinedFunctionResource
));
cfg.setQuery(jobConfigurationQuery);
content.setConfiguration(cfg);
Bigquery.Jobs.Insert request = bigqueryService.jobs().insert(projectId, content);
Job response = request.execute();

代码示例来源：origin: org.apache.beam/beam-sdks-java-io-google-cloud-platform

/**
 * {@inheritDoc}
 *
 * <p>Tries executing the RPC for at most {@code MAX_RPC_RETRIES} times until it succeeds.
 *
 * @throws IOException if it exceeds {@code MAX_RPC_RETRIES} attempts.
 */
@Override
public void startQueryJob(JobReference jobRef, JobConfigurationQuery queryConfig)
  throws IOException, InterruptedException {
 Job job =
   new Job()
     .setJobReference(jobRef)
     .setConfiguration(new JobConfiguration().setQuery(queryConfig));
 startJob(job, errorExtractor, client);
}

代码示例来源：origin: googlearchive/bigquery-samples-java

/**
 * Creates a Query Job for a particular query on a dataset
 *
 * @param bigquery  an authorized BigQuery client
 * @param projectId a String containing the project ID
 * @param querySql  the actual query string
 * @return a reference to the inserted query job
 * @throws IOException
 */
public static JobReference startQuery(Bigquery bigquery, String projectId,
                   String querySql) throws IOException {
 System.out.format("\nInserting Query Job: %s\n", querySql);
 Job job = new Job();
 JobConfiguration config = new JobConfiguration();
 JobConfigurationQuery queryConfig = new JobConfigurationQuery();
 config.setQuery(queryConfig);
 job.setConfiguration(config);
 queryConfig.setQuery(querySql);
 Insert insert = bigquery.jobs().insert(projectId, job);
 insert.setProjectId(projectId);
 JobReference jobId = insert.execute().getJobReference();
 System.out.format("\nJob ID of Query Job is: %s\n", jobId.getJobId());
 return jobId;
}

代码示例来源：origin: com.spotify/scio-bigquery

.setQuery(queryConfig)
    .setDryRun(true));
JobStatistics jobStats = executeWithBackOff(
Job job = new Job();
JobConfiguration config = new JobConfiguration();
config.setQuery(queryConfig);
job.setConfiguration(config);

代码示例来源：origin: org.apache.beam/beam-sdks-java-io-google-cloud-platform

@Override
public JobStatistics dryRunQuery(
  String projectId, JobConfigurationQuery queryConfig, String location)
  throws InterruptedException, IOException {
 JobReference jobRef = new JobReference().setLocation(location).setProjectId(projectId);
 Job job =
   new Job()
     .setJobReference(jobRef)
     .setConfiguration(new JobConfiguration().setQuery(queryConfig).setDryRun(true));
 return executeWithRetries(
     client.jobs().insert(projectId, job),
     String.format(
       "Unable to dry run query: %s, aborting after %d retries.",
       queryConfig, MAX_RPC_RETRIES),
     Sleeper.DEFAULT,
     createDefaultBackoff(),
     ALWAYS_RETRY)
   .getStatistics();
}

代码示例来源：origin: org.apache.beam/beam-sdks-java-io-google-cloud-platform

.setDestinationTable(tempTableReference)
    .setQuery(query);
JobConfiguration jc = new JobConfiguration().setQuery(jcQuery);

代码示例来源：origin: com.google.cloud/google-cloud-bigquery

queryConfigurationPb.setClustering(clustering.toPb());
return configurationPb.setQuery(queryConfigurationPb);

代码示例来源：origin: org.apache.beam/beam-sdks-java-io-google-cloud-platform

@Override
public void startQueryJob(JobReference jobRef, JobConfigurationQuery query) {
 synchronized (allJobs) {
  Job job = new Job();
  job.setJobReference(jobRef);
  job.setConfiguration(new JobConfiguration().setQuery(query));
  job.setKind(" bigquery#job");
  job.setStatus(new JobStatus().setState("PENDING"));
  allJobs.put(jobRef.getProjectId(), jobRef.getJobId(), new JobInfo(job));
 }
}

代码示例来源：origin: com.google.gcloud/gcloud-java-bigquery

queryConfigurationPb.setWriteDisposition(writeDisposition.toString());
return configurationPb.setQuery(queryConfigurationPb);

代码示例来源：origin: com.google.cloud/gcloud-java-bigquery

queryConfigurationPb.setUseLegacySql(useLegacySql);
return configurationPb.setQuery(queryConfigurationPb);

代码示例来源：origin: com.google.cloud.bigdataoss/bigquery-connector

config.setQuery(queryConfig);

代码示例来源：origin: io.digdag/digdag-standards

@Override
  protected JobConfiguration jobConfiguration(String projectId)
  {
    JobConfigurationQuery cfg = new JobConfigurationQuery()
        .setQuery(query);
    cfg.setUseLegacySql(params.get("use_legacy_sql", boolean.class, false));
    params.getOptional("allow_large_results", boolean.class).transform(cfg::setAllowLargeResults);
    params.getOptional("use_query_cache", Boolean.class).transform(cfg::setUseQueryCache);
    params.getOptional("create_disposition", String.class).transform(cfg::setCreateDisposition);
    params.getOptional("write_disposition", String.class).transform(cfg::setWriteDisposition);
    params.getOptional("flatten_results", Boolean.class).transform(cfg::setFlattenResults);
    params.getOptional("maximum_billing_tier", Integer.class).transform(cfg::setMaximumBillingTier);
    params.getOptional("priority", String.class).transform(cfg::setPriority);
    params.getOptional("table_definitions", new TypeReference<Map<String, ExternalDataConfiguration>>() {})
        .transform(cfg::setTableDefinitions);
    params.getOptional("user_defined_function_resources", new TypeReference<List<UserDefinedFunctionResource>>() {})
        .transform(cfg::setUserDefinedFunctionResources);
    Optional<DatasetReference> defaultDataset = params.getOptional("dataset", String.class)
        .transform(Bq::datasetReference);
    defaultDataset.transform(cfg::setDefaultDataset);
    params.getOptional("destination_table", String.class)
        .transform(s -> cfg.setDestinationTable(tableReference(projectId, defaultDataset, s)));
    return new JobConfiguration()
        .setQuery(cfg);
  }
}

内容来源于网络，如有侵权，请联系作者删除！

JobConfiguration

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com