[jira] [Created] (ARROW-13625) [C++][CSV] Timestamp parsing should accept any valid ISO 8601 without requiring custom parse strings

["Neal Richardson (Jira)" <ji...@apache.org>]

Neal Richardson created ARROW-13625:
---------------------------------------

             Summary: [C++][CSV] Timestamp parsing should accept any valid ISO 8601 without requiring custom parse strings
                 Key: ARROW-13625
                 URL: https://issues.apache.org/jira/browse/ARROW-13625
             Project: Apache Arrow
          Issue Type: Improvement
          Components: C++
            Reporter: Neal Richardson
             Fix For: 6.0.0


I was trying to read in some git logs and got this parse error for a column I had declared as timestamp type:

Error: Invalid: In CSV column #0: CSV conversion error to timestamp[s]: invalid value '2021-08-11T17:39:50-04:00'

This is valid ISO 8601 and is what git log produces with the {{I}} "strict ISO 8601 format" option (https://git-scm.com/docs/pretty-formats). 

I see mentioned on ARROW-10343 that timezone indicators are not supported--is that still true? And I recognize that it's not trivial because a timestamp array has to have the same timezone for all values, so if some rows in this CSV had different timezones listed, we would have to handle that (converting everything to UTC is probably the most useful thing but technically loses information).



--
This message was sent by Atlassian Jira
(v8.3.4#803005)