BQResult-class: Class "BQResult"

Description Objects from the Class Extends Methods Examples

Description

Incapsulates information regarding a specific query, including query statement, result, and result metadata.

Objects from the Class

Results can be created by querying the BigQuery database, either with dbSendQuery(conn, ...) or dbGetQuery(conn, ...)

Extends

Class "DBIResult", directly. Class "BQObject", directly. Class "DBIObject", by class "DBIResult", distance 2. Class "dbObjectId", by class "BQObject", distance 2.

Methods

dbClearResult

signature(res = "BQResult"): ...

dbColumnInfo

signature(res = "BQResult"): ...

dbGetInfo

signature(dbObj = "BQResult", what="character"): ...

dbGetStatement

signature(res = "BQResult"): ...

fetch

signature(res = "BQResult"): ...

summary

signature(object = "BQResult", what="character"): ...

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
 ## Not run: 
    result <- dbSendQuery(conn, "SELECT word FROM [bigquery/samples/shakespeare]
                                 WHERE word CONTAINS 'raisin'")
    summary(result)
    data <- fetch(result)
    
    ## or to get data directly, use
    data <- dbGetQuery(conn, "SELECT word FROM [bigquery/samples/shakespeare]
                              WHERE word CONTAINS 'raisin'")

## End(Not run)

RBigQuery documentation built on May 2, 2019, 5:09 p.m.