Set Drill SYSTEM or SESSION options

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).

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

Value

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

Details

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

References

Drill documentation

See also

Other Dill direct REST API Interface: drill_active, drill_cancel, drill_connection, drill_metrics, drill_options, drill_profiles, drill_profile, drill_query, drill_settings_reset, drill_show_files, drill_show_schemas, drill_stats, drill_status, drill_storage, drill_system_reset, drill_threads, drill_use, drill_version

Examples

# NOT RUN {
drill_connection() %>%
  drill_set(exec.errors.verbose=TRUE, store.format="parquet", web.logs.max_lines=20000)
# }