new com.google.api.services.bigquery.model.JobConfiguration(); JobConfigurationQuery queryConfigurationPb = new JobConfigurationQuery(); queryConfigurationPb.setQuery(query); if (!positionalParameters.isEmpty()) { List<QueryParameter> queryParametersPb =
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"))); }
queryConfig.setQuery(querySql);
new com.google.api.services.bigquery.model.JobConfiguration(); JobConfigurationQuery queryConfigurationPb = new JobConfigurationQuery(); queryConfigurationPb.setQuery(query); if (!positionalParameters.isEmpty()) { List<QueryParameter> queryParametersPb =
private JobConfigurationQuery createBasicQueryConfig() { return new JobConfigurationQuery() .setFlattenResults(flattenResults) .setQuery(query.get()) .setUseLegacySql(useLegacySql); }
/** * 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; }
.setAllowLargeResults(true) .setDestinationTable(tempTableReference) .setQuery(query); JobConfiguration jc = new JobConfiguration().setQuery(jcQuery);
bqOptions.getProject(), new JobConfigurationQuery() .setQuery(getQuery().get()) .setFlattenResults(getFlattenResults()) .setUseLegacySql(getUseLegacySql()),
new com.google.api.services.bigquery.model.JobConfiguration(); JobConfigurationQuery queryConfigurationPb = new JobConfigurationQuery(); queryConfigurationPb.setQuery(query); configurationPb.setDryRun(dryRun()); if (allowLargeResults != null) {
new com.google.api.services.bigquery.model.JobConfiguration(); JobConfigurationQuery queryConfigurationPb = new JobConfigurationQuery(); queryConfigurationPb.setQuery(query); configurationPb.setDryRun(dryRun()); if (allowLargeResults != null) {
queryConfig.setQuery(query);
@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); } }