Repository navigation
write_dataframe() does not finish #250
Description
Activity
- changed the title
[-]write_dataframe() does not finished[/-][+]write_dataframe() does not finish[/+]on Feb 3, 2025 Trying more I faced another problem that was: the cursor used on the write_dataframe function seems to overwrite the cursor params style and uses internally only position based formatting like
insert values (%s, %s, ...)so I had to reorder the pandas DataFrame columns based on the same order of the Redshift table columns.I'm using:
- Python 3.9.20
- pandas>=2.2.3
- redshift-connector>=2.1.5
Pinning
pandas < 2.0,numpy < 2.0let me run the query. Are the updated docs where it is stated the supported versions of the libraries integrations?
I'm trying to write a
pandas.DataFrameinto a table using thewrite_dataframefunction but I tried waiting 10 minutes, and it does not finish.I limited the size of the dataframe to have around 70 rows and 40 columns, the problem persists.
In the debugger, the code is stuck when calling the libray code
self.executemany(sql, arrays)intowrite_dataframe.How can I know what is the problem? I can read successfully another table. The table where I want to write was just created for testing purpouses.
Thanks