Re: unsubscribe

2020-02-13 Thread Devin Bost
I'm not sure if you sent this to the right place. Did you get a confirmation email about being unsubscribed? Devin G. Bost On Thu, Feb 13, 2020 at 10:23 PM Shahid Muhamed < shahid.muha...@expeedsoftware.com> wrote: > unsubscribe > > Thanks, > > Muhamed Shahid >

unsubscribe

2020-02-13 Thread Shahid Muhamed
unsubscribe Thanks, Muhamed Shahid

Re: JDBC Thin Client does not return

2020-02-13 Thread pg31
Hello I know all folks are busy with 2.8 release. It would be great, if someone can spare a little time to look at the above issue. Thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: How to failover/scale cluster in Apache Ignite

2020-02-13 Thread wentat
Ok, I'll try to get a reproducer. However, I think its pretty hard because the error seems to be transient errors related to failover with huge dataset (1 TB plus dataset). My follow up question would be: If kill -9 is not appropriate. What is the graceful way to failover a node? For a 1TB

Issue with Ignite Logging and Log4j2

2020-02-13 Thread Mitchell Rathbun (BLOOMBERG/ 731 LEX)
I am hoping to use a separate appender for Ignite logs in my application. In my configuration file, I have: IGNITE and MAIN are both RollingRandomAccessFile appenders pointing to different files. In my java code I have: File logConfigFile = new

Re: Load cache data into another POJO with SQL

2020-02-13 Thread Evgenii Zhuravlev
Hi, You can implement your own CacheStore and transform data in it: https://apacheignite.readme.io/docs/3rd-party-store#section-custom-cachestore Best Regards, Evgenii чт, 13 февр. 2020 г. в 13:29, Denis Magda : > I doubt that this is supported. > > - > Denis > > > On Thu, Feb 13, 2020 at

Re: Load cache data into another POJO with SQL

2020-02-13 Thread Denis Magda
I doubt that this is supported. - Denis On Thu, Feb 13, 2020 at 11:32 AM Edward Chen wrote: > Hello, > > I am using Ignite SQL, wondering it is possible to load cache data into > another POJO ? just like ORM, sql like this : > > select new MyPojo(p.name, p.age) from myCacheTable as p where

Re: REST API on top of ignite using node express

2020-02-13 Thread Denis Magda
Hi Nithin, 1. You can use Query.setPageSize method to instruct the Cursor to read the result set in chunks bigger than 1024. However, regardless of the pageSize the Cursor returns the whole result: https://github.com/apache/ignite/blob/master/modules/platforms/nodejs/lib/Query.js#L56 2. That's

Re: Loading and Fetching the Data using Node js.

2020-02-13 Thread Denis Magda
According to the exception, the field name OrderId is of "long" type in Java and of "double" type in Node.JS (or vice versa). The types of the fields have to be identical. It seems like OrderId is a primitive field and you, probably, should enforce its type to "long" on Node.JS end. Also, check

Load cache data into another POJO with SQL

2020-02-13 Thread Edward Chen
Hello, I am using Ignite SQL, wondering it is possible to load cache data into another POJO ?  just like ORM, sql like this : select new MyPojo(p.name, p.age) from myCacheTable as p where p.age > 30 Thanks. Ed

Re: where to download odbc driver ?

2020-02-13 Thread Mikhail
Hi Ed, Please read the doc: https://www.gridgain.com/docs/latest/developers-guide/SQL/ODBC/odbc-driver#installing-odbc-driver you can find binaries here: %IGNITE_HOME%\platforms\cpp\bin\odbc\ Thanks, Mike. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Dynamic Cache Change not allowed

2020-02-13 Thread Evgenii Zhuravlev
Hi, The message says: Failed to execute dynamic cache change request,* client node disconnected*. So, it means that your client node is not connected to the cluster at this moment. It looks like you have connectivity issues between your local machine and remote server, I would recommend to check

Re: Nodes started on local machine require more than 80% of physical RAM

2020-02-13 Thread Mikhail
> but 4GB for container OS seems a bit much. Thanks for letting me know in any case! Absolutely agree with you that 4GB is too much, especially for the container environment. I think the person who wrote the check thought about big bare-metal installations with 128GB+ RAM, but you can just

where to download odbc driver ?

2020-02-13 Thread Edward Chen
Hello, As per Ignite doc, ignite is shipped with ODBC windows pre-built installers. I can not find any odbc msi file in apache-ignite-2.7.6-bin.zip.  Do you know how to get the odbc driver ? https://apacheignite-sql.readme.io/docs/odbc-driver#building-odbc-driver Thanks. Ed

Re: Ignite Cluster and Kubernetes Cluster

2020-02-13 Thread narges saleh
Thanks for the reply. So, what I need is to set TcpDiscoveryKubernetesIpFinder.namespaceName to a different namespace for each cluster and declare the namespace in the related ignite connector service yaml file? On Wed, Feb 12, 2020 at 10:19 PM pg31 wrote: > Yes. You should deploy them in a

Re: Slow cache updates with indexing module enabled

2020-02-13 Thread xero
Hi Andrei, thanks for taking the time to answer my question. I will consider your suggestion if we decide to switch to a multiple tables approach that will require those JOIN considerations. But, in this case we have only 1 cache and the operation that we are executing is an update. We tried using

