Re: SqlFieldQueries on property of custom user type

2017-02-20 Thread davida
Thanks Denis it works (forgot to add the field in app.config's queryfields collection). -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SqlFieldQueries-on-property-of-custom-user-type-tp10719p10751.html Sent from the Apache Ignite Users mailing list archive at

Re: java.lang.NoClassDefFoundError: Could not initialize class org.apache.ignite.sink.flink.IgniteSink$SinkContext$Holder

2017-02-20 Thread dkarachentsev
Is it possible to provide reproducible example? -Dmitry. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/java-lang-NoClassDefFoundError-Could-not-initialize-class-org-apache-ignite-sink-flink-IgniteSink-Sir-tp10703p10750.html Sent from the Apache Ignite Users

Ignite client doing asynchronously operation will be jammed

2017-02-20 Thread ght230
I start an Ignite server first, then start an Ignite client which do some asynchronously operations on cache. But only after several seconds, the operation jammed. Is there anything wrong about my code? public class ContinuousQuery { public static void main(String[] args) {

Re: SqlFieldQueries on property of custom user type

2017-02-20 Thread Denis Magda
It’s possible to execute queries accessing fields of inner classes. In your example you need to remove “ChildObject” prefix from the query and it will work fine: "select ParentID, ChildID from Parent where ChildID < 10” — Denis > On Feb 20, 2017, at 6:14 AM, davida

Re: Get high throughput for loading data in ignite

2017-02-20 Thread Andrey Mashenkov
Sorry for late answer. Common performance tip described in [1] and [2]. Do you have all your ignite nodes on single machine? Do you use any Virtual Environment like VmWare ESX? Ignite running inside VM can have some performance issues. Also I've notice from screenshot you provide: - almost half

Task was not deployed error

2017-02-20 Thread rflachlan
Hello, I am new to Ignite, and am stuck on something probably very basic. I have a compute job that needs to (a) run 1000 tasks; (b) calculate some statistics; (c) run another set of the same 1000 tasks (same classes, and methods, different initial parameters). The program correctly runs the

Re: ODBC configuratoin for Ignite.Net

2017-02-20 Thread Saifullah Zahid
Hi Pavel, Thanks, it worked for me. Saif On Mon, Feb 20, 2017 at 10:38 PM, Pavel Tupitsyn wrote: > Hi, > > ODBC configuration is not yet supported directly in .NET ( > https://issues.apache.org/jira/browse/IGNITE-4730), > you can configure ODBC in Spring XML file (as

Re: ODBC connection error

2017-02-20 Thread Saifullah Zahid
Thanks, it worked. On Mon, Feb 20, 2017 at 10:42 PM, Igor Sapego wrote: > Pavel already answered this question in another mail. > > Best Regards, > Igor > > On Mon, Feb 20, 2017 at 8:35 PM, Saifullah Zahid > wrote: > >> Igor, >> >> Thanks for your

Re: ODBC connection error

2017-02-20 Thread Igor Sapego
Pavel already answered this question in another mail. Best Regards, Igor On Mon, Feb 20, 2017 at 8:35 PM, Saifullah Zahid wrote: > Igor, > > Thanks for your reply, may be this is the cause of issue. > > My server configuration is in app.config file. > > How I can add

Re: ODBC configuratoin for Ignite.Net

2017-02-20 Thread Pavel Tupitsyn
Hi, ODBC configuration is not yet supported directly in .NET ( https://issues.apache.org/jira/browse/IGNITE-4730), you can configure ODBC in Spring XML file (as described in the docs: https://apacheignite.readme.io/docs/odbc-driver#section-cluster-configuration ) and then use

Re: ODBC connection error

2017-02-20 Thread Saifullah Zahid
Igor, Thanks for your reply, may be this is the cause of issue. My server configuration is in app.config file. How I can add following XML configuration in it? ... ... Thanks, Saif On Mon, Feb 20, 2017 at 10:32 PM, Igor Sapego wrote: > Hi Saif, >

getOrCreateCache hang

2017-02-20 Thread Matt Warner
I'm experiencing Ignite client hangs when calling getOrCreateCache when both are starting simultaneously. The stack trace shows the clients are hung in the getOrCreateCache method, which is why I'm focusing here. This seems like a deadlock when both clients are trying to simultaneously call

Re: ODBC connection error

2017-02-20 Thread Igor Sapego
Hi Saif, Did you take a look on [1]? You need to enable OdbcProcessor on the node side. Does it help? [1] - https://apacheignite.readme.io/docs/odbc-driver#section-cluster-configuration Best Regards, Igor On Mon, Feb 20, 2017 at 7:47 PM, Saifullah Zahid wrote: > Hi, > >

ODBC configuratoin for Ignite.Net

2017-02-20 Thread Saifullah Zahid
Hi, How I can provide ODBC configuration in app.config for Ignite.Net. I am using version 1.8. Thanks, Saif

ODBC connection error

2017-02-20 Thread Saifullah Zahid
Hi, I have installed ignite odbc driver (1.8) But I am getting following error message An error occurred: Failed to connect: 08001: Failed to establish connection with the host. Ignite server is created using ignite.net 1.8 I am trying to connect using c++ odbc example. connection string

Re: java.lang.NoClassDefFoundError: Could not initialize class org.apache.ignite.sink.flink.IgniteSink$SinkContext$Holder

2017-02-20 Thread dkarachentsev
Hi, Check that file in path igniteCfgFile that you pass to IgniteSink constructor is available. If class initialization failed NoClassDefFoundError will be thrown. Also verify if IgniteSink$SinkContext$Holder.class is present in ignite-flink-2.0.jar. -Dmitry. -- View this message in

Re: SqlFieldQueries on property of custom user type

2017-02-20 Thread davida
Hi Denis, unfortunately that did not work for me (I had problem with inner class). Let me clarify what I was trying to do. I have following classes: class Parent { int ParentID; Child ChildObject; // assume initialized } class Child { int ChildID; } Parent properly is

Re: Ignit Cache Stopped

2017-02-20 Thread Andrey Gura
Anil, No, it doesn't. Only client should left topology in this case. On Mon, Feb 20, 2017 at 3:44 PM, Anil wrote: > Hi Andrey, > > Does client ignite gc impact ignite cluster topology ? > > Thanks > > On 17 February 2017 at 22:56, Andrey Gura wrote: >> >>

Re: Ignit Cache Stopped

2017-02-20 Thread Anil
Hi Andrey, Does client ignite gc impact ignite cluster topology ? Thanks On 17 February 2017 at 22:56, Andrey Gura wrote: > From GC logs at the end of files I see Full GC pauses like this: > > 2017-02-17T04:29:22.118-0800: 21122.643: [Full GC (Allocation Failure) >

Re: Replace H2 database with MySQL within SQL Grid SQL Engine

2017-02-20 Thread zaid
Hi, Unfortunately the first query I am transforming to cache query, I encountered GROUP_CONCAT function. Please find below code snippet from ignite-indexing module: class file: GridSqlAggregateFunction line no: 84 switch (type) { case GROUP_CONCAT: throw new

Re: Pessimistic TXN did not release lock on a key, all subsequent txns failed

2017-02-20 Thread Andrey Gura
Hi, Actualy dead lock detection for pessimistic transactions was introduced in Apache Ignite 1.7 release. But anyway it is good idea to try the same code on the newest release. In case of trasaction timeout dead lock detection should be triggered and TransactionTimoutException should contain

Ignite cluster unstable when doing continuous query

2017-02-20 Thread ght230
I found Ignite cluster unstable when doing continuous query. Following is my test code. ContinuousQuery.java public class ContinuousQuery { /** Cache name. */ private static final String CACHE_NAME_INPUTDATA = "inputdata"; private static final String CACHE_NAME_UPDATEDATA