Re: Understanding SQL CREATE TABLE 'WITH' Parameters?

Hi >1) Do the settings of the parameters in the 'WITH' clause apply only to the >cached data? Or also to the persisted data? When you create a table by SQL, ignite will create a cache that with settings provided in 'WITH' clause. if by persisted data you meant ignite native persistence, then

Re: Same DDL should work table created thru DDL and table created thru Java API

Hi Naveen, If a table was created with a native api then it can be assessed only with schema prefix only. Thanks, Mike. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

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

Hi, We also got exact same error. Ours is setup without kubernetes. We are using ignite data streamer to put data into caches. After streaming aroung 500k records streamer failed with exception mentioned in original email. Thanks, Gaurav On 16-Mar-2018 4:44 PM, "Arseny Kovalchuk"

Re: Topic based messaging

thanks Dmitry. looks like i need to stick to distributed Queue as it supports replicated backup copy. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Unsubscribe

Please unsubscribe Virus-free. www.avg.com <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

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

Hi Dmitry. Thanks for you attention to this issue. I changed repository to jcenter and set Ignite version to 2.4. Unfortunately the reproducer starts with the same error message in the log (see attached). I cannot say whether behavior of the whole cluster will change on 2.4, I mean if the

Re: QueryEntity and inheritence

Hi, I put OTC and Security objects into the same cache and it is splitted into 2 tables which is actualy what i wanted. But also want to have a third table which would be a vue with all objects in the cache (Security and OTC) whith only common attributes which I understand is not supported.

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

Hi Arseny, I've observed in reproducer ignite_version=2.3.0 Could you check if it is reproducible in our freshest release 2.4.0. I'm not sure about ticket number, but it is quite possible issue is already fixed. Sincerely, Dmitriy Pavlov чт, 15 мар. 2018 г. в 19:34, Dmitry Pavlov

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

Yes, the affinity key must be part of the primary key. Welcome to my world On Fri, Mar 16, 2018 at 3:23 AM, Naveen wrote: > Hi Mike > > I have created a table called CITY > > : jdbc:ignite:thin://127.0.0.1> CREATE TABLE City ( city_id LONG PRIMARY > KEY, name

RE: How to configure a cluster as a persistent, replicated SQLdatabase

Hi Stan I was able to setup ignite with Oracle as persistent layer. However I still have one concern, the existing Oracle DMLs are not working with ignite For e.g In Oracle below is the insert statement I use insert into map_dummy (ENTITY_ID, MAPPING_ID_LIST, RELATIONSHIP,

Re: Exception while using select query

Hi Anshu, This looks like a bug that was fixed in 2.4, try to upgrade [1]. [1] https://ignite.apache.org/download.cgi Thanks! -Dmitry -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: QueryEntity and inheritence

Hi Ralf, As I understand you put OTC objects and Security object into cache and except that query to Assets will return all of these objects as Assets class is parent to OTC and Security. This is not supported. In Ignite, you will have 3 tables, one per value object class. As a workaround, you

Exception while using select query

Hi All, We have a situation where in a table has the following 3 columns say CREATE TABLE EMPLOYEES (EMPLOYEE_ID VARCHAR, EMPLOYEE_NAME VARCHAR, UPDATEDDATETIME TIMESTAMP, PRIMARY KEY (EMPLOYEE_ID, EMPLOYEE_NAME))WITH

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

Hi Mike I have created a table called CITY : jdbc:ignite:thin://127.0.0.1> CREATE TABLE City ( city_id LONG PRIMARY KEY, name VARCHAR) WITH "template=replicated"; No rows affected (0.224 seconds) Creating a table called Person with affinity key as city_id 0: jdbc:ignite:thin://127.0.0.1>

DDL should work without prefixing the schema

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,

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

Well, I've solved this problem. Thanks a lot.

Re: Topic based messaging

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