python - Teradataml 错误 mlengine_alias_definitions_v1.0' 未为当前 Vantage 版本“vantage1.0”定义

Question

我正在尝试创建一个利用 teradataml python 的 exe 文件。我正在尝试在 teradata 中创建一个表并导入数据表单 pandas 数据框。这是我的代码。

import pandas as pd
from sqlalchemy import create_engine
from teradataml.context.context import *
from sqlalchemy import *
from teradataml.dataframe.copy_to import copy_to_sql
from sqlalchemy.dialects import registry
from teradatasqlalchemy import dialect
registry.register('teradata', 'teradatasqlalchemy', 'dialect')

user = 'dbc'
pasw=user
host = '192.168.1.7'

td_engine = create_engine('teradata://'+ user +':' + pasw + '@'+ host )

create_context(tdsqlengine =td_engine)

df = pd.read_csv(r"C:/krishna/data/FL_insurance_sample1.csv", delimiter=',')
copy_to_sql(df = df, table_name = "Insurece_sample", primary_index="InsurenceID", if_exists="replace")
remove_context()

最初我遇到了错误，但是我修复了那个。

sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:teradata

我试过的pyinstaller命令：

pyinstaller --add-binary "C:\Users\krishna\AppData\Local\Programs\Python\Python38\Lib\site-packages\teradatasql\teradatasql.dll;teradatasql"-F pyinstalletest.py

我现在得到的错误：

Traceback (most recent call last):
  File "pyinstalletest.py", line 18, in <module>
  File "teradataml\context\context.py", line 459, in create_context
  File "teradataml\context\context.py", line 751, in _load_function_aliases
  File "teradataml\common\utils.py", line 1591, in _check_alias_config_file_exists
teradataml.common.exceptions.TeradataMlException: [Teradata][teradataml](TDML_2069) Alias config file 'C:\Users\krishna\AppData\Local\Temp\_MEI63962\teradataml\config\mlengine_alias_definitions_v1.0' is not defined for the current Vantage version 'vantage1.0'. Please add the config file.
[1660] Failed to execute script pyinstalletest

请帮我解决错误。

标签： pythonpython-3.xsqlalchemypyinstallerteradata