/** * Execute query on the given cache. * * @param node Node. * @param qry Query. * @return Cursor. */ private static FieldsQueryCursor<List<?>> execute(Ignite node, SqlFieldsQuery qry) { return cache(node).query(qry.setLazy(true)); }
qry.setDistributedJoins(distributedJoins); qry.setEnforceJoinOrder(enforceJoinOrder); qry.setLazy(lazy); qry.setSchema(schemaName);
qry.setDistributedJoins(distributedJoins); qry.setEnforceJoinOrder(enforceJoinOrder()); qry.setLazy(lazy()); qry.setSchema(schemaName);
sqlFieldsQry.setLazy(true).setPageSize(1);
sqlFieldsQry.setLazy(true).setPageSize(1);
.setLazy(true) .setPageSize(1);
qry.setEnforceJoinOrder(arg.isEnforceJoinOrder()); qry.setReplicatedOnly(arg.isReplicatedOnly()); qry.setLazy(arg.getLazy());
/** * Lazy query release partitions on cursor close test. * * @throws Exception If failed. */ @Test public void testLazyQueryPartitionsReleaseOnClose() throws Exception { Ignite node1 = startGrid(0); IgniteCache<Integer, Person> cache = node1.cache(PERSON_CACHE); cache.clear(); Affinity<Integer> aff = node1.affinity(PERSON_CACHE); int partsFilled = fillAllPartitions(cache, aff); SqlFieldsQuery qry = new SqlFieldsQuery("select name, age from person") .setLazy(true) .setPageSize(1); FieldsQueryCursor<List<?>> qryCursor = cache.query(qry); Iterator<List<?>> it = qryCursor.iterator(); if (it.hasNext()) it.next(); else fail("No query results."); startGrid(1); // Close cursor. Partitions should be released now. qryCursor.close(); for (Ignite ig : G.allGrids()) ig.cache(PERSON_CACHE).rebalance().get(); assertEquals("Wrong result set size", partsFilled, cache.query(qry).getAll().size()); }
/** * Reads fields query. * * @param reader Binary reader. * @return Query. */ private Query readFieldsQuery(BinaryRawReaderEx reader) { boolean loc = reader.readBoolean(); String sql = reader.readString(); final int pageSize = reader.readInt(); Object[] args = readQueryArgs(reader); boolean distrJoins = reader.readBoolean(); boolean enforceJoinOrder = reader.readBoolean(); boolean lazy = reader.readBoolean(); int timeout = reader.readInt(); boolean replicated = reader.readBoolean(); boolean collocated = reader.readBoolean(); String schema = reader.readString(); return new SqlFieldsQuery(sql) .setPageSize(pageSize) .setArgs(args) .setLocal(loc) .setDistributedJoins(distrJoins) .setEnforceJoinOrder(enforceJoinOrder) .setLazy(lazy) .setTimeout(timeout, TimeUnit.MILLISECONDS) .setReplicatedOnly(replicated) .setCollocated(collocated) .setSchema(schema); }
"where a.z between ? and ? " + "and check_scan_flag(?,true)") .setLazy(true) .setDataPageScanEnabled(DirectPageScanIndexing.expectedDataPageScanEnabled) .setArgs(1, expNestedLoops, DirectPageScanIndexing.expectedDataPageScanEnabled)
.setEnforceJoinOrder(enforceJoinOrder) .setCollocated(collocated) .setLazy(lazy) .setTimeout(timeout, TimeUnit.MILLISECONDS);
qry.setDistributedJoins(distributedJoins); qry.setEnforceJoinOrder(enforceJoinOrder); qry.setLazy(lazy); qry.setSchema(schemaName);
qry.setDistributedJoins(distributedJoins); qry.setEnforceJoinOrder(enforceJoinOrder()); qry.setLazy(lazy()); qry.setSchema(schemaName);
qry.setEnforceJoinOrder(arg.isEnforceJoinOrder()); qry.setReplicatedOnly(arg.isReplicatedOnly()); qry.setLazy(arg.getLazy());
/** * Reads fields query. * * @param reader Binary reader. * @return Query. */ private Query readFieldsQuery(BinaryRawReaderEx reader) { boolean loc = reader.readBoolean(); String sql = reader.readString(); final int pageSize = reader.readInt(); Object[] args = readQueryArgs(reader); boolean distrJoins = reader.readBoolean(); boolean enforceJoinOrder = reader.readBoolean(); boolean lazy = reader.readBoolean(); int timeout = reader.readInt(); boolean replicated = reader.readBoolean(); boolean collocated = reader.readBoolean(); String schema = reader.readString(); return new SqlFieldsQuery(sql) .setPageSize(pageSize) .setArgs(args) .setLocal(loc) .setDistributedJoins(distrJoins) .setEnforceJoinOrder(enforceJoinOrder) .setLazy(lazy) .setTimeout(timeout, TimeUnit.MILLISECONDS) .setReplicatedOnly(replicated) .setCollocated(collocated) .setSchema(schema); }
.setEnforceJoinOrder(enforceJoinOrder) .setCollocated(collocated) .setLazy(lazy) .setTimeout(timeout, TimeUnit.MILLISECONDS);