Re: Column not found exception while running SqlQuery i Ignite.

Hello begineer, Please use the same type for parameter as property type for example Date startdate = new Date(2016, 03, 03); -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Column-not-found-exception-while-running-SqlQuery-i-Ignite-tp6464p6467.htm

Re: Create cache configuration error

Hi deleerhai Could you show source and class hierarchy for ContractInfo. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Create-cache-configuration-error-tp6218p6226.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: sql query large data set which is larger than memory

HI November, Please look at memory parameters JVM_OPTS for server nodes. Try to use off-heap memory for cache [1] [1] http://apacheignite.gridgain.org/v1.5-b1/docs/off-heap-memory -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/sql-query-large-data-set-which-i

Re: LoadCache

Hello Level D, I suppose you have gc performance problems. Read JVM and System Tuning [1], article which provides general recommendations on how to tune the GC and JVM. If you know cache size, good practice define it in cache configuration Also better preload cahes eqt + eqt_temp bef

Re: Cache Partitioned Mode

Hi daniel07, 1 Entity is divides on nodes according affinity key, default or user defined. It is mean data divided about 50/50. For big cache size you can get better performance. 2 Yes, see examples CacheAffinityExample and link [1] [1] http://apacheignite.gridgain.org/docs/affinity-collocation

Re: How to set isolated Ignite Clusters

Hello ght230 please replace IpFinder to Run 2 servers in console, nodes should work separately [22:32:22] Topology snapshot [ver=1, servers=1, clients=0, CPUs=4, heap=1.0GB] and [22:32:22] Topology snapshot [ver=1, servers=1, clients=0, CPUs=4, heap=1.0GB] -- View th

Re: LoadCache

Hello Level D, Could you show more detail about cache loading - sample of code and cluster configuration. What Cache configuration used, what type and size used for cache values? How many servers in the cluster and memory configuration. -- View this message in context: http://apache-ignite-us

Re: [IGFS][Semaphore] Write file concurrently from several nodes

In the code I tried reproduce you issue. I ran code in 2 IDEA sessions, the ignite work correctly without any exception. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/IGFS-Semaphore-Write-file-concurrently-from-several-nodes-tp6009p6080.html Sent from the Apach

Re: [IGFS][Semaphore] Write file concurrently from several nodes

Hello cristic83, could you add same code to https://gist.github.com/AndreyVel/bc8b5e004dc47fdd5959caacdb308b37 for reproducing issue? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/IGFS-Semaphore-Write-file-concurrently-from-several-nodes-tp6009p6055.html

Re: Strange collocated distributed set behavior

It is magic, now DistributedSetDemo for new node shows size() == 0. Since there is no backup configured for the set it’s a normal situation when the set is empty after all the nodes that held its data had left the topology. Please note, that the set as a data structure is not removed in such a c

Re: Strange collocated distributed set behavior

Hello zshamrock, I cannot reproduce you issue Scenario#1 on Ignite 1.6.0. It is strange why instance 2-3-4 prints: [local] Size of the numbers distributed set is 0, and items are [] Should be [local] Size of the numbers distributed set is 1, and items are [42] To be honest I ha

Re: How to accelerate the query speed in Partitioned Mode

It is not correct compare internal TPS and distributed networks TPS. Could you compare TPS for 2 and 4 nodes? What query do you run? How distributed selected data on cluster, is any affinity function used? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-ac

Re: Correlated Subquery Performance

H2 engine chooses index internalRobotName_idx because you have expression WHERE (S1.INTERNALROBOTNAME = 'gp1') In current H2 version it's not possible to specify index hints. You can use same tricks. For complex queries more convenient to use temp tables. CREATE TEMP TABLE IF NOT EXISTS TEMP

Re: How to get the configuration of a given cache in Apache Ignite?

Sorry, you can get ExpiryPolicy without hacking Factory factory = cacheCfg.getExpiryPolicyFactory(); ExpiryPolicy policy = factory.create(); long timeToLive = policy.getExpiryForCreation().getDurationAmount(); -- View this message in context: http://apache

Re: How to get the configuration of a given cache in Apache Ignite?

Hello yucigou, You code nice only for implementation CreatedExpiryPolicy, Ignite cache configuration has signature setExpiryPolicyFactory(Factory factory) you can create any logic for expiration, for example depends from stock market or earth shake. In such implementation TimeToLive is not defi

Re: Correlated Subquery Performance

Hello bearrito, What Execution plan in you query, indexes used? https://apacheignite.readme.io/docs/sql-queries#using-explain You query can split to 2 different query SELECT internalMissionId FROM STATEFULROBOTTELEMETRY S2 WHERE S2.internalRobotName = ? ORDER BY internalTimeStamp DESC LIMIT 1 a

Re: i have a question,asynchronous write no success

Property writeThrough missed in you config file. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/i-have-a-question-asynchronous-write-no-success-tp5869p5883.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: i have a question,asynchronous write no success

Helo liang, Could you show code example for reproducing issue? Please properly subscribe to the user list. All you need to do is send an email to ì user-subscr...@ignite.apache.orgî and follow simple instructions in the reply. -- View this message in context: http://apache-ignite-users.70518.

Re: how can I only get keySet() returned without values?

Hello elvis, Try to use select special field _key in query. Ignite stores cache keys and values as _key and _val fields, so we use this syntax in our SQL query. QueryCursor> qcur = cache.query(new SqlFieldsQuery("select _key from Person")); -- View this message in context: http://apache-ign

Re: System.exit() not exiting cleanly (locked on IgnitionEx$IgniteNamedInstance)

Coul you tell more detail how reproduce issue. What OS and java version used. How many memory has OS and how many used. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/System-exit-not-exiting-cleanly-locked-on-IgnitionEx-IgniteNamedInstance-tp5814p5870.html Sent

Re: How to accelerate the query speed in Partitioned Mode

Could you tell more details about result size, cache size. Does cache have index? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-accelerate-the-query-speed-in-Partitioned-Mode-tp5826p5850.html Sent from the Apache Ignite Users mailing list archive at Nabb

Re: System.exit() not exiting cleanly (locked on IgnitionEx$IgniteNamedInstance)

Hello bintisepaha, Try disable shared memory in config file TcpCommunicationSpi/setSharedMemoryPort(-1) Maybe Runtime.getRuntime().halt(int) can terminate the program. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/System-exit-not-exiting-cleanly-locked-on-Ign

Re: How to accelerate the query speed in Partitioned Mode

Hello ght230 Do you use setAffinityMapper to put selected rows in one partition? cacheCfg.setAffinityMapper(new AffinityKeyMapper() { @Override public Object affinityKey(Object key) { if (key instanceof PersonKey){ PersonKey det =

Re: Replicated cache leaks entries on 1.6 and 1.7-SNAPSHOT

Hi Kristian, interesting idea about inconsistent equals/hashCode could you show the code for review you can display cache statistics: cacheCfg.setStatisticsEnabled(true); ... System.out.println("cache.metrics: " + cache.metrics());

Re: Performance Degredation when adding more nodes

Hello thammoud, Try to use affinity feature for cache. For given accountId all PIDDetails better place in one node. Example: cacheCfg.setAffinityMapper(new AffinityKeyMapper() { @Override public Object affinityKey(Object key) { if (keyinstanceof PIDDetails){ PIDDetails

Re: Performance Degredation when adding more nodes

Hello thammoud, Every operation cache.put() takes network roundtrip, by this reason performance of single operation depends on client network adapter. Try to use IgniteDataStreamer for bulk loading. Example: try (IgniteDataStreamer stmr = Ignition.ignite().dataStreamer(cache.getName()))