R Observatory: Metrics for RPresto version 1.4.8

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

This package was removed from CRAN on 2025-12-02. Its history is shown below.

Details below reflect version 1.4.8, its last release before removal.

RPresto

1.4.8Package record

0packages dependsuggested by 2

11.3Kdownloads / year

25.6%test coverage

–flavors OK

Overview

About

Maintained by Jarod G.R. MengCRAN page ↗GitHub ↗

Changes in 1.4.8

Add presto_type() function for tbl_presto objects to get column type information including Presto types for complex and nested types. This function works with remote tables after dplyr operations and CTEs.
Add dbColumnType() function for PrestoConnection to get column type information for tables, including Presto types for complex and nested types. This complements the existing dbColumnInfo() method for PrestoResult objects. (#295)
Add dbAppendTableAs() and sqlAppendTableAs() functions to append data to existing tables using SQL queries. These functions support both SQL strings and tbl_presto objects as input. (#307)
Implement db_save_query() for PrestoConnection with smart overwriting. When overwriting an existing table, the function renames the original table, creates the new table, and drops the old table on success. If creation fails, the original table is restored. This prevents data loss if the write operation fails. (#271)

Show all changes in 1.4.8Hide the rest of the changes in 1.4.8

Add presto_unnest() function to unnest array columns in Presto tables using CROSS JOIN UNNEST syntax. This function is similar to tidyr::unnest() but works with Presto database tables. (#267)
Replaced deprecated with_mock() usage in unit testing with with_mocked_bindings(). (#292)
Add a feature to report text similarity when a CTE is overwritten. (#294)
BIGINT to integer coercion now emits column-aware overflow warnings, including full nested paths. This can be controlled via options(rpresto.bigint_overflow.warning = TRUE|FALSE). (#198)

From NEWS.md in the release

Install

R (source archive)pak (dev)

url <- "https://cran.r-project.org/src/contrib/Archive/RPresto/RPresto_1.4.8.tar.gz"
pkgFile <- "RPresto_1.4.8.tar.gz"
download.file(url, pkgFile)
install.packages(pkgFile, type = "source", repos = NULL)

This package is no longer on CRAN, so install.packages() cannot fetch it by name. This downloads the last archived source (1.4.8) and builds it locally. Install its dependencies first, and note that building from source needs the usual compiler toolchain.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("prestodb/RPresto")

Development version from prestodb/RPresto. Installs pak first if it is not already available.

Health

CRAN checks

CRAN check results are not tracked yet.

Status changes

ERROR11 OK, 2 ERROR2026-06-18
OK13 OK2026-06-09
ERROR12 OK, 1 ERROR2026-06-08
OK14 OK2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 1.4.8

READMEYes · 778 wordsVignettesYes · 3 · dynamicNEWSYes · 100% structured · mentions 1.4.8Citation fileNoWebsitenot declared in DESCRIPTION

Help pages: 38 (21 internal)includes a package overview page
Examples that run: 30%3 run in a plain check · 7 never run
Exported functions with examples: 50%
Documented parameters: 100%
Return-value docs: 36%
Help pages citing references: 0%

How these are measured

Downloads

11.3K

CRAN downloads in the past year

Rank #13,218 · ~31/day · ~938/mo

Releases R versions

Daily download trend is not available in this view yet.

030 days

85490 days

11.3K1 year

Compare downloads with other packages →

Also on399 r2u9 autocran3.3K conda_forge120 c2d4u

How downloads are counted

Repository

prestodb/rpresto ↗Historical

Last recorded for this package on 2026-08-23. The package was removed from CRAN, so this repository is no longer tracked.

How these are measured

PracticesHistoricalBeta

5 development-tooling and community-health practices detected across 4 families in the repository last recorded for this package

Checks last ran against github.com/prestodb/rpresto on 2026-08-23. The package was removed from CRAN, so this is no longer updated.

Continuous integration (2)

GitHub ActionsTravis CI (config file)

Docs source (1)

README.Rmd

CRAN release process (1)

cran-comments.md

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v3 (2026-09-26)

Dependencies

Declared dependencies

22 external dependencies (excludes base and recommended)

Depends (2)

R >= 3.1.0methods

Imports (19)

DBI httr openssl jsonlite stringistatsutilspurrr dplyr dbplyr tibble tidyselect bit64 rlang lifecycle lubridate progress vctrs stringdist

LinkingTo (0)

none

Suggests (5)

testthat hms knitr rmarkdown withr

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

–indirect (not tracked)

Suggested by 2

Suggests, most downloaded first

resourcer DIZutils

How these are counted

Code & Tests

People & History

People (5)

Jarod G.R. Meng

Author, Maintainer since 1.4.0 (2022) · added in 1.3.7

Onur Ismail Filiz

Author

Sergey Goder

Author

Thomas J. Leeper

Contributor · added in 1.3.6

John Myles White

Contributor

Previously maintained by Thomas J. Leeper (1.3.6 to 1.3.7) and Onur Ismail Filiz (1.2.0 to 1.3.5).

Releases (19)

Pick two releases to compare their code metrics.

archivedRemoved from CRAN
2026-08-24
issues were not corrected in time
R
R 4.6.0 released · 2026-04-24
1.4.8
record
2025-12-02 · diff ↗ ·
added 5 exports
dbAppendTableAs, dbColumnType, presto_type, presto_unnest, sqlAppendTableAs
R
R 4.5.0 released · 2025-04-11
1.4.7
record
2025-01-08 · diff ↗
R
R 4.4.0 released · 2024-04-24
1.4.6
record
2023-11-01 · diff ↗
1.4.5
record
2023-05-05 · diff ↗
R
R 4.3.0 released · 2023-04-21
1.4.4
record
2023-03-09 · diff ↗
1.4.3
record
2023-03-03 · diff ↗
1.4.2
record
2023-01-13 · diff ↗ ·
added 3 exports
dbRenameTable, dummyPrestoConnection, kerberos_configs
1.4.1
record
2022-11-16 · diff ↗ ·
added 1 export
add_chunk
1.4.0
record
2022-09-27 · diff ↗ ·
removed 10 exports
sql_escape_date.PrestoConnection, sql_escape_datetime.PrestoConnection, copy_to.src_presto, db_data_type.PrestoConnection, db_desc.PrestoConnection, db_explain.PrestoConnection, db_query_fields.PrestoConnection, db_query_rows.PrestoConnection, sql_translate_env.PrestoConnection, tbl.src_presto

added 4 exports
dbCreateTableAs, presto_default, presto_has_default, sqlCreateTableAs
R
R 4.2.0 released · 2022-04-22
1.3.7
record
2021-09-04 · diff ↗

Show 16 earlier eventsHide 16 earlier events

1.3.6
record
2021-05-31 · diff ↗
R
R 4.1.0 released · 2021-05-18
1.3.5
record
2020-11-13 · diff ↗ ·
added 2 exports
sql_escape_date.PrestoConnection, sql_escape_datetime.PrestoConnection
R
R 4.0.0 released · 2020-04-24
1.3.4
record
2019-10-18 · diff ↗
1.3.3
record
2019-05-04 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.3.2
record
2018-10-23 · diff ↗ ·
removed 2 exports
src_desc.src_presto, src_translate_env.src_presto
1.3.1
record
2018-09-10 · diff ↗
R
R 3.5.0 released · 2018-04-23
1.3.0
record
2017-07-13 · diff ↗ ·
added 1 export
db_desc.PrestoConnection
R
R 3.4.0 released · 2017-04-21
R
R 3.3.0 released · 2016-05-03
1.2.1
record
2016-04-06 · diff ↗ ·
added 2 exports
db_query_fields.PrestoConnection, sql_translate_env.PrestoConnection
1.2.0
record
2016-03-18
R
R 3.2.0 released · 2015-04-16

Package metadata

First published: 2016-03-18
Total releases: 19 / 10 yrs
License: BSD_3_clause + file LICENSE OSI
Minimum R: ≥ 3.1.0
Download size: 166 KB

Appears in task views

Databases with R

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("RPresto")

Format

Filiz, O. I., Goder, S., Meng, J. G. R., Leeper, T. J., & White, J. M. (n.d.). RPresto (Version 1.4.8) [Computer software]. Retrieved October 19, 2026, from https://CRAN.R-project.org/package=RPresto

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for RPresto version 1.4.8 [Data set]. HJJB, LLC. Data release v2026-10-18. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-18, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →