pyodps 获取表数据,向表写数据,行记录Record报错
来源:互联网 发布:有电影翻译软件 编辑:程序博客网 时间:2024/06/03 11:36
阿里云pyodps文档 http://pyodps.readthedocs.io/zh_CN/latest/base-tables-zh.html
获取表数据,向表写数据,行记录Record报错
报错信息:
>>> with mytable.open_writer(partition='pt=test') as writer:
... writer.write([1,2])
...
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/lib64/python2.6/contextlib.py", line 16, in __enter__
return self.gen.next()
File "/usr/lib/python2.6/site-packages/odps/models/table.py", line 403, in open_writer
upload_id=upload_id, **kw)
File "/usr/lib/python2.6/site-packages/odps/tunnel/tabletunnel/tabletunnel.py", line 54, in create_upload_session
compress_option=compress_option)
File "/usr/lib/python2.6/site-packages/odps/tunnel/tabletunnel/uploadsession.py", line 57, in __init__
self._init()
File "/usr/lib/python2.6/site-packages/odps/tunnel/tabletunnel/uploadsession.py", line 71, in _init
resp = self._client.post(url, {}, params=params, headers=headers)
File "/usr/lib/python2.6/site-packages/odps/rest.py", line 120, in post
return self.request(url, 'post', data=data, **kwargs)
File "/usr/lib/python2.6/site-packages/odps/rest.py", line 112, in request
errors.throw_if_parsable(res)
File "/usr/lib/python2.6/site-packages/odps/errors.py", line 78, in throw_if_parsable
raise NoSuchObject('No such object.')
odps.errors.NoSuchObject: No such object.
解决:
找不到分区,也就是mytable表没有test分区
可以先添加分区
mytable.create_partition('pt=test')
有test分区后就能写如数据了
>>> with mytable.open_writer(partition='pt=test') as writer:
... records = [[111],
... [222],
... [333],
... [444]]
... writer.write(records)
报错信息:
>>> with mytable.open_writer(partition='pt=test') as writer:
... records=[1,2,3,4]
... writer.writer(records)
...
Traceback (most recent call last):
File "<stdin>", line 3, in <module>
File "/usr/lib64/python2.6/contextlib.py", line 34, in __exit__
self.gen.throw(type, value, traceback)
File "/usr/lib/python2.6/site-packages/odps/models/table.py", line 477, in open_writer
yield RecordWriter()
File "<stdin>", line 3, in <module>
AttributeError: 'RecordWriter' object has no attribute 'writer'
>>>
解决:
writer.write(records)中第二个writer多个r,如下
>>>
>>> with mytable.open_writer(partition='pt=test') as writer:
... records = [[111],
... [222],
... [333],
... [444]]
... writer.write(records)
...
- pyodps 获取表数据,向表写数据,行记录Record报错
- 向HDFS 中写数据
- 向优盘写RAW数据
- python向mysql写数据
- mapreduce向hbase写数据
- 向文件中写数据
- PyOdps DataFrame来临,数据分析从未如此简单!
- Tensorflow object_detection API 训练自己数据集生成.record报错
- 怎么使用object与record类型返回表类型数据
- Replace Record with Data Class(以数据类取代记录 )
- Extjs-数据存储与传输-记录集 Ext.data.Record
- Java报错 无法从已删除行获取数据
- IOS9获取HTML数据报错解决
- 错误笔记:写项目时用PreparedStatement向数据库中插入数据报游标不足错误
- [Android]使用Bmob向云数据库插入数据报错
- c# oracle 向表中添加数据 报错:invalid character 。原因是在sql后面加了分号
- hibernate获取数据获取不到,没有报错
- Mysql命令insert into:向表中插入数据(记录)
- 由两个平方三位数获得三个平方两位数
- 上周热点回顾(2.20-2.26)
- java Cipher加密、解密
- 前端小程序——js+canvas 给图片添加水印
- mysql触发器
- pyodps 获取表数据,向表写数据,行记录Record报错
- ExtJS入门实例
- 自定义ViewGroup笔记--ViewDragHelper
- 2.一心只想创业,想改变世界,你愿意一起吗?
- 解决idea新建maven项目时一直loading问题
- PdoDb 数据库类
- 平分七筐鱼
- Windows实验
- VMware不能连网解决方法——必须开启Windows的VMware相关服务