array.len: Get the length of the array in an array column

Description Usage Arguments Value Author(s) See Also Examples

View source: R/method-as.list_.R

Description

The column of a table in database can be an array. This function measures the length of the array.

Usage

1

Arguments

x

A db.obj object.

Value

An integer, which is the length of the array.

Author(s)

Author: Predictive Analytics Team at Pivotal Inc.

Maintainer: Frank McQuillan, Pivotal Inc. [email protected]

See Also

db.array combines columns of a table/view into an array.

as.list expands the db.obj columns into a list of separated db.Rquery objects.

cbind2 and cbind combine multiple db.obj objects into one db.obj object.

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
## Not run: 



## set up the database connection
## Assume that .port is port number and .dbname is the database name
cid <- db.connect(port = .port, dbname = .dbname, verbose = FALSE)

delete("abalone", conn.id = cid)
x <- as.db.data.frame(abalone, "abalone", conn.id = cid, verbose = FALSE)
y <- db.array(x[-2]) # put columns into an array
names(y) # "agg_opr"
array.len(y$agg_opr) # 9

db.disconnect(cid, verbose = FALSE)

## End(Not run)

PivotalR documentation built on May 30, 2017, 8:18 a.m.