Package: sergeant 0.9.1

sergeant: Tools to Transform and Query Data with Apache Drill

Apache Drill is a low-latency distributed query engine designed to enable data exploration and analysis on both relational and non-relational data stores, scaling to petabytes of data. Methods are provided that enable working with Apache Drill instances via the REST API, DBI methods and using 'dplyr'/'dbplyr' idioms. Helper functions are included to facilitate using official Drill Docker images/containers.

Authors:Bob Rudis [aut, cre], Edward Visel [ctb], Andy Hine [ctb], Scott Came [ctb], David Severski [ctb], James Lamb [ctb]

sergeant_0.9.1.tar.gz
sergeant_0.9.1.zip(r-4.7)sergeant_0.9.1.zip(r-4.6)sergeant_0.9.1.zip(r-4.5)
sergeant_0.9.1.tgz(r-4.6-any)sergeant_0.9.1.tgz(r-4.5-any)
sergeant_0.9.1.tar.gz(r-4.7-any)sergeant_0.9.1.tar.gz(r-4.6-any)
sergeant_0.9.1.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
sergeant/json (API)
NEWS

# Install 'sergeant' in R:
install.packages('sergeant', repos = c('https://hrbrmstr.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://gitlab.com/hrbrmstr/sergeant

On CRAN:

Conda:

apache-drilldplyrdrillparquet-filesr-cybersql

6.31 score 125 stars 65 scripts 271 downloads 46 exports 49 dependencies

Last updated from:9408208e41. Checks:7 WARNING, 2 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64WARNING196
source / vignettesOK174
linux-release-x86_64WARNING155
macos-release-arm64WARNING85
macos-oldrel-arm64WARNING138
windows-develWARNING136
windows-releaseWARNING136
windows-oldrelWARNING116
wasm-releaseOK133

Exports:%>%ctas_profiledbClearResultdbConnectdbDataTypedbDisconnectdbFetchdbGetInfodbGetStatementdbHasCompleteddbIsValiddbListFieldsdbQuoteIdentifierdbSendQuerydbUnloadDriverDrilldrill_activedrill_canceldrill_connectiondrill_downdrill_functionsdrill_metricsdrill_mod_storagedrill_optionsdrill_optsdrill_profiledrill_profilesdrill_querydrill_rm_storagedrill_setdrill_settings_resetdrill_show_filesdrill_show_schemasdrill_statsdrill_statusdrill_storagedrill_system_resetdrill_threadsdrill_updrill_upliftdrill_usedrill_versionkillall_drillshowall_drillsrc_drilltbl

Dependencies:askpassbase64encbitbit64blobclicliprcpp11crayoncurlDBIdbplyrdigestdplyrfarverfastmapgenericsgluehmshtmltoolshttrjsonlitelabelinglifecyclemagrittrmimeopensslpillarpkgconfigprettyunitsprogresspurrrR6RColorBrewerreadrrlangscalesstringistringrsystibbletidyrtidyselecttzdbutf8vctrsviridisLitevroomwithr

Readme and manuals

Help Manual

Help pageTopics
Generate a Drill CTAS Statement from a Queryctas_profile
Drill dbDataTypedbDataType,DrillConnection-method
Metadata about database objectsdbGetInfo,DrillConnection-method dbGetInfo,DrillDriver-method
Unload driverdbUnloadDriver,DrillDriver-method
DrilldbConnect,DrillDriver-method Drill
Test whether Drill HTTP Drill direct REST API Interface server is updrill_active
Cancel the query that has the given queryiddrill_cancel
Setup a Drill connectiondrill_connection
Drill expressions / custom functions 'dplyr' translationsdrill_custom_functions
Show all the available Drill built-in functions & UDFsdrill_functions
Get the current memory metricsdrill_metrics
List the name, default, and data type of the system and session optionsdrill_options
Show all the available Drill optionsdrill_opts
Get the profile of the query that has the given queryiddrill_profile
Get the profiles of running and completed queriesdrill_profiles
Submit a query and return resultsdrill_query
Set Drill SYSTEM or SESSION optionsdrill_set
Changes (optionally, all) session settings back to system defaultsdrill_settings_reset
Show files in a file system schema.drill_show_files
Returns a list of available schemas.drill_show_schemas
Get Drillbit information, such as ports numbersdrill_stats
Get the status of Drilldrill_status
Retrieve, modify or update storage plugin names and configurationsdrill_mod_storage drill_rm_storage drill_storage
Changes (optionally, all) system settings back to system defaultsdrill_system_reset
Get information about threadsdrill_threads
Start a Dockerized Drill Instancedrill_down drill_up
Turn columnar query results into a type-converted tbldrill_uplift
Change to a particular schema.drill_use
Identify the version of Drill runningdrill_version
A concise character representation (label) for a 'DrillConnection'format.DrillConnection
Prune all dead and running Drill Docker containerskillall_drill
Print function for 'drill_conn' objectsprint.drill_conn
sergeant exported operatorssergeant-exports tbl
Show all dead and running Drill Docker containersshowall_drill
Connect to Drill (dplyr)src_drill tbl.src_drill