WillAyd commented on issue #1080:
URL: https://github.com/apache/arrow-adbc/issues/1080#issuecomment-1728404033
From a source install I think there is now a new issue in general with
ingest:
```
In [3]: import pyarrow as pa
...: from adbc_driver_postgresql import dbapi
...:
...:
...: uri = "postgresql://postgres:postgres@localhost:5432/pandas"
...: with dbapi.connect(uri) as conn:
...: with conn.cursor() as cur:
...: data = pa.array([1, 2, 4])
...: tbl = pa.Table.from_arrays([data], names=["CAPITALIZED"])
...: cur.adbc_ingest("test_table", tbl, mode="create")
...: conn.commit()
...:
---------------------------------------------------------------------------
ProgrammingError Traceback (most recent call last)
Cell In[3], line 10
8 data = pa.array([1, 2, 4])
9 tbl = pa.Table.from_arrays([data], names=["CAPITALIZED"])
---> 10 cur.adbc_ingest("test_table", tbl, mode="create")
11 conn.commit()
File
~/clones/arrow-adbc/python/adbc_driver_manager/adbc_driver_manager/dbapi.py:878,
in Cursor.adbc_ingest(self, table_name, data, mode, catalog_name,
db_schema_name, temporary)
874 options = {
875 adbc_driver_manager.StatementOptions.INGEST_TEMPORARY.value:
"false",
876 }
877 try:
--> 878 self._stmt.set_options(**options)
879 except NotSupportedError:
880 pass
File adbc_driver_manager/_lib.pyx:1374, in
adbc_driver_manager._lib.AdbcStatement.set_options()
File adbc_driver_manager/_lib.pyx:227, in
adbc_driver_manager._lib.check_error()
ProgrammingError: INVALID_ARGUMENT: [libpq] Invalid value 'false' for option
'adbc.ingest.temporary'
```
--
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]