Re: Ignite yarn resources keep on increasing

2020-02-13 Thread ChandanS
Hi Andrei, I am using below configurations: IGNITE_NODE_COUNT=40 IGNITE_RUN_CPU_PER_NODE=5 IGNITE_MEMORY_PER_NODE=15000 IGNITE_PATH=/project/ecpdevbermuda/ignite/apache-ignite-2.7.0-bin.zip IGNITE_VERSION=2.7.0 IGNITE_WORKING_DIR=/project/ecpdevbermuda/ignite/

Re: How to failover/scale cluster in Apache Ignite

2020-02-13 Thread Vladimir Pligin
Hi, I'll try to do my best to help you. >> Is kill -9 the right way to kill a node? No, I don't think this is the right way. >> How about re-adding new nodes that were previously killed? You should clean a node's work directory before re-adding. >> How long does it take for the nodes to

Re: Ignite yarn resources keep on increasing

2020-02-13 Thread Andrei Aleksandrov
Hi, Could you please provide more details: 1)Your configurations and environment variables (IGNITE_PATH?) 2)The logs of your Ignite nodes where you see the mentioned exception. IGNITE_PATH - a path to unzipped Ignite distribution instead of the URL. Is it possible that you didn't unzip the

Re: Dynamic Cache Change not allowed

2020-02-13 Thread nithin91
Also one important observation is ,we are not getting this error "dynamic cache change is not allowed" when Ignite server node and client node is running on local machine.Getting this error only when server node is running in unix and trying to connect to this node from local system. Should the

Re: Scheduling Cache Refresh using Ignite

2020-02-13 Thread Andrei Aleksandrov
Hi, Can you please attach the full logs with the mentioned exception? BTW I don't see any attaches in the previous message (probably user list can't do it). BR, Andrei 2/13/2020 3:44 PM, nithin91 пишет: Attached the bean file used -- Sent from:

Re: Scheduling Cache Refresh using Ignite

2020-02-13 Thread nithin91
Following is the java code that loads the cache. package Load; import java.sql.Types; import org.apache.ignite.Ignite; import org.apache.ignite.IgniteCache; import org.apache.ignite.Ignition; import org.apache.ignite.cache.CacheAtomicityMode; import

Re: Scheduling Cache Refresh using Ignite

2020-02-13 Thread nithin91
Attached the bean file used -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Scheduling Cache Refresh using Ignite

2020-02-13 Thread nithin91
Thanks aealexsandrov. This information is very useful. Also i have one more query. Currently as a part of POC, installed Ignite in UNIX and trying to load the data from Oracle DB to Ignite Cache using Cache JDBC Pojo Store. As a part of this process, bean file is custom

Re: Slow cache updates with indexing module enabled

2020-02-13 Thread Andrei Aleksandrov
Hi, SQL query performance can be not great because of several cases: 1)Incorrect indexes. Please check that your EXPLAIN contains indexes and doesn't have scans for joins: INNER JOIN PUBLIC.PERSON P__Z1     /* PUBLIC.PERSON.__SCAN_ */ Probably the inline size for used index is incorrect or

Re: Scheduling Cache Refresh using Ignite

2020-02-13 Thread Andrei Aleksandrov
Hi, Please read my comments: 1)Ignite generally doesn't support changing of the cache configuration without re-creation of the the cache. But for SQL caches that were created via QueryEntity or CREATE TABLE you can add and remove the columns using ALTER TABLE commands:

Re: Ignite on yarn doesn't started

2020-02-13 Thread Andrei Aleksandrov
Hi, I asked you to check it because I see the next option: IGNITE_PATH = /tmp/ignite/apache-ignite-2.7.6-bin.zip This option should be a path to *unzipped *Ignite distribution instead of the URL (you set zip) Also I see commented IGNITE_URL option: #IGNITE_URL =

Re: Using EntryProcessor arguments recommendations

2020-02-13 Thread Andrei Aleksandrov
Hi, I suggest to read the documentation: EntryProcessor: https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/cache/CacheEntry.html Invoke java doc:

Re: JDBC thin client incorrect security context

2020-02-13 Thread Andrei Aleksandrov
Hi, I see that you found the ticket related to the current issue: https://issues.apache.org/jira/browse/IGNITE-12589 Looks like it can be a reason of your problem. Generally, I don't know how you implemented your security plugin if you take a look at similar plugin from third party vendor

Ignite yarn resources keep on increasing

2020-02-13 Thread ChandanS
I am using ignite 2.7 version for ignite yarn deployment. I have my own spark application that start ignite yarn cluster and load data to ignite. It works fine in positive scenarios, but whenever there is an exception from the ignite-yarn.jar side like giving wrong path for some properties

Re: Loading and Fetching the Data using Node js.

2020-02-13 Thread nithin91
Hi Pasted below the code and error i got.Actually i am trying query an existing cache using node js which is loaded using Cache JDBC Pojo Store in Java.It would be really helpful share me if you have any sample code. PS C:\Users\ngovind\NodeApp> node NodeIgnite.js ERROR: Binary type has