aiguofer opened a new issue, #878:
URL: https://github.com/apache/arrow-adbc/issues/878
Hi, I've been trying to use parametrized queries against our AFS server and
can't seem to figure out how to do it.
Here's what I tried in python:
```
with conn.cursor() as cur:
cur.execute("select ?", [1])
```
and here's the error:
```
Traceback (most recent call last):
File
"/Users/aiguofer/work/dbtlabs/sl-example-clients/python/src/adbc_example.py",
line 86, in <module>
main(sys.argv)
File
"/Users/aiguofer/work/dbtlabs/sl-example-clients/python/src/adbc_example.py",
line 51, in main
cur.execute("select ?", [1])
File "/Users/aiguofer/Library/Application
Support/hatch/env/virtual/afs-example/vPTxZbV9/afs-example/lib/python3.11/site-packages/adbc_driver_manager/dbapi.py",
line 604, in execute
handle, self._rowcount = self._stmt.execute_query()
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "adbc_driver_manager/_lib.pyx", line 991, in
adbc_driver_manager._lib.AdbcStatement.execute_query
File "adbc_driver_manager/_lib.pyx", line 385, in
adbc_driver_manager._lib.check_error
adbc_driver_manager._lib.InternalError: ADBC_STATUS_INTERNAL (9):
[FlightSQL] rpc error: code = Internal desc = There was an error servicing your
request.
```
When I look through the logs, I see that the driver tried to make a
`acceptPutPreparedStatementQuery` call, which we haven't implemented on our
service yet. What exactly is the purpose of this call?
Are we supposed to implement the string replacement for the parameters? I
haven't been able to find much documentation about this.
--
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]
