aws / aws/amazon-redshift-python-driver
The field names should be presented.
- Lingua principale
- Python
- Stelle
- 220
- Fork
- 86
- Metriche di merge delle PR
- Nessuna PR unita negli ultimi 30g
Descrizione
The generated sql code for insert do not point the field names.
Then the only way to make it work is to order the field names in the dataframe.
```
if not self.__is_valid_table(table):
raise InterfaceError("Invalid table name passed to write_dataframe: {}".format(table))
sanitized_table_name: str = self.__sanitize_str(table)
arrays: list = df.values.tolist()
placeholder: str = ", ".join(["%s"] * len(arrays[0]))
sql: str = "insert into {table} values ({placeholder})".format(
table=sanitized_table_name, placeholder=placeholder
)
```
https://github.com/aws/amazon-redshift-python-driver/blob/64cbd54ef6a5e71d98ce193630d09267cc154379/redshift_connector/cursor.py#L584C1-L591C10
Guida per i contributori
Apri la guida per i contributori
Valutazione
Questa issue non è ancora stata valutata.