python里data显示无效的语法_使用python从terdata获取表列表时出现语法错误怎么办？...

我尝试用以下代码从Python中的Teradata获取表列表：import jaydebeapi

import pandas as pd

try:

conn = jaydebeapi.connect(jclassname='com.teradata.jdbc.TeraDriver',

url="jdbc:teradata://10.10.10.10",

driver_args=['@user','@pss'],

jars=['/mnt/TERADATA/tdgssconfig.jar','/mnt/TERADATA/terajdbc4.jar'])

print("Connection was successful")

except Exception as e:

print(e)

#df = pd.read_sql_query('SELECT Databasename,TableName FROM dbc.tables WHERE tablekind = \'T\'',conn)

dfr = pd.DataFrame(df)

print(dfr.head(3))

上面的操作很好，但是当我尝试根据数据库名称获取表列表时， 就不起作用了：df = pd.read_sql_query('SELECT Databasename,TableName FROM dbc.tables WHERE tablekind = \'T\' and DatabaseName ='SALES'',conn)

dfr = pd.DataFrame(df)

print(dfr.head(3))

我得到：Error: Invalid Syntax