ANSI SQL scripting inside rules engine
Platform bundles with ANSI-99 compliant, horizontally scalable and fault-tolerant distributed SQL database (Apache Ignite). The distribution is provided either by partitioning the data across cluster nodes or by full replication, depending on the use case.
As a SQL database, Ignite supports all DML commands including SELECT, UPDATE, INSERT, and DELETE queries and also implements a subset of DDL commands relevant for distributed systems.
Context Variable: sql
//Update/Merge a record into a table Integer update(String table, Map<String, Object> data); //Execute a stored SQL template and return results Map<String, Object> execute(String tempateId, Map<String, Object> args); //Execute a SQL query and return results Map<String, Object> execute(String query); //Insert a record into a table Integer insert(String table, Map<String, Object> data);
Updated over 1 year ago