[ARROW-12992] [R] bindings for substr(), substring(), str_sub()

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 5.0.0
• Component/s: R
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/28709
• Assignee: Nicola Crane
• Reporter: Neal Richardson
• Created: 07/Jun/21 15:43
• Updated: 11/Jan/23 08:30
• Resolved: 15/Jul/21 18:08

Description

Followup to ARROW-10557, which implemented the C++

current state:

library(arrow)
library(dplyr)
library(stringr)

# get animal products, year 20919
open_dataset(
  "../cepii-datasets-arrow/parquet/baci_hs92",
  partitioning = c("year", "reporter_iso")
) %>% 
  filter(
    year == 2019,
    str_sub(product_code, 1, 2) == "01"
  ) %>% 
  collect()

Error: Filter expression not supported for Arrow Datasets: str_sub(product_code, 1, 2) == "01"
Call collect() first to pull data into R.

Issue Links

• links to: GitHub Pull Request #10624