Re: IgniteDataStreamer

Thank you Thomas, I did not even know the star "*" makes a CacheConfiguration bean registered as a template. I am not sure Ignite has it documented anywhere.

RE: IgniteDataStreamer

Hi You can configure a template as follows: Then you can do CREATE TABLE IF NOT EXISTS MyTable ( id bigint, myValue VARCHAR, PRIMARY KEY (id) ) WITH "template=myCache, cache_name=whateverYouWant"; If you don't set "cache_name" your

Re: Purpose of cache in cache.query(Create Table ...) statement

Hi Andrey, Thank you for the information. I want to create some tables using cache.query(Create Table ...) statement. Is there any way in which I can group some of my tables in one cache? Is there any hierarchy in organizing the caches like a super cache holding some sub caches? Regards,

Re: Connection problem between client and server

Thank you very much Denis, we will give it a try and let you know, I think this should solve our problem. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: IgniteDataStreamer

I saw that method. But the 2.3 for CREATE TABLE indicates you can passing by WITH for the template. WITH - accepts additional parameters not defined by ANSI-99 SQL: TEMPLATE= - case-sensitive​ name of a cache template registered in Ignite to use as a configuration for the

Re: Limit cache size ?

Hi Val, Is there a max entry limit for a single cache by default? Is it Integer.MAX_VALUE? what will happen if the data amount reaches the limit or pass it? Thanks, Jeff -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Create BinaryObject without starting Ignite?

zbyszek, Generally, the answer is no. Binary format depends on internal Ignite context, so there is no clean way to create a binary object without starting Ignite. The code that was provided in the referenced thread is a hacky workaround which could probably worked in one of the previous

Re: Semaphore Stuck when no acquirers to assign permit

I saw a release date set for 2.4 but have not had any feedback on the jira so i wanted to check in on this. Can this make it into the 2.4 release? Thanks Tim -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: IgniteDataStreamer

I do not think there is a way to add a cache template via XML configuration file. You have to write code ignite.addCacheConfiguration(cacheTemplate) where cacheTemplate is an instance of CacheConfiguration that you reference from CREATE TABLE ... WITH "template=NAME" by NAME.

RE: SQL Error: Failed to query Ignite

I deleted everything under $IGNITE_HOME/work and it's working as expected now. I probably messed up big with all my different configuration attempts :) Again, thank you so much for your help! ./t -Original Message- From: slava.koptilin [mailto:slava.kopti...@gmail.com] Sent: mandag 15.

Re: Test Ignite Client

Hi Humphrey, Consider forcing server mode on the client https://apacheignite.readme.io/docs/clients-vs-servers#section-forcing-server-mode-on-client-nodes. Another option is to enforce bean definition registration order. You could explicitly order configurations so that server bean gets

Re: IgniteOutOfMemoryException when using putAll instead of put

Hi Larry, I am without my PC for a while. I will check the file you attached later this week. Thanks, Alexey -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Default Cache template

Hello, Cache template can be configured in the following way In that case, you should be able to create a table: CREATE TABLE TEST(id LONG, name VARCHAR, PRIMARY KEY (id)) WITH template=cachetemplate; Thanks, Slava. --

Re: Default Cache template

Hi gene, You just need to create the template in Ignite before it: https://apacheignite.readme.io/v2.1/docs/distributed-ddl#section-extended-parameters The template should be registered as the common cache, but with symbol '*' in its name. If you are not able to create it from java API or xml

Re: IgniteDataStreamer

thank you. -g -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: IgniteDataStreamer

Thank you. I've moved past this issue now and have been able to create Table/Cache's using the DDL and WITH parameters. The only issue I'm facing now is how to register a cache template that I can call using the WITH Template= -g -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Default Cache template

Hello, I'm having difficulties setting the default template while using the DDL create table. I've tried multiple ways, however I don't believe I have the register cache template part down. While trying to create any Table w/ DDL using template= I get a cache not found error. please advise.

Re: Purpose of cache in cache.query(Create Table ...) statement

Hi Shravya, This is because of Ignite API allows to run query with having some cache instance. We are going to deprecate with API and implement SQL API on higher level to avoid dummy cache creation, but anyway old API can't be dropped until next major (3.0) version due to compatibility

Re: Upgrading Ignite Persistence from 2.1 to 2.3

Hi Josephine, Just try to update ignite up to 2.3 with specifying pageSize=2048 in configuration. On Thu, Jan 11, 2018 at 2:58 PM, Josephine Barboza < josephine.barb...@nviz.com> wrote: > Hi Andrey, > > Thanks for the info. Could you also let me know how to migrate the data > from 2.1 to 2.3.

RE: SQL Error: Failed to query Ignite

Hi, > Now my question is simply, why the star? What does it do? "*" means that it is a cache template :) > I now have two "identical" caches Hmm, I cannot reproduce that behavior. Please share your Ignite configuration. Thanks! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Create BinaryObject without starting Ignite?

