NoSuchModuleError:无法加载插件:sqlalchemy.dialects:teradata [英] NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:teradata

问题描述

我正在尝试使用 sqlalchemy-teradata 将 Pandas 数据帧写入 Teradata 表.这是我正在使用的代码:

Hi I am attempting to use sqlalchemy-teradata to write a pandas dataframe into a Teradata table. Here is the code I am using:

from sqlalchemy import create_engine
import sqlalchemy_teradata

td_engine=create_engine('teradata://'+uid+':'+password+'@'+host+':22/')

上面的错误又回来了.我也试过这个代码，以及我在 stackoverflow 上的其他地方看到过这个:

That comes back with the error above. I have also tried this code as well as I've seen this elsewhere on stackoverflow:

engine=create_engine('teradata://'+ uid +':' + password + '@'+ host + '/' + '?authentication=LDAP')

我已经安装了以下所有软件包:sqlalchemy、sqlalchemy-teradata 和 teradatasqlalchemy.

I have installed all of the following packages: sqlalchemy, sqlalchemy-teradata, and teradatasqlalchemy.

有没有人见过这个错误?任何帮助将不胜感激！

Has anyone seen this error before? Any help would be much appreciated!

推荐答案

我会首先检查软件包是否正确安装:

I would first of all check if the packages are installed correctly:

$ python
>>> import teradata
>>> import sqlalchemy_teradata

这会给出任何错误信息吗?

Does this give any error messages?

另外，我相信你只需要 sqlalchemy-teradata 包，而不是 teradatasqlalchemy.

Also, I believe you only need the sqlalchemy-teradata package, not teradatasqlalchemy.

这篇关于NoSuchModuleError:无法加载插件:sqlalchemy.dialects:teradata的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！