Package: RPresto 1.4.6.9000

Jarod G.R. Meng

RPresto: DBI Connector to Presto

Implements a 'DBI' compliant interface to Presto. Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes: <https://prestodb.io/>.

Authors:Onur Ismail Filiz [aut], Sergey Goder [aut], Jarod G.R. Meng [aut, cre], Thomas J. Leeper [ctb], John Myles White [ctb]

RPresto_1.4.6.9000.tar.gz
RPresto_1.4.6.9000.zip(r-4.5)RPresto_1.4.6.9000.zip(r-4.4)RPresto_1.4.6.9000.zip(r-4.3)
RPresto_1.4.6.9000.tgz(r-4.4-any)RPresto_1.4.6.9000.tgz(r-4.3-any)
RPresto_1.4.6.9000.tar.gz(r-4.5-noble)RPresto_1.4.6.9000.tar.gz(r-4.4-noble)
RPresto_1.4.6.9000.tgz(r-4.4-emscripten)RPresto_1.4.6.9000.tgz(r-4.3-emscripten)
RPresto.pdf |RPresto.html✨
RPresto/json (API)
NEWS

# Install 'RPresto' in R:

install.packages('RPresto', repos = c('https://prestodb.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/prestodb/rpresto/issues

On CRAN:

37 exports 131 stars 4.81 score 39 dependencies 1 dependents 24 scripts 1.7k downloads

Last updated 5 months agofrom:804c29aff1. Checks:OK: 1 NOTE: 6. Indexed: yes.

Target	Result	Date
Doc / Vignettes	OK	Sep 14 2024
R-4.5-win	NOTE	Sep 14 2024
R-4.5-linux	NOTE	Sep 14 2024
R-4.4-win	NOTE	Sep 14 2024
R-4.4-mac	NOTE	Sep 14 2024
R-4.3-win	NOTE	Sep 14 2024
R-4.3-mac	NOTE	Sep 14 2024

Exports:add_chunk dbAppendTable dbClearResult dbConnect dbCreateTable dbCreateTableAs dbDataType dbDisconnect dbExistsTable dbFetch dbGetInfo dbGetQuery dbGetRowCount dbGetRowsAffected dbGetStatement dbHasCompleted dbIsValid dbListFields dbListTables dbQuoteIdentifier dbQuoteLiteral dbReadTable dbRemoveTable dbRenameTable dbSendQuery dbUnloadDriver dbWriteTable dummyPrestoConnection fetch kerberos_configs Presto presto_default presto_has_default show sqlCreateTable sqlCreateTableAs src_presto

Dependencies:askpass bit bit64 blob cli cpp11 crayon curl DBI dbplyr dplyr fansi generics glue hms httr jsonlite lifecycle lubridate magrittr mime openssl pillar pkgconfig prettyunits progress purrr R6 rlang stringi stringr sys tibble tidyr tidyselect timechange utf8 vctrs withr

Common Table Expressions (CTEs)

Rendered fromcommon-table-expressions.Rmdusingknitr::rmarkdownon Sep 14 2024.

Last update: 2022-09-27
Started: 2022-09-16

Primitive Presto data types to R types

Rendered fromprimitive-types.Rmdusingknitr::rmarkdownon Sep 14 2024.

Last update: 2022-10-26
Started: 2022-09-06

Translating complex Presto data types

Rendered fromcomplex-types.Rmdusingknitr::rmarkdownon Sep 14 2024.

Last update: 2022-11-16
Started: 2022-09-06

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Add a chunk field to a data frame	add_chunk
dbplyr database methods	db_compute.PrestoConnection db_copy_to.PrestoConnection db_has_table.PrestoConnection db_list_tables.PrestoConnection db_sql_render.PrestoConnection db_write_table.PrestoConnection
Create a table in database using a statement	dbCreateTableAs
Return the corresponding presto data type for the given R 'object'	dbDataType,PrestoDriver-method
Metadata about database objects	dbGetInfo,PrestoConnection-method dbGetInfo,PrestoDriver-method dbGetInfo,PrestoResult-method
Inform the dbplyr version used in this package	dbplyr_edition.PrestoConnection
Rename a table	dbRenameTable
A convenient wrapper around Kerberos config	kerberos_configs
Connect to a Presto database	dbConnect,PrestoDriver-method dbDisconnect,PrestoConnection-method Presto
Check if default database is available.	presto_default presto_has_default
dbplyr SQL methods	sql_query_save.PrestoConnection
Compose query to create a simple table using a statement	sqlCreateTableAs
dplyr integration to connect to a Presto database.	src_presto