{
"_id": "6a2132c8cd65a98ecbd25cb5",
"Package": "RPresto",
"Title": "DBI Connector to Presto",
"Version": "1.4.8.9000",
"Authors@R": "c(\nperson('Onur Ismail', 'Filiz', , 'onur@fb.com', role='aut'),\nperson('Sergey', 'Goder', , 'sgoder@fb.com', role='aut'),\nperson('Jarod G.R.', 'Meng', , 'jarodm@fb.com', role=c('aut', 'cre')),\nperson('Thomas J.', 'Leeper', , 'thomasleeper@fb.com', role='ctb'),\nperson('John Myles', 'White', , 'johnmyleswhite@fb.com', role='ctb')\n)",
"Copyright": "Meta Platforms, Inc. 2015-present.",
"Description": "Implements a 'DBI' compliant interface to Presto. Presto\nis an open source distributed SQL query engine for running\ninteractive analytic queries against data sources of all sizes\nranging from gigabytes to petabytes: .",
"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' 'PrestoSession.R'\n'PrestoConnection.R' 'PrestoQuery.R' 'PrestoResult.R'\n'RPresto-package.R' 'chunk.R' 'create.dummy.tables.R' 'cte.R'\n'dbAppendTable.R' 'dbAppendTableAs.R' 'dbClearResult.R'\n'dbColumnType.R' 'dbColumnInfo.R' 'dbConnect.R'\n'dbCreateTable.R' 'dbCreateTableAs.R' 'dbDataType.R'\n'dbDisconnect.R' 'dbExistsTable.R' 'dbFetch.R' 'dbGetInfo.R'\n'dbGetQuery.R' 'dbGetRowCount.R' 'dbGetRowsAffected.R'\n'dbGetStatement.R' 'dbHasCompleted.R' 'dbIsValid.R'\n'dbListFields.R' 'dbListTables.R' 'dbQuoteIdentifier.R'\n'dbQuoteLiteral.R' 'dbReadTable.R' 'dbRemoveTable.R'\n'dbRenameTable.R' 'dbSendQuery.R' 'dbUnloadDriver.R'\n'dbWriteTable.R' 'dbplyr-db.R' 'dbplyr-sql.R' 'dbplyr-src.R'\n'default.R' 'fetch.R' 'presto.field.R'\n'presto.field_utilities.R' 'presto_type.R' 'presto_unnest.R'\n'request_headers.R' 'sqlAppendTableAs.R' 'sqlCreateTable.R'\n'sqlCreateTableAs.R' 'zzz.R'",
"RoxygenNote": "7.3.2",
"VignetteBuilder": "knitr",
"Roxygen": "list(markdown = TRUE)",
"Config/pak/sysreqs": "libicu-dev libssl-dev",
"Repository": "https://prestodb.r-universe.dev",
"Date/Publication": "2026-01-05 13:10:13 UTC",
"RemoteUrl": "https://github.com/prestodb/rpresto",
"RemoteRef": "HEAD",
"RemoteSha": "2b37d0725e598ab554446ec56c0dce36463f5cb7",
"NeedsCompilation": "no",
"Packaged": {
"Date": "2026-06-04 08:04:31 UTC",
"User": "root"
},
"Author": "Onur Ismail Filiz [aut],\nSergey Goder [aut],\nJarod G.R. Meng [aut, cre],\nThomas J. Leeper [ctb],\nJohn Myles White [ctb]",
"Maintainer": "Jarod G.R. Meng ",
"MD5sum": "c181ad2ee9e58fbab9094d6eaf284199",
"_user": "prestodb",
"_type": "src",
"_file": "RPresto_1.4.8.9000.tar.gz",
"_fileid": "6e75f52ee2507812e37991c0fb9a195b3deb67aa87d9766652474daf96aced9a",
"_filesize": 293771,
"_sha256": "6e75f52ee2507812e37991c0fb9a195b3deb67aa87d9766652474daf96aced9a",
"_created": "2026-06-04T08:04:31.000Z",
"_published": "2026-06-04T08:09:44.390Z",
"_distro": "noble",
"_jobs": [
{
"job": 79476035735,
"time": 166,
"config": "linux-devel-x86_64",
"r": "4.7.0",
"check": "OK",
"artifact": "7406232577"
},
{
"job": 79476035791,
"time": 203,
"config": "linux-release-x86_64",
"r": "4.6.0",
"check": "OK",
"artifact": "7406245251"
},
{
"job": 79476035835,
"time": 273,
"config": "macos-oldrel-arm64",
"r": "4.5.3",
"check": "OK",
"artifact": "7406249795"
},
{
"job": 79476035766,
"time": 222,
"config": "macos-release-arm64",
"r": "4.6.0",
"check": "OK",
"artifact": "7406238799"
},
{
"job": 79475511329,
"time": 193,
"config": "source",
"r": "4.6.0",
"check": "OK",
"artifact": "7406179366"
},
{
"job": 79476035757,
"time": 115,
"config": "wasm-release",
"r": "4.6.0",
"check": "OK",
"artifact": "7406216945"
},
{
"job": 79476035749,
"time": 239,
"config": "windows-devel",
"r": "4.7.0",
"check": "OK",
"artifact": "7406256676"
},
{
"job": 79476036161,
"time": 203,
"config": "windows-oldrel",
"r": "4.5.3",
"check": "OK",
"artifact": "7406244794"
},
{
"job": 79476035755,
"time": 183,
"config": "windows-release",
"r": "4.6.0",
"check": "OK",
"artifact": "7406238091"
}
],
"_buildurl": "https://github.com/r-universe/prestodb/actions/runs/26938948592",
"_status": "success",
"_host": "GitHub-Actions",
"_upstream": "https://github.com/prestodb/rpresto",
"_commit": {
"id": "2b37d0725e598ab554446ec56c0dce36463f5cb7",
"author": "Jarod G.R. Meng ",
"committer": "Jarod G.R. Meng ",
"message": "Add retry logic to compute() for table existence check (#332)\n",
"time": 1767618613
},
"_maintainer": {
"name": "Jarod G.R. Meng",
"email": "jarodm@fb.com"
},
"_registered": true,
"_dependencies": [
{
"package": "R",
"version": ">= 3.1.0",
"role": "Depends"
},
{
"package": "methods",
"role": "Depends"
},
{
"package": "DBI",
"version": ">= 0.3.0",
"role": "Imports"
},
{
"package": "httr",
"version": ">= 0.6",
"role": "Imports"
},
{
"package": "openssl",
"role": "Imports"
},
{
"package": "jsonlite",
"role": "Imports"
},
{
"package": "stringi",
"role": "Imports"
},
{
"package": "stats",
"role": "Imports"
},
{
"package": "utils",
"role": "Imports"
},
{
"package": "purrr",
"role": "Imports"
},
{
"package": "dplyr",
"version": ">= 0.7.0",
"role": "Imports"
},
{
"package": "dbplyr",
"version": ">= 2.3.3",
"role": "Imports"
},
{
"package": "tibble",
"role": "Imports"
},
{
"package": "tidyselect",
"role": "Imports"
},
{
"package": "bit64",
"role": "Imports"
},
{
"package": "rlang",
"role": "Imports"
},
{
"package": "lifecycle",
"role": "Imports"
},
{
"package": "lubridate",
"role": "Imports"
},
{
"package": "progress",
"role": "Imports"
},
{
"package": "vctrs",
"role": "Imports"
},
{
"package": "stringdist",
"role": "Imports"
},
{
"package": "testthat",
"role": "Suggests"
},
{
"package": "hms",
"role": "Suggests"
},
{
"package": "knitr",
"role": "Suggests"
},
{
"package": "rmarkdown",
"role": "Suggests"
},
{
"package": "withr",
"role": "Suggests"
}
],
"_owner": "prestodb",
"_selfowned": true,
"_usedby": 4,
"_updates": [
{
"week": "2025-45",
"n": 12
},
{
"week": "2025-46",
"n": 1
},
{
"week": "2025-49",
"n": 2
},
{
"week": "2026-02",
"n": 1
}
],
"_tags": [
{
"name": "v1.4.8",
"date": "2025-12-01"
}
],
"_stars": 135,
"_contributors": [
{
"user": "cosinequanon",
"count": 64,
"uuid": 1226424
},
{
"user": "jarodmeng",
"count": 48,
"uuid": 854353
},
{
"user": "onurfiliz",
"count": 40,
"uuid": 1843577
},
{
"user": "leepface",
"count": 12,
"uuid": 44214355
},
{
"user": "copernican",
"count": 9,
"uuid": 10757582
},
{
"user": "oggy",
"count": 2,
"uuid": 11112
},
{
"user": "hadley",
"count": 2,
"uuid": 4196
},
{
"user": "saurfang",
"count": 1,
"uuid": 4317392
},
{
"user": "sophiazys",
"count": 1,
"uuid": 24470207
},
{
"user": "yash-tekena",
"count": 1,
"uuid": 42548912
}
],
"_userbio": {
"uuid": 6882181,
"type": "organization",
"name": "Presto",
"description": "Distributed SQL query engine for big data"
},
"_downloads": {
"count": 895,
"source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RPresto"
},
"_devurl": "https://github.com/prestodb/rpresto",
"_searchresults": 37,
"_rbuild": "4.6.0",
"_assets": [
"extra/citation.cff",
"extra/citation.html",
"extra/citation.json",
"extra/citation.txt",
"extra/contents.json",
"extra/NEWS.html",
"extra/NEWS.txt",
"extra/readme.html",
"extra/readme.md",
"extra/RPresto.html",
"manual.pdf"
],
"_homeurl": "https://github.com/prestodb/rpresto",
"_realowner": "prestodb",
"_cranurl": true,
"_releases": [
{
"version": "1.2.0",
"date": "2016-03-17"
},
{
"version": "1.2.1",
"date": "2016-04-06"
},
{
"version": "1.3.0",
"date": "2017-07-13"
},
{
"version": "1.3.1",
"date": "2018-09-10"
},
{
"version": "1.3.2",
"date": "2018-10-23"
},
{
"version": "1.3.3",
"date": "2019-05-04"
},
{
"version": "1.3.4",
"date": "2019-10-18"
},
{
"version": "1.3.5",
"date": "2020-11-13"
},
{
"version": "1.3.6",
"date": "2021-05-31"
},
{
"version": "1.3.7",
"date": "2021-09-04"
},
{
"version": "1.4.0",
"date": "2022-09-27"
},
{
"version": "1.4.1",
"date": "2022-11-16"
},
{
"version": "1.4.2",
"date": "2023-01-14"
},
{
"version": "1.4.3",
"date": "2023-03-03"
},
{
"version": "1.4.4",
"date": "2023-03-09"
},
{
"version": "1.4.5",
"date": "2023-05-05"
},
{
"version": "1.4.6",
"date": "2023-11-01"
},
{
"version": "1.4.7",
"date": "2025-01-08"
},
{
"version": "1.4.8",
"date": "2025-12-02"
}
],
"_exports": [
"add_chunk",
"dbAppendTable",
"dbAppendTableAs",
"dbClearResult",
"dbColumnInfo",
"dbColumnType",
"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",
"presto_type",
"presto_unnest",
"show",
"sqlAppendTableAs",
"sqlCreateTable",
"sqlCreateTableAs",
"src_presto"
],
"_help": [
{
"page": "add_chunk",
"title": "Add a chunk field to a data frame",
"topics": [
"add_chunk"
]
},
{
"page": "dbplyr-db",
"title": "dbplyr database methods",
"topics": [
"db_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"
]
},
{
"page": "dbAppendTableAs",
"title": "Append to a table in database using a statement",
"topics": [
"dbAppendTableAs"
]
},
{
"page": "dbCreateTableAs",
"title": "Create a table in database using a statement",
"topics": [
"dbCreateTableAs"
]
},
{
"page": "dbDataType",
"title": "Return the corresponding presto data type for the given R 'object'",
"topics": [
"dbDataType,PrestoDriver-method"
]
},
{
"page": "dbGetInfo",
"title": "Metadata about database objects",
"topics": [
"dbGetInfo,PrestoConnection-method",
"dbGetInfo,PrestoDriver-method",
"dbGetInfo,PrestoResult-method"
]
},
{
"page": "dbplyr_edition.PrestoConnection",
"title": "Inform the dbplyr version used in this package",
"topics": [
"dbplyr_edition.PrestoConnection"
]
},
{
"page": "dbRenameTable",
"title": "Rename a table",
"topics": [
"dbRenameTable"
]
},
{
"page": "kerberos_configs",
"title": "A convenient wrapper around Kerberos config",
"topics": [
"kerberos_configs"
]
},
{
"page": "Presto",
"title": "Connect to a Presto database",
"topics": [
"dbConnect,PrestoDriver-method",
"dbDisconnect,PrestoConnection-method",
"Presto"
]
},
{
"page": "presto_has_default",
"title": "Check if default database is available.",
"topics": [
"presto_default",
"presto_has_default"
]
},
{
"page": "presto_type",
"title": "Get column type information for a Presto table or query",
"topics": [
"presto_type",
"presto_type.tbl_presto"
]
},
{
"page": "presto_unnest",
"title": "Unnest array columns in Presto tables",
"topics": [
"presto_unnest",
"presto_unnest.tbl_presto"
]
},
{
"page": "dbplyr-sql",
"title": "dbplyr SQL methods",
"topics": [
"sql_query_save.PrestoConnection"
]
},
{
"page": "sqlAppendTableAs",
"title": "Compose query to append to a table using a statement",
"topics": [
"sqlAppendTableAs"
]
},
{
"page": "sqlCreateTableAs",
"title": "Compose query to create a simple table using a statement",
"topics": [
"sqlCreateTableAs"
]
},
{
"page": "src_presto",
"title": "dplyr integration to connect to a Presto database.",
"topics": [
"src_presto"
]
}
],
"_readme": "https://github.com/prestodb/rpresto/raw/HEAD/README.md",
"_rundeps": [
"askpass",
"bit",
"bit64",
"blob",
"cli",
"cpp11",
"crayon",
"curl",
"DBI",
"dbplyr",
"dplyr",
"generics",
"glue",
"hms",
"httr",
"jsonlite",
"lifecycle",
"lubridate",
"magrittr",
"mime",
"openssl",
"pillar",
"pkgconfig",
"prettyunits",
"progress",
"purrr",
"R6",
"rlang",
"stringdist",
"stringi",
"stringr",
"sys",
"tibble",
"tidyr",
"tidyselect",
"timechange",
"utf8",
"vctrs",
"withr"
],
"_vignettes": [
{
"source": "common-table-expressions.Rmd",
"filename": "common-table-expressions.html",
"title": "Common Table Expressions (CTEs)",
"engine": "knitr::rmarkdown",
"headings": [
"Setup",
"Define CTEs while creating a PrestoConnection",
"Incorporating CTEs with dplyr backend"
],
"created": "2022-09-16 17:11:35",
"modified": "2022-09-27 05:25:16",
"commits": 2
},
{
"source": "primitive-types.Rmd",
"filename": "primitive-types.html",
"title": "Primitive Presto data types to R types",
"engine": "knitr::rmarkdown",
"headings": [
"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"
],
"created": "2022-09-06 18:33:11",
"modified": "2022-10-26 10:33:48",
"commits": 3
},
{
"source": "complex-types.Rmd",
"filename": "complex-types.html",
"title": "Translating complex Presto data types",
"engine": "knitr::rmarkdown",
"headings": [
"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"
],
"created": "2022-09-06 18:33:11",
"modified": "2022-11-16 06:01:04",
"commits": 4
}
],
"_score": 9.510110498432596,
"_indexed": true,
"_nocasepkg": "rpresto",
"_universes": [
"prestodb"
],
"_binaries": [
{
"r": "4.7.0",
"os": "linux",
"version": "1.4.8.9000",
"date": "2026-06-04T08:06:45.000Z",
"distro": "noble",
"commit": "2b37d0725e598ab554446ec56c0dce36463f5cb7",
"fileid": "1417d7fcd41b114197be5fe9caddaf60fe1cba277a9df15a6a1c6c0fffdcb0ba",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/prestodb/actions/runs/26938948592"
},
{
"r": "4.6.0",
"os": "linux",
"version": "1.4.8.9000",
"date": "2026-06-04T08:07:15.000Z",
"distro": "noble",
"commit": "2b37d0725e598ab554446ec56c0dce36463f5cb7",
"fileid": "aeabb7f4113a7053f168cc8cf5b246987ad7bcfc42414a1b83d1765050a7f84c",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/prestodb/actions/runs/26938948592"
},
{
"r": "4.5.3",
"os": "mac",
"version": "1.4.8.9000",
"date": "2026-06-04T08:07:29.000Z",
"commit": "2b37d0725e598ab554446ec56c0dce36463f5cb7",
"fileid": "162fc54b09c44f69dbd29a667eec79d1bc6be743a491a601d47be33d64cd3728",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/prestodb/actions/runs/26938948592"
},
{
"r": "4.6.0",
"os": "mac",
"version": "1.4.8.9000",
"date": "2026-06-04T08:06:57.000Z",
"commit": "2b37d0725e598ab554446ec56c0dce36463f5cb7",
"fileid": "6ba714ccdcd9ecdac73d1b6c5ee7d530fd24e431eccb0274398fc153e5a2430b",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/prestodb/actions/runs/26938948592"
},
{
"r": "4.6.0",
"os": "wasm",
"version": "1.4.8.9000",
"date": "2026-06-04T08:06:48.000Z",
"commit": "2b37d0725e598ab554446ec56c0dce36463f5cb7",
"fileid": "10e13d89f011de9a387533a0b6edfbfc730a874fb6e381ea91de6ed9d9d0718a",
"status": "success",
"buildurl": "https://github.com/r-universe/prestodb/actions/runs/26938948592"
},
{
"r": "4.7.0",
"os": "win",
"version": "1.4.8.9000",
"date": "2026-06-04T08:07:37.000Z",
"commit": "2b37d0725e598ab554446ec56c0dce36463f5cb7",
"fileid": "bea11881f632e62da19d82803eb7e48655d0289c87de74e586432ded55509484",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/prestodb/actions/runs/26938948592"
},
{
"r": "4.5.3",
"os": "win",
"version": "1.4.8.9000",
"date": "2026-06-04T08:06:56.000Z",
"commit": "2b37d0725e598ab554446ec56c0dce36463f5cb7",
"fileid": "122d2c82e5eaf86777ad0a73ab35e49a5aaac41d5e909b82798225882d414063",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/prestodb/actions/runs/26938948592"
},
{
"r": "4.6.0",
"os": "win",
"version": "1.4.8.9000",
"date": "2026-06-04T08:06:42.000Z",
"commit": "2b37d0725e598ab554446ec56c0dce36463f5cb7",
"fileid": "afe8c0648b4a55ecb8003b927af1c6464731e9d7ec12e122d46312b59285e8d4",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/prestodb/actions/runs/26938948592"
}
]
}