{"Package":"RPresto","Title":"DBI Connector to Presto","Version":"1.3.7","Authors@R":"c(\nperson('Onur Ismail', 'Filiz', , 'onur@fb.com', role='aut'),\nperson('Sergey', 'Goder', , 'sgoder@fb.com', role='aut'),\nperson(\n'Thomas J.', 'Leeper', ,\n'thomasleeper@fb.com',\nrole=c('ctb', 'cre')\n),\nperson('John Myles', 'White', , 'johnmyleswhite@fb.com', role='ctb'),\nperson('Jarod G.R.', 'Meng', , 'jarodm@fb.com', role='ctb')\n)","Copyright":"Facebook, Inc. 2015-present.","Description":"Implements a 'DBI' compliant interface to Presto. Presto is\nan open source distributed SQL query engine for running interactive\nanalytic queries against data sources of all sizes ranging from\ngigabytes to petabytes: .","Depends":"R (>= 3.1.0), methods","Imports":"DBI (>= 0.3.0), httr (>= 0.6), openssl, jsonlite, stringi,\nstats, Rcpp (>= 0.12.7), utils, purrr","Suggests":"testthat, dplyr (>= 0.7.0), dbplyr","License":"BSD_3_clause + file LICENSE","URL":"https://github.com/prestodb/RPresto","BugReports":"https://github.com/prestodb/RPresto/issues","Encoding":"UTF-8","Collate":"'PrestoDriver.R' 'Presto.R' 'utility_functions.R'\n'PrestoSession.R' 'PrestoConnection.R' 'PrestoCursor.R'\n'PrestoResult.R' 'RcppExports.R' 'src.presto.R'\n'copy.to.src.presto.R' 'db.data.type.PrestoConnection.R'\n'dbplyr_compatible.R' 'db.explain.PrestoConnection.R'\n'db.query.rows.PrestoConnection.R' 'request_headers.R'\n'dbHasCompleted.R' 'dbClearResult.R' 'dbConnect.R'\n'dbDataType.R' 'dbDisconnect.R' 'dbSendQuery.R'\n'json.tabular.to.data.frame.R' 'extract.data.R'\n'parse.response.R' 'dbFetch.R' 'dbGetQuery.R' 'dbListTables.R'\n'dbExistsTable.R' 'dbGetInfo.R' 'dbGetRowCount.R'\n'dbGetStatement.R' 'dbIsValid.R' 'dbListFields.R'\n'dbUnloadDriver.R' 'description_from_info.R'\n'db_desc.PrestoConnection.R' 'db_query_fields.R' 'fetch.R'\n'help.R' 'sql_escape_date.R' 'sql_escape_datetime.R'\n'sql_translate_env.R' 'tbl.src.presto.R'","RoxygenNote":"7.1.1","LinkingTo":"Rcpp","NeedsCompilation":"yes","Packaged":"2021-09-04 12:16:05 UTC; thomasleeper","Author":"Onur Ismail Filiz [aut],\nSergey Goder [aut],\nThomas J. Leeper [ctb, cre],\nJohn Myles White [ctb],\nJarod G.R. Meng [ctb]","Maintainer":"Thomas J. Leeper ","Repository":"CRAN","Date/Publication":"2021-09-04 12:40:02 UTC","repoType":"cran","tarballUrl":"ftp://cran.r-project.org/pub/R/src/contrib/RPresto_1.3.7.tar.gz","jsonAuthors":[{"name":"Onur Ismail Filiz","email":"onur@fb.com","maintainer":false},{"name":"Sergey Goder","email":"sgoder@fb.com","maintainer":false},{"name":"Thomas J. Leeper","email":"thomasleeper@fb.com","maintainer":true},{"name":"John Myles White","email":"johnmyleswhite@fb.com","maintainer":false},{"name":"Jarod G.R. Meng","email":"jarodm@fb.com","maintainer":false}],"readme":"# RPresto\n\nRPresto is a [DBI](https://github.com/r-dbi/DBI)-based adapter for\nthe open source distributed SQL query engine [Presto](https://prestodb.io/)\nfor running interactive analytic queries.\n\n## Installation\n\nRPresto is both on [CRAN](https://cran.r-project.org/package=RPresto)\nand [github](https://github.com/prestodb/RPresto).\nFor the CRAN version, you can use\n\n```R\ninstall.packages('RPresto')\n```\n\nYou can install the github development version via\n\n```R\ndevtools::install_github('prestodb/RPresto')\n```\n\n## Examples\n\nThe standard DBI approach works with RPresto:\n\n```R\nlibrary('DBI')\n\ncon <- dbConnect(\n RPresto::Presto(),\n host='http://localhost',\n port=7777,\n user=Sys.getenv('USER'),\n schema='',\n catalog='',\n source=''\n)\n\nres <- dbSendQuery(con, 'SELECT 1')\n# dbFetch without arguments only returns the current chunk, so we need to\n# loop until the query completes.\nwhile (!dbHasCompleted(res)) {\n chunk <- dbFetch(res)\n print(chunk)\n}\n\nres <- dbSendQuery(con, 'SELECT CAST(NULL AS VARCHAR)')\n# Due to the unpredictability of chunk sizes with presto, we do not support\n# custom number of rows\n# testthat::expect_error(dbFetch(res, 5))\n\n# To get all rows using dbFetch, pass in a -1 argument\nprint(dbFetch(res, -1))\n\n# An alternative is to use dbGetQuery directly\n\n# `source` for iris.sql()\nsource(system.file('tests', 'testthat', 'utilities.R', package='RPresto'))\n\niris <- dbGetQuery(con, paste(\"SELECT * FROM\", iris.sql()))\n\ndbDisconnect(con)\n```\n\nWe also include [dplyr](https://github.com/tidyverse/dplyr) integration.\n\n```R\nlibrary(dplyr)\n\ndb <- src_presto(\n host='http://localhost',\n port=7777,\n user=Sys.getenv('USER'),\n schema='',\n catalog='',\n source=''\n)\n\n# Assuming you have a table like iris in the database\niris <- tbl(db, 'iris')\n\niris %>%\n group_by(species) %>%\n summarise(mean_sepal_length = mean(as(sepal_length, 0.0))) %>%\n arrange(species) %>%\n collect()\n```\n\n## How RPresto works\n\nPresto exposes its interface via a REST based API¹. We utilize the\n[httr](https://github.com/r-lib/httr) package to make the API calls and\nuse [jsonlite](https://github.com/jeroen/jsonlite) to reshape the\ndata into a `data.frame`. Note that as of now, only read operations are\nsupported.\n\nRPresto has been tested on Presto 0.100.\n\n## License\nRPresto is BSD-licensed.\n\n[1] See for a\ndescription of the API.","jobInfo":{"package":"RPresto","version":"1.3.7","parsingStatus":"success","parserVersion":2,"parsedAt":"2022-09-27T10:30:22+0000"}}

Description

Arguments

Examples