{ "_id": "6a105028acfb0bcc41ca103c", "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-05-10 05:45:02 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 ", "MD5sum": "4589e77c092bdc75dfaee7188d180277", "_user": "hrbrmstr", "_type": "src", "_file": "sergeant_0.9.1.tar.gz", "_fileid": "34c92e64f5de4e8cec654516c75cdc853055d6f51be1fa3d1f49a11851b64eb3", "_filesize": 229515, "_sha256": "34c92e64f5de4e8cec654516c75cdc853055d6f51be1fa3d1f49a11851b64eb3", "_created": "2026-05-10T05:45:02.000Z", "_published": "2026-05-22T12:46:32.698Z", "_distro": "noble", "_jobs": [ { "job": 77382091004, "time": 196, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "6901346462" }, { "job": 77382090777, "time": 155, "config": "linux-release-x86_64", "r": "4.6.0", "check": "WARNING", "artifact": "6901342696" }, { "job": 77382090817, "time": 138, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "6901340910" }, { "job": 77382090573, "time": 85, "config": "macos-release-arm64", "r": "4.6.0", "check": "WARNING", "artifact": "6901335669" }, { "job": 77382090451, "time": 174, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6901326856" }, { "job": 77382090340, "time": 133, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7160808671" }, { "job": 77382090932, "time": 136, "config": "windows-devel", "r": "4.7.0", "check": "WARNING", "artifact": "6901341101" }, { "job": 77382090835, "time": 116, "config": "windows-oldrel", "r": "4.5.3", "check": "WARNING", "artifact": "6901338770" }, { "job": 77382090898, "time": 136, "config": "windows-release", "r": "4.6.0", "check": "WARNING", "artifact": "6901340824" } ], "_buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/25621017712", "_status": "success", "_host": "GitHub-Actions", "_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", "uuid": 509878 }, "_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": 125, "_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", "description": "🇺🇦 Pampa • Don't look at me…I do what he does—just slower. #rstats avuncular•👨‍🍳•✝️• 💤• Distinguished Engineer @ Censys + CMU Lecturer" }, "_downloads": { "count": 271, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sergeant" }, "_devurl": "https://gitlab.com/hrbrmstr/sergeant", "_searchresults": 65, "_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/sergeant.html", "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.307763378322949, "_indexed": true, "_nocasepkg": "sergeant", "_universes": [ "hrbrmstr", "gitlab-hrbrmstr" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.9.1", "date": "2026-05-10T05:47:58.000Z", "distro": "noble", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "93b2e869bbc86ce928d9b1e4b0e21c76634c01bc165e87005d06d7885a65a6ad", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/25621017712" }, { "r": "4.6.0", "os": "linux", "version": "0.9.1", "date": "2026-05-10T05:47:21.000Z", "distro": "noble", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "47a9b2f0f0dcf2419ef7f36cd24cee1da1c0929a75e6d07c2ce208be81c18561", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/25621017712" }, { "r": "4.5.3", "os": "mac", "version": "0.9.1", "date": "2026-05-10T05:46:58.000Z", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "b74c292a8e6b616c8913a52e96b033d38a5f311a45258624c75736c90fa1882a", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/25621017712" }, { "r": "4.6.0", "os": "mac", "version": "0.9.1", "date": "2026-05-10T05:46:21.000Z", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "db7e1ca89ed67631ca3cb4172de39f29422c19e086a226822a281c499900d2bf", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/25621017712" }, { "r": "4.7.0", "os": "win", "version": "0.9.1", "date": "2026-05-10T05:46:40.000Z", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "1975cbf7b70dd755129611c3c1bc8e99fd91582361ab031e613edc1e62a02dab", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/25621017712" }, { "r": "4.5.3", "os": "win", "version": "0.9.1", "date": "2026-05-10T05:46:17.000Z", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "c345a45b5f0749d0d6b02e474677264cf3664a010883b970e8557a90702506c0", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/25621017712" }, { "r": "4.6.0", "os": "win", "version": "0.9.1", "date": "2026-05-10T05:46:32.000Z", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "14c6839699d85035b7f13e3c10b8260919d0cf3bca170196dec6a33604f72446", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/25621017712" }, { "r": "4.6.0", "os": "wasm", "version": "0.9.1", "date": "2026-05-22T12:46:15.000Z", "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96", "fileid": "a0f0c46a296d5381b0894fd0ae1068f7da7bbe75bd8c9ba80e75a7e4248b0bdb", "status": "success", "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/25621017712" } ] }