Re: Apache Ignite Rest API JOIN with multiple Caches

The above solution works fine with Ignite JDBC and however I am trying with Ignite REST API. http://localhost:8080/ignite?cmd=qryfldexe=100=CustomerCache=select+id+from+Customer c+join+ AccountCache.account a+on+where+c.id=a.id I am getting "error": "Schema \"ACCOUNTCACHE\" not found; SQL

Apache Ignite Rest API JOIN with multiple Caches

Hello, I have two objects i.e account and customer loaded to apache ignite server. Both objects are loaded with data and each of them stored in its cache. Account object/table is loaded to accountcache and customer object/table is loaded to customercache. I am trying to access both the tables

Loading Cache

Currently I am loading data with one line in java. Below ocmmand will load all data from database to Cache. Example: ignite.cache("CustomerCache").loadCache(null); I would like to load data for specific period. How would I do that? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Running Server Node in UNIX

is any help on this? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Running Server Node in UNIX

Running below command in UNIX and getting error.it runs fine in windows in eclipse..any help on this? 1. java -cp /opt/lib/*.jar:/opt/com/test/cache/*.*:/opt/com/test/config/*.* ServerNodeCodeStartup Error: Could not find or load main class ServerNodeCodeStartup 2. java -cp

Re: Running Server Node in UNIX

Thank you. I have all jars in lib as below and added to the cp command. lib folder - ./lib/ignite-indexing-2.5.0.jar ./lib/ignite-rest-http-2.5.0.jar ./lib/mssql-jdbc-6.4.0.jre8.jar ./lib/ignite-slf4j-2.5.0.jar ./ib/...jar source code compiled as below structure(.class)

Re: Running Server Node in UNIX

I don't have IGNITE_HOME set up from my windows- eclipse and able to run without any issue. I have ignite-core, ignite-spring, ignite-indexing and ignite-rest-http in the pom.xml. I am trying to run same structure in UNIX. I have required libs in the jar. Is anything am i missing? -- Sent

Re: Loading Cache

Thank you for reply. Is there example can you provide to load the data with criteria i.e load data (select query) is based on date range is restricted. i.e cache.loadcache(select * from table name where date = '02/02/108'). -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Igniter TCPDiscovery

I have two independent machines where ignite server node is running. i.e ,193.169.15.50 and ,193.169.15.51. Both are running with two different versions of cache. However when i tried to load the data to cache(i.e ,193.169.15.50) from one of these machine, it always finds another machine (i.e

Duplicate Table Error

Getting an error Duplicate table name [cache=CustomerCache,tblName=CUSTOMER, type1=Customer, type2=Customer] when i tried to add index as below ccfg.setIndexedTypes(Long.class,Customer.class); public class Customer implements Serializable { /** Value for dwId. */ @QuerySqlField(index =

RE: Ignite Query Slow

Thank you..Tried @QuerySQLFields...but column name not appeared same as database table(i.e underscore("_") is missing in ignite). Hence I have added index to qryEntity and noticed that Query takes about 7 seconds (i.e select * from customercache.customer) for against ignite cache data of 200,000

RE: Ignite Query Slow

Any help on this? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Security Setup

I am trying to setup basic login and password. I have coded as below but getting an error as in the Ignite documentation. IgniteConfiguration cfg = new IgniteConfiguration(); // Ignite persistence configuration. DataStorageConfiguration storageCfg = new

Re: Ignite Query Slow

Documentation has example as ccfg.setIndexedTypes(Long.class, Person.class);. I believe this is single field. How to register multiple indexes for CacheConfiguration? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite Query Slow

I tried with setting up field with @QuerySqlField (index = true) and still slow. Example : /** Value for customerId. */ @QuerySqlField (index = true) private Long customerId -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Apache Ingite Join returns wrong records

I am using Apache Ignite 2.6 version. I have two tables as below i.e SUMMARY and SEQUENCE SUMMARY-> DW_Id bigint (Primary key) , Sumamry_Number varchar, Account_Type varchar SEQUENCE-> DW_Id bigint (Primary key) , Account_Type varchar Database and cache has same number of records in both tables.

Re: Ignite Query Slow

Thank you for suggestion. Can you give example how to create secondary indices? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Apache Ingite Join returns wrong records

Is there setDistributedJoins at cache level? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Ignite Query Slow

I have 3 cache store and each has its own table. When I tried to do simple join, query is taking longer in DBeaver. Server topology is ver=4, servers=1, clients=1, CPUs=4, offheap=3.2GB, heap=6.0GB Cache 1. GroupCache"."[GROUP]" has 100k records Cache 2. "GroupMemberCache".GROUP_MEMBER has 200k

Re: Ignite Query Slow

1. I have defined primary key - dwId 2. Not defined affinity_key since there is no Forgein Key in table. 3. CacheConfiguration ccfg = new CacheConfiguration(); ccfg.setName(cacheName); ccfg.setCacheMode(CacheMode.PARTITIONED);

Re: Ignite Query Slow

Here is the explain query # PLAN 1 "SELECT ADDR__Z2.ADDRESS_LINE_1 AS __C0_0, ADDR__Z2.ADDRESS_LINE_2 AS __C0_1, ADDR__Z2.ADDRESS_LINE_3 AS __C0_2, ADDR__Z2.STREET AS __C0_3, ADDR__Z2.CITY AS __C0_4, ADDR__Z2.STATE AS __C0_5, ADDR__Z2.COUNTRY AS __C0_6,

Ignite Remote Node

Hello I have upgraded my code from Apache ignite version 2.6 to 2.7. I am running two server nodes in two different machines. However after upgrade, noticed that these two server nodes joined. Log shows as servers=2, state=ACTIVE. Based on previous suggestion, I have commented out TCPDiscoverSPI

Apache Ignite Join

I have single node with REPLICATE mode. Record counts in database and ignite is matching when query the number of records in each table. However when it comes to join, there is a mismatch in some cases. I am using JAVA code version(Not Spring Version). Example: Table A has code as below :-

Re: Ignite Query Slow

How about 6 cores. Will that help? In that case what is the thread counts? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite Query Slow

Enclosed CPU/Thread usage. Ignite became super slow after applying below. I am still not sure how many threads are required to span 100 queries simultaneously. I am seeing CPU is hitting almost 100%. cfg.setQueryThreadPoolSize(16); cfg.setSystemThreadPoolSize(16);

web console

I am trying to ocnnect web console and downloaded ignite-web-agent-2.7.1. It doesnt seems to support java 1.8 and getting an error "jdk1.8.0_171 was unexpected at this time." What is the java version supported for ignite-web-agent-2.7.1? -- Sent from:

Re: Ignite Query Slow

Ok..Will 2 nodes helps? I saw only one node is busy most of time since I have configured as REPLICATE and also found that REPLICATE is faster in multi join queries than PARTITIONED in my case. Is there anyway REPLICATE (with 2 nodes) take loads equally among 2 nodes? -- Sent from:

Re: Ignite Query Slow

sql-performance.PNG enclosed sql performance time. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite Query Slow

is there anyway i can run ignite on machine and port without discovery? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite Query Slow

It is different machine. Wondering why not able to use same port? I have put the IP and port for each node in different machine. Machine 1: node discovery.setLocalAddress("192.2.2.1"); discovery.setLocalPort(new Integer("10800"))); Machine 2: node discovery.setLocalAddress("192.2.2.2");

