drill_set: Set Drill SYSTEM or SESSION options

Description Usage Arguments Details Value References See Also Examples

View source: R/set.R

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

1
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

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

## End(Not run)

sergeant documentation built on Nov. 30, 2021, 1:06 a.m.