Package: RPresto 1.4.8.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.8.9000.tar.gz
RPresto_1.4.8.9000.zip(r-4.7)RPresto_1.4.8.9000.zip(r-4.6)RPresto_1.4.8.9000.zip(r-4.5)
RPresto_1.4.8.9000.tgz(r-4.6-any)RPresto_1.4.8.9000.tgz(r-4.5-any)
RPresto_1.4.8.9000.tar.gz(r-4.7-any)RPresto_1.4.8.9000.tar.gz(r-4.6-any)
RPresto_1.4.8.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
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:

Conda:

9.51 score 135 stars 4 packages 37 scripts 895 downloads 43 exports 39 dependencies

Last updated from:2b37d0725e. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK166
source / vignettesOK193
linux-release-x86_64OK203
macos-release-arm64OK222
macos-oldrel-arm64OK273
windows-develOK239
windows-releaseOK183
windows-oldrelOK203
wasm-releaseOK115

Exports:add_chunkdbAppendTabledbAppendTableAsdbClearResultdbColumnInfodbColumnTypedbConnectdbCreateTabledbCreateTableAsdbDataTypedbDisconnectdbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsValiddbListFieldsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbReadTabledbRemoveTabledbRenameTabledbSendQuerydbUnloadDriverdbWriteTabledummyPrestoConnectionfetchkerberos_configsPrestopresto_defaultpresto_has_defaultpresto_typepresto_unnestshowsqlAppendTableAssqlCreateTablesqlCreateTableAssrc_presto

Dependencies:askpassbitbit64blobclicpp11crayoncurlDBIdbplyrdplyrgenericsgluehmshttrjsonlitelifecyclelubridatemagrittrmimeopensslpillarpkgconfigprettyunitsprogresspurrrR6rlangstringdiststringistringrsystibbletidyrtidyselecttimechangeutf8vctrswithr

Common Table Expressions (CTEs)

Rendered fromcommon-table-expressions.Rmdusingknitr::rmarkdownon Jun 04 2026.

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

Primitive Presto data types to R types

Rendered fromprimitive-types.Rmdusingknitr::rmarkdownon Jun 04 2026.

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

Translating complex Presto data types

Rendered fromcomplex-types.Rmdusingknitr::rmarkdownon Jun 04 2026.

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

Readme and manuals

Help Manual

Help pageTopics
Add a chunk field to a data frameadd_chunk
dbplyr database methodsdb_compute.PrestoConnection db_copy_to.PrestoConnection db_has_table.PrestoConnection db_list_tables.PrestoConnection db_save_query.PrestoConnection db_sql_render.PrestoConnection db_write_table.PrestoConnection
Append to a table in database using a statementdbAppendTableAs
Create a table in database using a statementdbCreateTableAs
Return the corresponding presto data type for the given R 'object'dbDataType,PrestoDriver-method
Metadata about database objectsdbGetInfo,PrestoConnection-method dbGetInfo,PrestoDriver-method dbGetInfo,PrestoResult-method
Inform the dbplyr version used in this packagedbplyr_edition.PrestoConnection
Rename a tabledbRenameTable
A convenient wrapper around Kerberos configkerberos_configs
Connect to a Presto databasedbConnect,PrestoDriver-method dbDisconnect,PrestoConnection-method Presto
Check if default database is available.presto_default presto_has_default
Get column type information for a Presto table or querypresto_type presto_type.tbl_presto
Unnest array columns in Presto tablespresto_unnest presto_unnest.tbl_presto
dbplyr SQL methodssql_query_save.PrestoConnection
Compose query to append to a table using a statementsqlAppendTableAs
Compose query to create a simple table using a statementsqlCreateTableAs
dplyr integration to connect to a Presto database.src_presto