DDL should work without prefixing the schema

2018-03-15 Thread Naveen
Hi I am using ignite 2.3 I have created a table thru SQL DDL like below CREATE TABLE MAP_ASSOCIATED (PARTY_ID VARCHAR, ASSOCIATED_LIST VARCHAR, UPDATEDDATETIME TIMESTAMP, UPDATEDBY VARCHAR, PRIMARY KEY (PARTY_ID))WITH "template=partitioned,backups=1,cache_name=MAP_ASSOCIATED, value_type=com.ril.

Re:Re:RE: Re: Node can not join cluster

2018-03-15 Thread Lucky
Well, I've solved this problem. Thanks a lot.

Re: Topic based messaging

2018-03-15 Thread Dmitry Pavlov
Yes, you can have backup copies of data in caches. At the same time you can have several message listeners set up on several nodes being . About topic message instance itself, there is only one copy of message in cluster. So particlar message may be lost in some cases of node failure. This is wh

Re: Topic based messaging

2018-03-15 Thread piyush
Thanks. Can it have extra backup copies in Ignite Cluster (for HA or fault tolerance) ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Fwd: [ANNOUNCE] Apache Ignite 2.4.0 Released: Machine Learning GA and Spark DataFrames

2018-03-15 Thread Denis Magda
Igniters, Please use your social media accounts to promote the release we were working on for a while: https://twitter.com/denismagda/status/974438862465351681 It will be great if you can translate the article into your native language and publish it in your country of origin.

Understanding SQL CREATE TABLE 'WITH' Parameters?

2018-03-15 Thread joseheitor
Three questions regarding relationship of cached data to persisted data: 1) Do the settings of the parameters in the 'WITH' clause apply only to the cached data? Or also to the persisted data? 2) Can the parameters set in a CREATE TABLE 'WITH' clause be rather externally and globally set in a co

Re: Topic based messaging

2018-03-15 Thread Dmitry Pavlov
Hi, I've used this feature also, I've used it to build requests processing system with decoupled componends. Topic Based Messaging does not support persistence, so if persistable message is required than it is better to use Ignite with Kafka. Please see also related discussion at SO: https://stac

Re: QueryEntity and inheritence

2018-03-15 Thread Ralph Benchetrit
Up > > Hi, > > I have some objects that I want to put in an ignite cache and also want to > query them using jdbc sql. > I have used QueryEntity to define the mapping between object model and > relational model. > > My problem is : > > My objects uses inheritence. > "Asset" object is the paren

Kubernetes - Access Ignite Cluster Externally

2018-03-15 Thread Ryan Samo
Hey guys and gals! I have created a development environment for Ignite 2.3 Native Persistence on Kubernetes 1.9.3 and have it up and running successfully. I then attempted to activate one of my clusters via a Java client call and discovered that the TcpDiscoveryKubernetesIpFinder doesn't support th

Re: AffinityKey Configuration in order to achieve multiple joins across caches

2018-03-15 Thread StartCoding
Hi Mike, Thanks for your quick response. I am afraid denormalizing will work for me because I have just given a simple example. There are 16 tables which in that case needs to be joined into single entity. Replication was an approach I thought about and we have already considered smaller tables

Re: Topic based messaging

2018-03-15 Thread Raymond Wilson
Yes, I use it. It works well. Sent from my iPhone > On 16/03/2018, at 2:56 AM, piyush wrote: > > Has anybody used this feature ? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: AffinityKey Configuration in order to achieve multiple joins across caches

2018-03-15 Thread Mikhail
Hi, You can have only one affinity key in a class, so in your case, you need to choose the smallest table and made it replicated to avoid distributed joins. Another option is to use denormalization of you data, for example, to store Class B Class C in one class as one row. Thanks, Mike. -- S

Re: Affinity Key column to be always part of the Primary Key

2018-03-15 Thread Mikhail
Hi Naveen >If I do not have the affinity key column as part of the primary key, it does >not allow me to create the table itself. Could you please explain how it doesn't allow you create the table? is there any exceptions/errors messages? Thanks, Mike. -- Sent from: http://apache-ignite-u

Re: Partition eviction failed, this can cause grid hang. (Caused by: java.lang.IllegalStateException: Failed to get page IO instance (page content is corrupted))

2018-03-15 Thread Dmitry Pavlov
Hi Alexey, It may be serious issue. Could you recommend expert here who can pick up this? Sincerely, Dmitriy Pavlov чт, 15 мар. 2018 г. в 19:25, Arseny Kovalchuk : > Hi, guys. > > I've got a reproducer for a problem which is generally reported as "Caused > by: java.lang.IllegalStateException: F

