Trying to create a table in teradata using Sqlalchemy. This is the command -
df_depts.to_sql('AT_tryout',engine,index= False, if_exists ='replace',dtype={"similarity": BIGINT ,"inputs": CLOB ,"recommendations": CLOB})
Any idea of why I am getting unable to create index error.
Enitre error looks like this -
sqlalchemy.exc.DatabaseError: (teradata.api.DatabaseError) (5660, '[HY000] [Teradata][ODBC Teradata Driver][Teradata Database] Cannot create index on LOB columns. ') [SQL: '\nCREATE TABLE "AT_tryout" (\n\tinputs CLOB(255), \n\trecommendations CLOB(255), \n\tsimilarity BIGINT\n)\n\n'] (Background on this error at: http://sqlalche.me/e/4xp6)
Any help is appreciated. Thank you.