Re: How to get the column names(or fieldsNames) of existing ignite sql table

Hi , Thank You for Reply, *And for question 2, I think, yes, from my learning, SQL Create Table always create another cache with default naming like SQL_PUBLIC_ . But according to manual, you can override the name by supplying options after "with".* IgniteCache cache = ignite.getOrCreateCache(

Re: How to get the column names(or fieldsNames) of existing ignite sql table

Hi , *And for question 2, I think, yes, from my learning, SQL Create Table always create another cache with default naming like SQL_PUBLIC_ . But according to manual, you can override the name by supplying options after "with".* But For execute a query we should have Ignitecache object which is

Re: Ignite Authentication

Hi Denis, Sorry for comming late on this topic. I have written a custom plugin and was to able to load. Can you please help in answering the below queries: 1. GridSecurityProcessor interface is used only for authorization or for Authentication also? 2. Can we provide custom IgniteAuthenticationP

Re: java.lang.ClassCastException: org.apache.ignite.internal.pagemem.impl.PageMemoryNoStoreImpl

Hi Ilya, Thank you for your reponse. Any configuration I choose, like the one below, http://www.springframework.org/schema/beans"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springfram

Re: NearCache entries on heap ?

Hi, Can anyone help me on the same ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Simple off heap implementation ?

Hi All, I am an extensive user of Apache Ignite and it has worked well for me in many scenarios. I was going through the documentation of https://apacheignite.readme.io/docs/cache-modes#local-mode As mentioned in the documentation it

Re: New added property with @QuerySqlField does not persist

i noticed there is a comment from @slava.koptilin > I think the problem is to support dynamic update of fields in QueryEntity. I am afraid that there is no plan to support that. At least, I didn't find a ticket in JIRA. is there any plan to add this feature? it's obviously with the system go

New added property with @QuerySqlField does not persist

My case is very similar with this one http://apache-ignite-users.70518.x6.nabble.com/SQL-cannot-find-data-of-new-class-definition-td22081.html I add the new column(property) via sql as addressed in the http://apache-ignite-users.70518.x6.nabble.com/SQL-cannot-find-data-of-new-class-definition-

Re: Ignite.Net - Defining SQL Schema without using QuerySqlField custom attribute

Sure. Hope this won't get too long and will still be readable from e-mail, and thank you for helping.  Really appreciate it. using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using Apache.Ignite.Core;using Apache.Ignite.Core.Cache;usi

Re: ZookeeperDiscovery block when communication error

Hello Wangsan, Seems it's known issue https://issues.apache.org/jira/browse/IGNITE-9493 . пн, 12 нояб. 2018 г. в 18:06, wangsan : > I have a server node in zone A ,then I start a client from zone B, Now > access > between A,B was controlled by firewall,The acl is B can access A,but A can > not a

Re: SQL 'affinityKey' or 'AFFINITY_KEY"

I asked the same question in Gitter awhile back, here was the response: > it doesn't matter, Ignite understand both. affinity_key was added later, I think affinitykey was treated as typo > private static final String PARAM_AFFINITY_KEY_OLD = "AFFINITYKEY"; > private static final String PARAM_AFFIN

Re: Ignite.Net - Defining SQL Schema without using QuerySqlField custom attribute

Hi, can you please attach a minimal runnable project that reproduces the issue? On Fri, Nov 16, 2018 at 4:08 AM Peter Sham wrote: > Hello, > > I’m trying to learn Ignite.Net and has been following examples bundled > with source or binary distribution. However, when I try to define SQL > Schema

Re: JDBC Streaming

Hi Ilya, Tried executing SQL statement - 'SET STREAMING ON' from code, but this produces an exception. Here is my table definition: CREATE TABLE public.test_data ( pk LONG, id LONG, k VARCHAR, v VARCHAR, PRIMARY KEY (pk, id)) WITH "TEMPLATE=PARTITIONED, BACKUPS=1, ATOMICITY=TRANSACTIONAL, W

Re: how to do hibernate configuration for Apache ignite database

Hello! I'm pretty sure you had a working example at http://apache-ignite-users.70518.x6.nabble.com/how-to-do-i-hibernate-configuration-for-Apache-ignite-database-td24946.html#a24957 Regards, -- Ilya Kasnacheev сб, 17 нояб. 2018 г. в 15:46, Malashreepolo : > How to Configure Spring XML file fo

Re: how to do i hibernate configuration for Apache ignite database

Hello! Have you tried H2Dialect? Ignite's SQL is based on H2 so it should be a good fit. Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Does a Ignite Cache return size metrics for a cache in local mode

I posted this on Stack Overflow a while back, but this is probably a better place for the question. It seems like Ignite does not return the cache size metrics for a cache in local mode. The code I used to test this in Ignite 2.6 is: IgniteConfiguration igniteConfig = new IgniteConfiguration()

Re: java.lang.ClassCastException: org.apache.ignite.internal.pagemem.impl.PageMemoryNoStoreImpl

Hello! This may be to https://issues.apache.org/jira/browse/IGNITE-7731 Looks like it's still unresolved. However, I can see that you don't have persistenceEnabled=true in your config. I recommend setting this property, retrying. See https://apacheignite.readme.io/docs/distributed-persistent-sto

Re: SQL 'affinityKey' or 'AFFINITY_KEY"

Hello! I think it's AFFINITY_KEY. Have you tried either one? I think Ignite will complain if there's invalid input. Regards, -- Ilya Kasnacheev вс, 18 нояб. 2018 г. в 10:45, joseheitor : > What is the correct syntax for the affinity key parameter in the WITH > clause > in a CREATE TABLE SQL s

Re: JDBC Streaming

Hello! Have you tried force-flushing by doing SET STREAMING OFF; SET STREAMING ON; every once in a while? If this does not help, can you post a small reproducer on github? Regards, -- Ilya Kasnacheev вс, 18 нояб. 2018 г. в 10:43, joseheitor : > JDBC Client connection URL with 'streaming=true