dbGetQuery-src_impala-character-method function

Send SQL query to Impala and retrieve results

Returns the result of an Impala SQL query as a data frame.

## S4 method for signature 'src_impala,character'
dbGetQuery(conn, statement, ...)

Arguments

• conn: object with class class src_impala
• statement: a character string containing SQL
• ...: other arguments passed on to methods

Returns

A data.frame with as many rows as records were fetched and as many columns as fields in the result set, even if the result is a single value or has one or zero rows

Note

This method is for SELECT queries only. Use dbExecute() for data definition or data manipulation statements.

Examples

## Not run:

flights_by_carrier_df <- dbGetQuery(
  impala,
  "SELECT carrier, COUNT(*) FROM flights GROUP BY carrier"
)
## End(Not run)