unionSQLDataFrame: Union of 'SQLDataFrame' objects

Description Usage Arguments Value Examples

Description

Performs union operations on SQLDataFrame objects.

Usage

1
2
## S4 method for signature 'SQLDataFrame,SQLDataFrame'
union(x, y, copy = FALSE)

Arguments

x

A SQLDataFrame object.

y

A SQLDataFrame object.

Value

A SQLDataFrame object.

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
obj1 <- SQLDataFrame(dbname = "inst/extdata/test.db",
                     dbtable = "state",
                     dbkey = c("region", "population"))
obj2 <- SQLDataFrame(dbname = "inst/extdata/test1.db",
                     dbtable = "state1",
                     dbkey = c("region", "population"))
obj1_sub <- obj1[1:10, 2:3]
obj2_sub <- obj2[8:15,2:3]

## union
res_union <- union(obj1_sub, obj2_sub)  ## sorted
dim(res_union)

Liubuntu/SQLDataFrame documentation built on May 17, 2019, 7:43 a.m.