v1.4.8

What's Changed

• Hot fix for 1.4.7 release to fix Readme.md broken links by @jarodmeng in #287
• Update Readme.md after Readme.Rmd fix by @jarodmeng in #288
• Improve unit testing infrastructure by @jarodmeng in #289
• Fix CRAN cross reference note by @jarodmeng in #290
• Replace deprecated with_mock() with with_mocked_bindings() by @jarodmeng in #291
• Add a small feature to compute and report text similarity when a CTE … by @jarodmeng in #296
• docs: Add comprehensive testing instructions for contributors by @jarodmeng in #300
• Add presto_unnest() function (#267) by @jarodmeng in #301
• BIGINT: column-aware overflow warnings with nested paths by @jarodmeng in #302
• Remove experimental badges from CTE features and lifecycle badge from… by @jarodmeng in #303
• Fix linter issues: line length, indentation, formatting by @jarodmeng in #304
• Refactor presto_unnest() implementation by @jarodmeng in #305
• Implement db_save_query() with smart overwriting by @jarodmeng in #306
• Fix group_by() after presto_unnest() by @jarodmeng in #309
• Fix duplicate columns when values_to is NULL (#307) by @jarodmeng in #310
• Add sqlAppendTableAs() and dbAppendTableAs() functions by @jarodmeng in #311
• Add presto_type() and dbColumnType() functions (#295) by @jarodmeng in #312
• Fix presto_unnest() CTE handling and mark as experimental by @jarodmeng in #313
• Prepare for 1.4.8 release by @jarodmeng in #315

Full Changelog: v1.4.7...v1.4.8

v1.4.7

What's Changed

• Fix nested CTE leading to nested WITH problem by @jarodmeng in #262
• fix typo for tbl.PrestoConnection() by @copernican in #268
• Add paste and paste0 translation by @jarodmeng in #269
• Make RPresto compatible with new Presto JSON data format and dbplyr 2.5.0 by @jarodmeng in #280
• dbWriteTable(overwrite = TRUE) creates temp table in the destination schema by @jarodmeng in #282
• Reorganize unit test help functions and address Presto-Trino discrepancies by @jarodmeng in #283
• Expand copy_to arg list to avoid passing duplicated arguments by @jarodmeng in #284

Full Changelog: v1.4.6...v1.4.7

v1.4.6

What's Changed

• Fix print.presto_field() method's signature naming and sequence to match the generic (#253)
• Make RPresto compatible with dbplyr 2.4.0 (#257)
• RPresto now supports tidyr::fill() (#258)

Full Changelog: v1.4.5...v1.4.6

v1.4.5

• Fixed a bug in compute() whereby non-character table names are not used properly.
• Refactor compute.tbl_presto() to break into a dbExecute() execution and a tbl() remote table registration part so that developers have more flexibility customizing the function in their downstream usage.

What's Changed

• Use simple name in compute() by @jarodmeng in #248
• Refactor compute.tbl_presto() into two parts, one executes the query and the other creates the remote table by @jarodmeng in #250

Full Changelog: v1.4.4...v1.4.5

v1.4.4

What's Changed

• Allow compute() to add permanent table when CTE is used by @jarodmeng in #244
• Update tbl() and db_query_rows() arg names to suppress S3 generic consistency warnings in R CMD CHECK by @jarodmeng in #245

Full Changelog: v1.4.3...v1.4.4

v1.4.3

What's Changed

• Fixed dbplyr 2.3.0 compatibility issues which cause test warnings and failures by @jarodmeng in #238

Full Changelog: v1.4.2...v1.4.3

v1.4.2

• Add a convenient wrapper kerberos_configs() to generate Kerberos header configs that can be passed to the request.config argument of dbConnect(). (#202 and #221). Thanks to @suzzettedetorres for providing this solution.
• All functions that take table name as argument now work with dbplyr::in_schema() and DBI::Id() besides the usual character table name. (#228)
• Create a new dbRenameTable() function to rename table name.

Full Changelog: v1.4.1...v1.4.2

v1.4.1

What's Changed

• dbListFields now works with identifier name which in turn supports the use of in_schema() in tbl() (#200)
• Fix an error whereby join query's CTEs are not properly retrieved (#203)
• Fix a bug that causes NULL values in a ROW to return data-schema mismatch error (#206)
• Add dbQuoteLiteral() and dbAppendTable() implementations.
• Rewrite dbWriteTable() implementation to use dbCreateTable() and dbAppendTable(). It also supports all default arguments now (#199)
• dbWriteTable() gains a use.one.query option to use a single CREATE TABLE AS query.

Full Changelog: v1.4.0...v1.4.1

v1.4.0

What's Changed

RPresto v1.4.0 is a major release encompassing a few big changes:

• User-facing APIs are organized on 3 levels: DBI's db*() methods that act on DBIConnection and DBIResult classes; dplyr's db_() methods that are usually a simple wrapper around the lower-level db*() methods; and lastly dbplyr's c*() verbs (i.e. collect(), collapse() and compute()) and src functions. You can find their implementation details in the backend-implementations.md file. We now have implementations for most of the commonly-used API methods across all 3 levels.
• Besides the front-end, we also had a major refactoring of the back-end which handles how RPresto converts data returned by Presto's REST API to R data.
  • The output is changed from data.frame to tibble to offer better printing and be more consistent with other DBI-compatible datawarehouse packages
  • Add more user-friendly R types translation for primitive Presto data types (e.g., DATE types are now translated to Date classes in R; TIMESTAMP types are translated to POSIXct classes; TIME types are translated to difftime classes; INTERVAL types are translated to Duration classes)
  • Enable more choices of BIGINT type handling (i.e., integer64, integer, numeric, or character). (#61)
  • Add complete support for complex Presto types (i.e., ARRAY, MAP, and ROW). They are now translated to typed vectors, lists, or tibbles depending on the types and structure of the data. (#118) See vignette("primitive-types") and vignette("complex-types").
  • It supports all primitive and complex data types for Trino too. (#176)
• We added an experimental feature on "common table expressions" (CTEs). See vignette("common-table-expressions").
• PrestoConnection gains a request.config slot whereby users can set extra Curl configs (as returned by httr::config() to GET/POST requests. (#173)
• dbConnect() now uses empty string "" (rather than UTC) as the default session.timezone which translates to the Presto server timezone.
• dbConnect() and src_presto() gain an output.timezone argument which can be used to control how TIME WITH TZ and TIMESTAMP values are represented in the output tibble.
• dbGetQuery() and dbSendQuery() gain a quiet argument which defaults to getOption("rpresto.quiet") which is NA if not set. This argument controls a progress bar for long-running queries. (#191)
• Styling the whole package using styler::style_pkg(). A notable change is to user double quotes everywhere instead of a combination of single and double quotes. (#174)

New Contributors

• @yash-tekena made their first contribution in #148

Full Changelog: v1.3.7...v1.4.0

v1.3.7

• Fix testing errors caused by Presto changes since last update (#131)
• Change [[ translation from [] subscript operator to ELEMENT_AT() (#132)
• Enable simple ROW type support (#137)
• Fix a bug whereby is.infinite() is incorrectly translated to IS_FINITE()
  instead of IS_INFINITE() in SQL (#139)
• Disabled translation of median() and quantile() and suggested approx_quantile() instead. (#120)