Moving a folder when deployed on Kubernetes

2018-02-15 Thread Stéphane Thibaud
Hello! I am wondering how I should move the folder as suggested on https://apacheignite-tools.readme.io/docs/getting-started#ignite-web-agent , when I have deployed on Google Cloud’s Kubernetes using this guide: https:

Re: Failed to parse query

2018-02-15 Thread Stéphane Thibaud
Thank you for your answer! I put the device table creation in a play framework ‘evolution’: # --- !Ups CREATE TABLE device ( id VARCHAR, secret VARCHAR, name VARCHAR, updated_at TIMESTAMP, created_at TIMESTAMP, PRIMARY KEY (id) ); # --- !Downs DROP TABLE device; The ‘ups’ part should

Re: Failed to parse query

2018-02-15 Thread Stéphane Thibaud
Thank you for your answer! I am not sure about the cache name. Where would I have created this cache? The ‘first ignite sql application does not mention it either. Wouldn’t the table creation suffice? I have also looked at the logs of the kubernetes node and saw this: ignite-node <> 2018-02-16T0

RE: Affinity Key Annotation

2018-02-15 Thread Williams, Michael
Imagine, for example, I have four keys: Public class ThingOneKey { @QuerySqlField @AffinityKeyMapped int recordNo; ... } Public class ThingTwoKey { @QuerySqlField @AffinityKeyMapped int recordNo; @QuerySqlField Date birthday

Re: Affinity Key Annotation

2018-02-15 Thread vkulichenko
Mike, Not sure I understand a question.. Can you show an example of your data model and clarify what kind of collocation strategy you want to achieve? -Val -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: BinaryInvalidTypeException

2018-02-15 Thread Alexey Kukushkin
1. Peer class loading is applicable only to computational code and not to the cache key and value types. In your case enabling peer class loading helped you to auto-deploy your IgniteCallable but it is not supposed to auto-deploy your Person cache value type. 2. You can avoid manuall

Re: Table creation in Ignite

2018-02-15 Thread Prasad Bhalerao
Hello Mikhail, Thank you for the clarification. But still little confusion. Please correct me if I am wrong. Simple scenario, I create a table in ignite and then map it to some Java pojo. Now if I query the cache using SQL, ignite will just deserialize the part pojo which is mentioned in where cl

Affinity Key Annotation

2018-02-15 Thread Williams, Michael
Assume I have 4 integers tagged with @AffinityKeyMapped in different data structures. How does Ignite determine which correspond to affinity pairs? EG, if I wanted two pairs that have a mutual affinity, how would ignite know which to pair, or would all be paired together? Thanks, Mike

Re: BinaryInvalidTypeException in IgniteCallable

2018-02-15 Thread risbarov
Exception: ... Caused by: class org.apache.ignite.binary.BinaryInvalidTypeException: test.ignite.Person ... Caused by: java.lang.ClassNotFoundException: test.ignite.Person -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: BinaryInvalidTypeException in IgniteCallable

2018-02-15 Thread risbarov
Rubber duck debugging is working . I understood my issue: I still use my domain model class in IgniteCallable instead of BinaryObject. In my real project we have large and complex domain model and it would be inconvenient to work with each type as BinaryObject. Is there a way to use my domain clas

Re: BinaryInvalidTypeException in IgniteCallable

2018-02-15 Thread Mikhail
Hi Looks like you forgot to add the exception that you to the mail. Could you please send it to us? Thanks, Mike. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Table creation in Ignite

2018-02-15 Thread Mikhail
Hi Prasad, >Does it mean that it stores the data in table as well as in key value cache? I meant to say that does it duplicates the data? There's no data duplication, everything is stored in ignite cache only. SQL is just another way access to data. Plus SQL provides indices. >In which format

BinaryInvalidTypeException

2018-02-15 Thread risbarov
Hello dear support team! My problem is similar to http://apache-ignite-users.70518.x6.nabble.com/Issue-while-using-Affinity-function-for-mapping-keys-with-nodes-td9580.html

Re: Ignite performance

2018-02-15 Thread luqmanahmad
Hi Val, Thanks for the quick response. I was checking at the network throughput for the redis cache for one minute and the traffic is around 5GB, I can bet it is not optimised, with one farm which has got 10 nodes. Lets say if we have an Ignite cluster of 100 nodes how you would and check the ma

Re: Table creation in Ignite

2018-02-15 Thread Prasad Bhalerao
Hi, As per this https://apacheignite-sql.readme.io/docs/create-table link, The CREATE TABLE creates a new Ignite cache and defines an SQL table on top of it. The cache stores the data in the form of key-value pairs while the table allows processing the data with SQL queries. Does it mean that i

Table creation in Ignite

2018-02-15 Thread Prasad Bhalerao
Hi, As per this https://apacheignite-sql.readme.io/docs/create-table link, The CREATE TABLE creates a new Ignite cache and defines an SQL table on top of it. The cache stores the data in the form of key-value pairs while the table allows processing the data with SQL queries. Does it mean that i

Re: Failed to parse query

2018-02-15 Thread Mikhail
Hi Stéphane, I believe a good description of the error you will find in server node log. You need to specify a schema for your query, like this: insert into "cache_name".device(id, secret, updated_at, created_at) there's the existent ticket for error message improvement, I added this thread a

Re: Failed to parse query

2018-02-15 Thread Вячеслав Коптилин
Hi Stéphane, The parametrized queries are supported by the thin JDBC driver. Could you please share a code snippet that illustrates table 'device' creation and JDBC driver using? Please provide the log from the server node. It should contain additional details about the issue. Thanks, Slava.

Re: Kubernetes discovery with readinessProbe

2018-02-15 Thread dkarachentsev
Hi Bryan, You need to use StatefulSet [1], Kubernetes will start nodes one-by-one when each comes in a ready state. [1] https://kubernetes.io/docs/concepts/workloads/controllers/statefulset/ Thanks! -Dmitry -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: 100% Consistency

2018-02-15 Thread Alexey Kukushkin
It is fully consistent only in "full sync" backup update mode but not in "primary sync" or "async" modes. Relaxing consistency requirements would give you better performance. Consider if your app really needs full consistency and configure the backup update mode correspondingly.

Failed to parse query

2018-02-15 Thread Stéphane Thibaud
Hello! I am trying to convert our Play Framework application to use Apache Ignite. I encountered a failure to parse an existing query, but I do not see what is so special about this query: java.sql.SQLException: Failed to parse query: insert into device(id, secret, updated_at, created_at)

Hortonworks HDP Installation without IGFS

2018-02-15 Thread Sparsh Singhal
I have a 10 node cluster with 1 edgenode (for ambari), 1 namenode and 8 datanode. I want to integrate Ignite for HDP and for Yarn without IGFS (mainly for In-Memory MapReduce). I set up everything using official docs on namenode, and started the ignite node. It blocks the shell and then I couldn'