ensureQuerySize: Ensure sqlQuery constructed meets limits namely max size(1MB)...

In Fuzzy-Logix/AdapteR: Converts R syntax to SQL to provide fast analytics using in-database C++ library DB Lytix.

Description

Ensure sqlQuery constructed meets limits namely max size(1MB) and max nestings(140-147)

Usage

ensureQuerySize(pResult, pInput, pOperator, pStoreResult = FALSE, ...)

Arguments

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

Value

pResult after storing transparently inputs and recomputing the operation

Examples

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]]))

Fuzzy-Logix/AdapteR documentation built on May 6, 2019, 5:07 p.m.