Hi,
We are using rqEval to call a Rscript that builds AssociationRule model
We are working on a data set with approx. 1.1k rows & 10 predictors.
After the model is built successfully and when we try load the rules we get the error.
When we give confidence & support as 0.00001, with maxRuleLength - 4 it works fine and load the rules, but when we choose maxRulelength as 10 or any high value it fails with ORA -28579 error
Sql Query
SELECT *
from table(rqEval(cursor(select 1 "ore.connect" , 'DISC_WOY_15793;' as
"rhs.filter", '' as "lhs.filter" , '1805' as "model.id",'1795' as
"model.func.id",'DMModelsList' as "model.list",'IoTAppsModelsDS' as "ds.Name"
from dual), 'select cast(''a'' as varchar2(4000))
"rules", 1 as "support", 1 as "confidence", 1 as "lift", 1 as "kulc" from
dual','IOTAppsGetAssocRules'))
How can we solve the issue?
Thanks,
Pushkala