[
https://issues.apache.org/jira/browse/ARROW-15659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jonathan Keane resolved ARROW-15659.
------------------------------------
Fix Version/s: 8.0.0
Resolution: Fixed
Issue resolved by pull request 12402
[https://github.com/apache/arrow/pull/12402]
> [R] strptime should return NA (not error) with format mismatch
> ---------------------------------------------------------------
>
> Key: ARROW-15659
> URL: https://issues.apache.org/jira/browse/ARROW-15659
> Project: Apache Arrow
> Issue Type: Bug
> Components: R
> Reporter: Dragoș Moldovan-Grünfeld
> Assignee: Dragoș Moldovan-Grünfeld
> Priority: Major
> Labels: pull-request-available
> Fix For: 8.0.0
>
> Time Spent: 3h 50m
> Remaining Estimate: 0h
>
> {{base::strptime()}} returns {{NA}} when the value passed to the {{format}}
> argument does not match the string to be parsed. The arrow binding currently
> errors in the same scenario.
> {code:r}
> strptime("2022-02-11", format = "%Y-%m-%d")
> #> [1] "2022-02-11 GMT"
> strptime("2022-02-11", format = "%Y %m-%d")
> #> [1] NA
> {code}
> {code:r}
> suppressMessages(library(lubridate))
> suppressMessages(library(arrow))
> suppressMessages(library(dplyr))
> df <- tibble(x = "2022-02-11")
> df %>%
> mutate(z = strptime(x, format = "%Y-%m %d"))
> #> # A tibble: 1 × 2
> #> x z
> #> <chr> <dttm>
> #> 1 2022-02-11 NA
> df %>%
> record_batch() %>%
> mutate(z = strptime(x, format = "%Y-%m %d")) %>%
> collect()
> #> Error: Invalid: Failed to parse string: '2022-02-11' as a scalar of type
> timestamp[ms]
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
