[ https://issues.apache.org/jira/browse/ARROW-18244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17628919#comment-17628919 ]
Lucas Mation commented on ARROW-18244: -------------------------------------- [~npr] OK. Then, I guess we should close this issue, since ifelse if fixed in the dev version. But on str_replace (and maybe this should be a ticket of it's own) it does not replicate R's behaviuour in this case ``` q <- data.table(x=c('','1','2')) q %>% write_dataset('q') #in R q %>% mutate(x2=x %>% str_replace('^\\s*$',NA_character_)) x x2 1: <NA> 2: 1 1 3: 2 2 #in arrow q2 <- 'q' %>% open_dataset %>% mutate(x2=x %>% str_replace('^\\s*$',NA_character_)) %>% collect q2 x x2 1: 2: 1 1 3: 2 2 ``` > [R] `mutate(x2=ifelse(x=='',NA,x))` Error: Function 'if_else' has no kernel > matching input types > ------------------------------------------------------------------------------------------------- > > Key: ARROW-18244 > URL: https://issues.apache.org/jira/browse/ARROW-18244 > Project: Apache Arrow > Issue Type: Bug > Reporter: Lucas Mation > Assignee: Neal Richardson > Priority: Major > Fix For: 11.0.0 > > > > ``` > 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|https://arrow.apache.org/docs/r/reference/acero.html] 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. > ``` > -- This message was sent by Atlassian Jira (v8.20.10#820010)