Re: How Does Ignite Create Lucene Index?

Cache stores data, not indexes. In addition, each node has its own Lucene engine that stores indexes that reference in-cache data that belongs to the local node. When distributed query is executed, the request is broadcasted, each nodes applies indexes and executes the query locally and sends

Re: What does mean caching database exactly ?

1. You can have a cluster consisting of several server nodes with one or more caches storing some data. Then you can have multiple applications, each will start a client node to connect to the same cluster and use this data. JDBC and REST can also be used. So the answer is definitely YES, this is

Re: Apache Arrow with Ignite ?

Hi, Can you please properly subscribe to the mailing list so that the community can receive email notifications? Here is the instruction: http://apache-ignite-users.70518.x6.nabble.com/mailing_list/MailingListOptions.jtp?forum=1 limabean wrote > One of the things I like about Apache Ignite is

Re: SQL gives incorrect results

Thanks Val. I do use query on the partitioned cache. Here is my config - cip-ignite-client.xml here is my query - String sql = "SELECT distinct sid_mah_id, sid_itm_id, sid_prm_id, sid_cha_code, sid_service,

Re: Cross cache query on spark: schema not found

Hi, By default schema name is the cache name, but I don't that you set names in CacheConfiguration. Actually, this also means that you create one cache instead of two. Can you check this and make sure that CacheConfiguration.setName() provides unique name for each cache? -Val -- View this

Re: How to load 2 tables in a cache

Database first_name name should be mapped to firstName in Java object, and you should use the Java name when executing SQL queries against the data in memory. Can you try this? -Val -- View this message in context:

Re: How to perform lazy write to database

You get it after the commit. When you start a new thread, the original one goes on and commits the transaction. The new one blocks on get(), waits for that commit and then prints out the value. -Val -- View this message in context:

Re: How to load 2 tables in a cache

Actually, this is what's happening: This is the code: package org.apache.ignite.organization; import java.util.List; import java.io.BufferedReader; import java.io.InputStream; import java.io.InputStreamReader; import java.security.KeyStore.Entry; import java.sql.Connection; import

Re: How to check what is loaded into cache ?

Hi, Can you please properly subscribe to the mailing list so that the community can receive email notifications? Here is the instruction: http://apache-ignite-users.70518.x6.nabble.com/mailing_list/MailingListOptions.jtp?forum=1 tomk wrote > Is there exist any way to controlling contains of

Re: How to perform lazy write to database

