Re: read-though tutorial for a big table

Hello Denis,That is possible, my writing activities should be continued. The only question is to get my local project to production, there is no sense in writing another model example. So I hope there will be a progress in the nearest futureVladimir2:25, 12 марта 2020 г., Denis Magda :Hello Vladimi

cache/table metadata

Hi All, How would one extract, programmatically, the metadata for the fields/columns for a cache/table? I want to get the field names along with the data type for each field, say, for example, if the table is defined via queryentity or SQL/JDBC. thanks.

Re: page is broken,cannot restore it from wal (2.8.0)

Hi Denis, This problem has certain randomness, it is difficult to write a code that can reproduce 100%. This has been the case in our past tests, with the use of COPY commands to import large amounts of data and in transaction scenarios with KV interfaces. 在 2020/3/12 上午7:20, Denis Magda

Re: 2.8.0 : JDBC Thin Client : Unable to load the tables via DBeaver

in my environment, no problem. 在 2020/3/11 下午11:39, VeenaMithare 写道: Hi , Yes, I have put 2.8.0 ignite core jar in the path for the DBeaver to pickup the latest jdbc jars. Steps to reproduce : 1. Create a table on dbeaver : CREATE TABLE TEST ( USERNAME VARCHAR, APPLICATIONNAME

Re: read-though tutorial for a big table

Hello Vladimir, Just to clarify, are you suggesting to create a tutorial for data loading scenarios when data resides in an external database? - Denis On Tue, Mar 10, 2020 at 11:41 PM wrote: > Andrei, Evgenii, thanks for answer. > > Aa far as I see, there is no ready to use tutorial. I manage

Re: page is broken,cannot restore it from wal (2.8.0)

Let's see if and how we can get to root cause together. Try to prepare a small reproducer and elaborate on the instructions to follow to get the exception. Please also attach complete log files. - Denis On Wed, Mar 11, 2020 at 3:10 AM 18624049226 <18624049...@163.com> wrote: > Hi Denis, > > In

Re: 2.8.0 : JDBC Thin Client : Unable to load the tables via DBeaver

index.jar is already in classpath of server. I added it on the dbeaver classpath ( Not sure, I dont think it is needed. ) I am on DBeaver 6.1.3. Here is what I do : 1. Clear my data directory. 2. Start the 3 servers with 2.8.0 3. Activate the cluster 4. Add the table via dbeaver : CREATE TABLE

Re: Issue in Distributed joins

Hello again! Having one table as replicated and other as partitioned works already. Can you please file a defect for why nested joins are not working in the distributed mode as claimed. Regards Deepika Singh -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: 2.8.0 : JDBC Thin Client : Unable to load the tables via DBeaver

Hello! I have just tried it with DBeaver 4.2.2 and it runs OK. Consider also adding ignite indexing jar to class path. Regards, -- Ilya Kasnacheev ср, 11 мар. 2020 г. в 18:39, VeenaMithare : > Hi , > > Yes, I have put 2.8.0 ignite core jar in the path for the DBeaver to pickup > the latest j

Re: 2.8.0 : JDBC Thin Client : Unable to load the tables via DBeaver

Hi , Yes, I have put 2.8.0 ignite core jar in the path for the DBeaver to pickup the latest jdbc jars. Steps to reproduce : 1. Create a table on dbeaver : CREATE TABLE TEST ( USERNAME VARCHAR, APPLICATIONNAME VARCHAR, MACHINENAME VARCHAR, PRIMARY KEY ( USERNAME)

Re: Ignite 2.7.6: Memory Leak with Direct buffers in TCPCommunication SPI

Hello! I can see that you have 19G of Object[] in heap. I'm not sure if it has any relation to direct buffers. Can you debug where these Object[]'s are referenced from? As a side note, our test suites bring tens of thousands of nodes up and down in one JVM and not face this issue. Regards, --

Re: cache.containsKey returns false

Hello! As far as my understanding goes, this is how readThrough work. It may update only subset of REPLICATED cache partitions across cluster. Regards, -- Ilya Kasnacheev пт, 28 февр. 2020 г. в 21:09, Prasad Bhalerao : > Hi, > > We have not set any expiration/ eviction policy. > We were getti

Re: Ignite Transaction vs Lock

Hello! I'm not sure if that is what you want, have you tried Transaction Isolation Level of SERIALIZABLE? Regards, -- Ilya Kasnacheev пн, 2 мар. 2020 г. в 10:43, Rout, Biswajeet : > Hi, > > I used transactions in my project when I interact to cache. The > transaction isolation and concurrency

Re: Issue in Distributed joins

Hello! Bad news is that I can't say what went wrong here. Maybe people more familiar with our SQL engine will chime in. Good news is, I have a work-around. It is obvious in your case that blood_group_info is a reference table (i.e. a small constant-size table instead of data table). I recommend s

Re: 2.8.0 : JDBC Thin Client : Unable to load the tables via DBeaver

Hello! Do you have any steps to reproduce? Are you sure you are using latest version of JDBC driver with DBeaver? Regards, -- Ilya Kasnacheev ср, 11 мар. 2020 г. в 14:26, VeenaMithare : > Hi Team, > > First of all, thank you for the SYS schema that is now available to view > via > Dbeaver. Lo

2.8.0 : JDBC Thin Client : Unable to load the tables via DBeaver

Hi Team, First of all, thank you for the SYS schema that is now available to view via Dbeaver. Looks interesting. The issue I am facing is that I am unable to query any of my tables in the public schema when I switch over to 2.8.0. These tables currently do not have any data in it. I get this mes

Re: Cache metrics on server nodes does not update correctly

Denis, I don't sure that I understand what is expected behavior should be. There are local and aggregated cluster wide metrics. I don't know which one used by Visor because I never used it :) Also it would be great to know what version of Apache Ignite used in described case. I remember some bug

Re: page is broken,cannot restore it from wal (2.8.0)

Hi Denis, In ignite's 2.7 series, if data is written after persistence is turned on, page data corruption may occur, but the error message is a little different from this, but it has the same meaning. In the JIRA list, there are records of similar problems, but some have been fixed. I know I

Re: Issue in Distributed joins

Hello Ilya, Please find the script in the attachment. The file also contains the query to run in comments. Also, *we have enabled non-collocated joins check. * forDistributedJoins.sql Regards Deepika Singh