FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
python-docs-samples/bigquery/api/async_query.py at master · fullstackguy/python-docs-samples · GitHub
fullstackguy
/
python-docs-samples
Public
forked from
GoogleCloudPlatform/python-docs-samples
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Wiki
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Wiki
Security and quality
Insights
Expand file tree
Breadcrumbs
python-docs-samples
/
bigquery
/
api
/
async_query.py
Copy path
More file actions
More file actions
Latest commit
History
History
History
executable file
·
148 lines (123 loc) · 4.22 KB
Breadcrumbs
python-docs-samples
/
bigquery
/
api
/
async_query.py
Copy path
File metadata and controls
executable file
·
148 lines (123 loc) · 4.22 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
#!/usr/bin/env python
# Copyright 2015, Google, Inc.
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
"""Command-line application to perform an asynchronous query in BigQuery.
For more information, see the README.md under /bigquery.
"""
import
argparse
import
json
import
time
import
uuid
import
googleapiclient
.
discovery
# [START async_query]
def
async_query
(
bigquery
,
project_id
,
query
,
batch
=
False
,
num_retries
=
5
,
use_legacy_sql
=
False
):
# Generate a unique job ID so retries
# don't accidentally duplicate query
job_data
=
{
'jobReference'
: {
'projectId'
:
project_id
,
'jobId'
:
str
(
uuid
.
uuid4
())
},
'configuration'
: {
'query'
: {
'query'
:
query
,
'priority'
:
'BATCH'
if
batch
else
'INTERACTIVE'
,
# Set to False to use standard SQL syntax. See:
# https://cloud.google.com/bigquery/sql-reference/enabling-standard-sql
'useLegacySql'
:
use_legacy_sql
}
}
}
return
bigquery
.
jobs
().
insert
(
projectId
=
project_id
,
body
=
job_data
).
execute
(
num_retries
=
num_retries
)
# [END async_query]
# [START poll_job]
def
poll_job
(
bigquery
,
job
):
"""Waits for a job to complete."""
print
(
'Waiting for job to finish...'
)
request
=
bigquery
.
jobs
().
get
(
projectId
=
job
[
'jobReference'
][
'projectId'
],
jobId
=
job
[
'jobReference'
][
'jobId'
])
while
True
:
result
=
request
.
execute
(
num_retries
=
2
)
if
result
[
'status'
][
'state'
]
==
'DONE'
:
if
'errorResult'
in
result
[
'status'
]:
raise
RuntimeError
(
result
[
'status'
][
'errorResult'
])
print
(
'Job complete.'
)
return
time
.
sleep
(
1
)
# [END poll_job]
# [START run]
def
main
(
project_id
,
query_string
,
batch
,
num_retries
,
interval
,
use_legacy_sql
):
# [START build_service]
# Construct the service object for interacting with the BigQuery API.
bigquery
=
googleapiclient
.
discovery
.
build
(
'bigquery'
,
'v2'
)
# [END build_service]
# Submit the job and wait for it to complete.
query_job
=
async_query
(
bigquery
,
project_id
,
query_string
,
batch
,
num_retries
,
use_legacy_sql
)
poll_job
(
bigquery
,
query_job
)
# Page through the result set and print all results.
page_token
=
None
while
True
:
page
=
bigquery
.
jobs
().
getQueryResults
(
pageToken
=
page_token
,
**
query_job
[
'jobReference'
]).
execute
(
num_retries
=
2
)
print
(
json
.
dumps
(
page
[
'rows'
]))
page_token
=
page
.
get
(
'pageToken'
)
if
not
page_token
:
break
# [END run]
# [START main]
if
__name__
==
'__main__'
:
parser
=
argparse
.
ArgumentParser
(
description
=
__doc__
,
formatter_class
=
argparse
.
RawDescriptionHelpFormatter
)
parser
.
add_argument
(
'project_id'
,
help
=
'Your Google Cloud project ID.'
)
parser
.
add_argument
(
'query'
,
help
=
'BigQuery SQL Query.'
)
parser
.
add_argument
(
'-b'
,
'--batch'
,
help
=
'Run query in batch mode.'
,
action
=
'store_true'
)
parser
.
add_argument
(
'-r'
,
'--num_retries'
,
help
=
'Number of times to retry in case of 500 error.'
,
type
=
int
,
default
=
5
)
parser
.
add_argument
(
'-p'
,
'--poll_interval'
,
help
=
'How often to poll the query for completion (seconds).'
,
type
=
int
,
default
=
1
)
parser
.
add_argument
(
'-l'
,
'--use_legacy_sql'
,
help
=
'Use legacy BigQuery SQL syntax instead of standard SQL syntax.'
,
type
=
bool
,
default
=
False
)
args
=
parser
.
parse_args
()
main
(
args
.
project_id
,
args
.
query
,
args
.
batch
,
args
.
num_retries
,
args
.
poll_interval
,
args
.
use_legacy_sql
)
# [END main]
Back
|
FazBrowse Home
|
New Git URL