Skip to content

bigrquery 1.1.0
Compare
Choose a tag to compare
@hadley hadley released this 06 Feb 23:35
v1.1.0
d6648d0

Improved type support

  • bq_table_download() and the DBI::dbConnect method now has a bigint
    argument which governs how BigQuery integer columns are imported into R. As
    before, the default is bigint = "integer". You can set
    bigint = "integer64" to import BigQuery integer columns as
    bit64::integer64 columns in R which allows for values outside the range of
    integer (-2147483647 to 2147483647) (@rasmusab, #94).

  • bq_table_download() now treats NUMERIC columns the same was as FLOAT
    columns (@paulsendavidjay, #282).

  • bq_table_upload() works with POSIXct/POSIXct varibles (#251)

SQL translation

  • as.character() now translated to SAFE_CAST(x AS STRING) (#268).

  • median() now translates to APPROX_QUANTILES(x, 2)[SAFE_ORDINAL(2)] (@valentinumbach, #267).

Minor bug fixes and improvements

  • Jobs now print their ids while running (#252)

  • bq_job() tracks location so bigrquery now works painlessly with non-US/EU
    locations (#274).

  • bq_perform_upload() will only autodetect a schema if the table does
    not already exist.

  • bq_table_download() correctly computes page ranges if both max_results
    and start_index are supplied (#248)

  • Unparseable date times return NA (#285)

Assets 2
Loading