drill_set {sergeant}R Documentation

Set Drill SYSTEM or SESSION options

Description

Helper function to make it more R-like to set Drill SESSION or SYSTEM optons. It handles the conversion of R types (like TRUE) to SQL types and automatically quotes parameter values (when necessary).

Usage

drill_set(drill_con, ..., type = c("session", "system"))

Arguments

drill_con

drill server connection object setup by drill_connection()

...

named parameters to be sent to ⁠ALTER SYSTEM⁠ or ⁠ALTER SESSION⁠

type

set the session or system parameter

Details

If any query errors result, error messages will be presented to the console.

Value

a tbl (invisibly) with the ALTER queries sent and results, including errors.

References

Drill documentation

See Also

Other Drill direct REST API Interface: drill_active(), drill_cancel(), drill_connection(), drill_functions(), drill_metrics(), drill_options(), drill_opts(), drill_profiles(), drill_profile(), drill_query(), drill_settings_reset(), drill_stats(), drill_status(), drill_storage(), drill_system_reset(), drill_threads(), drill_version()

Examples

## Not run: 
drill_connection() %>%
  drill_set(exec.errors.verbose=TRUE, store.format="parquet", web.logs.max_lines=20000)

## End(Not run)

[Package sergeant version 0.9.1 Index]