Lucas Mation created ARROW-18241:
------------------------------------
Summary: as.integer can't handdle empty character cels (ex c(''))
Key: ARROW-18241
URL: https://issues.apache.org/jira/browse/ARROW-18241
Project: Apache Arrow
Issue Type: Bug
Reporter: Lucas Mation
I am importing a dataset with arrow, and then converting variable types. But I
got an error message because the `arrow` implementation of `as.integer` can't
handle empty strings (which is legal in base R). Is this a bug?
```
#In R
'' %>% as.integer()
[1] NA
#in arrow
q <- data.table(x=c('','1','2'))
q %>% write_dataset(paste0(p2,'/q'))
q2 <- paste0(p2,'/q') %>% open_dataset %>% mutate(x=as.integer(x)) %>% collect
Error in `collect()`:
! Invalid: Failed to parse string: '' as a scalar of type int32
Run `rlang::last_error()` to see where the error occurred.
```
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