Re: And again... Failed to get page IO instance (page content is corrupted)

2018-03-15 Thread Arseny Kovalchuk
Hi guys. I've got a reproducer that can be related. See comments http://apache-ignite-users.70518.x6.nabble.com/Partition-eviction-failed-this-can-cause-grid-hang-Caused-by-java-lang-IllegalStateException-Failed--tp19122p20524.html Sergey Sergeev, just for reference, what kind of file system do y

Re: Large durable caches

2018-03-15 Thread Larry
Hi Alexey. Were there any findings? Any updates would be helpful. Thanks, -Larry On Thu, Mar 8, 2018 at 3:48 PM, Dmitriy Setrakyan wrote: > Hi Lawernce, > > I believe Alexey Goncharuk was working on improving this scenario. Alexey, > can you provide some of your findings here? > > D. > >

Re: Partition eviction failed, this can cause grid hang. (Caused by: java.lang.IllegalStateException: Failed to get page IO instance (page content is corrupted))

2018-03-15 Thread Arseny Kovalchuk
Hi, guys. I've got a reproducer for a problem which is generally reported as "Caused by: java.lang.IllegalStateException: Failed to get page IO instance (page content is corrupted)". Actually it reproduces the result. I don't have an idea how the data has been corrupted, but the cluster node doesn

AffinityKey Configuration in order to achieve multiple joins across caches

2018-03-15 Thread StartCoding
Hi Team, Below are my java templates whose object I want to store in the Ignite Caches Class A { field1 field2 field3 } Class B { field1 field4 field5 } Class C { field5 field6 field7 } I wanted to colocate data in such a way that all instances of class A and

Re: Ignite Expiry Inconsistency with Native Persistence

2018-03-15 Thread Subash Chaturanga
Here’s my code. *public static void *main(String[] args) *throws*InterruptedException { String region = *"4GRegion"*; String cacheName = *"bar2"*; String path = *"C:**\\**dev**\\**dpsrc**\\**simple-java**\\**work"*; DataStorageConfiguration storageCfg = *new* Data

Re: Topic based messaging

2018-03-15 Thread piyush
Has anybody used this feature ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Apache ignit : Syntax error in SQL statement create table

2018-03-15 Thread Ilya Kasnacheev
Hello Guillaume! Please share your pom.xml (or other source of dependencies) since something is amiss here. In my projects h2 dependency is of proper version 1.4.195. Thanks, -- Ilya Kasnacheev 2018-03-05 16:51 GMT+03:00 guillaume : > Hello, > > thx you for your response. > > I checked my dep

Re: Affinity Key column to be always part of the Primary Key

2018-03-15 Thread Naveen
Do we have any update on this clarification regarding the affinity Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: 2.3 vs 2.4 compatibility

2018-03-15 Thread Mikael
I made a backup of the files before I deleted them so I guess I can repeat it again, I will have a look at it. Mikael Den 2018-03-15 kl. 12:18, skrev Dmitry Pavlov: Hi, It should work and data from 2.3 should be loaded by 2.4. Could you please share details? Do you have logs, and entries s

Re: 2.3 vs 2.4 compatibility

2018-03-15 Thread Dmitry Pavlov
Hi, It should work and data from 2.3 should be loaded by 2.4. Could you please share details? Do you have logs, and entries saved in persistent store? Sincerely, Dmitriy Pavlov чт, 15 мар. 2018 г. в 12:56, Mikael : > Hi! > > Are persistent storage compatible between 2.3 and 2.4 ? I upgraded to

2.3 vs 2.4 compatibility

2018-03-15 Thread Mikael
Hi! Are persistent storage compatible between 2.3 and 2.4 ? I upgraded to 2.4 and got a lot of exceptions at startup, when I deleted all the persistence files and restarted everything worked fine, no big deal, just wanted to know if it should work with 2.3 persistence files and upgrade to 2.4

Re:RE: Re: Node can not join cluster

2018-03-15 Thread Lucky
Hi, I load data from database with 192.168.63.36 node. The other node don't load data. This you can see it from default-config_60.xml and default-config.xml file. I have provide files all about this . Thank you. At 2018-03-06 16:53:49, "Stanislav Lukyanov" wrote: Hi, As Ale

Ignite cluster always throw java.lang.NoClassDefFoundError

2018-03-15 Thread 王 刚
Hi, guys. I meat an issue in ignite cluster. I am using ignite in spring-boot 1.5.8 by add ignite-core dependency 2.30. And the cluster use JDBC DiscoverySpi as cluster ipFinder. If i kill spring-boot-ignite by chance, and try to restart, ignite alaws throws an NoClassDefFoundError: java.lang.