duckdb (version 0.3.1-1)

duckdb_result-class: DuckDB Result Set

Description

Methods for accessing result sets for queries on DuckDB connections. Implements '>DBIResult.

Usage

# S4 method for duckdb_result
show(object)
# S4 method for duckdb_result
dbClearResult(res, ...)
duckdb_fetch_arrow(
  res,
  stream = FALSE,
  vector_per_chunk = 1,
  return_table = FALSE
)
duckdb_fetch_record_batch(res, approx_batch_size = 1)
# S4 method for duckdb_result
dbFetch(res, n = -1, ...)
# S4 method for duckdb_result
dbHasCompleted(res, ...)
# S4 method for duckdb_result
dbGetInfo(dbObj, ...)
# S4 method for duckdb_result
dbIsValid(dbObj, ...)
# S4 method for duckdb_result
dbGetStatement(res, ...)
# S4 method for duckdb_result
dbColumnInfo(res, ...)
# S4 method for duckdb_result
dbGetRowCount(res, ...)
# S4 method for duckdb_result
dbGetRowsAffected(res, ...)
# S4 method for duckdb_result
dbBind(res, params, ...)

Arguments

object

Any R object

res

Query result to be converted to an Arrow Table

...

Other arguments passed on to methods.

stream

If we are streaming the query result or returning it all at once

vector_per_chunk

If streaming, how many vectors per chunk we should emit

return_table

If we return results as a list of RecordBatches or an Arrow Table

n

maximum number of records to retrieve per fetch. Use n = -1 or n = Inf to retrieve all pending records. Some implementations may recognize other special values.

dbObj

An object inheriting from '>DBIObject, i.e. '>DBIDriver, '>DBIConnection, or a '>DBIResult

params

A list of bindings, named or unnamed.