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✨
DESCRIPTION |NEWS
card.svg |card.png
RPresto/json (API)

# 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.52 score 134 stars 4 packages 37 scripts 1.0k downloads 43 exports 39 dependencies

Last updated from:2b37d0725e. Checks:7 ERROR, 2 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64ERROR186
source / vignettesOK183
linux-release-x86_64ERROR174
macos-release-arm64ERROR166
macos-oldrel-arm64ERROR155
windows-develERROR142
windows-releaseERROR138
windows-oldrelERROR139
wasm-releaseOK122

Exports:add_chunkdbAppendTabledbAppendTableAsdbClearResultdbColumnInfodbColumnTypedbConnectdbCreateTabledbCreateTableAsdbDataTypedbDisconnectdbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsValiddbListFieldsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbReadTabledbRemoveTabledbRenameTabledbSendQuerydbUnloadDriverdbWriteTabledummyPrestoConnectionfetchkerberos_configsPrestopresto_defaultpresto_has_defaultpresto_typepresto_unnestshowsqlAppendTableAssqlCreateTablesqlCreateTableAssrc_presto

Dependencies:askpassbitbit64blobclicpp11crayoncurlDBIdbplyrdplyrgenericsgluehmshttrjsonlitelifecyclelubridatemagrittrmimeopensslpillarpkgconfigprettyunitsprogresspurrrR6rlangstringdiststringistringrsystibbletidyrtidyselecttimechangeutf8vctrswithr

Translating complex Presto data types
Package setup | Overview | Walkthrough preparation | Local Presto server in memory | Presto connection in R | Atomic structural types that contain primitive types | ARRAYs | Create a table with ARRAYs of primitive types | Translate ARRAYs to R vectors | MAPs | Create a table with MAPS of primitive types | Translate MAPs to R vectors | Repeated ARRAYs and MAPs | ROW type | Single ROW translation | Repeated ROWs translation | Walkthrough wrap-up
Rendered fromcomplex-types.Rmdusingknitr::rmarkdown

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

Primitive Presto data types to R types
Package setup | Overview | Walkthrough preparation | Local Presto server in memory | Presto connection in R | Primitive data types table in Presto | Data types mapping to R | Boolean | Integers | Non-BIGINT integers | BIGINT integers | Floating numbers | Fixed-precision numbers | Strings | VARCHAR and CHAR types | VARBINARY | Date and Time | DATE | TIMESTAMP | INTERVALs | Walkthrough wrap-up
Rendered fromprimitive-types.Rmdusingknitr::rmarkdown

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

Common Table Expressions (CTEs)
Setup | Define CTEs while creating a PrestoConnection | Incorporating CTEs with dplyr backend
Rendered fromcommon-table-expressions.Rmdusingknitr::rmarkdown

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

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