Description Usage Arguments Value Note Author(s) See Also Examples
These binary operators perform arithmetic on
db.obj
objects
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 | ## S4 method for signature 'db.obj,db.obj'
e1 + e2
## S4 method for signature 'db.obj,db.obj'
e1 - e2
## S4 method for signature 'db.obj,ANY'
e1 - e2
## S4 method for signature 'db.obj,db.obj'
e1 * e2
## S4 method for signature 'db.obj,db.obj'
e1 / e2
## S4 method for signature 'db.obj,db.obj'
e1 %% e2
## S4 method for signature 'db.obj,db.obj'
e1 %/% e2
## S4 method for signature 'db.obj,db.obj'
e1 ^ e2
## S4 method for signature 'numeric,db.obj'
e1 + e2
## S4 method for signature 'character,db.obj'
e1 + e2
## S4 method for signature 'numeric,db.obj'
e1 - e2
## S4 method for signature 'character,db.obj'
e1 - e2
## S4 method for signature 'numeric,db.obj'
e1 * e2
## S4 method for signature 'numeric,db.obj'
e1 / e2
## S4 method for signature 'numeric,db.obj'
e1 %% e2
## S4 method for signature 'numeric,db.obj'
e1 %/% e2
## S4 method for signature 'numeric,db.obj'
e1 ^ e2
## S4 method for signature 'db.obj,numeric'
e1 + e2
## S4 method for signature 'db.obj,character'
e1 + e2
## S4 method for signature 'db.obj,numeric'
e1 - e2
## S4 method for signature 'db.obj,character'
e1 - e2
## S4 method for signature 'db.obj,numeric'
e1 * e2
## S4 method for signature 'db.obj,numeric'
e1 / e2
## S4 method for signature 'db.obj,numeric'
e1 %% e2
## S4 method for signature 'db.obj,numeric'
e1 %/% e2
## S4 method for signature 'db.obj,numeric'
e1 ^ e2
|
e1, e2 |
numeric or |
db.Rquery
object, which contains the SQL query
that computes the arithmetic operations.
A meaningful expression is generated only when the
.col.data_type
is "numeric", otherwise a "NULL" value is
generated.
"-"
and "+"
support computing the arithmetic computations between dates, timestamps, times etc.
Author: Predictive Analytics Team at Pivotal Inc.
Maintainer: Frank McQuillan, Pivotal Inc. fmcquillan@pivotal.io
db.Rquery
contains a SQL query that does the
operations.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | ## Not run:
## get the help for a method
## help("+,db.obj,db.obj-method")
## 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)
## ----------------------------------------------------------------------
## create a table from the example data.frame "abalone"
delete("abalone", conn.id = cid)
x <- as.db.data.frame(abalone, "abalone", conn.id = cid, verbose = FALSE)
x$rings <- (x$rings + 2.3) * 3 # change the values
x$area <- x$length * x$height # add a new column
lk(x$area, 10) # view the actual values computed in database
fit <- madlib.lm(rings ~ area, data = x)
## ----------------------------------------------------------------------
db.disconnect(cid, verbose = FALSE)
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.