{
  "_id": "6ac64c56f511ae58c09a9b31",
  "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-10-07 11:13:29 UTC",
    "User": "root"
  },
  "Author": "Bob Rudis [aut, cre] (ORCID: <https://orcid.org/0000-0001-5670-2640>),\nEdward Visel [ctb],\nAndy Hine [ctb],\nScott Came [ctb],\nDavid Severski [ctb] (ORCID: <https://orcid.org/0000-0001-7867-0459>),\nJames Lamb [ctb]",
  "Maintainer": "Bob Rudis <bob@rud.is>",
  "_user": "hrbrmstr",
  "_type": "src",
  "_file": "sergeant_0.9.1.tar.gz",
  "_fileid": "https://r2.ropensci.org/c5a6ddf8843f7bef2c96cab668d7a25049c4cb7a209d5c92de56b8f23c42db28",
  "_filesize": 225474,
  "_sha256": "c5a6ddf8843f7bef2c96cab668d7a25049c4cb7a209d5c92de56b8f23c42db28",
  "_expires": "2027-01-15T13:42:44.000Z",
  "_created": "2026-10-07T11:13:29.000Z",
  "_published": "2026-10-07T13:42:46.424Z",
  "_buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/37612215169",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 112763465564,
      "time": 158,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "11479190123"
    },
    {
      "job": 112763465438,
      "time": 184,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "11478705510"
    },
    {
      "job": 112763465528,
      "time": 133,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "11486475024"
    },
    {
      "job": 112763465663,
      "time": 108,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "11485114609"
    },
    {
      "job": 112762149963,
      "time": 207,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11478039481"
    },
    {
      "job": 112763465464,
      "time": 106,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11478975033"
    },
    {
      "job": 112763465676,
      "time": 161,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "11478179940"
    },
    {
      "job": 112763465710,
      "time": 122,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "11478760263"
    },
    {
      "job": 112763465501,
      "time": 122,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "11478394602"
    }
  ],
  "_upstream": "https://github.com/hrbrmstr/sergeant",
  "_commit": {
    "id": "9408208e41ecb2636d4a9856d32789ffb93b9d96",
    "author": "boB Rudis <bob@rud.is>",
    "committer": "GitHub <noreply@github.com>",
    "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": 1817,
    "description": "🇺🇦 Pampa • Don't look at me…I do what he does—just slower. #rstats avuncular•👨‍🍳•✝️• 💤• Distinguished Engineer @ Censys + CMU Lecturer"
  },
  "_downloads": {
    "count": 298,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sergeant"
  },
  "_devurl": "https://gitlab.com/hrbrmstr/sergeant",
  "_searchresults": 57,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/sergeant.html",
    "LICENSE"
  ],
  "_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.2472365495067645,
  "_indexed": true,
  "_nocasepkg": "sergeant",
  "_universes": [
    "hrbrmstr",
    "gitlab-hrbrmstr"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.9.1",
      "date": "2026-10-07T11:16:02.000Z",
      "distro": "resolute",
      "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96",
      "fileid": "https://r2.ropensci.org/9a2fd1e9c3f542a450c24d052536adb7388de084611d7ded96c7985a71f7cd00",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/37612215169"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.9.1",
      "date": "2026-10-07T11:16:27.000Z",
      "distro": "resolute",
      "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96",
      "fileid": "https://r2.ropensci.org/39a212e99db8a33432c5980d7eb2ae9553f9dc7f65f698ba52b93d0d9f7a09a6",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/37612215169"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.9.1",
      "date": "2026-10-07T13:41:09.000Z",
      "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96",
      "fileid": "https://r2.ropensci.org/8fb0fcc638ca759aa87b26e4a8b8f5c6a6d00fb4e8f9b9881c3fc98fe65a877c",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/37612215169"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.9.1",
      "date": "2026-10-07T13:41:54.000Z",
      "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96",
      "fileid": "https://r2.ropensci.org/f0e9de4609defa0e77269f4f4e62c742c5d03eb41e32d43ed2c2ef0352360214",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/37612215169"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.9.1",
      "date": "2026-10-07T11:15:39.000Z",
      "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96",
      "fileid": "https://r2.ropensci.org/94481114c624741c7d59f598506a9a0bca1913cfcac7d52bcefe15b16adf297c",
      "status": "success",
      "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/37612215169"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.9.1",
      "date": "2026-10-07T11:15:35.000Z",
      "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96",
      "fileid": "https://r2.ropensci.org/bc24fd60b248135c86c2f714461a38aff5cd41ec229562133ee5086e20c0ae48",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/37612215169"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.9.1",
      "date": "2026-10-07T11:14:52.000Z",
      "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96",
      "fileid": "https://r2.ropensci.org/96ad3b74c3f14831946bb84b6cfd5f17a7a28d77204ebb13b11688b5c316b220",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/37612215169"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.9.1",
      "date": "2026-10-07T11:14:52.000Z",
      "commit": "9408208e41ecb2636d4a9856d32789ffb93b9d96",
      "fileid": "https://r2.ropensci.org/1bd91973e5799da2c807840dca4ababf91de7e295cdf2d70e271126b20460d57",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/hrbrmstr/actions/runs/37612215169"
    }
  ]
}