ibnubay opened a new issue, #2177:
URL: https://github.com/apache/arrow-adbc/issues/2177
### What would you like help with?
Env:
- Macos Sonoma (14.5)
- Python 3.11.9
- pyarrow 17.0.0
- adbc_driver_postgresql 1.2.0
Background:
I want to load data into Postgresql using Bulk Ingestion/Copy command from
parquet file.
I have pyarrow "amount" column with pa.float64(), to be inserted into
Numeric with scale type in Postgresql "amount numeric(18, 2)".
Then I got this error below:
`Exception: ProgrammingError('INVALID_ARGUMENT: [libpq] Failed to execute
COPY statement: PGRES_FATAL_ERROR ERROR: insufficient data left in
message\nCONTEXT: COPY invoice_new, line 1, column amount\n. SQLSTATE: 08P01')`
To fix this error, do I need cast pyarrow "amount" column schema to another
schema type?
Ty
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
