aws / aws/amazon-redshift-python-driver

write_dataframe() does not finish

Offen
#250 2 Kommentare 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
Vorherrschende Sprache
Python
Sterne
220
Forks
86
PR-Merge-Kennzahlen
Keine gemergten PRs in 30 T.

Beschreibung

I'm trying to write a `pandas.DataFrame` into a table using the `write_dataframe `function 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)` into `write_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

Beitragsleitfaden

Beitragsleitfaden öffnen

Rechercherichtung

Start at write_dataframe() and inspect the self.executemany(sql, arrays) call described in the report. Reproduce the hang with a roughly 70-row, 40-column pandas.DataFrame and the newly created test table, then determine what allows the write to finish and verify that the dataframe is inserted successfully.

Vom Indexierungsmodell aus dem Issue-Text verfasst.

Bewertung

Tech-Stack
aws, pandas, python
Bereich
databases
Issue-Typ
Bug
Schwierigkeit
4/5
Geschätzter Aufwand
3-5 Tage
Aktivitätsstatus
Veraltet
Klarheit
Muss geklärt werden
Anfängerfreundlichkeit
30/100

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.