python - python中的bigquery API出现问题“AttributeError:'NoneType'对象没有属性'path'”
问题描述
我正在尝试使用 python 访问 bigquery 并遇到以下错误,并且想知道您是否可以帮助我调试问题
delete_job = client.query(sql_raw)
try:
delete_job.result() # Waits for job to complete.
print("Job was successful")
except exceptions.BadRequest:
handle_exceptions(delete_job)
Sql_raw = """delete from A.table_1 where activity_date in (select distinct activity_date from A.table_B);
insert into A.table_1 select * from A.table_2 ;"""
Error
Traceback (most recent call last):
File "/Python_Envs/3.6.1/lib/python3.6/runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "/Python_Envs/3.6.1/lib/python3.6/runpy.py", line 85, in _run_code
exec(code, run_globals)
File "/Python_Packages/ec2-python_old.zip/m/executor/__main__.py", line 192, in <module>
File "/Python_Packages/ec2-python_old.zip/m/executor/__main__.py", line 183, in main
File "/Python_Packages/ec2-python_old.zip/m/d/A/custom.py", line 223, in load
File "/Python_Envs/3.6.1/lib/python3.6/site-packages/google/cloud/bigquery/job.py", line 1950, in result
retry=retry)
File "/Python_Envs/3.6.1/lib/python3.6/site-packages/google/cloud/bigquery/client.py", line 1274, in list_rows
path='%s/data' % (table.path,),
AttributeError: 'NoneType' object has no attribute 'path'
更新:我认为它是 python 3.6.1 包或其他东西的错误。我将我的 python 更新到 3.6.5,它现在可以正常工作了。
解决方案
你可以这样试试:
try:
job.result() # Waits for table load to complete.
except:
print(job.exception())
推荐阅读
- pagespeed - 配额限制 Page Speed V5
- django - Django 监控数据库和电子邮件作为警报,如果数据库达到条件
- c# - 为什么我的变量值加倍 Visual C#
- windows - 使用 .batch 更改调用 cmd 提示符的目录
- dtd - 是什么导致此 xml 文件出现此错误
- c++ - Eigen middleCols() 惩罚
- javascript - 如何将事件侦听器添加到由 javascript 对象模型生成的 HTML
- opengl - 离屏渲染和 alpha 与背景颜色缓冲区的混合
- javascript - 调用调度后组件不更新
- c++ - 可写的邮编范围是不可能的?