Skip to content

bigrquery 1.3.0

Compare
Choose a tag to compare
@hadley hadley released this 08 May 12:17
  • Old functions (not starting with bq_) are deprecated (@byapparov, #335)

  • When bq_perform_*() fails, you now see all errors, not just the first (#355).

  • bq_perform_query() can now execute parameterised query with parameters
    of ARRAY type (@byapparov, #303). Vectors of length > 1 will be
    automatically converted to ARRAY type, or use bq_param_array() to
    be explicit.

  • bq_perform_upload() works once again (#361). It seems like the generated
    JSON was always incorrect, but Google's type checking only recently become
    strict enough to detect the problem.

  • dbExecute() is better supported. It no longer fails with a spurious
    error for DDL queries, and it returns the number of affected rows for
    DML queries (#375).

  • dbSendQuery() (and hence dbGetQuery()) and collect() passes on ...
    to bq_perform_query(). collect() gains page_size and max_connection
    arguments that are passed on to bq_table_download() (#374).

  • copy_to() now works with BigQuery (although it doesn't support temporary
    tables so application is somewhat limited) (#337).

  • str_detect() now correctly translated to REGEXP_CONTAINS
    (@jimmyg3g, #369).

  • Error messages inlude hints for common problems (@deflaux, #353).