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.5)sergeant_0.9.1.zip(r-4.4)sergeant_0.9.1.zip(r-4.3)
sergeant_0.9.1.tgz(r-4.4-any)sergeant_0.9.1.tgz(r-4.3-any)
sergeant_0.9.1.tar.gz(r-4.5-noble)sergeant_0.9.1.tar.gz(r-4.4-noble)
sergeant_0.9.1.tgz(r-4.4-emscripten)sergeant_0.9.1.tgz(r-4.3-emscripten)
sergeant.pdf |sergeant.html✨
sergeant/json (API)
NEWS

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

Peer review:

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

On CRAN:

3.45 score 56 scripts 205 downloads 46 exports 52 dependencies

Last updated 4 years agofrom:f211f6b214. Checks:OK: 1 WARNING: 6. Indexed: yes.

TargetResultDate
Doc / VignettesOKOct 11 2024
R-4.5-winWARNINGOct 11 2024
R-4.5-linuxWARNINGOct 11 2024
R-4.4-winWARNINGOct 11 2024
R-4.4-macWARNINGOct 11 2024
R-4.3-winWARNINGOct 11 2024
R-4.3-macWARNINGOct 11 2024

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:askpassbase64encbitbit64blobclicliprcolorspacecpp11crayoncurlDBIdbplyrdigestdplyrfansifarverfastmapgenericsgluehmshtmltoolshttrjsonlitelabelinglifecyclemagrittrmimemunsellopensslpillarpkgconfigprettyunitsprogresspurrrR6RColorBrewerreadrrlangscalesstringistringrsystibbletidyrtidyselecttzdbutf8vctrsviridisLitevroomwithr

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 operators%>% sergeant-exports tbl
Show all dead and running Drill Docker containersshowall_drill
Connect to Drill (dplyr)src_drill tbl.src_drill