SQL 'affinityKey' or 'AFFINITY_KEY"

2018-11-17 Thread joseheitor
What is the correct syntax for the affinity key parameter in the WITH clause in a CREATE TABLE SQL statement? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

JDBC Streaming

2018-11-17 Thread joseheitor
JDBC Client connection URL with 'streaming=true' runs (much faster than without) but no data is inserted into table. No errors are reported. I have two nodes with one partitioned table. Without 'streaming=true' it take around 8 hours to load 8,000,000 rows. The insert loop takes only around 8 minu

Re: Which ports does ignite cluster need to run normally?

2018-11-17 Thread Juan Carlos Franzoy
I am facing a similar problem, trying to use apache-ignite 2.6. May be, you can help me. I set up my discovering using TcpDiscoverySpi and TcpDiscoveryMulticastIpFinder: ipFinder.setMulticastGroup(228.10.10.157) ipFinder.setMulticastPort(10501) discoverySpi.setLocalPort(10502) disc

Local messaging not happening asynchronously

2018-11-17 Thread Bob Newcomer
Hello, I have a distributed app that has an ignite client instance connected to a grid. Every app registers for the same topic and uses it to broadcast information to its peers and itself to perform async work in the ignite thread pool. The handler for this topic may take several minutes to perfor

NearCache entries on heap ?

2018-11-17 Thread userx
Hi All, I have created a NearCache using the following code. Ignition.setClientMode(true); Ignite ignite = Ignition.start("example-persistent-store.xml"); ignite.cluster().active(true); NearCacheConfiguration nCfg = new NearCacheConf

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

2018-11-17 Thread Peter Sham
Hello, I don't think you can get all the tables created in a cache by SQL. I'm learning this stuff and hit the same questions and figure I can find it out by the following steps in code (I'm coding c# and don't know if the methods apply in Java). Get all cache names from IIgnite by GetCachename

Re: how to do hibernate configuration for Apache ignite database

2018-11-17 Thread Malashreepolo
How to Configure Spring XML file for Ignite Database Using org.apache.ignite.IgniteJdbcThinDriver -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: how to do hibernate configuration for Apache ignite database

2018-11-17 Thread Malashreepolo
how to configure Spring XML file for Ignite Database using org.apache.ignite.IgniteJdbcThinDriver -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Is near cache persistent ?

2018-11-17 Thread userx
Hi All, Any comments on this question ? https://apacheignite.readme.io/docs/near-caches does not categorically mention about NearCache being used in persistent mode. Though an example with an eviction policy is given and eviction policy is only

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

2018-11-17 Thread Dmitry Lazurkin
Hello. On 17.11.2018 13:25, siva wrote: > Quetions: > === > 1.How to get the existing table columnNames ? > > i am trying to use this query but its throwing exception > > *select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where > TABLE_NAME='Person'* You need query with setLocal(true). I don

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

2018-11-17 Thread siva
Hi, Creating tables using sql api IgniteCache cache = ignite.getOrCreateCache(new CacheConfiguration<>().setSqlSchema("PUBLIC").setName(cacheName)); createtableQuery = create table Person(name varchar ,id int primarykey) with "template ="Replicated". cache.query(new SqlFieldsQ