Re: Ignite Query Slow

I have following code in node1 -> TcpDiscoverySpi discovery = new TcpDiscoverySpi(); discovery.setLocalAddress("192.2.2.1"); discovery.setLocalPort(new Integer("10800"))); cfg.setDiscoverySpi(discovery); and node 2 -> TcpDiscoverySpi discovery = new

Re: Ignite Query Slow

Ignite.zip Ignite is using high CPU and enclosed high CPU profile. Let me know if you need any further information to help us on this. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite Query Slow

Currently I have only one node and other node is idle and brought it down. I have noticed that only one node is busy and I have code as below. IgniteConfiguration cfg = new IgniteConfiguration(); TcpDiscoverySpi discovery = new TcpDiscoverySpi();

Re: Ignite Query Slow

Thank you for reply. I have 2 core, 20 GB memory space allocated for Ignite cache. My data size is about 3 to 4 GB. I have batch process(multi threaded) where simultaneously 100 requests sends to ignite cache (same query with different parameters for each request). What is the recommended thread

Ignite Query Slow

Hello I have ignite server running with 2 nodes. Each node has 30 cache stores with one table in each with REPLICATE configured. Found query is taking longer to return when simultaneous 100 requests were sent to ignite. In the first iteration the query is quick. But as number of hits more, same

Ignite Query Slow

Hello I have ignite server running with 2 nodes. Each node has 30 cache stores with one table in each with REPLICATE configured. Found query is taking longer to return when simultaneous 100 requests were sent to ignite. In the first iteration the query is quick. But as number of hits more, same

Re: Ignite Query Slow

Attached. Thanks gclog.zip -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite Query Slow

Hello Are u suggesting to have more nodes with REPLICATE OR PARTITIONED settings? Thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite Query Slow

Also attached GC-> 2018-11-26T13:35:23.058-0500: 1172.703: [GC pause (G1 Evacuation Pause) (young), 0.0070730 secs] [Parallel Time: 6.3 ms, GC Workers: 2] [GC Worker Start (ms): Min: 1172702.9, Avg: 1172703.3, Max: 1172703.7, Diff: 0.8] [Ext Root Scanning (ms): Min: 1.1, Avg: 1.4,

Re: Loading Cache

Tried below code, but code is not complaining in IDE..Keep seeing error message asking to change the method loadcache() to method localloadCache(). When changed to method localloadcache(), asking to change method to loadCache(). ignite.cache("CustomerCache").loadCache(new

Error while loading data to cache

I am trying to load data to cache using below code and seeing an error. ignite.cache("CustomerCache").loadCache(new IgniteBiPredicate() { @Override public boolean apply(Object key, Object value) {

Re: Error while loading data to cache

Your suggestion is working.Thank you. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Ignite Performance

I have 250,000 records for each cache store and when I tried to join they are pretty slow. Is annotation -> @affinityKey, @SqlQueryField works in java version? I am using JDK1.8 version AND NOT Spring version. Can someone help how to use @affinitykey in group for below example in 'PARTIONED'

Cache Join

Hello I am using apache ignite 2.7 version and trying to join three tables and My query looks as below. All tables are configured as PARTIONED and also set "distributedjoin=true" == SELECT CAS.Group_Customer_ID as groupCustomerId,

Re: Query Monitoring

How do i see this view? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Query Monitoring

I am using Apache ignite 2.7.0 and agent - ignite-web-agent-2.7.3. I have also configured cache with ccfg.setStatisticsEnabled(true) and ccfg.setQueryDetailMetricsSize(10); But I seeing error in ignite web console as - "No statistic information about executed query Query monitoring is not