Submit a query and return results

This function can handle REST API connections or JDBC connections. There is a benefit to calling this function for JDBC connections vs a straight call to dbGetQuery() in that the function result is a `tbl_df` vs a plain data.frame so you get better default printing (which can be helpful if you accidentally execute a query and the result set is huge).

drill_query(drill_con, query, uplift = TRUE, .progress = interactive())

Arguments

drill_con	drill server connection object setup by drill_connection() or drill_jdbc())
query	query to run
uplift	automatically run drill_uplift() on the result? (default: TRUE, ignored if drill_con is a JDBCConnection created by drill_jdbc())
.progress	if TRUE (default if in an interactive session) then ask httr::POST to display a progress bar

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_settings_reset, drill_set, drill_show_files, drill_show_schemas, drill_stats, drill_status, drill_storage, drill_system_reset, drill_threads, drill_use, drill_version

Examples

try({
drill_connection() %>%
  drill_query("SELECT * FROM cp.`employee.json` limit 5")
}, silent=TRUE)