15:47:39.753 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
15:47:39.758 INFO BigQueryUtils - Sending query to server...
15:47:40.699 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=ac1fbaa7-27a0-4fcc-90b2-e56971c0a6c2, location=US} to complete...
15:47:41.099 INFO BigQueryUtils - Retrieving query results...
15:47:41.827 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=ac1fbaa7-27a0-4fcc-90b2-e56971c0a6c2, location=US}
15:47:41.827 INFO BigQueryUtils - Query returned 3 results.
15:47:41.830 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
15:47:41.830 INFO BigQueryUtils - Sending query to server...
15:47:42.212 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=a3b5810a-7e3a-4ade-964f-4ebcf8cc3d16, location=US} to complete...
15:47:42.572 INFO BigQueryUtils - Retrieving query results...
15:47:43.195 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=a3b5810a-7e3a-4ade-964f-4ebcf8cc3d16, location=US}
15:47:43.195 INFO BigQueryUtils - Query returned 3 results.
15:47:43.197 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
15:47:43.197 INFO BigQueryUtils - Sending query to server...
15:47:43.640 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=34d90d55-f801-4a6e-94d0-b6cfbdc7429b, location=US} to complete...
15:47:43.976 INFO BigQueryUtils - Retrieving query results...
15:47:44.649 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=34d90d55-f801-4a6e-94d0-b6cfbdc7429b, location=US}
15:47:44.649 INFO BigQueryUtils - Query returned 3 results.
15:47:44.650 INFO gatk - testwhereclause03b2c243-a026-4169-9a2b-b5c0eb1eee64
15:47:44.651 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1` WHERE name = 'Fred'
15:47:44.652 INFO BigQueryUtils - Sending query to server...
15:47:45.274 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=72040d96-c58b-40e8-ad1e-0a280c9a53f5, location=US} to complete...
15:47:45.630 INFO BigQueryUtils - Retrieving query results...
15:47:46.343 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=72040d96-c58b-40e8-ad1e-0a280c9a53f5, location=US}
15:47:46.343 INFO BigQueryUtils - Query returned 1 results.
15:47:46.344 INFO BigQueryUtils - SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1` WHERE false
15:47:47.024 INFO BigQueryUtils - Estimated 0 MB scanned
15:47:47.026 INFO BigQueryUtils - Executing Query:
CREATE TABLE `broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_50764da0_5bdb_4edc_8a60_2b89c8bc8ae9`
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
15:47:47.026 INFO BigQueryUtils - Sending query to server...
15:47:47.419 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=a13f9f87-c2b4-4ccc-bfd6-aba0e609f09e, location=US} to complete...
15:47:49.058 INFO BigQueryUtils - Retrieving query results...
15:47:49.417 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=a13f9f87-c2b4-4ccc-bfd6-aba0e609f09e, location=US}
15:47:49.417 INFO BigQueryUtils - Query returned 0 results.
15:47:49.680 INFO BigQueryUtils - Query temp table created with 0 rows and 0 bytes in size
15:47:49.682 INFO StorageAPIAvroReader - Using Storage API from broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_50764da0_5bdb_4edc_8a60_2b89c8bc8ae9 with 'null'
15:47:49.996 INFO log - Logging initialized @17769ms to org.eclipse.jetty.util.log.Slf4jLog
15:47:50.791 INFO StorageAPIAvroReader - Storage API Session ID: projects/broad-dsde-dev/locations/us/sessions/CAISDC1MbW5uU0lYYks2ahoCanIaAmpk
15:47:50.791 INFO StorageAPIAvroReader - Storage API Estimated Bytes Scanned for broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_50764da0_5bdb_4edc_8a60_2b89c8bc8ae9:0
15:47:51.229 INFO BigQueryUtils - Executing Query:
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
15:47:51.230 INFO BigQueryUtils - Sending query to server...
15:47:51.669 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=3347218a-5ca0-49d5-861b-c7384c04e81e, location=US} to complete...
15:47:52.063 INFO BigQueryUtils - Retrieving query results...
15:47:52.667 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=3347218a-5ca0-49d5-861b-c7384c04e81e, location=US}
15:47:52.667 INFO BigQueryUtils - Query returned 3 results.
15:47:52.668 INFO BigQueryUtils - SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
15:47:53.262 INFO BigQueryUtils - Estimated 0 MB scanned
15:47:53.264 INFO BigQueryUtils - Executing Query:
CREATE TABLE `broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_f284069e_f8fd_4a0f_a0a0_30517eb53ca1`
OPTIONS(
expiration_timestamp=TIMESTAMP_ADD(CURRENT_TIMESTAMP(), INTERVAL 1 DAY)
) AS
SELECT * FROM `broad-dsde-dev.gatk_bigquery_test_dataset.gatk_bigquery_test_table1`
15:47:53.264 INFO BigQueryUtils - Sending query to server...
15:47:53.660 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=f2f04fe9-35e0-4b04-82c2-199d38c95bd2, location=US} to complete...
15:47:55.556 INFO BigQueryUtils - Retrieving query results...
15:47:55.864 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=f2f04fe9-35e0-4b04-82c2-199d38c95bd2, location=US}
15:47:55.865 INFO BigQueryUtils - Query returned 0 results.
15:47:56.144 INFO BigQueryUtils - Query temp table created with 3 rows and 38 bytes in size
15:47:56.144 INFO StorageAPIAvroReader - Using Storage API from broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_f284069e_f8fd_4a0f_a0a0_30517eb53ca1 with 'null'
15:47:56.788 INFO StorageAPIAvroReader - Storage API Session ID: projects/broad-dsde-dev/locations/us/sessions/CAISDEdsMVIzaXRwb09IZxoCanIaAmpk
15:47:56.788 INFO StorageAPIAvroReader - Storage API Estimated Bytes Scanned for broad-dsde-dev.gatk_bigquery_test_dataset.temp_table_f284069e_f8fd_4a0f_a0a0_30517eb53ca1:22
15:47:57.193 INFO BigQueryUtils - Sending query to server...
15:47:57.674 INFO BigQueryUtils - Waiting for query JobId{project=broad-dsde-dev, job=3cea88d5-d548-47f2-9b43-fea69228d7e5, location=US} to complete...
15:47:57.991 INFO BigQueryUtils - Retrieving query results...
15:47:58.555 INFO BigQueryUtils - 0.00 MB actually scanned for job: JobId{project=broad-dsde-dev, job=3cea88d5-d548-47f2-9b43-fea69228d7e5, location=US}