Inserting pyarrow.date32 fails

[mauropagano]

Submitting this as a discussion because I thought this worked, but I might be remembering incorrectly

Trying to ingest an Arrow table with a date32 column fails, which is unfortunate since lots of date without time component are read as date32 by Arrow.

Example below

import oracledb
import pyarrow as pa
import datetime
  
a = pa.array([datetime.date(2025, 11, 1)], type=pa.date32())
t = pa.Table.from_arrays([a], names=["a"])
# pyarrow.Table
# a: date32[day]
# ----
# a: [[2025-11-01]]
conn = oracledb.connect("...")                                                                                                                                                                                                                                                                                                                                   
cursor = conn.cursor()
cursor.executemany("insert into insert_pq (start_month) values (:1)", t)
# oracledb.exceptions.NotSupportedError: DPY-3032: conversion from Arrow format "tdD" to Oracle Database is not supported

[anthony-tuininga]

Yes, this is not supported today. That could be fixed, though! Feel free to turn this into an enhancement request. :-)

[mauropagano]

Awesome, let me change that! thanks @anthony-tuininga !