Prussian1870 opened a new issue, #834:
URL: https://github.com/apache/arrow-adbc/issues/834
When a SQLite table is created from an arrow table the table is created but
the data types are not defined:
import adbc_driver_sqlite as adbc_sqlite
import pyarrow as pa
conn=adbc_sqlite.connect("C:/dbs/adbc.db")
tbl=pa.Table.from_pydict({'numbers': [1, 2], 'letters': ['a', 'b']})
db_cursor=conn.cursor()
db_cursor.execute("drop table if exists adbc_bug")
db_cursor.adbc_ingest("adbc_bug", tbl, "create")
db_cursor.connection.commit()
db_cursor.close()
conn.close()
The columns ("numbers","letters") have no data type definition:
CREATE TABLE adbc_bug (numbers, letters)
It should be:
CREATE TABLE adbc_bug (numbers INTEGER,letters TEXT)
Thanks
--
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]
