pyodps写入mysql分区表_pyodps操作maxCompute

连接ODPS

from odps import ODPS

odps = ODPS('**your-access-id**', '**your-secret-access-key**', '**

your-default-project**',

endpoint='**your-end-point**')

your-default-project**',

endpoint='**your-end-point**')

这两个可省略，通过get_project命令获取到某个项⽬空间

创建非分区表data_temp:table_name,data_count,time 三个字段

table = odps.create_table('data_temp','table_name string, data_count bigint, time datetime',if_not_exists=True)

操作表

t = odps.get_table('data_temp')

插入数据，使用列表的形式

records = [['lrb', 344322, '2020-04-28 14:09:37'],

['zcfzb', 4343434, '2020-04-28 14:09:37'],

['xjllb', 21142232, '2020-04-28 14:09:37'],

['test', 343242, '2020-04-28 14:09:37']]

odps.writ