SQL Alchemy无法在事务块内运行 [英] Sql Alchemy cannot run inside a transaction block
本文介绍了SQL Alchemy无法在事务块内运行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试通过python脚本在redshift中运行查询,但出现错误:
I'm trying to run a query in redshift from a python script, but I'm getting error:
sqlalchemy.exc.InternalError: (psycopg2.InternalError) ALTER EXTERNAL TABLE cannot run inside a transaction block
这是我的代码:
engine = create_engine(SQL_ENGINE % urlquote(REDSHIFT_PASS))
partition_date = (date.today() - timedelta(day)).strftime("%Y%m%d")
query = """alter table {table_name} add partition (dt={date_partition}) location 's3://dft-dwh-files/raw_data/google_analytics/revenue_per_channel/{date_partition}/';""".format(date_partition=partition_date,table_name=table_name)
conn = engine.connect()
conn.execute(query).execution_options(autocommit=True)
我该如何解决?
推荐答案
For PostgreSQL, you need to set the isolation level to AUTOCOMMIT
, not the SQLAlchemy autocommit
:
conn.execution_options(isolation_level="AUTOCOMMIT").execute(query)
这篇关于SQL Alchemy无法在事务块内运行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文