[ARROW-3176] [Python] Overflow in Date32 column conversion to pandas

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.10.0
• Fix Version/s: 0.15.0
• Component/s: Python
• External issue URL: https://github.com/apache/arrow/issues/19522
• Assignee: Unassigned
• Reporter: Florian Jetter
• Created: 05/Sep/18 14:19
• Updated: 11/Jan/23 07:25
• Resolved: 26/Sep/19 03:19

Description

When converting an arrow column holding a Date32Array to pandas there seems to be an overflow at the date 2262-04-12 such that the type and value are wrong. The issue only occurs for columns, not for arrays.

Running on debian 9.5 w/ python2 gives
 

In [1]: import numpy as np

In [2]: import datetime

In [3]: import pyarrow as pa

In [4]: pa.__version__
Out[4]: '0.10.0'

In [5]: arr = pa.array(np.array([datetime.date(2262, 4, 12)], dtype='datetime64[D]'))

In [6]: arr.to_pandas(date_as_object=False)
Out[6]: array(['2262-04-12'], dtype='datetime64[D]')

In [7]: pa.column('name', arr).to_pandas(date_as_object=False)
Out[7]:
0 1677-09-21 00:25:26.290448384
Name: name, dtype: datetime64[ns]

Issue Links

• is related to: ARROW-3910 [Python] Set date_as_object to True in *.to_pandas as default after deduplicating logic implemented