This is the type of queries I run to do the analytics I need. It may seem crazy. But it is, what it is... :)
String unionPrefix = "UNION SELECT \"" + CACHE_NAME + "\".MyExtPrimModel._key, \"" + CACHE_NAME + "\".MyExtPrimModel._val FROM MyExtPrimModel "; String sqlStr = "SELECT * FROM MyExtPrimModel WHERE field1 = ? " + unionPrefix + "WHERE field2 = ?" + unionPrefix + "WHERE field3 = ? " + unionPrefix + "WHERE field4 = ? " + unionPrefix + "WHERE field5 = ? " + unionPrefix + "WHERE field6 = ? " + unionPrefix + "WHERE field7 = ? " + unionPrefix + "WHERE field8 = ? " + unionPrefix + "WHERE field9 = ? "; If we can squeeze out even more performance and make ignite even faster then awesome. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Btw-anyone-heard-of-CQ-engine-tp1421p1447.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