But, in my transaction method: PersonKey key = new PersonKey(5); System.out.println(); System.out.println(">>> Update salary and write-through to database for person with ID: " + key.getId()); try (Transaction tx = ignite.transactions().txStart()) { //

Re: TcpCommunicationSpi warning messages

Hi Kevin, This message means that one of the messages was not successfully sent within the timeout. Message is resent in this case and Ignite makes sure that it's delivered. But if the warnings are frequent, it usually means that the network is unstable or slow, which can cause performance

Re: ignite v 1.5.9 binary

Hi, Can you please properly subscribe to the mailing list so the community can receive email notifications? Here is the instruction: http://apache-ignite-users.70518.x6.nabble.com/mailing_list/MailingListOptions.jtp?forum=1 tony.mak wrote > I get this when I start up ignite 1.5.6 : > New

Re: How to perform lazy write to database

In PESSIMISTIC/REPEATABLE_READ transaction (which is the default one) any operation with a particular key will lock this key until the transaction is committed or rolled back. So in your case the second thread will block on get() and wait for the first transaction to finish. It will then get v2

Re: How Does Ignite Create Lucene Index?

Hi, All indexes (both SQL and Lucene) are created on each node independently for the data that resides locally. Ignite then uses its own mechanisms to execute distributed queries across the cluster. There is no leader node or router, all nodes in Ignite cluster are equal. Did I answer your

Re: hibernate open session error while running with tomcat server

Hi Ravi, This looks like exactly the same issue you were reporting earlier. You were able to fix the classpath, right? Is it possible that the fix was not applied somewhere? -Val -- View this message in context:

Re: SQL gives incorrect results

Hi Arthi, Please make sure that you call query() method on a partitioned cache, otherwise it can be executed locally. If this doesn't help, provide the example to reproduce the issue. Generally your expectations are valid - if one of the caches is replicated, you don't need to bother about

Re: How to load 2 tables in a cache

On Mon, Apr 11, 2016 at 10:29 AM, tusharnakra wrote: > Yes, it makes sense! So, is there any way that the SQL JOIN relations can > work in gridgain for the 2 tables loaded in different cache? > Yes, you can find the example for cross-cache join here:

Re: How to load 2 tables in a cache

Yes, it makes sense! So, is there any way that the SQL JOIN relations can work in gridgain for the 2 tables loaded in different cache? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4069.html Sent from the Apache Ignite

TcpCommunicationSpi warning messages

Hi, I have a 2 node cluster and I noticed the following warning messages. I can't see any problems on a superficial level though. The cluster still looks seemingly stable after these messages. What do the messages mean? Are they indicative of any problems?

Re: How to perform lazy write to database

Thanks, I was able to test it now! Just confirming for the final time, so if before tx.commit(), I do: cache.put(k1,v1); cache.put(k1,v2); and then if I get k1's value: cache.get(k1), in a new thread before doing tx.commit(), then I'll get value v2 for key k1, right? Coz in the cache value for

Re: Host Arrays in C++ API

Hi Igor, the SQL query for getNext() takes a whole lot of time when the results returned is more than 900,000 both using Java and C++ API. I have tried a number of configurations with indexes, but just dont get to speed these up. thanks, Arthi -- View this message in context:

Re: How to load 2 tables in a cache

I don't understand what you mean by data types? I'm talking about 2 database tables present in the same MySql database/ -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4065.html Sent from the Apache Ignite Users mailing

Re: .NET SQLQuery Error

Great..thanks for the info. We are not on production yet. We have a couple more months. Will try the approach you suggested. Thanks. On Apr 11, 2016 9:22 AM, "Pavel Tupitsyn" wrote: > Some say that 1.6 is expected by the end of the month, can't say for sure. > >

Re: .NET SQLQuery Error

Some say that 1.6 is expected by the end of the month, can't say for sure. Obviously, I can't recommend to use unreleased code in production, but other than that, our master branch is usually stable, so you are welcome to try out latest features! If you decide to do so, have a look at updated

Re: .NET SQLQuery Error

That makes sense. Thanks for the explanation. Any idea what is the wait time for 1.6? Do you recommend building from source for 1.6 and use that till 1.6 is GA? On Apr 11, 2016 7:28 AM, "Pavel Tupitsyn" wrote: > In fact, keyType and valType can be arbitrary strings. >

Re: Behavior of init() for clustered singleton

Please provide app logs after the issue gets reproduced. --Yakov 2016-04-08 19:20 GMT+03:00 dstieglitz : > Ok I added the debug statements: > > > https://github.com/dstieglitz/grails-ignite/blob/v0.4.x/src/java/org/grails/ignite/DistributedSchedulerServiceImpl.java

Re: .NET SQLQuery Error

In fact, keyType and valType can be arbitrary strings. They are used to create SQL tables internally. Look at SqlQuery constructors: some of them accept "string queryType". This string must be equal to valType string in configuration. Using type name without namespace is just a convention.

Re: .NET SQLQuery Error

Hi Pavel, You are absolutely right. I had 2 config files and I indeed am referring to wrong version. I copied and pasted and VS and instead of creating a new file, it created a link. Thanks for helping me out. Based on your suggestion that the valueType needs to be unqualified without the

答复: re: Ignite Sql Query performance problem

Dear Val, I found another post that you have answered : http://apache-ignite-users.70518.x6.nabble.com/problem-run-jar-file-td1973.html And solved my problem by adding several extra jar files on server side libs folder. Best regards, Kevin -邮件原件- 发件人: vkulichenko

How Does Ignite Create Lucene Index?

Hi, I Would Like To Know How Ignite Creates Lucene Index When I Try Text Quary With Partitioned Mode In Detail. I don't think that the progress is just the same as solr cause ignite doesn't have something like a leader node. Is there anything similar? If every node in ignite cluster has

Re: .NET SQLQuery Error

Satya, I can run your solution without errors with fixed config. This means that you don't actually use the config above for your nodes. Something else gets loaded for some reason. Please do the following: * Make sure that SpringConfigUrl points to the updated file everywhere you use it. *

hibernate open session error while running with tomcat server

this is the error throws while executing with long start = System.currentTimeMillis(); System.out.println("Entering into loadCache ApacheIgniteCacheConfiguration"); // Start loading cache from persistent store on all caching nodes. cache.loadCache(null,100_000);// here

Re: How to load 2 tables in a cache

Hello @tusharnakra Idiomatic way of Ignite usage is creation of separated cache per data type. Ignite Schema import is deprecated. You can try to use Web Console, which already generate separated caches per data types and described at this page http://ignite.apache.org/addons.html#web-console