BUG: bq_table_download(api="arrow") fails with RANGE types

[caleb-palmer]

Related to r-dbi/bigrquery#646

The bigrquery json api is able to download ranges as a character type.

bq_project_query(billing, "SELECT RANGE(DATE '2024-01-01', DATE '2025-01-01') AS Year_Range") |> 
  bq_table_download(api = "json")

However, the newly-implemented arrow api fails

bq_project_query(billing, "SELECT RANGE(DATE '2024-01-01', DATE '2025-01-01') AS Year_Range") |> 
  bq_table_download(api = "arrow")

[meztez]

Thanks @caleb-palmer for reporting the issue.

I've identified a possible change to support RANGE fields. I'm adding tests to support all the RANGE data type described here : https://cloud.google.com/bigquery/docs/reference/standard-sql/range-functions#range

if (rlang::is_named(x) && length(x) == length(y[["fields"]])) {

RANGE field type has appeared in August 2024, taken from the release notes.

Have an excellent day.

[caleb-palmer]

@meztez great to hear! Happy to test it on my end

[meztez]

@caleb-palmer #83

remotes::install_github("meztez/bigrquerystorage@bq-range")

Let me know if the output format make sense for that data type and I will rewrite the test to match.

[caleb-palmer]

@meztez I'm going to be unavailable for a couple weeks, will be able to review in early October. Appreciate your work!