Skip to content

Instantly share code, notes, and snippets.

@jacobschaer

jacobschaer/bad_paging_bq

Created January 7, 2014 23:59
Show Gist options
  • Save jacobschaer/8309204 to your computer and use it in GitHub Desktop.
Save jacobschaer/8309204 to your computer and use it in GitHub Desktop.
Download ZIP
JSON Responses From Google BigQuery
Raw
bad_paging_bq
{
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'cacheHit': True,
'jobComplete': True,
'totalRows': '500000',
'pageToken': 'CIDBB777777QOGQIBCQI2BQQYCCD2===',
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/m_mgXE517TanzZAWeG-5si3LelE"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'cacheHit': True,
'jobComplete': True,
'totalRows': '500000',
'pageToken': 'CIDBB777777QOGQIBDAJUDAQYCCD2===',
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/xW7tCA1nDAlHr2nqfJaBDLmxydQ"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'cacheHit': True,
'jobComplete': True,
'totalRows': '500000',
'pageToken': 'CIDBB777777QOGQIBDQKOEQQYCCD2===',
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/psjDD19bAfxXYCprZyL29g74b9s"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'cacheHit': True,
'jobComplete': True,
'totalRows': '500000',
'pageToken': 'CIDBB777777QOGQIBCALKGAQYCCD2===',
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/RL-zpyOMxYw1aJFAGlRxhEZ_l_E"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'jobComplete': True,
'totalRows': '500000',
'cacheHit': True,
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/iQE36ywyUHNzCDYPPGNpkef8Kx8"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'cacheHit': True,
'jobComplete': True,
'totalRows': '500000',
'pageToken': 'CIDBB777777QOGQIBC53ODQQYCCD2===',
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/WuV8NcmLTRGht2LMmEcwJNRnhq8"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'cacheHit': True,
'jobComplete': True,
'totalRows': '500000',
'pageToken': 'CIDBB777777QOGQIBDN4IFAQYCCD2===',
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/9xFAwTbZBVnU186bFfGL6RSWTL8"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'cacheHit': True,
'jobComplete': True,
'totalRows': '500000',
'pageToken': 'CIDBB777777QOGQIBD55CGQQYCCD2===',
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/-I-DUX0IoySIs3lrHVB9Ta6SNB8"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'jobComplete': True,
'totalRows': '500000',
'cacheHit': True,
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/WXyR19JEVK6o-KL1hFe2__7a7jc"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'cacheHit': True,
'jobComplete': True,
'totalRows': '500000',
'pageToken': 'CIDBB777777QOGQIBDTIWFIQYCCD2===',
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/7FOe4S5TEnbQw1K6voyKlC9Ojpg"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'cacheHit': True,
'jobComplete': True,
'totalRows': '500000',
'pageToken': 'CIDBB777777QOGQIBCDJSGYQYCCD2===',
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/VFs3dDF3sI_EyQ3Ri-rJogOSt0Y"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'jobComplete': True,
'totalRows': '500000',
'cacheHit': True,
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/w_SrEVMn5GyRbe0uRVdfvFJX8Fc"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'cacheHit': True,
'jobComplete': True,
'totalRows': '500000',
'pageToken': 'CIDBB777777QOGQIBD7YUGQQYCCD2===',
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/xMFTjg8uc7_hwndd5SP-K0vklhE"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'jobComplete': True,
'totalRows': '500000',
'cacheHit': True,
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/U8f8n84rGlVoSgXZjGQ7I0Z-gdM"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'cacheHit': True,
'jobComplete': True,
'totalRows': '500000',
'pageToken': 'CIDBB777777QOGQIBCA3KHIQYCCD2===',
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/1ySkrFkhWRg88RmczD3UkF5ANec"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'jobComplete': True,
'totalRows': '500000',
'cacheHit': True,
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/MVxjn3yE-LSo4vjR_7PGjPhD9Pk"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'jobComplete': True,
'totalRows': '500000',
'cacheHit': True,
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/PUd7C7NgdAA0CL-6LUbGrgfB04A"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'jobComplete': True,
'totalRows': '500000',
'cacheHit': True,
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/yGEKbF4W_znz1G4_CJLDYRu9WdU"'
} {
'kind': 'bigquery#getQueryResultsResponse',
'jobReference': {
'projectId': 'xxxxxxxxxx',
'jobId': 'bqjob_r7e43d4e5edd15cb5_000001436f0ff05f_1'
},
'jobComplete': True,
'totalRows': '500000',
'cacheHit': True,
'etag': '"11dTZYgUnUwbk8emYQU9mVRTTLs/p4MHZf_AdfdbWdlV6o1IYxAOEWQ"'
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment