Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

Getting error while writitng my data from dataframe to SAP HANA table using python script.

AYE123
Level 1
Getting error while writitng my data from dataframe to SAP HANA table using python script.

I am getting this error while writitng my data from dataframe to SAP HANA table using python script.

Exception: An error occurred during dataset write (mdbQeu4jjA): JDBCDriverException: SAP DBTech JDBC: [288] (at 22): cannot use duplicate table name

df = dataiku.Dataset("data")

df.spec_item["appendMode"] = True
with df.get_writer() as writer:
    writer.write_dataframe(data_df)

0 Kudos
1 Reply
JordanB
Dataiker

Hi @AYE123,

Can you check if you might already have a table with the table_name "data_df"? If not, can you provide the full code with input and output table names and full stack trace? Also, are you using a python recipe or notebook to execute this code? 

Thanks!

Jordan

0 Kudos