SQL Query - Standard Devation

2016-05-19 Thread vineet
Hello,I was wondering if the SQL standard deviation functions STDDEV_POP and STDDEV_SAMP are supported. I did give it a try and got an ArrayIndexOutOfBounds exception (v 1.5.0):Caused by: java.lang.ArrayIndexOutOfBoundsException: 8 at

Re: Persistence using Cassandra

2016-05-19 Thread ChickyDutt
Thank you for the reply. Meanwhile could you illuminate on the XML configuration details for a node to operate with read and write through behaviours on Cassandra? Please let me know if you need any further information. Regards Ashish Sharma. On 19 May 2016 4:23 p.m., "Alexey Kuznetsov [via

SQL - SELECT clean rows

2016-05-19 Thread tomk
Hi, In my case I am caching database postgresql. Then, I want to query it via JDBC. It is working for me. One thing that bother me is format of returned rows. I wouldnt like to see key there (only value). How to lock returning Key by JDBC ? -- View this message in context:

Efficiency worse than postgresql. Why ?

2016-05-19 Thread tomk
Hello, I measure time of time: number of rows is 15 000, using JDBC in both cases. My case is such that ignite is cache of postgresql. Entire database is loaded to cache (ignitevisorcmd shown 15 000 rows in cache scan). Ignite SELECT COUNT(*): 53ms. SELECT *:290 ms Postgresql SELECT COUNT(*):

Re: Cancel tasks on Ignite compute grid worker nodes

2016-05-19 Thread fs12345
Hi, Thank you for your help. I have tried activeTaskFutures() and was able to cancel tasks that way. Regards, -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Cancel-tasks-on-Ignite-compute-grid-worker-nodes-tp5027p5039.html Sent from the Apache Ignite

Re: Failed to execute compound future reducer: Compound future listener []class org.apache.ignite.IgniteCheckedException

2016-05-19 Thread vkulichenko
Hi, Can you please properly subscribe to the mailing list so that the community can receive email notifications? Here is the instruction: cmnaik wrote > Hi, I am using data streamer for cache update, and using kafka to > integrate with streamer to update cache with incoming data, it works fine

Re: IgniteCache method replace(key,newVal) behave different with replace(key,oldVal,newVal)

2016-05-19 Thread vkulichenko
Hi, This trace is still not full. There should be also the root cause which happened on primary node and should be attached to this one. If it's not the case, please also check server node logs. -Val -- View this message in context:

Re: Error creating IgniteContext - Ignite instance with provided name doesn't exist.

2016-05-19 Thread vkulichenko
Hi, When IgniteContext is created it applies the following strategy: 1) First it checks whether Ignite instance is already started in the process using node name defined in configuration. 2) If failed, it tries to start a node. Exception handling in 1.5 is not ideal in this place because Ignite

Re: Cancel tasks on Ignite compute grid worker nodes

2016-05-19 Thread vkulichenko
In addition there is IgniteCompute.activeTaskFutures() method that returns all currently running tasks executed by current node. You can also use these futures to cancel tasks. Also note that you can only cancel the whole task (which as usually a set of several job executed on server nodes). Once

Re: Cancel tasks on Ignite compute grid worker nodes

2016-05-19 Thread vdpyatkov
Hello, My first answer is corrupted. I duplicate it again I would used support asynchronous operation, and cancel IgniteFuture if needed. For example: 1) Create cluster group by attribute cg = cluster.forAttribute("ROLE", "worker"); 2) Make compute async c = igniteClient.compute(cg).withAsync()

Re: Cancel tasks on Ignite compute grid worker nodes

2016-05-19 Thread vdpyatkov
fs12345 wrote > Hi all, > > Let me start by saying I am quite a novice with Apache Ignite. > > Here is my question : I want to be able to monitor and cancel tasks > running or that are going to run on worker nodes of an Ignite Cluster (say > for example if one task takes too long to complete),

Re: Persistence using Cassandra

2016-05-19 Thread Alexey Kuznetsov
Hi Chicky D.! Cassandra cache store was merged into upcoming ignite-1.6 release. ignite-1.6 is under voting process right now and may be released next week. JIRA issue for that store: https://issues.apache.org/jira/browse/IGNITE-1371 But you may already try latest nightly build. See

Persistence using Cassandra

2016-05-19 Thread ChickyDutt
Hi Team, I am trying to implement cache store persistence in Cassandra. Is their any Cassandra specific module available off the shelf or any ignite provided utilities that could help me binf the two? Please let me know if you need any further information. Regards, Chicky D. -- View this

Re: AWS Autoscaling

2016-05-19 Thread vdpyatkov
Hello dilipramji, You can use TcpDiscoveryS3IpFinder for AWS or TcpDiscoveryCloudIpFinder for adding nodes to cluster. Also see the articles: https://apacheignite.readme.io/docs/aws-config https://apacheignite.readme.io/docs/generic-cloud-configuration dilipramji wrote > Hi, > > Does

Re: database caching using php

2016-05-19 Thread vkulichenko
Hi, Can you please properly subscribe to the mailing list so that the community can receive email notifications? Here is the instruction: http://apache-ignite-users.70518.x6.nabble.com/mailing_list/MailingListOptions.jtp?forum=1 Jewel wrote > I need to know how many features of apache ignite I

read through not work

2016-05-19 Thread Zhengqingzheng
Hi there, I am trying to load a data record via read through method from cache. My cache configuration set read through to true, my cache key is an object with 5 fields, 2 of them might be null. When I called the following functions : IgniteCache binaryCache =

Cancel tasks on Ignite compute grid worker nodes

2016-05-19 Thread fs12345
Hi all, Let me start by saying I am quite a novice with Apache Ignite. Here is my question : I want to be able to monitor and cancel tasks running or that are going to run on worker nodes of an Ignite Cluster (say for example if one task takes too long to complete), and without using Visor. I