20:51:42.853 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
20:51:42.858 INFO BigQueryUtils - Sending query to server...
20:51:43.413 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=8704bc79-07b9-454e-beb8-90d121e442bc, location=US} to complete...
20:51:43.674 INFO BigQueryUtils - Retrieving query results...
20:51:44.219 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=8704bc79-07b9-454e-beb8-90d121e442bc, location=US}
20:51:44.220 INFO BigQueryUtils - Query returned 3 results.
20:51:44.223 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
20:51:44.223 INFO BigQueryUtils - Sending query to server...
20:51:44.617 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=b7defe4a-ba08-4349-9b5b-32abc0c08ec5, location=US} to complete...
20:51:44.881 INFO BigQueryUtils - Retrieving query results...
20:51:45.325 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=b7defe4a-ba08-4349-9b5b-32abc0c08ec5, location=US}
20:51:45.326 INFO BigQueryUtils - Query returned 3 results.
20:51:45.328 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
20:51:45.328 INFO BigQueryUtils - Sending query to server...
20:51:45.727 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=a951a327-b2ae-41f1-9358-90776b8cab2b, location=US} to complete...
20:51:45.967 INFO BigQueryUtils - Retrieving query results...
20:51:46.495 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=a951a327-b2ae-41f1-9358-90776b8cab2b, location=US}
20:51:46.495 INFO BigQueryUtils - Query returned 3 results.
20:51:46.496 INFO gatk - testwhereclauseb98fa4f9-008b-469c-8597-1bbbae5ce500
20:51:46.498 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1` WHERE name = 'Fred'
20:51:46.498 INFO BigQueryUtils - Sending query to server...
20:51:46.911 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=ba8a1b5c-6d67-489c-a23f-4e03117efb38, location=US} to complete...
20:51:47.159 INFO BigQueryUtils - Retrieving query results...
20:51:47.639 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=ba8a1b5c-6d67-489c-a23f-4e03117efb38, location=US}
20:51:47.639 INFO BigQueryUtils - Query returned 1 results.
20:51:47.640 INFO BigQueryUtils - SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1` WHERE false
20:51:48.279 INFO BigQueryUtils - Estimated 0 MB scanned
20:51:48.281 INFO BigQueryUtils - Executing Query:
CREATE TABLE `broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_87049362_5307_4c5d_89f0_d0f46db6e2ae`
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
20:51:48.281 INFO BigQueryUtils - Sending query to server...
20:51:48.703 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=26d7aa99-0155-411d-9f70-14c27aa90f86, location=US} to complete...
20:51:50.387 INFO BigQueryUtils - Retrieving query results...
20:51:50.653 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=26d7aa99-0155-411d-9f70-14c27aa90f86, location=US}
20:51:50.654 INFO BigQueryUtils - Query returned 0 results.
20:51:50.833 INFO BigQueryUtils - Query temp table created with 0 rows and 0 bytes in size
20:51:50.835 INFO StorageAPIAvroReader - Using Storage API from broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_87049362_5307_4c5d_89f0_d0f46db6e2ae with 'null'
20:51:51.145 INFO log - Logging initialized @15174ms to org.eclipse.jetty.util.log.Slf4jLog
20:51:51.912 INFO StorageAPIAvroReader - Storage API Session ID: projects/broad-dsde-dev/locations/us/sessions/CAISDE9tMW1mOGtqaC02bBoCanIaAmpk
20:51:51.913 INFO StorageAPIAvroReader - Storage API Estimated Bytes Scanned for broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_87049362_5307_4c5d_89f0_d0f46db6e2ae:0
20:51:52.203 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
20:51:52.203 INFO BigQueryUtils - Sending query to server...
20:51:52.591 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=3fd659de-b6b5-4fce-854c-3b2e30054872, location=US} to complete...
20:51:52.873 INFO BigQueryUtils - Retrieving query results...
20:51:53.311 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=3fd659de-b6b5-4fce-854c-3b2e30054872, location=US}
20:51:53.312 INFO BigQueryUtils - Query returned 3 results.
20:51:53.312 INFO BigQueryUtils - SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
20:51:53.949 INFO BigQueryUtils - Estimated 0 MB scanned
20:51:53.951 INFO BigQueryUtils - Executing Query:
CREATE TABLE `broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_36694cd9_58b9_4617_8363_f9050e9232bf`
OPTIONS(
expiration_timestamp=TIMESTAMP_ADD(CURRENT_TIMESTAMP(), INTERVAL 1 DAY)
) AS
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
20:51:53.951 INFO BigQueryUtils - Sending query to server...
20:51:54.417 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=83a53a47-2101-4bf2-a1d6-f7cbf29f9559, location=US} to complete...
20:51:55.992 INFO BigQueryUtils - Retrieving query results...
20:51:56.254 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=83a53a47-2101-4bf2-a1d6-f7cbf29f9559, location=US}
20:51:56.254 INFO BigQueryUtils - Query returned 0 results.
20:51:56.472 INFO BigQueryUtils - Query temp table created with 3 rows and 38 bytes in size
20:51:56.473 INFO StorageAPIAvroReader - Using Storage API from broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_36694cd9_58b9_4617_8363_f9050e9232bf with 'null'
20:51:57.490 INFO StorageAPIAvroReader - Storage API Session ID: projects/broad-dsde-dev/locations/us/sessions/CAISDElCa3lHS1NZVTJLbBoCanIaAmpk
20:51:57.491 INFO StorageAPIAvroReader - Storage API Estimated Bytes Scanned for broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_36694cd9_58b9_4617_8363_f9050e9232bf:22
20:51:57.810 INFO BigQueryUtils - Sending query to server...
20:51:58.239 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=0259d26b-f958-474a-b524-25847f6f6e86, location=US} to complete...
20:51:58.477 INFO BigQueryUtils - Retrieving query results...
20:51:58.923 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=0259d26b-f958-474a-b524-25847f6f6e86, location=US}