22:48:59.084 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
22:48:59.091 INFO BigQueryUtils - Sending query to server...
22:48:59.577 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=fa628371-1b9e-4dcd-bc74-47df6a1bd24e, location=US} to complete...
22:48:59.907 INFO BigQueryUtils - Retrieving query results...
22:49:00.557 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=fa628371-1b9e-4dcd-bc74-47df6a1bd24e, location=US}
22:49:00.558 INFO BigQueryUtils - Query returned 3 results.
22:49:00.560 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
22:49:00.561 INFO BigQueryUtils - Sending query to server...
22:49:01.019 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=bd721220-ba0c-446b-b454-db113b3c2d30, location=US} to complete...
22:49:01.363 INFO BigQueryUtils - Retrieving query results...
22:49:01.941 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=bd721220-ba0c-446b-b454-db113b3c2d30, location=US}
22:49:01.941 INFO BigQueryUtils - Query returned 3 results.
22:49:01.943 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
22:49:01.944 INFO BigQueryUtils - Sending query to server...
22:49:02.379 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=b4977425-284c-40df-a3d0-b77e99f9d365, location=US} to complete...
22:49:02.686 INFO BigQueryUtils - Retrieving query results...
22:49:03.258 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=b4977425-284c-40df-a3d0-b77e99f9d365, location=US}
22:49:03.259 INFO BigQueryUtils - Query returned 3 results.
22:49:03.260 INFO gatk - testwhereclausee24aa03b-b4a1-4542-9714-cfde1fc8bc64
22:49:03.261 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1` WHERE name = 'Fred'
22:49:03.261 INFO BigQueryUtils - Sending query to server...
22:49:03.681 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=fc874c42-b7cf-403d-952d-df0eb3ff683c, location=US} to complete...
22:49:03.957 INFO BigQueryUtils - Retrieving query results...
22:49:04.549 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=fc874c42-b7cf-403d-952d-df0eb3ff683c, location=US}
22:49:04.549 INFO BigQueryUtils - Query returned 1 results.
22:49:04.550 INFO BigQueryUtils - SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1` WHERE false
22:49:05.116 INFO BigQueryUtils - Estimated 0 MB scanned
22:49:05.118 INFO BigQueryUtils - Executing Query:
CREATE TABLE `broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_666f4ef2_2fcd_4c71_9fd8_835b20be0e22`
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
22:49:05.118 INFO BigQueryUtils - Sending query to server...
22:49:05.490 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=d6e1b662-2967-4e4d-8d37-24b0983ef0c0, location=US} to complete...
22:49:07.129 INFO BigQueryUtils - Retrieving query results...
22:49:07.433 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=d6e1b662-2967-4e4d-8d37-24b0983ef0c0, location=US}
22:49:07.433 INFO BigQueryUtils - Query returned 0 results.
22:49:07.655 INFO BigQueryUtils - Query temp table created with 0 rows and 0 bytes in size
22:49:07.657 INFO StorageAPIAvroReader - Using Storage API from broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_666f4ef2_2fcd_4c71_9fd8_835b20be0e22 with 'null'
22:49:08.024 INFO log - Logging initialized @19527ms to org.eclipse.jetty.util.log.Slf4jLog
22:49:08.730 INFO StorageAPIAvroReader - Storage API Session ID: projects/broad-dsde-dev/locations/us/sessions/CAISDGU3Tk5rcDZHSU40aBoCanIaAmpk
22:49:08.731 INFO StorageAPIAvroReader - Storage API Estimated Bytes Scanned for broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_666f4ef2_2fcd_4c71_9fd8_835b20be0e22:0
22:49:09.050 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
22:49:09.051 INFO BigQueryUtils - Sending query to server...
22:49:09.463 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=84d1b548-ba69-4e73-b78d-63046c8ef4e7, location=US} to complete...
22:49:09.737 INFO BigQueryUtils - Retrieving query results...
22:49:10.344 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=84d1b548-ba69-4e73-b78d-63046c8ef4e7, location=US}
22:49:10.344 INFO BigQueryUtils - Query returned 3 results.
22:49:10.346 INFO BigQueryUtils - SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
22:49:10.981 INFO BigQueryUtils - Estimated 0 MB scanned
22:49:10.983 INFO BigQueryUtils - Executing Query:
CREATE TABLE `broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_6fdafd09_76a2_4ea9_af7b_b2f381d5f673`
OPTIONS(
expiration_timestamp=TIMESTAMP_ADD(CURRENT_TIMESTAMP(), INTERVAL 1 DAY)
) AS
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
22:49:10.983 INFO BigQueryUtils - Sending query to server...
22:49:11.366 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=79c9bc85-ed23-45c0-9d2f-7b47c09bdf1b, location=US} to complete...
22:49:12.996 INFO BigQueryUtils - Retrieving query results...
22:49:13.275 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=79c9bc85-ed23-45c0-9d2f-7b47c09bdf1b, location=US}
22:49:13.276 INFO BigQueryUtils - Query returned 0 results.
22:49:13.508 INFO BigQueryUtils - Query temp table created with 3 rows and 38 bytes in size
22:49:13.509 INFO StorageAPIAvroReader - Using Storage API from broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_6fdafd09_76a2_4ea9_af7b_b2f381d5f673 with 'null'
22:49:14.128 INFO StorageAPIAvroReader - Storage API Session ID: projects/broad-dsde-dev/locations/us/sessions/CAISDGRVa3dOMzdnaE8wVxoCanIaAmpk
22:49:14.128 INFO StorageAPIAvroReader - Storage API Estimated Bytes Scanned for broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_6fdafd09_76a2_4ea9_af7b_b2f381d5f673:22
22:49:14.481 INFO BigQueryUtils - Sending query to server...
22:49:14.858 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=860924c1-ef70-4cf0-8cb5-7408b56d8b05, location=US} to complete...
22:49:15.150 INFO BigQueryUtils - Retrieving query results...
22:49:15.719 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=860924c1-ef70-4cf0-8cb5-7408b56d8b05, location=US}