Connecting | Authentication | Basic — LDAP or a password file | JWT — service accounts and pipelines | OAuth2 client credentials — corporate SSO | Internal certificate authorities | Querying | Statements | Writing data | Transactions | Timeouts | Big integers and precision | dplyr | Introspection | Session properties and other headers | Disconnecting
Package: RTrino 0.1.0
Luis A Casas Ballestas
RTrino: 'DBI' Backend for 'Trino'
A 'DBI' compliant backend for 'Trino' <https://trino.io>, the distributed SQL query engine (successor of 'PrestoSQL'). Connects to a 'Trino' cluster over its HTTP REST API, executes queries with automatic pagination, maps 'Trino' types to R types, and integrates with 'dplyr' through 'dbplyr' SQL dialects. Supports basic, JSON Web Token (JWT) bearer and OAuth2 client credentials authentication, as well as custom certificate authorities.
Authors:
RTrino_0.1.0.tar.gz
RTrino_0.1.0.zip(r-4.7-any)RTrino_0.1.0.zip(r-4.6-any)
RTrino_0.1.0.tar.gz(r-4.7-any)RTrino_0.1.0.tar.gz(r-4.6-any)
RTrino_0.1.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
RTrino/json (API)
| # Install 'RTrino' in R: |
| install.packages('RTrino', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/angelcasasbl/rtrino/issues
Pkgdown/docs site:https://angelcasasbl.github.io
Last updated from:3e3deb8354. Checks:6 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel | OK | 137 | ||
| source / vignettes | OK | 184 | ||
| linux-release | OK | 127 | ||
| windows-devel | OK | 84 | ||
| windows-release | OK | 92 | ||
| wasm-release | OK | 103 |
Exports:dbAppendTabledbBegindbBinddbClearResultdbColumnInfodbCommitdbConnectdbCreateTabledbDataTypedbDisconnectdbExecutedbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsValiddbListFieldsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbRemoveTabledbRenameTabledbRollbackdbSendQuerydbSendStatementdbUnloadDriverdbWriteTableshowsimulate_trinoTrinotrino_auth_basictrino_auth_jwttrino_auth_oauth2trino_ssltrino_type_to_r
Dependencies:askpassbitbit64clicurlDBIgluehttr2jsonlitelifecyclemagrittropensslpillarpkgconfigR6rlangsystibbleutf8vctrswithr
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Insert rows into an existing table | dbAppendTable,TrinoConnection-method |
| Start, commit and roll back a transaction | dbBegin,TrinoConnection-method dbCommit,TrinoConnection-method dbRollback,TrinoConnection-method |
| Parameters are not supported | dbBind,TrinoResult-method |
| Release a Trino result | dbClearResult,TrinoResult-method |
| Connect to a Trino cluster | dbConnect,TrinoDriver-method |
| Create a table | dbCreateTable,TrinoConnection-method |
| Map an R type to a Trino type | dbDataType,TrinoConnection-method |
| Disconnect from Trino | dbDisconnect,TrinoConnection-method |
| Execute a statement that returns no rows | dbExecute,TrinoConnection,character-method |
| Does a table exist? | dbExistsTable,TrinoConnection,ANY-method dbExistsTable,TrinoConnection,character-method dbExistsTable,TrinoConnection,Id-method |
| Fetch rows from a Trino result | dbFetch,TrinoResult-method |
| Metadata about a Trino connection | dbGetInfo,TrinoConnection-method |
| Run a query and return all of its rows | dbGetQuery,TrinoConnection,character-method |
| Have all rows of a result been consumed? | dbHasCompleted,TrinoResult-method |
| Is this connection or result still usable? | dbIsValid,TrinoConnection-method dbIsValid,TrinoResult-method |
| List a table's columns | dbListFields,TrinoConnection,ANY-method dbListFields,TrinoConnection,character-method dbListFields,TrinoConnection,Id-method |
| List the tables in the connection's schema | dbListTables,TrinoConnection-method |
| Quote identifiers and strings for Trino | dbQuoteIdentifier,TrinoConnection,character-method dbQuoteIdentifier,TrinoConnection,SQL-method dbQuoteString,TrinoConnection,character-method dbQuoteString,TrinoConnection,SQL-method |
| Quote R values as Trino literals | dbQuoteLiteral,TrinoConnection-method |
| Drop a table | dbRemoveTable,TrinoConnection,ANY-method dbRemoveTable,TrinoConnection,character-method dbRemoveTable,TrinoConnection,Id-method |
| Rename a table | dbRenameTable dbRenameTable,TrinoConnection-method |
| Submit a statement to Trino | dbSendQuery,TrinoConnection,character-method |
| Submit a statement that changes something | dbSendStatement,TrinoConnection,character-method |
| Write a table | dbWriteTable,TrinoConnection,ANY-method dbWriteTable,TrinoConnection,Id-method |
| Instantiate the Trino driver | Trino |
| Authentication methods for Trino | trino_auth trino_auth_basic trino_auth_jwt trino_auth_oauth2 |
| TLS options for a Trino connection | trino_ssl |
| Map a Trino type to the name of an R type | trino_type_to_r |