[ARROW-11390] [Python] pyarrow 3.0 issues with turbodbc

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: Python
• Labels: python turbodbc
• Environment: pyarrow 3.0.0 ; fsspec 0.8.4 ; adlfs v0.5.9 ; pandas 1.2.1 ; numpy 1.19.5 ; turbodbc 4.1.1
• External issue URL: https://github.com/blue-yonder/turbodbc/issues/289
• Assignee: Unassigned
• Reporter: Lance Dacey
• Created: 26/Jan/21 15:49
• Updated: 11/Jan/23 08:19
• Resolved: 27/Jan/21 23:43

Description

This is more of a turbodbc issue I think, but perhaps someone here would have some idea of what changed to cause potential issues. 

cursor = connection.cursor()
cursor.execute("select top 10 * from dbo.tickets")
table = cursor.fetchallarrow()

I am able to run table.num_rows and it will print out 10.

If I run table.to_pandas() or table.schema or try to write the table to a dataset, my kernel dies with no explanation. I reverted back to pyarrow 2.0 and the same code works again.

https://github.com/blue-yonder/turbodbc/issues/289