Re: ignite cache as database table

2020-04-10 Thread akorensh
Hi, Annotations and QueryEntities are just different ways of specifying the config. There should be no differences in how that config is being deployed inside Ignite. Currently there is no way to set a table name via annotations. It defaults to the name of the class. see:

Re: ignite cache as database table

2020-04-10 Thread Evgenii Zhuravlev
Hi. Can you share both xml configuration and class with entities? >The difference is the second one will create H2 database table. Then H2 will keep another copy so that it is using double size of memory ? No, h2 doesn't store a copy of data. Moreover, annotations are used to prepare

ignite cache as database table

2020-04-10 Thread Edward Chen
Hello, trying to load 17m record size of data, size is 3.4G. if pojo class field defined with QuerySqlField annotation, Ignite will use roughly 9G memory. If we create ignite cache as database table with QueryEntity / QueryField, it will use total 20G memory. The difference is the second one

Re: Tibco BW 6 plug-in for Apache Ignite

2020-04-10 Thread Denis Magda
Hi Angel, Thanks for sharing your plugin with the community! It's highly likely that there some folks on the user list who will be glad to know the plugin is available. We also supported you by sharing the integration via Ignite twitter handle:

Re: Ignite crashes with CorruptedTreeException: "B+Tree is corrupted" on a composite BinaryObject scenario

2020-04-10 Thread akorensh
Hi, When running your code I created the cache as follows: IgniteCache employeeCache = ignite.getOrCreateCache("employeeCache").withKeepBinary(); With the ".WithKeepBinary()" flag set code works, otherwise there are serialization errors. If you still get errors w/this flag set,

Tibco BW 6 plug-in for Apache Ignite

2020-04-10 Thread angel.duran
Hello Mods/ Admin, not sure if this is the right place to post the plugin I'm developing for Tibco BW. If it's not, kindly mre to the right section. Plug-in Code for Apache Ignite and TIBCO ActiveMatrix BusinessWorks™ 6 Apache Ignite plugin provides a convenient and easy-to-use interface for

Re: C++ ODBC Example Question

2020-04-10 Thread Igor Sapego
Yes, you can. You just need to combine C++ PutGet example and ODBC example, where from C++ you take a part that puts data in cache, and from ODBC you take the querying part. Best Regards, Igor On Wed, Apr 8, 2020 at 6:32 PM Anthony wrote: > Hello llya, > > I guess I may not describe my

Re: Ignite Persistence

2020-04-10 Thread Evgenii Zhuravlev
Hi, All data regions allocate offheap memory separately, so, it will be an additional 500mb to 20% of the default region. Also, size of the default region can be configured too. Evgenii пт, 10 апр. 2020 г. в 05:56, nithin91 < nithinbharadwaj.govindar...@franklintempleton.com>: > Hi > >

Re: [DISCUSSION] Major changes in Ignite in 2020

2020-04-10 Thread Юрий
Hi Igniters! Major changes that are going to be contributed from our side for IGNITE SQL: - Local runtime statistics which helps to estimate query execution plan. It should help use right join order in most cases. Seems could be done by Q3. - most efforts will be direct to new SQL

Ignite Persistence

2020-04-10 Thread nithin91
Hi Currently we are using ignite as an in-memory cache.We are now trying to explore the ignite persistence to avoid reloading the caches whenever the cluster restarts. Had a walk through of the documentation and have one question.Can any one help me answer the following question. For example i

Re: [DISCUSSION] Major changes in Ignite in 2020

2020-04-10 Thread Ivan Rakov
Hi everyone! Major changes that are going to be contributed from our side: - https://issues.apache.org/jira/browse/IGNITE-11704 - keeping tombstones for removed entries to make rebalance consistent (this problem is solved by on-heap deferred deletes queue so far). -

Re: JDBC Connection

2020-04-10 Thread narges saleh
Hi All, I think I have figured it out. I just need to specify the schema. thanks. On Thu, Apr 9, 2020 at 9:30 PM narges saleh wrote: > Hi All, > 1) How would one use ignite's JDBC connection to query multiple tables, > both in case of joins and separately? I.e., Can one get a JDBC connection, >

Re: [DISCUSSION] Major changes in Ignite in 2020

2020-04-10 Thread Anton Kalashnikov
My top priorities:* Cache warm-up - loading data from disk to memory before the join to cluster - https://cwiki.apache.org/confluence/display/IGNITE/IEP-40+Cache+warm-up* PDS Defragmentation - possibility to free up space on disc after removing entries-- Best regards,Anton Kalashnikov20.03.2020,