Currently returns the top n elements (rows) from result set or returns entire table from Athena.
# S4 method for AthenaResult dbFetch(res, n = -1, ...)
res | An object inheriting from DBIResult, created by
|
---|---|
n | maximum number of records to retrieve per fetch. Use |
... | Other arguments passed on to methods. |
dbFetch()
returns a data frame.
if (FALSE) { # Note: # - Require AWS Account to run below example. # - Different connection methods can be used please see `RAthena::dbConnect` documnentation library(DBI) # Demo connection to Athena using profile name con <- dbConnect(RAthena::athena()) res <- dbSendQuery(con, "show databases") dbFetch(res) dbClearResult(res) # Disconnect from Athena dbDisconnect(con) }