17:48:26.558 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
17:48:26.564 INFO BigQueryUtils - Sending query to server...
17:48:27.184 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=496b1ecd-670e-4501-85ae-66e4dd122813, location=US} to complete...
17:48:27.454 INFO BigQueryUtils - Retrieving query results...
17:48:28.028 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=496b1ecd-670e-4501-85ae-66e4dd122813, location=US}
17:48:28.028 INFO BigQueryUtils - Query returned 3 results.
17:48:28.031 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
17:48:28.032 INFO BigQueryUtils - Sending query to server...
17:48:28.424 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=c7939de2-f10e-48ec-be62-1ae26811b196, location=US} to complete...
17:48:28.728 INFO BigQueryUtils - Retrieving query results...
17:48:29.328 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=c7939de2-f10e-48ec-be62-1ae26811b196, location=US}
17:48:29.328 INFO BigQueryUtils - Query returned 3 results.
17:48:29.331 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
17:48:29.331 INFO BigQueryUtils - Sending query to server...
17:48:29.754 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=b2db80df-4d9b-4454-85fb-58ee51a5f1ab, location=US} to complete...
17:48:30.049 INFO BigQueryUtils - Retrieving query results...
17:48:30.567 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=b2db80df-4d9b-4454-85fb-58ee51a5f1ab, location=US}
17:48:30.568 INFO BigQueryUtils - Query returned 3 results.
17:48:30.569 INFO gatk - testwhereclause68cf79c1-68c4-422d-8650-090737f77bd1
17:48:30.570 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1` WHERE name = 'Fred'
17:48:30.570 INFO BigQueryUtils - Sending query to server...
17:48:30.963 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=7aac8d78-66a3-466e-abf3-20ed1a212bb7, location=US} to complete...
17:48:31.254 INFO BigQueryUtils - Retrieving query results...
17:48:31.724 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=7aac8d78-66a3-466e-abf3-20ed1a212bb7, location=US}
17:48:31.725 INFO BigQueryUtils - Query returned 1 results.
17:48:31.726 INFO BigQueryUtils - SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1` WHERE false
17:48:32.395 INFO BigQueryUtils - Estimated 0 MB scanned
17:48:32.397 INFO BigQueryUtils - Executing Query:
CREATE TABLE `broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_4ec24e36_7dcc_478f_af27_e7cfe0bb449f`
OPTIONS(
expiration_timestamp=TIMESTAMP_ADD(CURRENT_TIMESTAMP(), INTERVAL 1 DAY)
) AS
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1` WHERE false
17:48:32.397 INFO BigQueryUtils - Sending query to server...
17:48:33.105 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=360f4ff2-4ad0-42fe-aaca-c3c631efaba2, location=US} to complete...
17:48:34.478 INFO BigQueryUtils - Retrieving query results...
17:48:34.730 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=360f4ff2-4ad0-42fe-aaca-c3c631efaba2, location=US}
17:48:34.731 INFO BigQueryUtils - Query returned 0 results.
17:48:34.966 INFO BigQueryUtils - Query temp table created with 0 rows and 0 bytes in size
17:48:34.968 INFO StorageAPIAvroReader - Using Storage API from broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_4ec24e36_7dcc_478f_af27_e7cfe0bb449f with 'null'
17:48:35.366 INFO log - Logging initialized @15518ms to org.eclipse.jetty.util.log.Slf4jLog
17:48:37.543 INFO StorageAPIAvroReader - Storage API Session ID: projects/broad-dsde-dev/locations/us/sessions/CAISDFFGdm43Y1JDTTVGVBoCanIaAmlj
17:48:37.544 INFO StorageAPIAvroReader - Storage API Estimated Bytes Scanned for broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_4ec24e36_7dcc_478f_af27_e7cfe0bb449f:0
17:48:37.893 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
17:48:37.893 INFO BigQueryUtils - Sending query to server...
17:48:38.305 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=386eaca6-2492-4504-a6f5-138c83a698ee, location=US} to complete...
17:48:38.581 INFO BigQueryUtils - Retrieving query results...
17:48:39.106 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=386eaca6-2492-4504-a6f5-138c83a698ee, location=US}
17:48:39.106 INFO BigQueryUtils - Query returned 3 results.
17:48:39.107 INFO BigQueryUtils - SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
17:48:39.703 INFO BigQueryUtils - Estimated 0 MB scanned
17:48:39.704 INFO BigQueryUtils - Executing Query:
CREATE TABLE `broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_88d1a413_a60a_4301_a8aa_ab63e1aea096`
OPTIONS(
expiration_timestamp=TIMESTAMP_ADD(CURRENT_TIMESTAMP(), INTERVAL 1 DAY)
) AS
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
17:48:39.704 INFO BigQueryUtils - Sending query to server...
17:48:40.351 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=36558b52-ab33-44c1-832a-b42c6e4b8ef9, location=US} to complete...
17:48:41.724 INFO BigQueryUtils - Retrieving query results...
17:48:42.014 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=36558b52-ab33-44c1-832a-b42c6e4b8ef9, location=US}
17:48:42.014 INFO BigQueryUtils - Query returned 0 results.
17:48:42.236 INFO BigQueryUtils - Query temp table created with 3 rows and 38 bytes in size
17:48:42.236 INFO StorageAPIAvroReader - Using Storage API from broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_88d1a413_a60a_4301_a8aa_ab63e1aea096 with 'null'
17:48:43.867 INFO StorageAPIAvroReader - Storage API Session ID: projects/broad-dsde-dev/locations/us/sessions/CAISDDFVNmFzMG9oUlZrWBoCanIaAmlj
17:48:43.867 INFO StorageAPIAvroReader - Storage API Estimated Bytes Scanned for broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_88d1a413_a60a_4301_a8aa_ab63e1aea096:22
17:48:44.294 INFO BigQueryUtils - Sending query to server...
17:48:44.674 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=74c09a14-0067-44ef-b15d-5a0848084235, location=US} to complete...
17:48:44.954 INFO BigQueryUtils - Retrieving query results...
17:48:45.439 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=74c09a14-0067-44ef-b15d-5a0848084235, location=US}