Can Apache Superset connect with Apache Ignite ?

2020-05-14 Thread lan
as the topic , if yes, please share the approximate method,thanks. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Getting Baseline Topology Error

2020-05-14 Thread Evgenii Zhuravlev
Hi, When do you usually change the baseline topology? It looks like you changed topology for part of the nodes and the changed it for another node separately, so now they have different baseline topologies. Do you have nodes for runs before this issue happened? Thanks, Evgenii чт, 14 мая 2020

Re: SQL execution performance problems due to insufficient off-heap space

2020-05-14 Thread akorensh
The base rule is keep at 4K unless there is a very good reason to change it. See here: https://apacheignite.readme.io/docs/durable-memory-tuning#page-size also try to turn on direct IO: https://apacheignite.readme.io/docs/durable-memory-tuning#enabling-direct-io small page sizes might cause

Re: Question on the log of public pool thread [pub-#14505].

2020-05-14 Thread Evgenii Zhuravlev
James, > But whether could I know the other threads are stopped and destroy? That's how it works, Here in the code: https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/internal/IgnitionEx.java#L1763 you can see that Ignite create ThreadPoolExecutor with a max

Re: Scheduling Cache Refresh

2020-05-14 Thread akorensh
can you share the server logs. turn on debug for the appropriate package: org/apache/ignite/cache/store/jdbc https://apacheignite.readme.io/docs/logging What is the behavior you are getting? No logs related to this at all. you should be getting the following: Start loading entries from db

Re: BinaryObject field is not update

2020-05-14 Thread akorensh
Hi, See: https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/binary/datagrid/CacheClientBinaryPutGetExample.java and: https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/binary/BinaryObject.html

Re: Scheduling Cache Refresh

2020-05-14 Thread nithin91
Hi Actually the Bean File which contains the Cache Store Factory Details and Cache Configuration Details is deployed in Linux Server on which the Ignite Instance is running.I am try to connect to the ignite instance running on the Linux Server from my local machine. PFA for the bean file

Re: Scheduling Cache Refresh

2020-05-14 Thread akorensh
Hi, loadCache(..) is designed to load the cache from a 3rd party store. you are not setting the cache factory in your app. See: https://apacheignite.readme.io/docs/3rd-party-store#rdbms-integration example:

Re: Restarting the Main node when it goes down

2020-05-14 Thread akorensh
Hi, A baseline topology is set when you activate a cluster w/a set of nodes the first time around. You can subsequently change baseline the topology using the public API or control.sh command. Once all the baseline topology nodes are up the cluster automatically activates. use control

Re: About index inline size of primary key

2020-05-14 Thread 38797715
Hi, I see this property. If this property is configured, it has a global impact? What is the influence range of this parameter? 在 2020/5/14 下午9:41, Stephen Darlington 写道: Exactly as the warning says, with the IGNITE_MAX_INDEX_PAYLOAD_SIZE property: ./ignite.sh

Re: About index inline size of primary key

2020-05-14 Thread Stephen Darlington
Exactly as the warning says, with the IGNITE_MAX_INDEX_PAYLOAD_SIZE property: ./ignite.sh -J-DIGNITE_MAX_INDEX_PAYLOAD_SIZE=33 Regards, Stephen > On 14 May 2020, at 14:23, 38797715 <38797...@qq.com> wrote: > > Hi, > > Today, I see the following information in the log: > >

Re: SQL execution performance problems due to insufficient off-heap space

2020-05-14 Thread 18624049226
Hi, I tested and found that pageSize can be configured up to 16K. If 4K, 8K and 16K are configured respectively, the read performance will increase linearly, but the write performance will decrease linearly, and the disk space occupation of persistent files will also increase significantly.

About index inline size of primary key

2020-05-14 Thread 38797715
Hi, Today, I see the following information in the log: [2020-05-14T16:42:04,346][WARN][query-#7759][IgniteH2Indexing] Indexed columns of a row cannot be fully inlined into index what may lead to slowdown due to additional data page reads, increase index inline size if needed (set system

Getting Baseline Topology Error

2020-05-14 Thread BEELA GAYATRI
Hi, Sometimes I am getting the below error while starting the server nodes. After clearing the cache data in the persistence and Restart the nodes, then the nodes are up and running. I am using below code for setting BaseLineTopology ignite.cluster().active(true);

Re: Scheduling Cache Refresh

2020-05-14 Thread nithin91
Hi Attached link is at the end of post.However i am attaching it again here. srcandpom.zip Please let me know in case of any difficulties while opening the attachment. -- Sent from:

Re: ignite node ports

2020-05-14 Thread Stephen Darlington
If you download Ignite and run it, the REST server isn’t enabled. You have to copy ignite-rest-http from libs/optional to libs. Assuming you did that, you can start Ignite like this: ./ignite.sh -J-DIGNITE_JETTY_PORT=8088 That will start the REST service on port 8088. > On 14 May 2020, at

Re: Basic Affinity Question

2020-05-14 Thread Stephen Darlington
No, it needs to be able to determine which node the data should be on without reference to anything else. This means that you’d need company-id in your address table. > On 13 May 2020, at 21:23, narges saleh wrote: > >  > My other question is whether affinity is transitive. > Company

Re: Suggest a better way to access a particular K-V store

2020-05-14 Thread Ilya Kasnacheev
Hello! Have you tried adding an index on URLS (APPNAME_ID, SCORE DESC)? (or ASC if you are going to order ascending) Regards, -- Ilya Kasnacheev вт, 12 мая 2020 г. в 13:42, adipro : > We've already tried that but we are receiving these errors. We are using > index in a correct way only > We

Re: Scheduling Cache Refresh

2020-05-14 Thread Ilya Kasnacheev
Hello! Unfortunately I don't see any attachment to your message. Can you please share a link? Regards, -- Ilya Kasnacheev чт, 14 мая 2020 г. в 10:09, nithin91 < nithinbharadwaj.govindar...@franklintempleton.com>: > Hi > > Attached the Sample Spring Boot Application that i am running in my

Re: IOException in log and reference for dataRegion configure

2020-05-14 Thread kay
Hello again :) I read memory configuration section. https://apacheignite.readme.io/docs/memory-configuration and I don't know exactly what 'setSystemRegionInitialSize', 'setSystemRegionMaxSize' do? is it limit the global data storage of node? I didn't configure those things and configured

Restarting the Main node when it goes down

2020-05-14 Thread nithin91
Hi I have two nodes Node A(Main Node) and Node B with persistence enabled.When node B is restarted whenever it goes down, it is able to recognize node A and is joining the Baseline Topology but when Node A alone goes down and once Node A is restarted, it is not able to recognize Node B and it

Re: Scheduling Cache Refresh

2020-05-14 Thread nithin91
Hi Attached the Sample Spring Boot Application that i am running in my local machine to connect to ignite cluster deployed in Unix as a client node and refreshes the cache when ever a GET Request is made. Facing the following error.Can you please help me in resolving the errors

Re: UserVersion for Remote Deployment

2020-05-14 Thread Mahesh Renduchintala
typos - corrected a) is it a correct understanding that as long as UserVersion of the client matches that of the remote node for that class, the class will NOT be redeployed from any other client nodes?

UserVersion for Remote Deployment

2020-05-14 Thread Mahesh Renduchintala
Hi, We have a class (SqlQuery) that migrates from the client node to the remote node for execution. is the below way of fixing UserVersion for this class on the client node side correct? If not, what is the right way? see below. ignite.xml http://www.springframework.org/schema/beans;