{ "_id": "6a4f6b5621b18e1548501b36", "Package": "sergeant", "Title": "Tools to Transform and Query Data with Apache Drill", "Version": "0.9.1", "Authors@R": "c(\nperson(\"Bob\", \"Rudis\", email = \"bob@rud.is\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0001-5670-2640\")),\nperson(\"Edward\", \"Visel\", email = \"edward.visel@gmail.com\", role = \"ctb\"),\nperson(\"Andy\", \"Hine\", email = \"andyyhine@gmail.com\", role = \"ctb\"),\nperson(\"Scott\", \"Came\", email = \"scottcame10@gmail.com\", role = \"ctb\"),\nperson(\"David\", \"Severski\", email = \"davidski@deadheaven.com\", role = \"ctb\",\ncomment = c(ORCID = \"https://orcid.org/0000-0001-7867-0459\")),\nperson(\"James\", \"Lamb\", email = \"jaylamb20@gmail.com\", role = \"ctb\")\n)", "Description": "Apache Drill is a low-latency distributed query engine\ndesigned to enable data exploration and analysis on both\nrelational and non-relational data stores, scaling to petabytes\nof data. Methods are provided that enable working with Apache\nDrill instances via the REST API, DBI methods and using\n'dplyr'/'dbplyr' idioms. Helper functions are included to\nfacilitate using official Drill Docker images/containers.", "URL": "https://gitlab.com/hrbrmstr/sergeant", "BugReports": "https://gitlab.com/hrbrmstr/sergeant/-/issues", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "RoxygenNote": "7.1.2", "Roxygen": "list(markdown = TRUE)", "Config/pak/sysreqs": "libicu-dev libssl-dev libx11-dev", "Repository": "https://hrbrmstr.r-universe.dev", "Date/Publication": "2021-11-29 18:06:59 UTC", "RemoteUrl": "https://github.com/hrbrmstr/sergeant", "RemoteRef": "HEAD", "RemoteSha": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-09 09:31:43 UTC", "User": "root" }, "Author": "Bob Rudis [aut, cre] (ORCID: ),\nEdward Visel [ctb],\nAndy Hine [ctb],\nScott Came [ctb],\nDavid Severski [ctb] (ORCID: ),\nJames Lamb [ctb]", "Maintainer": "Bob Rudis ", "_user": "hrbrmstr", "_type": "src", "_file": "sergeant_0.9.1.tar.gz", "_fileid": "https://r2.ropensci.org/7a683967045237f9ea86d87afa4e542f46bf48053478abe78d84f6563956178f", "_filesize": 233645, "_sha256": "7a683967045237f9ea86d87afa4e542f46bf48053478abe78d84f6563956178f", "_expires": "2026-10-17T09:35:16.000Z", "_created": "2026-07-09T09:31:43.000Z", "_published": "2026-07-09T09:35:18.246Z", "_jobs": [ { "job": 86085985473, "time": 164, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "8194593470" }, { "job": 86085985468, "time": 167, "config": "linux-release-x86_64", "r": "4.6.1", "check": "WARNING", "artifact": "8194594370" }, { "job": 86085985432, "time": 131, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "8194580083" }, { "job": 86085985427, "time": 134, "config": "macos-release-arm64", "r": "4.6.1", "check": "WARNING", "artifact": "8194580987" }, { "job": 86085283341, "time": 211, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8194528153" }, { "job": 86085985476, "time": 123, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8194577543" }, { "job": 86085985463, "time": 149, "config": "windows-devel", "r": "4.7.0", "check": "WARNING", "artifact": "8194583234" }, { "job": 86085985470, "time": 122, "config": "windows-oldrel", "r": "4.5.3", "check": "WARNING", "artifact": "8194576543" }, { "job": 86085985518, "time": 162, "config": "windows-release", "r": "4.6.1", "check": "WARNING", "artifact": "8194592506" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/29008269358", "_status": "success", "_upstream": "https://github.com/hrbrmstr/sergeant", "_commit": { "id": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "author": "boB Rudis ", "committer": "GitHub ", "message": "Merge pull request #46 from hrbrmstr/cran\n\nfix CRAN checks", "time": 1638209219 }, "_maintainer": { "name": "Bob Rudis", "email": "bob@rud.is", "login": "hrbrmstr", "mastodon": "@hrbrmstr@mastodon.social", "bluesky": "@hrbrmstr.dev", "orcid": "0000-0001-5670-2640", "description": "🇺🇦 Pampa • Don't look at me…I do what he does—just slower. #rstats avuncular•👨‍🍳•✝️• 💤• Distinguished Engineer @ Censys + CMU Lecturer", "uuid": 509878 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.6.0", "role": "Depends" }, { "package": "bit64", "version": ">= 0.9-7", "role": "Imports" }, { "package": "DBI", "version": ">= 0.7", "role": "Imports" }, { "package": "dplyr", "version": ">= 0.8.0", "role": "Imports" }, { "package": "dbplyr", "version": ">= 1.3.0", "role": "Imports" }, { "package": "httr", "version": ">= 1.2.1", "role": "Imports" }, { "package": "jsonlite", "version": ">= 1.5.0", "role": "Imports" }, { "package": "htmltools", "version": ">= 0.3.6", "role": "Imports" }, { "package": "readr", "version": ">= 1.1.1", "role": "Imports" }, { "package": "purrr", "version": ">= 0.2.2", "role": "Imports" }, { "package": "scales", "version": ">= 0.4.1", "role": "Imports" }, { "package": "stringi", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "magrittr", "version": ">= 1.5", "role": "Imports" }, { "package": "DT", "version": ">= 0.5", "role": "Suggests" }, { "package": "stevedore", "role": "Suggests" }, { "package": "tinytest", "role": "Suggests" }, { "package": "covr", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "DBItest", "role": "Suggests" } ], "_owner": "hrbrmstr", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_topics": [ "apache-drill", "dplyr", "drill", "parquet-files", "r-cyber", "sql" ], "_stars": 124, "_contributors": [ { "user": "hrbrmstr", "count": 144, "uuid": 509878 }, { "user": "jameslamb", "count": 2, "uuid": 7608904 }, { "user": "scottcame", "count": 2, "uuid": 5532621 }, { "user": "ahine", "count": 1, "uuid": 21250429 }, { "user": "alistaire47", "count": 1, "uuid": 1693477 }, { "user": "trinker", "count": 1, "uuid": 1763278 } ], "_userbio": { "uuid": 509878, "type": "user", "name": "boB Rudis", "followers": 1811, "description": "🇺🇦 Pampa • Don't look at me…I do what he does—just slower. #rstats avuncular•👨‍🍳•✝️• 💤• Distinguished Engineer @ Censys + CMU Lecturer" }, "_downloads": { "count": 367, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sergeant" }, "_devurl": "https://gitlab.com/hrbrmstr/sergeant", "_searchresults": 60, "_rbuild": "4.6.1", "_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/sergeant.html", "LICENSE", "manual.pdf" ], "_homeurl": "https://github.com/hrbrmstr/sergeant", "_realowner": "hrbrmstr", "_cranurl": true, "_releases": [ { "version": "0.5.2", "date": "2017-07-17" }, { "version": "0.9.0", "date": "2020-06-01" }, { "version": "0.9.1", "date": "2021-11-29" } ], "_exports": [ "%>%", "ctas_profile", "dbClearResult", "dbConnect", "dbDataType", "dbDisconnect", "dbFetch", "dbGetInfo", "dbGetStatement", "dbHasCompleted", "dbIsValid", "dbListFields", "dbQuoteIdentifier", "dbSendQuery", "dbUnloadDriver", "Drill", "drill_active", "drill_cancel", "drill_connection", "drill_down", "drill_functions", "drill_metrics", "drill_mod_storage", "drill_options", "drill_opts", "drill_profile", "drill_profiles", "drill_query", "drill_rm_storage", "drill_set", "drill_settings_reset", "drill_show_files", "drill_show_schemas", "drill_stats", "drill_status", "drill_storage", "drill_system_reset", "drill_threads", "drill_up", "drill_uplift", "drill_use", "drill_version", "killall_drill", "showall_drill", "src_drill", "tbl" ], "_help": [ { "page": "ctas_profile", "title": "Generate a Drill CTAS Statement from a Query", "topics": [ "ctas_profile" ] }, { "page": "dbDataType-DrillConnection-method", "title": "Drill dbDataType", "concept": [ "Drill REST DBI API" ], "topics": [ "dbDataType,DrillConnection-method" ] }, { "page": "dbGetInfo", "title": "Metadata about database objects", "topics": [ "dbGetInfo,DrillConnection-method", "dbGetInfo,DrillDriver-method" ] }, { "page": "DrilDriver-class", "title": "Unload driver", "concept": [ "Drill REST DBI API" ], "topics": [ "dbUnloadDriver,DrillDriver-method" ] }, { "page": "Drill", "title": "Drill", "concept": [ "Drill REST DBI API" ], "topics": [ "dbConnect,DrillDriver-method", "Drill" ] }, { "page": "drill_active", "title": "Test whether Drill HTTP Drill direct REST API Interface server is up", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_active" ] }, { "page": "drill_cancel", "title": "Cancel the query that has the given queryid", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_cancel" ] }, { "page": "drill_connection", "title": "Setup a Drill connection", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_connection" ] }, { "page": "drill_custom_functions", "title": "Drill expressions / custom functions 'dplyr' translations", "concept": [ "Drill REST API (dplyr)" ], "topics": [ "drill_custom_functions" ] }, { "page": "drill_functions", "title": "Show all the available Drill built-in functions & UDFs", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_functions" ] }, { "page": "drill_metrics", "title": "Get the current memory metrics", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_metrics" ] }, { "page": "drill_options", "title": "List the name, default, and data type of the system and session options", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_options" ] }, { "page": "drill_opts", "title": "Show all the available Drill options", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_opts" ] }, { "page": "drill_profile", "title": "Get the profile of the query that has the given queryid", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_profile" ] }, { "page": "drill_profiles", "title": "Get the profiles of running and completed queries", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_profiles" ] }, { "page": "drill_query", "title": "Submit a query and return results", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_query" ] }, { "page": "drill_set", "title": "Set Drill SYSTEM or SESSION options", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_set" ] }, { "page": "drill_settings_reset", "title": "Changes (optionally, all) session settings back to system defaults", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_settings_reset" ] }, { "page": "drill_show_files", "title": "Show files in a file system schema.", "concept": [ "Dill direct REST API Interface" ], "topics": [ "drill_show_files" ] }, { "page": "drill_show_schemas", "title": "Returns a list of available schemas.", "concept": [ "Dill direct REST API Interface" ], "topics": [ "drill_show_schemas" ] }, { "page": "drill_stats", "title": "Get Drillbit information, such as ports numbers", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_stats" ] }, { "page": "drill_status", "title": "Get the status of Drill", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_status" ] }, { "page": "drill_storage", "title": "Retrieve, modify or update storage plugin names and configurations", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_mod_storage", "drill_rm_storage", "drill_storage" ] }, { "page": "drill_system_reset", "title": "Changes (optionally, all) system settings back to system defaults", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_system_reset" ] }, { "page": "drill_threads", "title": "Get information about threads", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_threads" ] }, { "page": "drill_up", "title": "Start a Dockerized Drill Instance", "concept": [ "Drill Docker functions" ], "topics": [ "drill_down", "drill_up" ] }, { "page": "drill_uplift", "title": "Turn columnar query results into a type-converted tbl", "topics": [ "drill_uplift" ] }, { "page": "drill_use", "title": "Change to a particular schema.", "concept": [ "Dill direct REST API Interface" ], "topics": [ "drill_use" ] }, { "page": "drill_version", "title": "Identify the version of Drill running", "concept": [ "Drill direct REST API Interface" ], "topics": [ "drill_version" ] }, { "page": "format.DrillConnection", "title": "A concise character representation (label) for a 'DrillConnection'", "topics": [ "format.DrillConnection" ] }, { "page": "killall_drill", "title": "Prune all dead and running Drill Docker containers", "concept": [ "Drill Docker functions" ], "topics": [ "killall_drill" ] }, { "page": "print.drill_conn", "title": "Print function for 'drill_conn' objects", "topics": [ "print.drill_conn" ] }, { "page": "sergeant-exports", "title": "sergeant exported operators", "topics": [ "sergeant-exports", "tbl" ] }, { "page": "showall_drill", "title": "Show all dead and running Drill Docker containers", "concept": [ "Drill Docker functions" ], "topics": [ "showall_drill" ] }, { "page": "src_drill", "title": "Connect to Drill (dplyr)", "concept": [ "Drill REST API (dplyr)" ], "topics": [ "src_drill", "tbl.src_drill" ] } ], "_readme": "https://github.com/hrbrmstr/sergeant/raw/HEAD/README.md", "_rundeps": [ "askpass", "base64enc", "bit", "bit64", "blob", "cli", "clipr", "cpp11", "crayon", "curl", "DBI", "dbplyr", "digest", "dplyr", "farver", "fastmap", "generics", "glue", "hms", "htmltools", "httr", "jsonlite", "labeling", "lifecycle", "magrittr", "mime", "openssl", "pillar", "pkgconfig", "prettyunits", "progress", "purrr", "R6", "RColorBrewer", "readr", "rlang", "scales", "stringi", "stringr", "sys", "tibble", "tidyr", "tidyselect", "tzdb", "utf8", "vctrs", "viridisLite", "vroom", "withr" ], "_score": 6.269512944217916, "_indexed": true, "_nocasepkg": "sergeant", "_universes": [ "hrbrmstr", "gitlab-hrbrmstr" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.9.1", "date": "2026-07-09T09:34:11.000Z", "distro": "resolute", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "https://r2.ropensci.org/382756bdc9ef6d29046409d8cfd35fda2d1c0008a81529ccf33f7e87161c33a2", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/29008269358" }, { "r": "4.6.1", "os": "linux", "version": "0.9.1", "date": "2026-07-09T09:34:12.000Z", "distro": "resolute", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "https://r2.ropensci.org/3167e9ed59af2d99f64f117812af3e67ae19466eabb65325a453f540378d6d85", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/29008269358" }, { "r": "4.5.3", "os": "mac", "version": "0.9.1", "date": "2026-07-09T09:33:42.000Z", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "https://r2.ropensci.org/de2fa0d6796af57de4928a5f9277e10f71db8f53c8a34e26b87b273e4adbcf95", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/29008269358" }, { "r": "4.6.1", "os": "mac", "version": "0.9.1", "date": "2026-07-09T09:33:42.000Z", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "https://r2.ropensci.org/21a2d74ed7927ee0672485792f7d746f39fda508ae6ccbdb6caa3f299e5d7a44", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/29008269358" }, { "r": "4.6.0", "os": "wasm", "version": "0.9.1", "date": "2026-07-09T09:34:06.000Z", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "https://r2.ropensci.org/c703aee94e89466f46bcf02755e2dc7019e69f20b73e50a6b909d6bd6a1a4501", "status": "success", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/29008269358" }, { "r": "4.7.0", "os": "win", "version": "0.9.1", "date": "2026-07-09T09:33:19.000Z", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "https://r2.ropensci.org/140c46139deecdbe095706d03927aa072c3c71f267abd04fefa19e157eb07759", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/29008269358" }, { "r": "4.5.3", "os": "win", "version": "0.9.1", "date": "2026-07-09T09:33:00.000Z", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "https://r2.ropensci.org/19d409e0a4531242cd588c9e387a71d0487a93d3188c2879d69448db1a00fc4f", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/29008269358" }, { "r": "4.6.1", "os": "win", "version": "0.9.1", "date": "2026-07-09T09:33:46.000Z", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "https://r2.ropensci.org/91e70ffc8cb9e4ecf3e9a9715681196d9d10ae1be21310d0c55b797004c2ddd7", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/29008269358" } ] }