ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sujay_kb@ymail.com" <sujay...@ymail.com>
Subject Re: Date compare fetch in the Query
Date Wed, 02 Mar 2016 02:41:15 GMT
*Config:*

CacheConfiguration<Object, Object>  cacheConfig = new
CacheConfiguration<>(cacheName);
		cacheConfig.setCacheMode(CacheMode.PARTITIONED);
		cacheConfig.setMemoryMode(CacheMemoryMode.OFFHEAP_TIERED);
		cacheConfig.setExpiryPolicyFactory(CreatedExpiryPolicy.factoryOf(new
Duration(TimeUnit.MINUTES, 40)));
		cacheConfig.setEvictionPolicy(new LruEvictionPolicy(2500));
		cacheConfig.setOffHeapMaxMemory(0);
		cacheConfig.setSwapEnabled(false);
		cacheConfig.setBackups(1);
		cacheConfig.setStoreKeepBinary(false);
		//cacheConfig.setWriteBehindEnabled(true);
	
cacheConfig.setWriteSynchronizationMode(CacheWriteSynchronizationMode.FULL_SYNC);
		cacheConfig.setAtomicityMode(CacheAtomicityMode.ATOMIC);
		cacheConfig.setIndexedTypes(String.class, Container.class);

*Model Object:*

public class Container implements Serializable {
	
	private static final long serialVersionUID = 1L;

	@QuerySqlField
	private String key;
	
	@QuerySqlField
	private Long counter;
	
	private String objectType;
	
	@QuerySqlField
	private Date updatedDate;
	
	private byte[] data;




This is the Code Details i am using, i am not getting exception..I tired
with other Fields also Filter is not working at all

code is running as Client Mode, I have one Ignite Server running in other
linux machine



And I tried other SqlQuery options, those also failing with Below Exception:
/*
select * from PB_PRICE.Container where counter >= 1456885117000 and counter
<= 1456885127000*/

javax.cache.CacheException: Failed to run reduce query locally.
Total Count:0
	at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:673)
	at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$2.iterator(IgniteH2Indexing.java:956)
	at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:61)
	at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$3.iterator(IgniteH2Indexing.java:990)
	at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:61)
	at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.getAll(QueryCursorImpl.java:73)
	at com.staples.catalog.dal.DataAccessLayer.getAll(DataAccessLayer.java:97)
	at com.staples.catalog.service.CacheService.getAll(CacheService.java:124)
	at
com.staples.catalog.processor.CacheProcessor.getAll(CacheProcessor.java:67)
	at com.staples.catalog.api.CacheApi.getAll(CacheApi.java:67)
	at
com.staples.catalog.main.price.pb.TestPBTimeFetch.execute(TestPBTimeFetch.java:58)
	at
com.staples.catalog.main.price.pb.TestPBTimeFetch.main(TestPBTimeFetch.java:45)
Caused by: java.lang.NullPointerException
	at
org.apache.ignite.internal.processors.query.h2.twostep.GridMergeIndexUnsorted$1.hasNext(GridMergeIndexUnsorted.java:97)
	at
org.apache.ignite.internal.processors.query.h2.twostep.GridMergeIndex$IteratorCursor.next(GridMergeIndex.java:327)
	at
org.apache.ignite.internal.processors.query.h2.twostep.GridMergeIndex$FetchingCursor.next(GridMergeIndex.java:358)
	at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:614)
	... 11 more 



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Date-compare-fetch-in-the-Query-tp3308p3328.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message