drill_set: Set Drill SYSTEM or SESSION options

Description Usage Arguments Details Value References 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|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

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)

hrbrmstr/sergeant documentation built on Aug. 6, 2018, 3:18 a.m.