drill_set: Set Drill SYSTEM or SESSION options

In sergeant: Tools to Transform and Query Data with Apache Drill

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)

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