Hello Igniters, Is it possible to create BinaryObject without starting Ignite? I was trying the following: private static BinaryObject createPrototype() throws IgniteCheckedException { // based on

Re: Segmentation fault (JVM crash) while memory restoring on start with native persistance

Hi Arseny, Have you success with reproducing the issue and getting stacktrace? Do you observe same behavior on OracleJDK? On Mon, Jan 15, 2018 at 5:50 PM, Andrey Mashenkov < andrey.mashen...@gmail.com> wrote: > Hi Arseny, > > Have you success with reproducing the issue and getting stacktrace? >

Re: Segmentation fault (JVM crash) while memory restoring on start with native persistance

Hi Arseny, Have you success with reproducing the issue and getting stacktrace? Do you observe same behavior on OracleJDK? On Tue, Dec 26, 2017 at 2:43 PM, Andrey Mashenkov < andrey.mashen...@gmail.com> wrote: > Hi Arseny, > > This looks like a known issues that is unresolved yet [1], > but we

Re: Error of start with multiple data regions

Hi, I've created JIRA ticket https://issues.apache.org/jira/browse/IGNITE-7414 As a temporary workaround, I'd suggest deactivating the cluster before closing. Thanks! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Apache Ignite & unixODBC and truncating text

ok, I ask becouse I wont to be sure. Fix will be included in Ignite 2.4 or 2.5? On the ticket: https://issues.apache.org/jira/browse/IGNITE-7362 in details is write that fix this bug is planning for 2.5 version... -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Purpose of cache in cache.query(Create Table ...) statement

Hi guys, I am new to the world of Ignite. I am currently going through the examples folder. The following are the statements from example CacheQueryDdlExample (apache-ignite-fabric-2.3.0-bin/examples/src/main/java/org/apache/ignite/examples/datagrid/CacheQueryDdlExample.java): cache.query(new

Re: Connection problem between client and server

Hi Jeff! There is a workaround for the problem of huge discovery messages. Try changing IgniteConfiguration.includeProperties parameter to an empty array. It will

RE: SQL Error: Failed to query Ignite

Another thing, I now have two "identical" caches, is this correct? I assumed I would just end up with SQL_PUBLIC_TOKEN +-+-+---+---+---+---+---+---+ | SQL_PUBLIC_TOKEN(@c2) | PARTITIONED | 2

RE: SQL Error: Failed to query Ignite

Yes! That did it! Now my question is simply, why the star? What does it do. I thought I had to use template= Thanks heaps! ./t -Original Message- From: slava.koptilin [mailto:slava.kopti...@gmail.com] Sent: mandag 15. januar 2018 11.55 To: user@ignite.apache.org Subject: Re: SQL

RE: Problem enabling read-through on cache - no suitable driver

Hi, please see my answer to that thread. I hope it solves the issue. Thanks! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SQL Error: Failed to query Ignite

Hi Thomas, Please try to configure your template in the following way: **" /> In that case, you should be able to create a table via thin driver: CREATE TABLE TOKEN(id LONG, token VARCHAR, PRIMARY KEY

RE: Problem enabling read-through on cache - no suitable driver

Hi Thomas, > however, when I try using my own templates I simply get SQL Error[5] > "Cache doesn't exist!" >- not sure why this is happening but maybe I'm not connecting to the right DB? Could you please provide us with the template you are trying to use? > Is the jdbc:ignite:thin

Re: BinaryObjectImpl.deserializeValue with specific ClassLoader

The ticket is on the radar, but not in immediate plans. The problem might sounds simple at first glance, but we already spent considerable time on implementation and review, because we heavily rely on classes caching, and a lot of internal BinaryMarshaller infrastructure should be reworked to

Re: insert so slow via JDBC thin driver

Streaming mode for thin JDBC driver is expected in Apache Ignite 2.5. Meanwhile you can load data using thick driver which support streaming, and then switch to thin driver for normal operations it you prefer it over thick one. On Fri, Dec 15, 2017 at 9:09 PM, Denis Magda

SQL Error: Failed to query Ignite

Hi guys ! I am not in any way sure that I'm on the right track here so please bear with me. I have a single node running with my cache: [10:48:34,480][INFO][main][IgniteKernal] Configured caches [in 'sysMemPlc' dataRegion: ['ignite-sys-cache'], in 'default' dataRegion: ['tokenCache']] I want

Re: Ignite 2.3 Swap Path configuration is causing issue

Hi, Just to reiterate and clarify the behavior. Region maxSize defines the total maxSize of the region, you will get OOME if your data size exceeds the maxSize. However, when using swap, you can set maxSize _bigger_ than RAM size, in this case, the OS will take care of the swapping. 2017-12-21

Re: Ignite yarn cluster deployment

Hello Andrey! You basically need to run: IGNITE_YARN_JAR=/mnt/ignite/apache-ignite-2.3.0-src/modules/yarn/target/ignite-yarn-2.3.0.jar yarn jar ${IGNITE_YARN_JAR} ${IGNITE_YARN_JAR} /mnt/ignite/ignite_yarn.properties As you can see there's two local paths - for JAR and for properties. If you

Re: How to re-direct Ignite logs to log4j2?

Hello Sherry! While you're waiting for the response from topic starter, this link may come in handy: https://apacheignite.readme.io/docs/logging#section-log4j2 ...path to log4j2.xml should be either absolute or a relative local file system path, relative to META-INF in classpath, or relative to

Re: Exception Occuredjava.sql.BatchUpdateException: ORA-00001: unique constraint

Hi, As for 9800 entries instead of 1 - most possible that you just have a small mistake when you work with your counter and these entries were not written to the DB: if(counter==100) Anyway, for both problems community need additional information for an investigation. It would be great if