[ARROW-18236] [R] Improve error message when providing a mix of readr and Arrow options

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: R
• External issue URL: https://github.com/apache/arrow/issues/33420
• Assignee: Unassigned
• Reporter: Nicola Crane
• Created: 03/Nov/22 11:47
• Updated: 11/Jan/23 11:58

Description

I was trying to solve a user issue today and tried to run the following code:

df = tibble(x = c("a","b",  ""  , "d"))
write_tsv(df, "data.tsv")
open_dataset("data.tsv", format="tsv", skip_rows=1, schema=schema(x=string()), skip_empty_rows = TRUE) %>%
  collect()

which gives me the error

Error: Use either Arrow parse options or readr parse options, not both

which is somewhat obnoxious as I have literally no context provided to know which options are being referred to and what the possible options are.

Also, like, why can't we have a mix of both? This is a totally valid use-case. I think both a code update and a more informative error message are needed here.