duckdb_result-class

duckdb_result

duckdb_fetch_arrow

duckdb_fetch_record_batch

dbBind__duckdb_result

dbBind,duckdb_result-method

dbClearResult__duckdb_result

dbClearResult,duckdb_result-method

dbColumnInfo__duckdb_result

dbColumnInfo,duckdb_result-method

dbFetch__duckdb_result

dbFetch,duckdb_result-method

dbGetInfo__duckdb_result

dbGetInfo,duckdb_result-method

dbGetRowCount__duckdb_result

dbGetRowCount,duckdb_result-method

dbGetRowsAffected__duckdb_result

dbGetRowsAffected,duckdb_result-method

dbGetStatement__duckdb_result

dbGetStatement,duckdb_result-method

dbHasCompleted__duckdb_result

dbHasCompleted,duckdb_result-method

dbIsValid__duckdb_result

dbIsValid,duckdb_result-method

show__duckdb_result

show,duckdb_result-method

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

internal

The DuckDB project is an embedded analytical data
management system with support for the Structured Query Language (SQL). This package includes all of
DuckDB and a R Database Interface (DBI) connector.

Hannes Muehleisen

duckdb

DBI Package for the DuckDB Database Management System

Hannes Mühleisen

Mark Raasveldt

Stichting DuckDB Foundation 

Apache Software Foundation 

PostgreSQL Global Development Group 

The Regents of the University of California 

Cameron Desrochers 

Victor Zverovich 

RAD Game Tools 

Valve Software 

Rich Geldreich 

Tenacious Software LLC 

The RE2 Authors 

Google Inc. 

Facebook Inc. 

Steven G. Johnson 

Jiahao Chen 

Tony Kelman 

Jonas Fonseca 

Lukas Fittl 

Salvatore Sanfilippo 

Art.sy, Inc. 

Oran Agra 

Redis Labs, Inc. 

Melissa O'Neill 

PCG Project contributors 

duckdb_result-class function

<dl><dt>res</dt>
<dd>Query result to be converted to a Record Batch Reader</dd>
<dt>chunk_size</dt>
<dd>The chunk size</dd>
<dt>params</dt>
<dd>A list of bindings, named or unnamed.</dd>
<dt>...</dt>
<dd>Other arguments passed on to methods.</dd>
<dt>n</dt>
<dd>maximum number of records to retrieve per fetch. Use <code>n = -1</code>
or <code>n = Inf</code>
to retrieve all pending records. Some implementations may recognize other
special values.</dd>
<dt>dbObj</dt>
<dd>An object inheriting from DBIObject,
i.e. DBIDriver, DBIConnection,
or a DBIResult</dd>
<dt>object</dt>
<dd>Any R object</dd></dl>

Arguments

DuckDB Result Set — duckdb_result-class

<dl>

<dt>res</dt>
<dd>Query result to be converted to a Record Batch Reader</dd>


<dt>chunk_size</dt>
<dd>The chunk size</dd>


<dt>params</dt>
<dd>A list of bindings, named or unnamed.</dd>


<dt>...</dt>
<dd>Other arguments passed on to methods.</dd>


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


<dt>dbObj</dt>
<dd>An object inheriting from DBIObject,
i.e. DBIDriver, DBIConnection,
or a DBIResult</dd>


<dt>object</dt>
<dd>Any R object</dd>

</dl>

DuckDB Result Set

duckdb_result-class: DuckDB Result Set

Description

Usage

Arguments