[ARROW-18244] [R] `mutate(x2=ifelse(x=='',NA,x))` Error: Function 'if_else' has no kernel matching input types

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 11.0.0
• External issue URL: https://github.com/apache/arrow/issues/33427
• Assignee: Neal Richardson
• Reporter: Lucas Mation
• Created: 03/Nov/22 21:44
• Updated: 11/Jan/23 11:59
• Resolved: 04/Nov/22 11:54

Description

 

```

q <- data.table(x=c('','30111976','01011976'))
q %>% write_dataset('q')
q2 <- 'q' %>% open_dataset %>% mutate(x2=ifelse(x=='',NA,x)) %>% collect
Error in `collect()`:
! NotImplemented: Function 'if_else' has no kernel matching input types (bool, bool, string)
Run `rlang::last_error()` to see where the error occurred.

```

In Functions available in Arrow dplyr queries it is stated that ifelse() is available, but the error above suggests otherwise.

Update, "str_replace" is another function that is supposedly available in 10.0.0 but is not (or does not seem to be):

```

q2 <- 'q' %>% open_dataset %>% mutate(x2=x %>% str_replace('',NA)) %>% collect
Error: Expression x %>% str_replace("", NA) not supported in Arrow
Call collect() first to pull data into R.

```

 

Issue Links

• is fixed by: ARROW-17462 [R] Cast scalars to type of field in Expression building