Description Usage Arguments Value Examples
Ensure sqlQuery constructed meets limits namely max size(1MB) and max nestings(140-147)
1 | ensureQuerySize(pResult, pInput, pOperator, pStoreResult = FALSE, ...)
|
pResult |
object whose constructSelect needs to be within limits |
pInput |
list of input objects |
pOperator |
function which generated the pResult |
pStoreResult |
Flag whether to store the pResult |
pResult after storing transparently inputs and recomputing the operation
1 2 3 4 5 6 7 8 | cat("Below Example shows how expressions with number of nested queries exceeding the limit are handled:")
flm <- FLMatrix("tblmatrixMulti",3,"Matrix_id","ROW_ID","COL_ID","CELL_VAL")
flv <- as.FLVector(rnorm(25))
vexpression <- paste0(rep("flm+flv",17),collapse="+")
cat(vexpression)
cat("no.of Nested Queries: ",length(gregexpr("FROM",constructSelect(eval(parse(text=vexpression))))[[1]]))
vResult <- eval(parse(text=vexpression))
cat("no.of Nested Queries in Result: ",length(gregexpr("FROM",constructSelect(vResult))[[1]]))
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.