/** * Test metrics for Scan queries. * * @throws Exception In case of error. */ @Test public void testSqlQueryHistoryNotFullyFetched() throws Exception { SqlQuery<Integer, String> qry = new SqlQuery<>("String", "from String"); qry.setPageSize(10); checkQueryNotFullyFetchedMetrics(qry, true); }
new SqlQuery<Integer, Person>(Person.class, "id >= ?").setArgs(minId).setPageSize(pageSize) );
/** * Test two step query without local reduce phase. */ @Test public void testTwoStepSkipReduceSqlQuery() { IgniteCache<Integer, Value> cache = grid(0).cache(DEFAULT_CACHE_NAME); List<Cache.Entry<Integer, Value>> all = cache.query( new SqlQuery<Integer, Value>(Value.class, "select * from Value").setPageSize(3)).getAll(); assertEquals(KEYS, all.size()); for (Cache.Entry<Integer, Value> entry : all) entry.getValue().str = "after"; check(cache); }
/** * Test metrics for Scan queries. * * @throws Exception In case of error. */ @Test public void testSqlQueryNotFullyFetchedMetrics() throws Exception { IgniteCache<Integer, String> cache = grid(0).context().cache().jcache("A"); SqlQuery<Integer, String> qry = new SqlQuery<>("String", "from String"); qry.setPageSize(10); checkQueryNotFullyFetchedMetrics(cache, qry, true); }
/** * Ctor. * * @param reader Reader. */ public ClientCacheSqlQueryRequest(BinaryRawReaderEx reader) { super(reader); qry = new SqlQuery(reader.readString(), reader.readString()) .setArgs(PlatformCache.readQueryArgs(reader)) .setDistributedJoins(reader.readBoolean()) .setLocal(reader.readBoolean()) .setReplicatedOnly(reader.readBoolean()) .setPageSize(reader.readInt()) .setTimeout((int) reader.readLong(), TimeUnit.MILLISECONDS); }
/** * Test metrics for Sql queries. * * @throws Exception In case of error. */ @Test public void testSqlQueryNotFullyFetchedMetrics() throws Exception { IgniteCache<Integer, String> cache = grid(0).context().cache().jcache("A"); SqlQuery qry = new SqlQuery<>("String", "from String"); qry.setPageSize(10); checkQueryNotFullyFetchedMetrics(cache, qry, true); }
/** * Reads sql query. * * @param reader Binary reader. * @return Query. */ private Query readSqlQuery(BinaryRawReaderEx reader) { boolean loc = reader.readBoolean(); String sql = reader.readString(); String typ = reader.readString(); final int pageSize = reader.readInt(); Object[] args = readQueryArgs(reader); boolean distrJoins = reader.readBoolean(); int timeout = reader.readInt(); boolean replicated = reader.readBoolean(); return new SqlQuery(typ, sql) .setPageSize(pageSize) .setArgs(args) .setLocal(loc) .setDistributedJoins(distrJoins) .setTimeout(timeout, TimeUnit.MILLISECONDS) .setReplicatedOnly(replicated); }
cache.query(new SqlQuery<Integer, Integer>(Integer.class, "_key >= 0 order by _key").setPageSize(10));
/** * @param cache Ignite cache. * @throws Exception If failed. */ private void testPaginationIterator(IgniteCache<Integer, Integer> cache) throws Exception { for (int i = 0; i < 50; i++) cache.put(i, i); SqlQuery<Integer, Integer> qry = new SqlQuery<>(Integer.class, "_key >= 0"); qry.setPageSize(10); QueryCursor<Cache.Entry<Integer, Integer>> q = cache.query(qry); int cnt = 0; for (Cache.Entry<Integer, Integer> e : q) { assertTrue(e.getKey() >= 0 && e.getKey() < 50); assertTrue(e.getValue() >= 0 && e.getValue() < 50); cnt++; } assertEquals(50, cnt); }
qry.setPageSize(1);
qry.setPageSize(1);
/** * Ctor. * * @param reader Reader. */ public ClientCacheSqlQueryRequest(BinaryRawReaderEx reader) { super(reader); qry = new SqlQuery(reader.readString(), reader.readString()) .setArgs(PlatformCache.readQueryArgs(reader)) .setDistributedJoins(reader.readBoolean()) .setLocal(reader.readBoolean()) .setReplicatedOnly(reader.readBoolean()) .setPageSize(reader.readInt()) .setTimeout((int) reader.readLong(), TimeUnit.MILLISECONDS); }
/** * Reads sql query. * * @param reader Binary reader. * @return Query. */ private Query readSqlQuery(BinaryRawReaderEx reader) { boolean loc = reader.readBoolean(); String sql = reader.readString(); String typ = reader.readString(); final int pageSize = reader.readInt(); Object[] args = readQueryArgs(reader); boolean distrJoins = reader.readBoolean(); int timeout = reader.readInt(); boolean replicated = reader.readBoolean(); return new SqlQuery(typ, sql) .setPageSize(pageSize) .setArgs(args) .setLocal(loc) .setDistributedJoins(distrJoins) .setTimeout(timeout, TimeUnit.MILLISECONDS) .setReplicatedOnly(replicated); }