[BEAM-4171] Python BigQuery source fails for timestamps < year 1900

• Type: Bug
• Status: Open
• Priority: P3
• Resolution: Unresolved
• Component/s: sdk-py-core
• Assignee: Unassigned
• Reporter: Chamikara Madhusanka Jayalath
• Created: 25/Apr/18 04:17
• Updated: 03/Jun/22 21:04

Description

This seems to be due to Python SDK using 'date.strftime' which has a known limitation.

https://bugs.python.org/issue1777412

This has been fixed for Python 3.3+ 

 

We might want to consider one of the workaround mentioned in the below post to fix BQ for Python 2.7.

https://stackoverflow.com/questions/10263956/use-datetime-strftime-on-years-before-1900-require-year-1900

 

This affects both Direct and Dataflow runners.