from:"Sriveena Mattaparthi"

Unsubscribe

2022-06-22 Thread Sriveena Mattaparthi


"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

Ignite 2.8.1 : Fetched result set was too large.

2021-02-24 Thread Sriveena Mattaparthi

Hi,

We are getting below exception execution join query using Cache.
We are using left outer join on two tables one with 2lakh rows and another with 
80K and output has around 60K rows with various where conditions.


Cache.executequery() is returning below exception.

Error:
class org.apache.ignite.IgniteException: Fetched result set was too large.
exception
javax.cache.CacheException: Failed to run reduce query locally. Failed to 
execute SQL query.
General error: "class org.apache.ignite.IgniteException: Fetched result set was 
too large."; SQL statement:

We are using Ignite persistence enabled cache and tried lazy loading and 
enforce join order options already.
Tried executing the join query in dbeaver and got same exception.

Will increasing RAM helps or is there any other solution to it. Please suggest.

Thanks in advance.
"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

Unsubscribe

2020-06-25 Thread Sriveena Mattaparthi


“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

RE: [CVE-2020-1963] Apache Ignite access to file system disclosure vulnerability

2020-06-03 Thread Sriveena Mattaparthi

Thanks, Could you please confirm when the analysis will be updated here for the 
CVE logged.
https://nvd.nist.gov/vuln/detail/CVE-2020-1963

Regards,
Sriveena

From: Юрий 
Sent: 03 June 2020 16:02
To: dev ; user@ignite.apache.org; annou...@apache.org; 
Apache Security Team ; Sriveena Mattaparthi 

Subject: [CVE-2020-1963] Apache Ignite access to file system disclosure 
vulnerability

Hi All,

Apache Ignite 2.8.1 has been released. The release contain fix of critical 
vulnerability

CVE-2020-1963: Apache Ignite access to file system through predefined H2 SQL 
functions

Severity: Critical

Vendor:
The Apache Software Foundation

Versions Affected:
All versions of Apache Ignite up to 2.8

Impact
An attacker can use embedded H2 SQL functions to access a filesystem for write 
and read.

Description:
Apache Ignite uses H2 database to build SQL distributed execution engine. H2 
provides SQL functions which could be used by attacker to access to a 
filesystem.

Mitigation:
Ignite 2.8 or earlier users should upgrade to 2.8.1
In case SQL is not used at all the issue could be mitigated by removing 
ignite-indexing.jar from Ignite classpath
Risk could be partially mitigated by using non privileged user to start Apache 
Ignite.

Credit:
This issue was discovered by Sriveena Mattaparthi of 
ekaplus.com<https://apc01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fekaplus.com%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cfd4be57b204d40b49a3208d807a952ca%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C637267771122745491&sdata=eOKf4r6a1PmMvRg1HKa79HZqd%2Fp%2Fhq%2BJGlHmIZoLy%2Bo%3D&reserved=0>

--
Живи с улыбкой! :D
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

RE: Ignite Upgrade 2.5.6 to 2.8.0 - data loss

2020-05-02 Thread Sriveena Mattaparthi

We have been receiving quick support till now on any queries raised.
Request to please guide us in this also ASAP as we have production upgrade 
planned in couple of days.

Thanks in advance.

Regards,
Sriveena

From: Sriveena Mattaparthi
Sent: 03 May 2020 01:21
To: user@ignite.apache.org
Subject: Ignite Upgrade 2.5.6 to 2.8.0 - data loss
Importance: High

Hi,

Thank for the support so far. We have been using ignite from 4 years and we 
have no issues so far.
But now, We are facing critical issue in data loss while upgrading ignite from 
2.5.6 to 2.8.0.

We tried copying the work folder from 2.5.6 to 2.8.0 and start 2.8.0 ignite 
server.
But the server is going down with below error.
Please help us ASAP.

[05:15:22] Ignite node started OK (id=233c2412)
[05:15:22] Topology snapshot [ver=1, locNode=233c2412, servers=1, clients=0, 
state=INACTIVE, CPUs=8, offheap=22.0GB, heap=14.0GB]
[05:15:22]   ^-- Baseline [id=0, size=1, online=1, offline=0]
[05:15:22]   ^-- All baseline nodes are online, will start auto-activation
[05:15:23,679][SEVERE][exchange-worker-#46][GridDhtPartitionsExchangeFuture] 
Failed to activate node components 
[nodeId=233c2412-5483-41ad-b27f-61cbacd1610c, client=false, 
topVer=AffinityTopologyVersion [topVer=1, minorTopVer=1]]
java.lang.IllegalStateException: Duplicate key
at 
org.apache.ignite.cache.QueryEntity.checkIndexes(QueryEntity.java:233)
at org.apache.ignite.cache.QueryEntity.makePatch(QueryEntity.java:184)
at 
org.apache.ignite.internal.processors.query.QuerySchema.makePatch(QuerySchema.java:114)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheContext(GridCacheProcessor.java:1972)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.lambda$null$6a5b31b9$1(GridCacheProcessor.java:1830)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.lambda$prepareStartCachesIfPossible$9(GridCacheProcessor.java:1771)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.lambda$prepareStartCaches$926b6886$1(GridCacheProcessor.java:1827)
at 
org.apache.ignite.internal.util.IgniteUtils.lambda$null$1(IgniteUtils.java:11138)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Suppressed: java.lang.IllegalStateException: Duplicate key
... 12 more
Suppressed: java.lang.IllegalStateException: Duplicate key
... 12 more
Suppressed: java.lang.IllegalStateException: Duplicate key
... 12 more
Suppressed: java.lang.IllegalStateException: Duplicate key
... 12 more
Suppressed: java.lang.IllegalStateException: Duplicate key
at 
org.apache.ignite.cache.QueryEntity.checkIndexes(QueryEntity.java:233)
at 
org.apache.ignite.cache.QueryEntity.makePatch(QueryEntity.java:184)
at 
org.apache.ignite.internal.processors.query.QuerySchema.makePatch(QuerySchema.java:114)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheContext(GridCacheProcessor.java:1972)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.lambda$null$6a5b31b9$1(GridCacheProcessor.java:1830)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.lambda$prepareStartCachesIfPossible$9(GridCacheProcessor.java:1771)


Thanks,
Sriveena
"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

Ignite Upgrade 2.5.6 to 2.8.0 - data loss

2020-05-02 Thread Sriveena Mattaparthi

Hi,

Thank for the support so far. We have been using ignite from 4 years and we 
have no issues so far.
But now, We are facing critical issue in data loss while upgrading ignite from 
2.5.6 to 2.8.0.

We tried copying the work folder from 2.5.6 to 2.8.0 and start 2.8.0 ignite 
server.
But the server is going down with below error.
Please help us ASAP.

[05:15:22] Ignite node started OK (id=233c2412)
[05:15:22] Topology snapshot [ver=1, locNode=233c2412, servers=1, clients=0, 
state=INACTIVE, CPUs=8, offheap=22.0GB, heap=14.0GB]
[05:15:22]   ^-- Baseline [id=0, size=1, online=1, offline=0]
[05:15:22]   ^-- All baseline nodes are online, will start auto-activation
[05:15:23,679][SEVERE][exchange-worker-#46][GridDhtPartitionsExchangeFuture] 
Failed to activate node components 
[nodeId=233c2412-5483-41ad-b27f-61cbacd1610c, client=false, 
topVer=AffinityTopologyVersion [topVer=1, minorTopVer=1]]
java.lang.IllegalStateException: Duplicate key
at 
org.apache.ignite.cache.QueryEntity.checkIndexes(QueryEntity.java:233)
at org.apache.ignite.cache.QueryEntity.makePatch(QueryEntity.java:184)
at 
org.apache.ignite.internal.processors.query.QuerySchema.makePatch(QuerySchema.java:114)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheContext(GridCacheProcessor.java:1972)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.lambda$null$6a5b31b9$1(GridCacheProcessor.java:1830)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.lambda$prepareStartCachesIfPossible$9(GridCacheProcessor.java:1771)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.lambda$prepareStartCaches$926b6886$1(GridCacheProcessor.java:1827)
at 
org.apache.ignite.internal.util.IgniteUtils.lambda$null$1(IgniteUtils.java:11138)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Suppressed: java.lang.IllegalStateException: Duplicate key
... 12 more
Suppressed: java.lang.IllegalStateException: Duplicate key
... 12 more
Suppressed: java.lang.IllegalStateException: Duplicate key
... 12 more
Suppressed: java.lang.IllegalStateException: Duplicate key
... 12 more
Suppressed: java.lang.IllegalStateException: Duplicate key
at 
org.apache.ignite.cache.QueryEntity.checkIndexes(QueryEntity.java:233)
at 
org.apache.ignite.cache.QueryEntity.makePatch(QueryEntity.java:184)
at 
org.apache.ignite.internal.processors.query.QuerySchema.makePatch(QuerySchema.java:114)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheContext(GridCacheProcessor.java:1972)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.lambda$null$6a5b31b9$1(GridCacheProcessor.java:1830)
at 
org.apache.ignite.internal.processors.cache.GridCacheProcessor.lambda$prepareStartCachesIfPossible$9(GridCacheProcessor.java:1771)


Thanks,
Sriveena
"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

Ignite -Option to close the open files

2020-04-21 Thread Sriveena Mattaparthi

Hi,

Ignite server in preproduction and production are going down with too many open 
files error.

Caused by: java.nio.file.FileSystemException: 
/opt/apache-ignite-fabric-2.5.0-bin/work/db/node00-94e4310a-f450-4bbc-acfd-f84ab29a158c/cache-SQL_PUBLIC_x/part-185.bin:
 Too many open files

Based on the suggestion given in 
https://issues.apache.org/jira/browse/IGNITE-11783, we have increased the limit.

But recently again after increasing the limit to 30 also, sever has crashed.

Is there a way programmatically to close the open files, so that the threshold 
limit is not exceeded.

Please suggest as production servers also, we are facing same issue and it is 
very critical for us.

Thanks,
Sriveena
"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

RE: Security threat due to H2 admin privileges for Ignite

2020-03-13 Thread Sriveena Mattaparthi

Hi Mikhail,

Thanks for the quick response.
Sure..will provide more details if it is ensured that this thread doesn't go 
public.
Please confirm.

Thanks,
Sriveena

-Original Message-
From: Mikhail 
Sent: 13 March 2020 23:50
To: user@ignite.apache.org
Subject: RE: Security threat due to H2 admin privileges for Ignite

Hi Sriveena,

I do no quite understand your concerns, Apache Ignite is just a java 
application which you can be run under any user account with restricted 
privileges.

Could you please describe you question in more detail?

>Which means user can execute any kind of system functions like
>filewrite,
fileread etc.
Also, I've never heard about such kind of function and have doubts that you can 
run this in Ignite SQL, could you please show me the example of usage for these 
functions?

Thanks,
Mike.



--
Sent from: 
https://apc01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fapache-ignite-users.70518.x6.nabble.com%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cca309c0fc06043bbe2f208d7c77b1cae%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C1%7C637197203916032313&sdata=CqQTCEgWnRti9Euljj6NMqzRKqPRfHGwH8OvBV3vHT0%3D&reserved=0
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

RE: Security threat due to H2 admin privileges for Ignite

2020-03-13 Thread Sriveena Mattaparthi

Please suggest on ways to override the ignite configurations to start h2 
database user with a custom user who has low privileges.

Thanks,
Sriveena

From: Sriveena Mattaparthi
Sent: 12 March 2020 15:42
To: user@ignite.apache.org
Subject: Security threat due to H2 admin privileges for Ignite

Hi,

We are using ignite to run join queries which are handwritten by user.
We have got a security threat using ignite as ignite is using h2 with admin 
privilieges.

Which means user can execute any kind of system functions like filewrite, 
fileread etc.
Is there a way to start ignite with a low privileged h2 user who doesn't have 
admin access to perform any of the system functions?
Please  help.

Thanks,
Sriveena

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

Security threat due to H2 admin privileges for Ignite

2020-03-12 Thread Sriveena Mattaparthi

Hi,

We are using ignite to run join queries which are handwritten by user.
We have got a security threat using ignite as ignite is using h2 with admin 
privilieges.

Which means user can execute any kind of system functions like filewrite, 
fileread etc.
Is there a way to start ignite with a low privileged h2 user who doesn't have 
admin access to perform any of the system functions?
Please  help.

Thanks,
Sriveena

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

RE: Settings to override default Ignite JDBC Thin Driver port 10800

2018-12-18 Thread Sriveena Mattaparthi

Thanks Ilya..

Regards,
Sriveena

From: Ilya Kasnacheev [mailto:ilya.kasnach...@gmail.com]
Sent: Tuesday, December 18, 2018 9:56 PM
To: user@ignite.apache.org
Subject: Re: Settings to override default Ignite JDBC Thin Driver port 10800

Hello!

As far as my understanding goes, you can have client connectors on both client 
and server nodes, so it is up to you to decide which nodes you will be using as 
endpoints for thin clients.

Regards,
--
Ilya Kasnacheev

вт, 18 дек. 2018 г. в 17:06, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thanks Ilya..

Are the client node changes mentioned below during start up not required 
then?please confirm

Regards,
Sriveena

From: Ilya Kasnacheev 
mailto:ilya.kasnach...@gmail.com>>
Sent: 18 December 2018 19:22:45
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Settings to override default Ignite JDBC Thin Driver port 10800

Hello!

On server, you can use

Regards,
--
Ilya Kasnacheev

вт, 18 дек. 2018 г. в 16:20, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Thanks Ilya,

Could you please correct the settings to be done for overrring the default port 
then?

Thanks & Regards,

Sriveena

From: Ilya Kasnacheev 
[mailto:ilya.kasnach...@gmail.com<mailto:ilya.kasnach...@gmail.com>]
Sent: Tuesday, December 18, 2018 6:21 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Settings to override default Ignite JDBC Thin Driver port 10800

Hello!

Client connector port is a different thing than either communication port or 
discovery port.

You don't have to override neither of those.

Regards,

--

Ilya Kasnacheev

вт, 18 дек. 2018 г. в 15:49, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Hi,

We would like to override the default port 10800. For this we have made the 
below changes.

On client node

Ignition.setClientMode(true);

ClientConnectorConfiguration clientCfg = new ClientConnectorConfiguration();

clientCfg.setPort(10850);

IgniteConfiguration cfg = new 
IgniteConfiguration().setClientConnectorConfiguration(clientCfg)

ignite = Ignition.start(cfg);

ignite.cluster().active(true);

and get the jdbc connection using

Connection conn = 
DriverManager.getConnection("jdbc:ignite:thin://127.0.0.1:10850/<https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2F127.0.0.1%3A10850%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C1228890b9d194ead51a408d665059620%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636807472020983000&sdata=nsFrNP5z%2Bd08m2bBneuDjqOH8AciThkSHR53lzutaHI%3D&reserved=0>");

On Ignite server

We didn’t setup 10850 port in any of the xml except

Do we have to setup the communication port 10850 in the xml also?

Please confirm.

Thanks & Regards,

Sriveena

“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any

Re: Settings to override default Ignite JDBC Thin Driver port 10800

2018-12-18 Thread Sriveena Mattaparthi

Thanks Ilya..

Are the client node changes mentioned below during start up not required 
then?please confirm

Regards,
Sriveena

From: Ilya Kasnacheev 
Sent: 18 December 2018 19:22:45
To: user@ignite.apache.org
Subject: Re: Settings to override default Ignite JDBC Thin Driver port 10800

Hello!

On server, you can use

  


  



  

Regards,
--
Ilya Kasnacheev


вт, 18 дек. 2018 г. в 16:20, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Thanks Ilya,



Could you please correct the settings to be done for overrring the default port 
then?



Thanks & Regards,

Sriveena



From: Ilya Kasnacheev 
[mailto:ilya.kasnach...@gmail.com<mailto:ilya.kasnach...@gmail.com>]
Sent: Tuesday, December 18, 2018 6:21 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Settings to override default Ignite JDBC Thin Driver port 10800



Hello!



Client connector port is a different thing than either communication port or 
discovery port.

You don't have to override neither of those.



Regards,

--

Ilya Kasnacheev





вт, 18 дек. 2018 г. в 15:49, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Hi,



We would like to override the default port 10800. For this we have made the 
below changes.



On client node



Ignition.setClientMode(true);

ClientConnectorConfiguration clientCfg = new ClientConnectorConfiguration();

clientCfg.setPort(10850);



IgniteConfiguration cfg = new 
IgniteConfiguration().setClientConnectorConfiguration(clientCfg)

ignite = Ignition.start(cfg);

ignite.cluster().active(true);



and get the jdbc connection using

Connection conn = 
DriverManager.getConnection("jdbc:ignite:thin://127.0.0.1:10850/<https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2F127.0.0.1%3A10850%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C85c0baebc5c14ec6b06008d664f02086%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636807379857891779&sdata=ms4kj12QuW6UXE%2F3PG7S71ktjq0v%2FmkOvFdCoP%2BYK6M%3D&reserved=0>");



On Ignite server

We didn’t setup 10850 port in any of the xml except



















Do we have to setup the communication port 10850 in the xml also?

Please confirm.



Thanks & Regards,

Sriveena



“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

RE: Settings to override default Ignite JDBC Thin Driver port 10800

2018-12-18 Thread Sriveena Mattaparthi

Thanks Ilya,

Could you please correct the settings to be done for overrring the default port 
then?

Thanks & Regards,
Sriveena

From: Ilya Kasnacheev [mailto:ilya.kasnach...@gmail.com]
Sent: Tuesday, December 18, 2018 6:21 PM
To: user@ignite.apache.org
Subject: Re: Settings to override default Ignite JDBC Thin Driver port 10800

Hello!

Client connector port is a different thing than either communication port or 
discovery port.
You don't have to override neither of those.

Regards,
--
Ilya Kasnacheev


вт, 18 дек. 2018 г. в 15:49, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi,

We would like to override the default port 10800. For this we have made the 
below changes.

On client node

Ignition.setClientMode(true);
ClientConnectorConfiguration clientCfg = new ClientConnectorConfiguration();
clientCfg.setPort(10850);

IgniteConfiguration cfg = new 
IgniteConfiguration().setClientConnectorConfiguration(clientCfg)
ignite = Ignition.start(cfg);
ignite.cluster().active(true);

and get the jdbc connection using
Connection conn = 
DriverManager.getConnection("jdbc:ignite:thin://127.0.0.1:10850/<https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2F127.0.0.1%3A10850%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C976c5d640cd14a3c93b208d664e78107%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636807342798216127&sdata=oUyR3mEWW9thk7luCC2Q6%2F7DB22nQoqjyZ5YiYbxB1k%3D&reserved=0>");

On Ignite server
We didn’t setup 10850 port in any of the xml except









Do we have to setup the communication port 10850 in the xml also?
Please confirm.

Thanks & Regards,
Sriveena

“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

Settings to override default Ignite JDBC Thin Driver port 10800

2018-12-18 Thread Sriveena Mattaparthi

Hi,

We would like to override the default port 10800. For this we have made the 
below changes.

On client node

Ignition.setClientMode(true);
ClientConnectorConfiguration clientCfg = new ClientConnectorConfiguration();
clientCfg.setPort(10850);

IgniteConfiguration cfg = new 
IgniteConfiguration().setClientConnectorConfiguration(clientCfg)
ignite = Ignition.start(cfg);
ignite.cluster().active(true);

and get the jdbc connection using
Connection conn = 
DriverManager.getConnection("jdbc:ignite:thin://127.0.0.1:10850/");

On Ignite server
We didn't setup 10850 port in any of the xml except









Do we have to setup the communication port 10850 in the xml also?
Please confirm.

Thanks & Regards,
Sriveena

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

RE: OVER() clause in ignite

2018-10-24 Thread Sriveena Mattaparthi

Thanks Andrey…

Regards,
Sriveena

From: Andrey Mashenkov [mailto:andrey.mashen...@gmail.com]
Sent: Wednesday, October 24, 2018 1:07 PM
To: user@ignite.apache.org; Sriveena Mattaparthi
Subject: Re: OVER() clause in ignite

Hi,

Ignite have no support window functions due to lack of underlying H2.
OVER is a part of SQL ANSI'03 standart, but Ignite claims to be ANSI'99 
complaint.

The only workaround is to rewrite query with using joins or calculate result 
manually.
User aggregate functions also are not supported and we have no plans for this, 
see IGNITE-2177 [1].

There is ticket for Window-functions support IGNITE-6918 [2], but it is not 
planned to any future version for now.

[1] 
https://issues.apache.org/jira/browse/IGNITE-2177<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fissues.apache.org%2Fjira%2Fbrowse%2FIGNITE-2177&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Ce9bb7fe8544b491a98e608d639838483%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636759634391503123&sdata=DTw5KI79Sqm11genZCHZOT5AHKgzqRpRV8OblOC5keg%3D&reserved=0>
[2] 
https://issues.apache.org/jira/browse/IGNITE-6918<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fissues.apache.org%2Fjira%2Fbrowse%2FIGNITE-6918&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Ce9bb7fe8544b491a98e608d639838483%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636759634391503123&sdata=8yZh%2BfUdBl3QDCCHzZcQ6AVt5vxEXBQCqh8tULLY96c%3D&reserved=0>

On Wed, Oct 24, 2018 at 9:55 AM Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>> 
wrote:
Thanks Mikael..Could you please suggest any other alternative to achieve this?

Regards,
Sriveena

From: Mikael 
[mailto:mikael-arons...@telia.com<mailto:mikael-arons...@telia.com>]
Sent: Wednesday, October 24, 2018 11:47 AM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: OVER() clause in ignite

Hi!

As far as I know H2 does not support OVER.
Mikael
Den 2018-10-24 kl. 07:28, skrev Sriveena Mattaparthi:
Do we support over() clause in SQL in ignite like
select count(*) over() totalrecords  from EMPLOYEE;

please confirm.

Thanks & Regards,
Sriveena

“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

--
Best regards,
Andrey V. Mashenkov
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

RE: OVER() clause in ignite

2018-10-24 Thread Sriveena Mattaparthi

Thanks Mikael

Regards,
Sriveena

From: Mikael [mailto:mikael-arons...@telia.com]
Sent: Wednesday, October 24, 2018 12:36 PM
To: user@ignite.apache.org
Subject: Re: OVER() clause in ignite

Hi!

I am not sure, but you might find something useful here:

https://stackoverflow.com/questions/6249449/is-h2-database-able-to-make-sql-query-of-the-over-clause-with-aggregate-function<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F6249449%2Fis-h2-database-able-to-make-sql-query-of-the-over-clause-with-aggregate-function&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C57a6bf08fed0464371f108d6397f2a8c%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636759615692736094&sdata=f9e4lkna49dOD5gJ2lpuppInptTA%2BD3T9WAeMne1OEE%3D&reserved=0>

Mikael

Den 2018-10-24 kl. 08:55, skrev Sriveena Mattaparthi:
Thanks Mikael..Could you please suggest any other alternative to achieve this?

Regards,
Sriveena

From: Mikael [mailto:mikael-arons...@telia.com]
Sent: Wednesday, October 24, 2018 11:47 AM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: OVER() clause in ignite

Hi!

As far as I know H2 does not support OVER.
Mikael
Den 2018-10-24 kl. 07:28, skrev Sriveena Mattaparthi:
Do we support over() clause in SQL in ignite like
select count(*) over() totalrecords  from EMPLOYEE;

please confirm.

Thanks & Regards,
Sriveena

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

RE: OVER() clause in ignite

2018-10-23 Thread Sriveena Mattaparthi

Thanks Mikael..Could you please suggest any other alternative to achieve this?

Regards,
Sriveena

From: Mikael [mailto:mikael-arons...@telia.com]
Sent: Wednesday, October 24, 2018 11:47 AM
To: user@ignite.apache.org
Subject: Re: OVER() clause in ignite

Hi!

As far as I know H2 does not support OVER.
Mikael
Den 2018-10-24 kl. 07:28, skrev Sriveena Mattaparthi:
Do we support over() clause in SQL in ignite like
select count(*) over() totalrecords  from EMPLOYEE;

please confirm.

Thanks & Regards,
Sriveena

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

RE: Over clause in ignite

2018-10-23 Thread Sriveena Mattaparthi

I am not the intended recipient of this email

From: Sriveena Mattaparthi [mailto:sriveena.mattapar...@ekaplus.com]
Sent: Wednesday, October 24, 2018 11:14 AM
To: user@ignite.apache.org
Subject: Over clause in ignite

Do we support over() clause in ignite SQL queries like
select count(*) over() totalrecords  from EMPLOYEE;

please confirm.

Thanks & Regards,
Sriveena

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."
"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

Over clause in ignite

2018-10-23 Thread Sriveena Mattaparthi

Do we support over() clause in ignite SQL queries like
select count(*) over() totalrecords  from EMPLOYEE;

please confirm.

Thanks & Regards,
Sriveena

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

RE: OVER() clause in ignite

2018-10-23 Thread Sriveena Mattaparthi

Do we support over() clause in SQL in ignite like
select count(*) over() totalrecords  from EMPLOYEE;

please confirm.

Thanks & Regards,
Sriveena

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

OVER() clause in ignite

2018-10-23 Thread Sriveena Mattaparthi

Do we support over() clause in SQL in ignite like
select count(*) over() totalrecords  from EMPLOYEE;

please confirm.

Thanks & Regards,
Sriveena

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

Re: Batch insert into ignite using jdbc thin driver taking long time

2018-09-06 Thread Sriveena Mattaparthi

Hi Ilya,

It did compiled...but it is not inserting records to ignite at all...

I waited for 20 mins for it to insert and terminated and there are no 
exceptions in the ignite log.

Could you please suggest the right syntax to enable the streaming using jdbc 
thin driver..and my key concern is performance...Inserting 1 million records 
with 90 columns each row should get completed in less than 30 sec is what we 
are looking for...
Is it possible with ignite?

Thanks & Regards,
Sriveena

From: Ilya Kasnacheev 
Sent: 06 September 2018 17:24:13
To: user@ignite.apache.org
Subject: Re: Batch insert into ignite using jdbc thin driver taking long time

Hello!

I'm not sure but it doesn't look right to me. Does it compile?

Note that you also need to SET STREAMING OFF after data load is complete.


--
Ilya Kasnacheev


чт, 6 сент. 2018 г. в 14:42, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Thanks Ilya. Will try using together.



Please correct if the below statement work.

getConnection().createStatement().execute("SET STREAMING ON");



Regards,

Sriveena



From: Ilya Kasnacheev 
[mailto:ilya.kasnach...@gmail.com<mailto:ilya.kasnach...@gmail.com>]
Sent: Thursday, September 06, 2018 3:28 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Batch insert into ignite using jdbc thin driver taking long time



Hello!



I don't see why not. Have you tried? Any difference in run time?



Regards,

--

Ilya Kasnacheev





чт, 6 сент. 2018 г. в 6:20, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Hi Ilya,



Can we cobimbe both of them together I mean

1. SET STREAMING ON;

2.   JDBC thin driver batch insert (pstmt.executeBatch())



Thanks & Regards,
Sriveena



From: Ilya Kasnacheev 
[mailto:ilya.kasnach...@gmail.com<mailto:ilya.kasnach...@gmail.com>]
Sent: Wednesday, September 05, 2018 7:02 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Batch insert into ignite using jdbc thin driver taking long time



Hello!



Have you tried streaming mode?



https://apacheignite-sql.readme.io/docs/set<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fset&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C7d329f7496a845c707bb08d61333fb1d%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636717511328312021&sdata=WfZ7m34afylAJv0PZ0GRo2o7mIQVxR6f%2BCb2MuQUj3M%3D&reserved=0>



Regards,

--

Ilya Kasnacheev





ср, 5 сент. 2018 г. в 15:44, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Hi,



I am trying to batch insert 30 records into ignite cache(on remote server) 
using jdbc thin driver.

It is taking nearly 4mins to complete this operation. Please advise.



Thanks & Regards,

Sriveena



“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and ma

RE: Batch insert into ignite using jdbc thin driver taking long time

2018-09-06 Thread Sriveena Mattaparthi

Thanks Ilya. Will try using together.

Please correct if the below statement work.
getConnection().createStatement().execute("SET STREAMING ON");

Regards,
Sriveena

From: Ilya Kasnacheev [mailto:ilya.kasnach...@gmail.com]
Sent: Thursday, September 06, 2018 3:28 PM
To: user@ignite.apache.org
Subject: Re: Batch insert into ignite using jdbc thin driver taking long time

Hello!

I don't see why not. Have you tried? Any difference in run time?

Regards,
--
Ilya Kasnacheev


чт, 6 сент. 2018 г. в 6:20, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi Ilya,

Can we cobimbe both of them together I mean

1. SET STREAMING ON;

2.   JDBC thin driver batch insert (pstmt.executeBatch())

Thanks & Regards,
Sriveena

From: Ilya Kasnacheev 
[mailto:ilya.kasnach...@gmail.com<mailto:ilya.kasnach...@gmail.com>]
Sent: Wednesday, September 05, 2018 7:02 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Batch insert into ignite using jdbc thin driver taking long time

Hello!

Have you tried streaming mode?

https://apacheignite-sql.readme.io/docs/set<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fset&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C7d329f7496a845c707bb08d61333fb1d%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636717511328312021&sdata=WfZ7m34afylAJv0PZ0GRo2o7mIQVxR6f%2BCb2MuQUj3M%3D&reserved=0>

Regards,
--
Ilya Kasnacheev


ср, 5 сент. 2018 г. в 15:44, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi,

I am trying to batch insert 30 records into ignite cache(on remote server) 
using jdbc thin driver.
It is taking nearly 4mins to complete this operation. Please advise.

Thanks & Regards,
Sriveena

“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

Memory configurations for ignite client on EC2

2018-09-05 Thread Sriveena Mattaparthi

Hi,

We are using ignite for heavy datajoins operations with persistence enabled set 
true. It was performing well on linux machines.
But once deployed to EC2( production environment), any data joins performed is 
crashing the client application.

EC2 used is 32GB RAM and 24GB is assigned to client application.
Ignite server is on a different EC2 instance.

Are there any recommended memory settings for ignite client node?

Thanks & Regards,
Sriveena

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

RE: Batch insert into ignite using jdbc thin driver taking long time

2018-09-05 Thread Sriveena Mattaparthi

Hi Ilya,

Can we cobimbe both of them together I mean

1. SET STREAMING ON;

2.   JDBC thin driver batch insert (pstmt.executeBatch())

Thanks & Regards,
Sriveena

From: Ilya Kasnacheev [mailto:ilya.kasnach...@gmail.com]
Sent: Wednesday, September 05, 2018 7:02 PM
To: user@ignite.apache.org
Subject: Re: Batch insert into ignite using jdbc thin driver taking long time

Hello!

Have you tried streaming mode?

https://apacheignite-sql.readme.io/docs/set<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fset&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C7d329f7496a845c707bb08d61333fb1d%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636717511328312021&sdata=WfZ7m34afylAJv0PZ0GRo2o7mIQVxR6f%2BCb2MuQUj3M%3D&reserved=0>

Regards,
--
Ilya Kasnacheev


ср, 5 сент. 2018 г. в 15:44, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi,

I am trying to batch insert 30 records into ignite cache(on remote server) 
using jdbc thin driver.
It is taking nearly 4mins to complete this operation. Please advise.

Thanks & Regards,
Sriveena

“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

Batch insert into ignite using jdbc thin driver taking long time

2018-09-05 Thread Sriveena Mattaparthi

Hi,

I am trying to batch insert 30 records into ignite cache(on remote server) 
using jdbc thin driver.
It is taking nearly 4mins to complete this operation. Please advise.

Thanks & Regards,
Sriveena

"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

RE: Example for server client configuration in ignite

2018-09-03 Thread Sriveena Mattaparthi

Hi,

Please point to some reference on the below questions.

Thanks & Regards,
Sriveena

From: Sriveena Mattaparthi
Sent: Friday, August 31, 2018 4:24 PM
To: user@ignite.apache.org
Subject: RE: Example for server client configuration in ignite

Hi Evgenii,

In the document mentioned on Result Set Lazy Load, if result set is too big to 
fit in the available memory, then it can lead to prolonged GC pauses and even 
OutOfMemoryError.

1.   Is it referring to the on heap memory of the client application or the 
off heap memory?

2.   Is it referring to prolonged GC of client application and how?

Thanks & Regards,
Sriveena

From: Evgenii Zhuravlev [mailto:e.zhuravlev...@gmail.com]
Sent: Wednesday, August 29, 2018 2:03 PM
To: user@ignite.apache.org
Subject: Re: Example for server client configuration in ignite

Join performed on the server nodes where data placed. To reduce the overall 
size of the reduce set on the client you can use lazy flag for result set: 
https://apacheignite-sql.readme.io/docs/performance-and-debugging#section-result-set-lazy-load<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fperformance-and-debugging%23section-result-set-lazy-load&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C4e5e1807d5f84dc0076008d60d8a2493%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636711284345864800&sdata=8DmrZhMEkuqhh1d6BDjGOBoYtRYJjCXo04YlBMeZTVg%3D&reserved=0>

Evgenii

пн, 27 авг. 2018 г. в 19:44, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thanks Evgenii..

Now the question is code for client ignite start is deployed in an application 
server.
Any data join performed on the client node cache is utilizing jvm heap memory 
assigned to the  application resulting in outofmemory on the application server.

Is there a way to limit the client node memory utilization of application 
server heap memory or run client node on separate ibn?

Please note that persistence is enabled on the ignite configuration.

From: Evgenii Zhuravlev 
mailto:e.zhuravlev...@gmail.com>>
Sent: 27 August 2018 21:41:41
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Example for server client configuration in ignite

Yes, you start client node, not a server. I'd recommend you to read about 
differences between client and server nodes: 
https://apacheignite.readme.io/docs/clients-vs-servers<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fclients-vs-servers&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C646c52d9b3064b05272f08d60c37ce47%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636709831174713298&sdata=DOLZ7OkBxVhNOpcb0la%2F3lmFeifM8ptU%2B0R5iXFajOc%3D&reserved=0>

2018-08-27 19:06 GMT+03:00 Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thanks Evgenii..

To reframe my question ..server is started on a separate host...client node is 
setup using java connecting to remote server as mentioned in the  below mail...

Does invoking ignition.start on client node means starting ignite once more?

Thanks & Regards,
Sriveena

From: Evgenii Zhuravlev 
mailto:e.zhuravlev...@gmail.com>>
Sent: 27 August 2018 19:54:16

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Example for server client configuration in ignite

>1.Do we have to start Ignite again on client node as Ignition.start(cfg)? What 
>does this imply?
Sorry, I didn't get it, what do you mean by "start again"?
>2.Will the client node uses the JVM heap memory
Ignite runs inside JVM, so yes, it will use JVM heap. Could you specify your 
question?

Evgenii

пн, 27 авг. 2018 г. в 14:36, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Thanks Evgenii

Started remote server, using the default configuration given as part of the 
ignite disctribution using

$ bin\ignite.bat examples\config\example-ignite.xml

And client node started in java  as pointed below using

Ignition.setClientMode(true);

TcpDiscoverySpi spi = new TcpDiscoverySpi();

TcpDiscoveryVmIpFinder ipFinder = new TcpDiscoveryVmIpFinder();

ipFinder.setAddresses(Arrays.asList("1.2.3.4", "1.2.3.5:47500..47509"));

spi.setIpFinder(ipFinder);

IgniteConfiguration cfg = new IgniteConfiguration();

cfg.setDiscoverySpi(spi);

// Start Ignite node.

Ignition.start(cfg);

My question is

1.Do we have to start Ignite again on client node as Ignition.start(cfg)? What 
does this imply?

2.Will the client node uses the JVM heap memory

Thanks & Regards,

Sriveena

From: Evgenii Zhuravlev 
[mailto:e.zhuravlev...@gmail.com<mailto:e.zhuravlev...@gmail.com>]
Sent: Monday, August 27, 2018 4:52 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Example for serve

RE: Example for server client configuration in ignite

2018-08-31 Thread Sriveena Mattaparthi

Hi Evgenii,

In the document mentioned on Result Set Lazy Load, if result set is too big to 
fit in the available memory, then it can lead to prolonged GC pauses and even 
OutOfMemoryError.


1.   Is it referring to the on heap memory of the client application or the 
off heap memory?

2.   Is it referring to prolonged GC of client application and how?

Thanks & Regards,
Sriveena

From: Evgenii Zhuravlev [mailto:e.zhuravlev...@gmail.com]
Sent: Wednesday, August 29, 2018 2:03 PM
To: user@ignite.apache.org
Subject: Re: Example for server client configuration in ignite

Join performed on the server nodes where data placed. To reduce the overall 
size of the reduce set on the client you can use lazy flag for result set: 
https://apacheignite-sql.readme.io/docs/performance-and-debugging#section-result-set-lazy-load<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fperformance-and-debugging%23section-result-set-lazy-load&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C4e5e1807d5f84dc0076008d60d8a2493%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636711284345864800&sdata=8DmrZhMEkuqhh1d6BDjGOBoYtRYJjCXo04YlBMeZTVg%3D&reserved=0>

Evgenii

пн, 27 авг. 2018 г. в 19:44, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thanks Evgenii..

Now the question is code for client ignite start is deployed in an application 
server.
Any data join performed on the client node cache is utilizing jvm heap memory 
assigned to the  application resulting in outofmemory on the application server.

Is there a way to limit the client node memory utilization of application 
server heap memory or run client node on separate ibn?

Please note that persistence is enabled on the ignite configuration.

From: Evgenii Zhuravlev 
mailto:e.zhuravlev...@gmail.com>>
Sent: 27 August 2018 21:41:41
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Example for server client configuration in ignite

Yes, you start client node, not a server. I'd recommend you to read about 
differences between client and server nodes: 
https://apacheignite.readme.io/docs/clients-vs-servers<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fclients-vs-servers&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C646c52d9b3064b05272f08d60c37ce47%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636709831174713298&sdata=DOLZ7OkBxVhNOpcb0la%2F3lmFeifM8ptU%2B0R5iXFajOc%3D&reserved=0>

2018-08-27 19:06 GMT+03:00 Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thanks Evgenii..

To reframe my question ..server is started on a separate host...client node is 
setup using java connecting to remote server as mentioned in the  below mail...

Does invoking ignition.start on client node means starting ignite once more?

Thanks & Regards,
Sriveena

From: Evgenii Zhuravlev 
mailto:e.zhuravlev...@gmail.com>>
Sent: 27 August 2018 19:54:16

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Example for server client configuration in ignite


>1.Do we have to start Ignite again on client node as Ignition.start(cfg)? What 
>does this imply?
Sorry, I didn't get it, what do you mean by "start again"?
>2.Will the client node uses the JVM heap memory
Ignite runs inside JVM, so yes, it will use JVM heap. Could you specify your 
question?

Evgenii

пн, 27 авг. 2018 г. в 14:36, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Thanks Evgenii



Started remote server, using the default configuration given as part of the 
ignite disctribution using

$ bin\ignite.bat examples\config\example-ignite.xml



And client node started in java  as pointed below using



Ignition.setClientMode(true);



TcpDiscoverySpi spi = new TcpDiscoverySpi();

TcpDiscoveryVmIpFinder ipFinder = new TcpDiscoveryVmIpFinder();

ipFinder.setAddresses(Arrays.asList("1.2.3.4", "1.2.3.5:47500..47509"));

spi.setIpFinder(ipFinder);

IgniteConfiguration cfg = new IgniteConfiguration();

cfg.setDiscoverySpi(spi);

// Start Ignite node.

Ignition.start(cfg);



My question is

1.Do we have to start Ignite again on client node as Ignition.start(cfg)? What 
does this imply?



2.Will the client node uses the JVM heap memory



Thanks & Regards,

Sriveena



From: Evgenii Zhuravlev 
[mailto:e.zhuravlev...@gmail.com<mailto:e.zhuravlev...@gmail.com>]
Sent: Monday, August 27, 2018 4:52 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Example for server client configuration in ignite



Hi,



The default configuration will work with the remote server, because it uses 
multicast. It will work if you want to check some examples, etc.



For production usage, I'd recommend using static Ip Find

RE: Drop table taking more time for execution

2018-08-29 Thread Sriveena Mattaparthi

Hi Denis,

We thought it would have the same performance impact as DROP TABLE. Hence we 
didn’t used it.
May be we will try that option and get back to you.

Thanks & Regards,
Sriveena

From: Denis Magda [mailto:dma...@apache.org]
Sent: Thursday, August 30, 2018 11:06 AM
To: user@ignite.apache.org
Subject: Re: Drop table taking more time for execution

Next time if there is change in the data from the data source in terms of 
addition of new column or delete column...Then we drop the table in ignite and 
recreate it.

Is there any reason why you can't use ALTER TABLE command for the addition or 
remove of columns in runtime? It will be more efficient.

--
Denis

On Tue, Aug 28, 2018 at 9:49 AM Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>> 
wrote:
Hi Ilya..
We load data from various data sources to ignite as tables and run data join 
queries on ignite and sends the response back.

Next time if there is change in the data from the data source in terms of 
addition of new column or delete column...Then we drop the table in ignite and 
recreate it.

Thanks,
Sriveena

From: Ilya Kasnacheev 
mailto:ilya.kasnach...@gmail.com>>
Sent: 28 August 2018 20:21:20
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Drop table taking more time for execution

Hello!

First of all, what is the problem that you are facing? Why DROP TABLE taking 
15s while being ran infrequently is a cause for concern?

Regards,
--
Ilya Kasnacheev


вт, 28 авг. 2018 г. в 17:42, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com><mailto:sriveena.mattapar...@ekaplus.com<mailto:sriveena.mattapar...@ekaplus.com>>>:
Thanks Ilya for the quick reply..

We have to drop the table in few cases where the table columns and datatypes 
changes ...
I guess alter table to add/ drop columns may take same longer time.

Any other alternative to drop table?

Regards,
Sriveena

From: Ilya Kasnacheev 
mailto:ilya.kasnach...@gmail.com><mailto:ilya.kasnach...@gmail.com<mailto:ilya.kasnach...@gmail.com>>>
Sent: 28 August 2018 20:04:09
To: 
user@ignite.apache.org<mailto:user@ignite.apache.org><mailto:user@ignite.apache.org<mailto:user@ignite.apache.org>>
Subject: Re: Drop table taking more time for execution

Hello!

As far as my understanding goes, DROP TABLE will usually destroy a cache, and 
that will require partition map exchange, which in turn will wait for all 
operations to finish. With increase of load and cluster size 15s does not seem 
excessive.

The suggestion is to avoid dropping/creating tables often, and especially as 
the course of normal operation.

Regards,
--
Ilya Kasnacheev


вт, 28 авг. 2018 г. в 17:24, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com><mailto:sriveena.mattapar...@ekaplus.com<mailto:sriveena.mattapar...@ekaplus.com>>>:
Hi,

Execution of drop table command is taking 15 sec on client node.Any suggestions 
to spewed up the execution.

Thanks & Regards,
Sriveena “Confidentiality Notice: The contents of this email message and any 
attachments are intended solely for the addressee(s) and may contain 
confidential and/or privileged information and may be legally protected from 
disclosure. If you are not the intended recipient of this message or their 
agent, or if this message has been addressed to you in error, please 
immediately alert the sender by reply email and then delete this message and 
any attachments. If you are not the intended recipient, you are hereby notified 
that any use, dissemination, copying, or storage of this message or its 
attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly pro

RE: Example for server client configuration in ignite

2018-08-29 Thread Sriveena Mattaparthi

Thank you so much Evgenii for the pointer.
Will try this option and get back to you.

Regards,
Sriveena

From: Evgenii Zhuravlev [mailto:e.zhuravlev...@gmail.com]
Sent: Wednesday, August 29, 2018 2:03 PM
To: user@ignite.apache.org
Subject: Re: Example for server client configuration in ignite

Join performed on the server nodes where data placed. To reduce the overall 
size of the reduce set on the client you can use lazy flag for result set: 
https://apacheignite-sql.readme.io/docs/performance-and-debugging#section-result-set-lazy-load<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fperformance-and-debugging%23section-result-set-lazy-load&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C4e5e1807d5f84dc0076008d60d8a2493%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636711284345864800&sdata=8DmrZhMEkuqhh1d6BDjGOBoYtRYJjCXo04YlBMeZTVg%3D&reserved=0>

Evgenii

пн, 27 авг. 2018 г. в 19:44, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thanks Evgenii..

Now the question is code for client ignite start is deployed in an application 
server.
Any data join performed on the client node cache is utilizing jvm heap memory 
assigned to the  application resulting in outofmemory on the application server.

Is there a way to limit the client node memory utilization of application 
server heap memory or run client node on separate ibn?

Please note that persistence is enabled on the ignite configuration.

From: Evgenii Zhuravlev 
mailto:e.zhuravlev...@gmail.com>>
Sent: 27 August 2018 21:41:41
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Example for server client configuration in ignite

Yes, you start client node, not a server. I'd recommend you to read about 
differences between client and server nodes: 
https://apacheignite.readme.io/docs/clients-vs-servers<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fclients-vs-servers&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C646c52d9b3064b05272f08d60c37ce47%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636709831174713298&sdata=DOLZ7OkBxVhNOpcb0la%2F3lmFeifM8ptU%2B0R5iXFajOc%3D&reserved=0>

2018-08-27 19:06 GMT+03:00 Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thanks Evgenii..

To reframe my question ..server is started on a separate host...client node is 
setup using java connecting to remote server as mentioned in the  below mail...

Does invoking ignition.start on client node means starting ignite once more?

Thanks & Regards,
Sriveena

From: Evgenii Zhuravlev 
mailto:e.zhuravlev...@gmail.com>>
Sent: 27 August 2018 19:54:16

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Example for server client configuration in ignite

>1.Do we have to start Ignite again on client node as Ignition.start(cfg)? What 
>does this imply?
Sorry, I didn't get it, what do you mean by "start again"?
>2.Will the client node uses the JVM heap memory
Ignite runs inside JVM, so yes, it will use JVM heap. Could you specify your 
question?

Evgenii

пн, 27 авг. 2018 г. в 14:36, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Thanks Evgenii

Started remote server, using the default configuration given as part of the 
ignite disctribution using

$ bin\ignite.bat examples\config\example-ignite.xml

And client node started in java  as pointed below using

Ignition.setClientMode(true);

TcpDiscoverySpi spi = new TcpDiscoverySpi();

TcpDiscoveryVmIpFinder ipFinder = new TcpDiscoveryVmIpFinder();

ipFinder.setAddresses(Arrays.asList("1.2.3.4", "1.2.3.5:47500..47509"));

spi.setIpFinder(ipFinder);

IgniteConfiguration cfg = new IgniteConfiguration();

cfg.setDiscoverySpi(spi);

// Start Ignite node.

Ignition.start(cfg);

My question is

1.Do we have to start Ignite again on client node as Ignition.start(cfg)? What 
does this imply?

2.Will the client node uses the JVM heap memory

Thanks & Regards,

Sriveena

From: Evgenii Zhuravlev 
[mailto:e.zhuravlev...@gmail.com<mailto:e.zhuravlev...@gmail.com>]
Sent: Monday, August 27, 2018 4:52 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Example for server client configuration in ignite

Hi,

The default configuration will work with the remote server, because it uses 
multicast. It will work if you want to check some examples, etc.

For production usage, I'd recommend using static Ip Finder instead of 
multicast, here is the simplest configuration that will work with remote server:

https://apacheignite.readme.io/docs/tcpip-discovery#section-static-ip-finder<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Ftcpip-discovery

Re: Drop table taking more time for execution

2018-08-28 Thread Sriveena Mattaparthi

Hi Ilya..
We load data from various data sources to ignite as tables and run data join 
queries on ignite and sends the response back.

Next time if there is change in the data from the data source in terms of 
addition of new column or delete column...Then we drop the table in ignite and 
recreate it.

Thanks,
Sriveena

From: Ilya Kasnacheev 
Sent: 28 August 2018 20:21:20
To: user@ignite.apache.org
Subject: Re: Drop table taking more time for execution

Hello!

First of all, what is the problem that you are facing? Why DROP TABLE taking 
15s while being ran infrequently is a cause for concern?

Regards,
--
Ilya Kasnacheev


вт, 28 авг. 2018 г. в 17:42, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thanks Ilya for the quick reply..

We have to drop the table in few cases where the table columns and datatypes 
changes ...
I guess alter table to add/ drop columns may take same longer time.

Any other alternative to drop table?

Regards,
Sriveena

From: Ilya Kasnacheev 
mailto:ilya.kasnach...@gmail.com>>
Sent: 28 August 2018 20:04:09
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Drop table taking more time for execution

Hello!

As far as my understanding goes, DROP TABLE will usually destroy a cache, and 
that will require partition map exchange, which in turn will wait for all 
operations to finish. With increase of load and cluster size 15s does not seem 
excessive.

The suggestion is to avoid dropping/creating tables often, and especially as 
the course of normal operation.

Regards,
--
Ilya Kasnacheev


вт, 28 авг. 2018 г. в 17:24, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi,

Execution of drop table command is taking 15 sec on client node.Any suggestions 
to spewed up the execution.

Thanks & Regards,
Sriveena “Confidentiality Notice: The contents of this email message and any 
attachments are intended solely for the addressee(s) and may contain 
confidential and/or privileged information and may be legally protected from 
disclosure. If you are not the intended recipient of this message or their 
agent, or if this message has been addressed to you in error, please 
immediately alert the sender by reply email and then delete this message and 
any attachments. If you are not the intended recipient, you are hereby notified 
that any use, dissemination, copying, or storage of this message or its 
attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

Re: Drop table taking more time for execution

2018-08-28 Thread Sriveena Mattaparthi

Thanks Ilya for the quick reply..

We have to drop the table in few cases where the table columns and datatypes 
changes ...
I guess alter table to add/ drop columns may take same longer time.

Any other alternative to drop table?

Regards,
Sriveena

From: Ilya Kasnacheev 
Sent: 28 August 2018 20:04:09
To: user@ignite.apache.org
Subject: Re: Drop table taking more time for execution

Hello!

As far as my understanding goes, DROP TABLE will usually destroy a cache, and 
that will require partition map exchange, which in turn will wait for all 
operations to finish. With increase of load and cluster size 15s does not seem 
excessive.

The suggestion is to avoid dropping/creating tables often, and especially as 
the course of normal operation.

Regards,
--
Ilya Kasnacheev


вт, 28 авг. 2018 г. в 17:24, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi,

Execution of drop table command is taking 15 sec on client node.Any suggestions 
to spewed up the execution.

Thanks & Regards,
Sriveena “Confidentiality Notice: The contents of this email message and any 
attachments are intended solely for the addressee(s) and may contain 
confidential and/or privileged information and may be legally protected from 
disclosure. If you are not the intended recipient of this message or their 
agent, or if this message has been addressed to you in error, please 
immediately alert the sender by reply email and then delete this message and 
any attachments. If you are not the intended recipient, you are hereby notified 
that any use, dissemination, copying, or storage of this message or its 
attachments is strictly prohibited.”
“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited.”

Drop table taking more time for execution

2018-08-28 Thread Sriveena Mattaparthi

Hi,

Execution of drop table command is taking 15 sec on client node.Any suggestions 
to spewed up the execution.

Thanks & Regards,
Sriveena "Confidentiality Notice: The contents of this email message and any 
attachments are intended solely for the addressee(s) and may contain 
confidential and/or privileged information and may be legally protected from 
disclosure. If you are not the intended recipient of this message or their 
agent, or if this message has been addressed to you in error, please 
immediately alert the sender by reply email and then delete this message and 
any attachments. If you are not the intended recipient, you are hereby notified 
that any use, dissemination, copying, or storage of this message or its 
attachments is strictly prohibited."

Re: Example for server client configuration in ignite

2018-08-27 Thread Sriveena Mattaparthi

Thanks Evgenii..

Now the question is code for client ignite start is deployed in an application 
server.
Any data join performed on the client node cache is utilizing jvm heap memory 
assigned to the  application resulting in outofmemory on the application server.

Is there a way to limit the client node memory utilization of application 
server heap memory or run client node on separate ibn?

Please note that persistence is enabled on the ignite configuration.


From: Evgenii Zhuravlev 
Sent: 27 August 2018 21:41:41
To: user@ignite.apache.org
Subject: Re: Example for server client configuration in ignite

Yes, you start client node, not a server. I'd recommend you to read about 
differences between client and server nodes: 
https://apacheignite.readme.io/docs/clients-vs-servers<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fclients-vs-servers&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C646c52d9b3064b05272f08d60c37ce47%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636709831174713298&sdata=DOLZ7OkBxVhNOpcb0la%2F3lmFeifM8ptU%2B0R5iXFajOc%3D&reserved=0>

2018-08-27 19:06 GMT+03:00 Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thanks Evgenii..

To reframe my question ..server is started on a separate host...client node is 
setup using java connecting to remote server as mentioned in the  below mail...

Does invoking ignition.start on client node means starting ignite once more?

Thanks & Regards,
Sriveena

From: Evgenii Zhuravlev 
mailto:e.zhuravlev...@gmail.com>>
Sent: 27 August 2018 19:54:16

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Example for server client configuration in ignite


>1.Do we have to start Ignite again on client node as Ignition.start(cfg)? What 
>does this imply?
Sorry, I didn't get it, what do you mean by "start again"?
>2.Will the client node uses the JVM heap memory
Ignite runs inside JVM, so yes, it will use JVM heap. Could you specify your 
question?

Evgenii

пн, 27 авг. 2018 г. в 14:36, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Thanks Evgenii



Started remote server, using the default configuration given as part of the 
ignite disctribution using

$ bin\ignite.bat examples\config\example-ignite.xml



And client node started in java  as pointed below using



Ignition.setClientMode(true);



TcpDiscoverySpi spi = new TcpDiscoverySpi();

TcpDiscoveryVmIpFinder ipFinder = new TcpDiscoveryVmIpFinder();

ipFinder.setAddresses(Arrays.asList("1.2.3.4", "1.2.3.5:47500..47509"));

spi.setIpFinder(ipFinder);

IgniteConfiguration cfg = new IgniteConfiguration();

cfg.setDiscoverySpi(spi);

// Start Ignite node.

Ignition.start(cfg);



My question is

1.Do we have to start Ignite again on client node as Ignition.start(cfg)? What 
does this imply?



2.Will the client node uses the JVM heap memory



Thanks & Regards,

Sriveena



From: Evgenii Zhuravlev 
[mailto:e.zhuravlev...@gmail.com<mailto:e.zhuravlev...@gmail.com>]
Sent: Monday, August 27, 2018 4:52 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Example for server client configuration in ignite



Hi,



The default configuration will work with the remote server, because it uses 
multicast. It will work if you want to check some examples, etc.



For production usage, I'd recommend using static Ip Finder instead of 
multicast, here is the simplest configuration that will work with remote server:

https://apacheignite.readme.io/docs/tcpip-discovery#section-static-ip-finder<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Ftcpip-discovery%23section-static-ip-finder&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cdf036d2b84054674a91608d60c0f4ee2%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636709657237020433&sdata=0H8nUrwx%2BmNG4bRr9v150MRZTLdwdxS4G2j4cJ5waYU%3D&reserved=0>

There you will need just to replace address in IpFinder with the address of 
your remote server. You don't need to place client address there.



Yo start client instead of the server node, you have to add clientMode=true 
property in this configuration.



Evgenii





пн, 27 авг. 2018 г. в 13:47, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Hi,



What is the recommended configuration for remote Server and one client node 
setup?

Can someone point to the relevant examples?



Thanks & Regards,

Sriveena



“Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this

Re: Example for server client configuration in ignite

2018-08-27 Thread Sriveena Mattaparthi

Thanks Evgenii..

To reframe my question ..server is started on a separate host...client node is 
setup using java connecting to remote server as mentioned in the  below mail...

Does invoking ignition.start on client node means starting ignite once more?

Thanks & Regards,
Sriveena

From: Evgenii Zhuravlev 
Sent: 27 August 2018 19:54:16
To: user@ignite.apache.org
Subject: Re: Example for server client configuration in ignite


>1.Do we have to start Ignite again on client node as Ignition.start(cfg)? What 
>does this imply?
Sorry, I didn't get it, what do you mean by "start again"?
>2.Will the client node uses the JVM heap memory
Ignite runs inside JVM, so yes, it will use JVM heap. Could you specify your 
question?

Evgenii

пн, 27 авг. 2018 г. в 14:36, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Thanks Evgenii



Started remote server, using the default configuration given as part of the 
ignite disctribution using

$ bin\ignite.bat examples\config\example-ignite.xml



And client node started in java  as pointed below using



Ignition.setClientMode(true);



TcpDiscoverySpi spi = new TcpDiscoverySpi();

TcpDiscoveryVmIpFinder ipFinder = new TcpDiscoveryVmIpFinder();

ipFinder.setAddresses(Arrays.asList("1.2.3.4", "1.2.3.5:47500..47509"));

spi.setIpFinder(ipFinder);

IgniteConfiguration cfg = new IgniteConfiguration();

cfg.setDiscoverySpi(spi);

// Start Ignite node.

Ignition.start(cfg);



My question is

1.Do we have to start Ignite again on client node as Ignition.start(cfg)? What 
does this imply?



2.Will the client node uses the JVM heap memory



Thanks & Regards,

Sriveena



From: Evgenii Zhuravlev 
[mailto:e.zhuravlev...@gmail.com<mailto:e.zhuravlev...@gmail.com>]
Sent: Monday, August 27, 2018 4:52 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Example for server client configuration in ignite



Hi,



The default configuration will work with the remote server, because it uses 
multicast. It will work if you want to check some examples, etc.



For production usage, I'd recommend using static Ip Finder instead of 
multicast, here is the simplest configuration that will work with remote server:

https://apacheignite.readme.io/docs/tcpip-discovery#section-static-ip-finder<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Ftcpip-discovery%23section-static-ip-finder&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cdf036d2b84054674a91608d60c0f4ee2%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636709657237020433&sdata=0H8nUrwx%2BmNG4bRr9v150MRZTLdwdxS4G2j4cJ5waYU%3D&reserved=0>

There you will need just to replace address in IpFinder with the address of 
your remote server. You don't need to place client address there.



Yo start client instead of the server node, you have to add clientMode=true 
property in this configuration.



Evgenii





пн, 27 авг. 2018 г. в 13:47, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Hi,



What is the recommended configuration for remote Server and one client node 
setup?

Can someone point to the relevant examples?



Thanks & Regards,

Sriveena



"Confidentiality Notice: The contents of this email message and any attachments 
are intended solely for the addressee(s) and may contain confidential and/or 
privileged information and may be legally protected from disclosure. If you are 
not the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are not 
the intended recipient, you are hereby notified that any use, dissemination, 
copying, or storage of this message or its attachments is strictly prohibited."

RE: Example for server client configuration in ignite

2018-08-27 Thread Sriveena Mattaparthi

Thanks Evgenii

Started remote server, using the default configuration given as part of the 
ignite disctribution using
$ bin\ignite.bat examples\config\example-ignite.xml

And client node started in java  as pointed below using

Ignition.setClientMode(true);

TcpDiscoverySpi spi = new TcpDiscoverySpi();
TcpDiscoveryVmIpFinder ipFinder = new TcpDiscoveryVmIpFinder();
ipFinder.setAddresses(Arrays.asList("1.2.3.4", "1.2.3.5:47500..47509"));
spi.setIpFinder(ipFinder);
IgniteConfiguration cfg = new IgniteConfiguration();
cfg.setDiscoverySpi(spi);
// Start Ignite node.
Ignition.start(cfg);

My question is
1.Do we have to start Ignite again on client node as Ignition.start(cfg)? What 
does this imply?

2.Will the client node uses the JVM heap memory

Thanks & Regards,
Sriveena

From: Evgenii Zhuravlev [mailto:e.zhuravlev...@gmail.com]
Sent: Monday, August 27, 2018 4:52 PM
To: user@ignite.apache.org
Subject: Re: Example for server client configuration in ignite

Hi,

The default configuration will work with the remote server, because it uses 
multicast. It will work if you want to check some examples, etc.

For production usage, I'd recommend using static Ip Finder instead of 
multicast, here is the simplest configuration that will work with remote server:
https://apacheignite.readme.io/docs/tcpip-discovery#section-static-ip-finder<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Ftcpip-discovery%23section-static-ip-finder&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cdf036d2b84054674a91608d60c0f4ee2%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636709657237020433&sdata=0H8nUrwx%2BmNG4bRr9v150MRZTLdwdxS4G2j4cJ5waYU%3D&reserved=0>
There you will need just to replace address in IpFinder with the address of 
your remote server. You don't need to place client address there.

Yo start client instead of the server node, you have to add clientMode=true 
property in this configuration.

Evgenii


пн, 27 авг. 2018 г. в 13:47, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi,

What is the recommended configuration for remote Server and one client node 
setup?
Can someone point to the relevant examples?

Thanks & Regards,
Sriveena

Example for server client configuration in ignite

2018-08-27 Thread Sriveena Mattaparthi

Hi,

What is the recommended configuration for remote Server and one client node 
setup?
Can someone point to the relevant examples?

Thanks & Regards,
Sriveena

RE: Batch insert into ignite

2018-07-25 Thread Sriveena Mattaparthi

Thanks Michael…I have a question here…


1.   Will the set/copy options mentioned work for SQL Query fields? 
Something like
.   Cache.query(new SQLQueryFields(“SET STREAMING 
ON”))


2.   IgniteDataStreamer streams data and add to cache without using JDBC 
driver.
But we would want to add the data stream into insert table. Is this possible?

Regards,
Sriveena


From: Michael Cherkasov [mailto:michael.cherka...@gmail.com]
Sent: Wednesday, July 25, 2018 6:23 PM
To: user@ignite.apache.org
Subject: Re: Batch insert into ignite

Hi again,

One more option as pure sql solution:
https://apacheignite-sql.readme.io/docs/copy<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fcopy&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cb6b82626c30540c84a7208d5f2305410%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636681211752818655&sdata=jn%2BOF9H0ydUVqQ8reY6dkQAFoBbq%2FpOyQWpkPYgWXLc%3D&reserved=0>
https://apacheignite-sql.readme.io/docs/set<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fset&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cb6b82626c30540c84a7208d5f2305410%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636681211752818655&sdata=18Gr7V7L7mB7Mj9dUbl0d4LqdoDVODrrA6w43XkiJVg%3D&reserved=0>

However, IgniteDataStreamer should work faster, because as I know, these SQL 
commands have data streamer as underlying implementation.

Thanks,
Mike.

2018-07-25 7:02 GMT+03:00 Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thanks for the clarification Michael..will try the streamer option.

Regards,
Sriveena

From: Michael Cherkasov 
[mailto:michael.cherka...@gmail.com<mailto:michael.cherka...@gmail.com>]
Sent: Tuesday, July 24, 2018 9:49 PM

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Batch insert into ignite

I can't say for sure which one should be better for sure, it must be 
benchmarked.
But if you can use SqlFieldsQuery this means that you can use native Ignite 
API, right? So, in this case, 
IgniteDataStreamer<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fdata-streamers&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd7a2e5237e04417740a408d5f1814956%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636680459959631292&sdata=Vm%2BmWgmalYFrA6O9fZEWPzW0XRF%2BOYFVaAIwus%2FNU5k%3D&reserved=0>
 would be the best choice.


2018-07-24 9:36 GMT+03:00 Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi Mikhail,

Do we have this streaming/batch insert option, if we do a bulk insert using
cache.query(new SqlFieldsQuery("sql");

Also could you please confirm which one would perform better
1. Insert using IgniteJdbcDriver
2. Insert using SqlFieldsQuery

Thanks & Regards,
Sriveena

-Original Message-
From: Mikhail 
[mailto:michael.cherka...@gmail.com<mailto:michael.cherka...@gmail.com>]
Sent: Monday, July 23, 2018 10:32 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Batch insert into ignite

Hi Sriveena,

for data load you can try to use streaming mode for jdbc:
https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fjdbc-driver%23section-streaming-mode&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd2ff72f68e13451756c008d5f0be11d6%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636679621511638203&sdata=QGfXouNn0Juxv18j1p0rgnBx%2Fle90Ioo3E6W3S6ohR8%3D&reserved=0
it will provide faster insert operation compare to regular insert, also you
can disable WAL:
https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fwrite-ahead-log%23section-wal-activation-and-deactivation&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd2ff72f68e13451756c008d5f0be11d6%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636679621511638203&sdata=pjwp4tCzN9KnUq8s0cvTbmmaIDVj8O4UPylv7acYEUg%3D&reserved=0
to get better throughput.

Thanks,
Mike.



--
Sent from: 
https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fapache-ignite-users.70518.x6.nabble.com%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd2ff72f68e13451756c008d5f0be11d6%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636679621511638203&sdata=0Z7q%2BpGVuPa2rpB4wjYg4tKt5MPDYi4denqAbskOtZg%3D&reserved=0

RE: Batch insert into ignite

2018-07-24 Thread Sriveena Mattaparthi

Thanks for the clarification Michael..will try the streamer option.

Regards,
Sriveena

From: Michael Cherkasov [mailto:michael.cherka...@gmail.com]
Sent: Tuesday, July 24, 2018 9:49 PM
To: user@ignite.apache.org
Subject: Re: Batch insert into ignite

I can't say for sure which one should be better for sure, it must be 
benchmarked.
But if you can use SqlFieldsQuery this means that you can use native Ignite 
API, right? So, in this case, 
IgniteDataStreamer<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fdata-streamers&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd7a2e5237e04417740a408d5f1814956%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636680459959631292&sdata=Vm%2BmWgmalYFrA6O9fZEWPzW0XRF%2BOYFVaAIwus%2FNU5k%3D&reserved=0>
 would be the best choice.

2018-07-24 9:36 GMT+03:00 Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi Mikhail,

Do we have this streaming/batch insert option, if we do a bulk insert using
cache.query(new SqlFieldsQuery("sql");

Also could you please confirm which one would perform better
1. Insert using IgniteJdbcDriver
2. Insert using SqlFieldsQuery

Thanks & Regards,
Sriveena

-Original Message-
From: Mikhail 
[mailto:michael.cherka...@gmail.com<mailto:michael.cherka...@gmail.com>]
Sent: Monday, July 23, 2018 10:32 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Batch insert into ignite

Hi Sriveena,

for data load you can try to use streaming mode for jdbc:
https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fjdbc-driver%23section-streaming-mode&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd2ff72f68e13451756c008d5f0be11d6%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636679621511638203&sdata=QGfXouNn0Juxv18j1p0rgnBx%2Fle90Ioo3E6W3S6ohR8%3D&reserved=0
it will provide faster insert operation compare to regular insert, also you
can disable WAL:
https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fwrite-ahead-log%23section-wal-activation-and-deactivation&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd2ff72f68e13451756c008d5f0be11d6%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636679621511638203&sdata=pjwp4tCzN9KnUq8s0cvTbmmaIDVj8O4UPylv7acYEUg%3D&reserved=0
to get better throughput.

Thanks,
Mike.

--
Sent from: 
https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fapache-ignite-users.70518.x6.nabble.com%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd2ff72f68e13451756c008d5f0be11d6%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636679621511638203&sdata=0Z7q%2BpGVuPa2rpB4wjYg4tKt5MPDYi4denqAbskOtZg%3D&reserved=0

RE: Batch insert into ignite

2018-07-23 Thread Sriveena Mattaparthi

Hi Mikhail,

Do we have this streaming/batch insert option, if we do a bulk insert using 
cache.query(new SqlFieldsQuery("sql");

Also could you please confirm which one would perform better 
1. Insert using IgniteJdbcDriver
2. Insert using SqlFieldsQuery

Thanks & Regards,
Sriveena

-Original Message-
From: Mikhail [mailto:michael.cherka...@gmail.com] 
Sent: Monday, July 23, 2018 10:32 PM
To: user@ignite.apache.org
Subject: Re: Batch insert into ignite

Hi Sriveena,

for data load you can try to use streaming mode for jdbc:
https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fjdbc-driver%23section-streaming-mode&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd2ff72f68e13451756c008d5f0be11d6%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636679621511638203&sdata=QGfXouNn0Juxv18j1p0rgnBx%2Fle90Ioo3E6W3S6ohR8%3D&reserved=0
it will provide faster insert operation compare to regular insert, also you
can disable WAL:
https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fwrite-ahead-log%23section-wal-activation-and-deactivation&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd2ff72f68e13451756c008d5f0be11d6%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636679621511638203&sdata=pjwp4tCzN9KnUq8s0cvTbmmaIDVj8O4UPylv7acYEUg%3D&reserved=0
to get better throughput.

Thanks,
Mike.



--
Sent from: 
https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fapache-ignite-users.70518.x6.nabble.com%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd2ff72f68e13451756c008d5f0be11d6%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636679621511638203&sdata=0Z7q%2BpGVuPa2rpB4wjYg4tKt5MPDYi4denqAbskOtZg%3D&reserved=0

RE: Batch insert into ignite

2018-07-23 Thread Sriveena Mattaparthi

Thanks Mikhail...will try the same and get back to you..

-Original Message-
From: Mikhail [mailto:michael.cherka...@gmail.com] 
Sent: Monday, July 23, 2018 10:32 PM
To: user@ignite.apache.org
Subject: Re: Batch insert into ignite

Hi Sriveena,

for data load you can try to use streaming mode for jdbc:
https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fjdbc-driver%23section-streaming-mode&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd2ff72f68e13451756c008d5f0be11d6%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636679621511638203&sdata=QGfXouNn0Juxv18j1p0rgnBx%2Fle90Ioo3E6W3S6ohR8%3D&reserved=0
it will provide faster insert operation compare to regular insert, also you
can disable WAL:
https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fwrite-ahead-log%23section-wal-activation-and-deactivation&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd2ff72f68e13451756c008d5f0be11d6%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636679621511638203&sdata=pjwp4tCzN9KnUq8s0cvTbmmaIDVj8O4UPylv7acYEUg%3D&reserved=0
to get better throughput.

Thanks,
Mike.

--
Sent from: 
https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fapache-ignite-users.70518.x6.nabble.com%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cd2ff72f68e13451756c008d5f0be11d6%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636679621511638203&sdata=0Z7q%2BpGVuPa2rpB4wjYg4tKt5MPDYi4denqAbskOtZg%3D&reserved=0

Batch insert into ignite

2018-07-23 Thread Sriveena Mattaparthi

Hi,

How can we perform batch insert/update into ignite tables (created through 
sqlquery fields as create table)?

Thanks & Regards,
Sriveena

RE: Information regarding Ignite Web Console

2018-07-11 Thread Sriveena Mattaparthi

Hi Denis,

Please find the highlighted comments inline.

Data will change every time we hit select * from table in database..(should 
drop or remove complete data and insert)
I don't really understand what you mean.
Will the data change in database or Ignite?

should drop or remove complete data and insert
What do you mean by that? You want to remove all data from cache and then load 
it back from scratch?


n  Data in the database table changes very frequently and every time we query 
the table we get different data.

n  My question was : Instead of updating the data already loaded in cache, can 
we clear the cache and reload again?


Thanks & Regards,
Sriveena


From: Denis Mekhanikov [mailto:dmekhani...@gmail.com]
Sent: Wednesday, July 11, 2018 1:41 PM
To: user@ignite.apache.org
Subject: Re: Information regarding Ignite Web Console

Sriveena,

> what if the query doesn't have any primary key or unique idbut still have 
> to load the entire table data in ignite for further join querying with other 
> caches
You can implement cache store in such way, that it will assign a synthetic key 
for every loaded entry in 
CacheStore.loadCache(...)<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fcache%2Fstore%2FCacheStore.html%23loadCache-org.apache.ignite.lang.IgniteBiInClosure-java.lang.Object...-&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C559bc983482a4b4df21708d5e705eff5%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636668935073486479&sdata=0Z6Y3aFz987CW1cHrFoEAI65aSo46BXw%2FLdFka2wo00%3D&reserved=0>.
But it will be hard to use read-through in this case.

> Data will change every time we hit select * from table in database..(should 
> drop or remove complete data and insert)
I don't really understand what you mean.
Will the data change in database or Ignite?

> should drop or remove complete data and insert
What do you mean by that? You want to remove all data from cache and then load 
it back from scratch?


Denis

вт, 10 июл. 2018 г. в 19:54, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi Denis,
Thanks for the detailed explanation ...
1. what if the query doesn't have any primary key or unique idbut still 
have to load the entire table data in ignite for further join querying with 
other caches
2. Data will change every time we hit select * from table in database..(should 
drop or remove complete data and insert)

Please suggest right pointer in such cases..

Regards,
Sriveena

From: Denis Mekhanikov mailto:dmekhani...@gmail.com>>
Sent: 10 July 2018 19:16:56

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console
Sriveena,

Read-through works as follows: when you do a cache.get(...), and a record is 
not in the cache, then it goes to the configured CacheStore and requests the 
value from it.
When the same key is read from cache next time, then call to the underlying 
database doesn't happen, and caches value is returned.

So, auto-synchronization doesn't happen. Cache is populated on demand.

And it works regardless of the key type.

Denis

вт, 10 июл. 2018 г. в 14:12, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Hi,



How does DataGrid readthrough works?

1.   How does it auto synchronize the cache with database data?

2.   Will it poll the underlying database?

3.   Will it incrementally pull the data based on the key specified on the 
cache?

4.   Will the read through works if the cache key datatype is different 
other than a number(like String, Composite key or timestamp)



Please confirm.



Thanks & Regards,

Sriveena



From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Wednesday, June 27, 2018 6:37 PM

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console



Sriveena,



You can have objects of different types in one cache, but querying it will be 
tricky.

You will have to configure 
QueryEntities<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 for your data, that will describe, which fields are available for querying.

Annotation based 
configuration<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8

Re: Information regarding Ignite Web Console

2018-07-10 Thread Sriveena Mattaparthi

Hi Denis,
Thanks for the detailed explanation ...
1. what if the query doesn't have any primary key or unique idbut still 
have to load the entire table data in ignite for further join querying with 
other caches
2. Data will change every time we hit select * from table in database..(should 
drop or remove complete data and insert)

Please suggest right pointer in such cases..

Regards,
Sriveena

From: Denis Mekhanikov 
Sent: 10 July 2018 19:16:56
To: user@ignite.apache.org
Subject: Re: Information regarding Ignite Web Console

Sriveena,

Read-through works as follows: when you do a cache.get(...), and a record is 
not in the cache, then it goes to the configured CacheStore and requests the 
value from it.
When the same key is read from cache next time, then call to the underlying 
database doesn't happen, and caches value is returned.

So, auto-synchronization doesn't happen. Cache is populated on demand.

And it works regardless of the key type.

Denis

вт, 10 июл. 2018 г. в 14:12, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Hi,



How does DataGrid readthrough works?

1.   How does it auto synchronize the cache with database data?

2.   Will it poll the underlying database?

3.   Will it incrementally pull the data based on the key specified on the 
cache?

4.   Will the read through works if the cache key datatype is different 
other than a number(like String, Composite key or timestamp)



Please confirm.



Thanks & Regards,

Sriveena



From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Wednesday, June 27, 2018 6:37 PM

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console



Sriveena,



You can have objects of different types in one cache, but querying it will be 
tricky.

You will have to configure 
QueryEntities<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 for your data, that will describe, which fields are available for querying.

Annotation based 
configuration<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 is also available.

Querying nested object is also possible, if you configure the query entities 
properly: 
https://apacheignite-sql.readme.io/docs/schema-and-indexes#section-indexing-nested-objects<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-indexing-nested-objects&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=1amkW4husY1fLSN%2FKtEBx8app5u%2FkUJhqiA4JCYgQ0o%3D&reserved=0>



So, if you want to run SQL queries over your data, it should have some concrete 
schema.



Denis



ср, 27 июн. 2018 г. в 14:08, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Thank you so much for the quicker responses unlike any other forums..I really 
appreciate that.



One last question Denis, we have plan to load all the mongodb collections to 
ignite cache and perform complex aggregations and join in memory.



But Unlike any RDBMS data stores we cannot have fixed model objects for each 
collections as each document in the collection may have its own columns and 
datatypes.



Could you please suggest, if ignite is the choice for this kind of scenario 
where same mongo collection have different type of data.



Please note that we have tried using BinaryObject, but we are stuck that ignite 
doesn’t support querying on the inner binaryobject.( binaryobject inside a 
binaryobject – sub documents, array inside a mongo document)



Thanks & Regards,

Sriveena



From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Wednesday, June 27, 2018 4:02 PM

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console



Sriveena,



CacheStore<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fcache%2Fstore%2FCacheStore.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122c

RE: Information regarding Ignite Web Console

2018-07-10 Thread Sriveena Mattaparthi

Hi,

How does DataGrid readthrough works?

1.   How does it auto synchronize the cache with database data?

2.   Will it poll the underlying database?

3.   Will it incrementally pull the data based on the key specified on the 
cache?

4.   Will the read through works if the cache key datatype is different 
other than a number(like String, Composite key or timestamp)

Please confirm.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov [mailto:dmekhani...@gmail.com]
Sent: Wednesday, June 27, 2018 6:37 PM
To: user@ignite.apache.org
Subject: Re: Information regarding Ignite Web Console

Sriveena,

You can have objects of different types in one cache, but querying it will be 
tricky.
You will have to configure 
QueryEntities<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 for your data, that will describe, which fields are available for querying.
Annotation based 
configuration<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 is also available.
Querying nested object is also possible, if you configure the query entities 
properly: 
https://apacheignite-sql.readme.io/docs/schema-and-indexes#section-indexing-nested-objects<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-indexing-nested-objects&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=1amkW4husY1fLSN%2FKtEBx8app5u%2FkUJhqiA4JCYgQ0o%3D&reserved=0>

So, if you want to run SQL queries over your data, it should have some concrete 
schema.

Denis

ср, 27 июн. 2018 г. в 14:08, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thank you so much for the quicker responses unlike any other forums..I really 
appreciate that.

One last question Denis, we have plan to load all the mongodb collections to 
ignite cache and perform complex aggregations and join in memory.

But Unlike any RDBMS data stores we cannot have fixed model objects for each 
collections as each document in the collection may have its own columns and 
datatypes.

Could you please suggest, if ignite is the choice for this kind of scenario 
where same mongo collection have different type of data.

Please note that we have tried using BinaryObject, but we are stuck that ignite 
doesn’t support querying on the inner binaryobject.( binaryobject inside a 
binaryobject – sub documents, array inside a mongo document)

Thanks & Regards,
Sriveena

From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Wednesday, June 27, 2018 4:02 PM

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console

Sriveena,

CacheStore<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fcache%2Fstore%2FCacheStore.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260911744&sdata=7LEcZ6l%2FFMHm7ZZ518w4WH%2FBm8ylC3yhTDTl05AcZ0M%3D&reserved=0>
 extends the 
CacheWriter<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260911744&sdata=UBNLjs2J4E4IZG6JGhToO6QzOr7QXkNo7OFZycVYbq0%3D&reserved=0>
 interface, which has 
delete<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html%23delete(java.lang.Object)&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260921745&sdata=2q1Mutj83625oVhVIEiawuiarAsK8UNmyZvrbk9J7nE%3D&reserved=0>
 and 
deleteAll<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%

RE: Information regarding Ignite Web Console

2018-07-09 Thread Sriveena Mattaparthi

Hi Denis,

Does ignite support oracle/RDBMS VIEWS without loading all the underlying 
tables that produced the view on to ignite cache?

Thanks & Regards,
Sriveena

From: Denis Mekhanikov [mailto:dmekhani...@gmail.com]
Sent: Wednesday, June 27, 2018 4:02 PM
To: user@ignite.apache.org
Subject: Re: Information regarding Ignite Web Console

Sriveena,

CacheStore<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fcache%2Fstore%2FCacheStore.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260911744&sdata=7LEcZ6l%2FFMHm7ZZ518w4WH%2FBm8ylC3yhTDTl05AcZ0M%3D&reserved=0>
 extends the 
CacheWriter<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260911744&sdata=UBNLjs2J4E4IZG6JGhToO6QzOr7QXkNo7OFZycVYbq0%3D&reserved=0>
 interface, which has 
delete<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html%23delete(java.lang.Object)&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260921745&sdata=2q1Mutj83625oVhVIEiawuiarAsK8UNmyZvrbk9J7nE%3D&reserved=0>
 and 
deleteAll<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html%23deleteAll(java.util.Collection)&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260921745&sdata=NIJFLEwPbXOgpgkja9m48c8hENGNg1dTOyghSzaIiJ4%3D&reserved=0>
 methods, which will be called by Ignite, when you remove entries from Ignite 
caches.
write<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html%23write(javax.cache.Cache.Entry)&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260931759&sdata=tBdc%2FPmMicFBKc82w7s10TvP5r9Sl7%2B7FLPJidwsFsw%3D&reserved=0>
 and 
writeAll<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html%23writeAll(java.util.Collection)&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260931759&sdata=Sw5W5BSEgyrBRfoIUpx7pwIfYl5gXSNXtYefE4ghmBk%3D&reserved=0>
 methods will be called, when you put some data into cache.
It works the same way with MySQL or any other relational DB.
So, CacheStore gives you a possibility to implement synchronization with any 
external data source. You can do it for MongoDB, if you need.

Denis

ср, 27 июн. 2018 г. в 13:18, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thanks Denis for the pointers.

But the case explained in 
https://www.youtube.com/watch?v=XBtI2Z01kAA<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DXBtI2Z01kAA&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260941765&sdata=HLmtH02Dr4h455PggnRBQxe0eZJxENxp7nDlPXb5xek%3D&reserved=0>
 -  Using Ignite Web Console for Automatic RDBMS Integration with Apache Ignite 
- Part 3.
shows that any deletions happening on ignite cache are getting reflected in the 
mysql database.

Which I thought is ignite feature of autosyncing data to and from RDBMS 
databases.
Please correct my understanding.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Wednesday, June 27, 2018 3:28 PM

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console

Sriveena,

Web Console can generate schema in Ignite based on an existing schema in a 
relational database.
But you can do it yourself, without use of Web Console.
Web Console only makes it easier to wire-up stuff, i.e. generate required data 
classes and configuration.

Unfortunately, this feature is not available for NoSQL databases. But you still 
can configure everything yourself.
You will need to implement a 
CacheStore<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2F

RE: Information regarding Ignite Web Console

2018-07-04 Thread Sriveena Mattaparthi

Hi,

I have tried it. But ignite.cache("IKAFKA").size() is still zero.
Also can you please suggest how to access the cache for the explained values on 
topic and extractor implementation. 

Thanks & Regards,
Sriveena

-Original Message-
From: vbm [mailto:bmvish...@gmail.com] 
Sent: Wednesday, July 04, 2018 4:35 PM
To: user@ignite.apache.org
Subject: RE: Information regarding Ignite Web Console

Hi

Try to set stmr.autoFlushFrequency(1000) and check whether entries are
coming in cache.

Regards,
Vishwas





--
Sent from: 
https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fapache-ignite-users.70518.x6.nabble.com%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Ce42792c97ff64f6866c608d5e19e010c%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C1%7C636662991109100707&sdata=B91M8SoCV2DTLevgqJzEFEL0%2Bb9uU5oP1mVj8I0Pxjk%3D&reserved=0

RE: Information regarding Ignite Web Console

2018-07-04 Thread Sriveena Mattaparthi

nd JSON converters.
You can deserialize any data, coming from Kafka.
All you need is to implement a proper 
StreamSingleTupleExtractor<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fstream%2FStreamSingleTupleExtractor.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cdba57179c28741cc91a908d5e02dbcd2%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636661409431759416&sdata=Czc1yxhVUceks5FoR058kA%2BctUnuEV8r80SaixTDGL0%3D&reserved=0>

Denis

пн, 2 июл. 2018 г. в 14:03, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Denis,

Have some open questions in ignite

1.   Does all the tables created in ignite gets converted to binary objects 
internally?

2.   Does all the cache entities like Person gets converted to binary 
objects internally?

3.   Is using binary objects better than entity cache objects?

4.   Is the a way to deserialize AvroFormat messages from kafka to ignite 
sink? Examples are available for String and JSON converters.

Please help.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Friday, June 29, 2018 8:09 PM

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console

Sriveena,

You should configure corresponding query entities to be able to query data in 
cache.
Annotation driven configuration is also available.

See more: 
https://apacheignite.readme.io/docs/cache-queries#section-query-configuration-by-annotations<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fcache-queries%23section-query-configuration-by-annotations&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C54bd9746eb084b48efc108d5ddce2906%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636658799914056234&sdata=jOJs8Be4hdwLNY1AYdwCHU0sisEzcdSkwGEQY4v9%2F3Y%3D&reserved=0>

Denis

пт, 29 июн. 2018 г. в 12:43, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi Denis,

I am trying to use the below code to query the binary object

IgniteCache cache = 
start.getOrCreateCache(cfg).withKeepBinary();
BinaryObjectBuilder builder = start.binary().builder("BinaryTest");
builder.setField("name", "Test");
cache.put(1, builder.build());

QueryCursor> query = cache.query(new SqlFieldsQuery("select name 
from BinaryTest"));

But it is failing in latest 2.5 version saying BinaryTest Table does not exist.

How do we query the binary objects in the above example?

Please help.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Wednesday, June 27, 2018 6:37 PM

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console

Sriveena,

You can have objects of different types in one cache, but querying it will be 
tricky.
You will have to configure 
QueryEntities<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 for your data, that will describe, which fields are available for querying.
Annotation based 
configuration<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 is also available.
Querying nested object is also possible, if you configure the query entities 
properly: 
https://apacheignite-sql.readme.io/docs/schema-and-indexes#section-indexing-nested-objects<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-indexing-nested-objects&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=1amkW4husY1fLSN%2FKtEBx8app5u%2FkUJhqiA4JCYgQ0o%3D&reserved=0>

So, if you want to run SQL queries over your data, it should have some concrete 
schema.

Denis

ср, 27 июн. 2018 г. в 14:08, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thank you so much for the quicker responses unlike any other forums..I really 
appreciate that.

One last question Denis, we have plan to load all t

RE: Information regarding Ignite Web Console

2018-07-02 Thread Sriveena Mattaparthi

Hi Deniz,

Thank you so much for the detailed explanation.
This clarified so many open questions on going forward with ignite.

Regards,
Sriveena

From: Denis Mekhanikov [mailto:dmekhani...@gmail.com]
Sent: Monday, July 02, 2018 8:39 PM
To: user@ignite.apache.org
Subject: Re: Information regarding Ignite Web Console

You should specify 
QueryEntity.valueType<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fcache%2FQueryEntity.html%23setValueType-java.lang.String-&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cdba57179c28741cc91a908d5e02dbcd2%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636661409431739415&sdata=FcyKO1Sy8oTG%2BOXLXGzg2XS4E9T2R%2FEHlH2LDvloTbs%3D&reserved=0>
 corresponding to the type name, that you use when constructing a binary object.

Please find attached example, that shows how to insert BinaryObjects in a way, 
that will let you query them from SQL.
I made a named constant PERSON_TYPE_NAME to emphasise, that 
QueryEntity#valueType<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fcache%2FQueryEntity.html%23setValueType-java.lang.String-&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cdba57179c28741cc91a908d5e02dbcd2%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636661409431739415&sdata=FcyKO1Sy8oTG%2BOXLXGzg2XS4E9T2R%2FEHlH2LDvloTbs%3D&reserved=0>
 should match BinaryObject's type name.

If you want different binary objects with the same name to have different 
fields, you should disable 
BinaryConfiguration#compactFooter<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fconfiguration%2FBinaryConfiguration.html%23setCompactFooter-boolean-&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cdba57179c28741cc91a908d5e02dbcd2%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636661409431749411&sdata=%2FH%2FailQQWResSh1we9dAMVUu9idd57yITlI5opUXXHQ%3D&reserved=0>.
It will let different BinaryObjects with the same name have different schemas.
See the following thread for more information about compactFooter: 
http://apache-ignite-users.70518.x6.nabble.com/Best-practice-for-class-versioning-marshaller-error-td22294.html<https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fapache-ignite-users.70518.x6.nabble.com%2FBest-practice-for-class-versioning-marshaller-error-td22294.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cdba57179c28741cc91a908d5e02dbcd2%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636661409431749411&sdata=1qEv4ftuaWvuss20ksZZhyjCnFJbxD2lA7MNdNCnjnQ%3D&reserved=0>

But all fields, that you want to access from SQL, should be specified in the 
QueryEntity, so you should think about it in advance.

Denis

пн, 2 июл. 2018 г. в 17:54, Denis Mekhanikov 
mailto:dmekhani...@gmail.com>>:
> Does all the tables created in ignite gets converted to binary objects 
> internally?
Yes, unless you specify a different 
IgniteConfiguration#marshaller<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fconfiguration%2FIgniteConfiguration.html%23setMarshaller-org.apache.ignite.marshaller.Marshaller-&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cdba57179c28741cc91a908d5e02dbcd2%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636661409431759416&sdata=GrF7BYIXRQy%2F29%2Fv01XB5M6MRFXEifYYCl7eJVM%2FGV8%3D&reserved=0>.
But if you want to query data with Ignite SQL, only BinaryMarshaller is 
applicable.

> Does all the cache entities like Person gets converted to binary objects 
> internally?
All entries are serialized with a configured marshaller. It is binary 
marshaller by default.

> Is using binary objects better than entity cache objects?
Using POJOs is usually more convenient. But BinaryObject lets you operate over 
objects without having the corresponding POJOs on your class path.
Also by using BinaryObject you skip (de)serialization step, when performing 
put/get operations, so you may get better performance.

> Is the a way to deserialize AvroFormat messages from kafka to ignite sink? 
> Examples are available for String and JSON converters.
You can deserialize any data, coming from Kafka.
All you need is to implement a proper 
StreamSingleTupleExtractor<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fstream%2FStreamSingleTupleExtractor.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cdba57179c28741cc91a908d5e02dbcd2%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636661409431759416&sdata=Czc1yxhVUceks5FoR058kA%2BctUnuEV8r80SaixTDGL0%3D&reserved=0>

Denis

пн, 2 июл. 2018 г.

RE: Information regarding Ignite Web Console

2018-07-02 Thread Sriveena Mattaparthi

Denis,

Have some open questions in ignite

1.   Does all the tables created in ignite gets converted to binary objects 
internally?

2.   Does all the cache entities like Person gets converted to binary 
objects internally?

3.   Is using binary objects better than entity cache objects?

4.   Is the a way to deserialize AvroFormat messages from kafka to ignite 
sink? Examples are available for String and JSON converters.

Please help.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov [mailto:dmekhani...@gmail.com]
Sent: Friday, June 29, 2018 8:09 PM
To: user@ignite.apache.org
Subject: Re: Information regarding Ignite Web Console

Sriveena,

You should configure corresponding query entities to be able to query data in 
cache.
Annotation driven configuration is also available.

See more: 
https://apacheignite.readme.io/docs/cache-queries#section-query-configuration-by-annotations<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fcache-queries%23section-query-configuration-by-annotations&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C54bd9746eb084b48efc108d5ddce2906%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636658799914056234&sdata=jOJs8Be4hdwLNY1AYdwCHU0sisEzcdSkwGEQY4v9%2F3Y%3D&reserved=0>

Denis

пт, 29 июн. 2018 г. в 12:43, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi Denis,

I am trying to use the below code to query the binary object

IgniteCache cache = 
start.getOrCreateCache(cfg).withKeepBinary();
BinaryObjectBuilder builder = start.binary().builder("BinaryTest");
builder.setField("name", "Test");
cache.put(1, builder.build());

QueryCursor> query = cache.query(new SqlFieldsQuery("select name 
from BinaryTest"));

But it is failing in latest 2.5 version saying BinaryTest Table does not exist.

How do we query the binary objects in the above example?

Please help.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Wednesday, June 27, 2018 6:37 PM

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console

Sriveena,

You can have objects of different types in one cache, but querying it will be 
tricky.
You will have to configure 
QueryEntities<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 for your data, that will describe, which fields are available for querying.
Annotation based 
configuration<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 is also available.
Querying nested object is also possible, if you configure the query entities 
properly: 
https://apacheignite-sql.readme.io/docs/schema-and-indexes#section-indexing-nested-objects<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-indexing-nested-objects&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=1amkW4husY1fLSN%2FKtEBx8app5u%2FkUJhqiA4JCYgQ0o%3D&reserved=0>

So, if you want to run SQL queries over your data, it should have some concrete 
schema.

Denis

ср, 27 июн. 2018 г. в 14:08, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thank you so much for the quicker responses unlike any other forums..I really 
appreciate that.

One last question Denis, we have plan to load all the mongodb collections to 
ignite cache and perform complex aggregations and join in memory.

But Unlike any RDBMS data stores we cannot have fixed model objects for each 
collections as each document in the collection may have its own columns and 
datatypes.

Could you please suggest, if ignite is the choice for this kind of scenario 
where same mongo collection have different type of data.

Please note that we have tried using BinaryObject, but we are stuck that ignite 
doesn’t support querying on the inner binaryobject.( binaryobject inside a 
binaryobject – sub documents, array inside a mongo document)

Thanks & Regards,
Sriveena

From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com

RE: Information regarding Ignite Web Console

2018-07-01 Thread Sriveena Mattaparthi

Thanks Denis…

I understand that the example mentioned in the link is querying on the entity 
named Person

CacheConfiguration cacheCfg = new CacheConfiguration<>();
...
cacheCfg.setName("mycache");

// Setting up query entity.
QueryEntity queryEntity = new QueryEntity();

queryEntity.setKeyType(Long.class.getName());
queryEntity.setValueType(Person.class.getName());

But we are using Binary Objects and we will not have a definite entity unlike 
Person.

And our exact use case is to perform cross joins on mongo collections.
As we couldn’t perform complex joins using mongo, we are planning to load all 
the mongo collections to ignite and perform joins inmemory.
The only option to load mongo collections to inmemory is to create binary 
object. But we are now stuck with the querying part.

Please help.


Regards,
Sriveena

From: Denis Mekhanikov [mailto:dmekhani...@gmail.com]
Sent: Friday, June 29, 2018 8:09 PM
To: user@ignite.apache.org
Subject: Re: Information regarding Ignite Web Console

Sriveena,

You should configure corresponding query entities to be able to query data in 
cache.
Annotation driven configuration is also available.

See more: 
https://apacheignite.readme.io/docs/cache-queries#section-query-configuration-by-annotations<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fcache-queries%23section-query-configuration-by-annotations&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C54bd9746eb084b48efc108d5ddce2906%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636658799914056234&sdata=jOJs8Be4hdwLNY1AYdwCHU0sisEzcdSkwGEQY4v9%2F3Y%3D&reserved=0>

Denis

пт, 29 июн. 2018 г. в 12:43, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi Denis,

I am trying to use the below code to query the binary object

IgniteCache cache = 
start.getOrCreateCache(cfg).withKeepBinary();
BinaryObjectBuilder builder = start.binary().builder("BinaryTest");
builder.setField("name", "Test");
cache.put(1, builder.build());

QueryCursor> query = cache.query(new SqlFieldsQuery("select name 
from BinaryTest"));

But it is failing in latest 2.5 version saying BinaryTest Table does not exist.

How do we query the binary objects in the above example?

Please help.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Wednesday, June 27, 2018 6:37 PM

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console

Sriveena,

You can have objects of different types in one cache, but querying it will be 
tricky.
You will have to configure 
QueryEntities<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 for your data, that will describe, which fields are available for querying.
Annotation based 
configuration<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 is also available.
Querying nested object is also possible, if you configure the query entities 
properly: 
https://apacheignite-sql.readme.io/docs/schema-and-indexes#section-indexing-nested-objects<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-indexing-nested-objects&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=1amkW4husY1fLSN%2FKtEBx8app5u%2FkUJhqiA4JCYgQ0o%3D&reserved=0>

So, if you want to run SQL queries over your data, it should have some concrete 
schema.

Denis

ср, 27 июн. 2018 г. в 14:08, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thank you so much for the quicker responses unlike any other forums..I really 
appreciate that.

One last question Denis, we have plan to load all the mongodb collections to 
ignite cache and perform complex aggregations and join in memory.

But Unlike any RDBMS data stores we cannot have fixed model objects for each 
collections as each document in the collection may have its own columns and 
datatypes.

Could you please suggest, if ignite is the choice for this kind of scenario 
where same mongo collection ha

RE: Information regarding Ignite Web Console

2018-06-29 Thread Sriveena Mattaparthi

Hi Denis,

I am trying to use the below code to query the binary object

IgniteCache cache = 
start.getOrCreateCache(cfg).withKeepBinary();
BinaryObjectBuilder builder = start.binary().builder("BinaryTest");
builder.setField("name", "Test");
cache.put(1, builder.build());

QueryCursor> query = cache.query(new SqlFieldsQuery("select name 
from BinaryTest"));

But it is failing in latest 2.5 version saying BinaryTest Table does not exist.

How do we query the binary objects in the above example?

Please help.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov [mailto:dmekhani...@gmail.com]
Sent: Wednesday, June 27, 2018 6:37 PM
To: user@ignite.apache.org
Subject: Re: Information regarding Ignite Web Console

Sriveena,

You can have objects of different types in one cache, but querying it will be 
tricky.
You will have to configure 
QueryEntities<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 for your data, that will describe, which fields are available for querying.
Annotation based 
configuration<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 is also available.
Querying nested object is also possible, if you configure the query entities 
properly: 
https://apacheignite-sql.readme.io/docs/schema-and-indexes#section-indexing-nested-objects<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-indexing-nested-objects&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=1amkW4husY1fLSN%2FKtEBx8app5u%2FkUJhqiA4JCYgQ0o%3D&reserved=0>

So, if you want to run SQL queries over your data, it should have some concrete 
schema.

Denis

ср, 27 июн. 2018 г. в 14:08, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thank you so much for the quicker responses unlike any other forums..I really 
appreciate that.

One last question Denis, we have plan to load all the mongodb collections to 
ignite cache and perform complex aggregations and join in memory.

But Unlike any RDBMS data stores we cannot have fixed model objects for each 
collections as each document in the collection may have its own columns and 
datatypes.

Could you please suggest, if ignite is the choice for this kind of scenario 
where same mongo collection have different type of data.

Please note that we have tried using BinaryObject, but we are stuck that ignite 
doesn’t support querying on the inner binaryobject.( binaryobject inside a 
binaryobject – sub documents, array inside a mongo document)

Thanks & Regards,
Sriveena

From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Wednesday, June 27, 2018 4:02 PM

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console

Sriveena,

CacheStore<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fcache%2Fstore%2FCacheStore.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260911744&sdata=7LEcZ6l%2FFMHm7ZZ518w4WH%2FBm8ylC3yhTDTl05AcZ0M%3D&reserved=0>
 extends the 
CacheWriter<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260911744&sdata=UBNLjs2J4E4IZG6JGhToO6QzOr7QXkNo7OFZycVYbq0%3D&reserved=0>
 interface, which has 
delete<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html%23delete(java.lang.Object)&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260921745&sdata=2q1Mutj83625oVhVIEiawuiarAsK8UNmyZvrbk9J7nE%3D&reserved=0>
 and

RE: Information regarding Ignite Web Console

2018-06-27 Thread Sriveena Mattaparthi

Thanks Denis…Will try this and revert to you.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov [mailto:dmekhani...@gmail.com]
Sent: Wednesday, June 27, 2018 6:37 PM
To: user@ignite.apache.org
Subject: Re: Information regarding Ignite Web Console

Sriveena,

You can have objects of different types in one cache, but querying it will be 
tricky.
You will have to configure 
QueryEntities<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 for your data, that will describe, which fields are available for querying.
Annotation based 
configuration<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-queryentity-based-configuration&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=Z093el7e%2Fj%2BngjoDdJjUwWNUWfPu4Yb0OZgKv3ZEiis%3D&reserved=0>
 is also available.
Querying nested object is also possible, if you configure the query entities 
properly: 
https://apacheignite-sql.readme.io/docs/schema-and-indexes#section-indexing-nested-objects<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fschema-and-indexes%23section-indexing-nested-objects&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C6e1e06d9d5c0452da8da08d5dc2ee46a%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636657016326903455&sdata=1amkW4husY1fLSN%2FKtEBx8app5u%2FkUJhqiA4JCYgQ0o%3D&reserved=0>

So, if you want to run SQL queries over your data, it should have some concrete 
schema.

Denis

ср, 27 июн. 2018 г. в 14:08, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thank you so much for the quicker responses unlike any other forums..I really 
appreciate that.

One last question Denis, we have plan to load all the mongodb collections to 
ignite cache and perform complex aggregations and join in memory.

But Unlike any RDBMS data stores we cannot have fixed model objects for each 
collections as each document in the collection may have its own columns and 
datatypes.

Could you please suggest, if ignite is the choice for this kind of scenario 
where same mongo collection have different type of data.

Please note that we have tried using BinaryObject, but we are stuck that ignite 
doesn’t support querying on the inner binaryobject.( binaryobject inside a 
binaryobject – sub documents, array inside a mongo document)

Thanks & Regards,
Sriveena

From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Wednesday, June 27, 2018 4:02 PM

To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console

Sriveena,

CacheStore<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fcache%2Fstore%2FCacheStore.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260911744&sdata=7LEcZ6l%2FFMHm7ZZ518w4WH%2FBm8ylC3yhTDTl05AcZ0M%3D&reserved=0>
 extends the 
CacheWriter<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260911744&sdata=UBNLjs2J4E4IZG6JGhToO6QzOr7QXkNo7OFZycVYbq0%3D&reserved=0>
 interface, which has 
delete<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html%23delete(java.lang.Object)&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260921745&sdata=2q1Mutj83625oVhVIEiawuiarAsK8UNmyZvrbk9J7nE%3D&reserved=0>
 and 
deleteAll<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html%23deleteAll(java.util.Collection)&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260921745&sdata=NIJFLEwPbXOgpgkja9m48c8hENGNg1dTOyghSzaIiJ4%3D&reserved=0>
 methods, which will be called by Ignite, when you remove entries from Ignite 
caches.
wr

RE: Information regarding Ignite Web Console

2018-06-27 Thread Sriveena Mattaparthi

Thank you so much for the quicker responses unlike any other forums..I really 
appreciate that.

One last question Denis, we have plan to load all the mongodb collections to 
ignite cache and perform complex aggregations and join in memory.

But Unlike any RDBMS data stores we cannot have fixed model objects for each 
collections as each document in the collection may have its own columns and 
datatypes.

Could you please suggest, if ignite is the choice for this kind of scenario 
where same mongo collection have different type of data.

Please note that we have tried using BinaryObject, but we are stuck that ignite 
doesn’t support querying on the inner binaryobject.( binaryobject inside a 
binaryobject – sub documents, array inside a mongo document)

Thanks & Regards,
Sriveena

From: Denis Mekhanikov [mailto:dmekhani...@gmail.com]
Sent: Wednesday, June 27, 2018 4:02 PM
To: user@ignite.apache.org
Subject: Re: Information regarding Ignite Web Console

Sriveena,

CacheStore<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fcache%2Fstore%2FCacheStore.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260911744&sdata=7LEcZ6l%2FFMHm7ZZ518w4WH%2FBm8ylC3yhTDTl05AcZ0M%3D&reserved=0>
 extends the 
CacheWriter<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260911744&sdata=UBNLjs2J4E4IZG6JGhToO6QzOr7QXkNo7OFZycVYbq0%3D&reserved=0>
 interface, which has 
delete<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html%23delete(java.lang.Object)&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260921745&sdata=2q1Mutj83625oVhVIEiawuiarAsK8UNmyZvrbk9J7nE%3D&reserved=0>
 and 
deleteAll<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html%23deleteAll(java.util.Collection)&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260921745&sdata=NIJFLEwPbXOgpgkja9m48c8hENGNg1dTOyghSzaIiJ4%3D&reserved=0>
 methods, which will be called by Ignite, when you remove entries from Ignite 
caches.
write<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html%23write(javax.cache.Cache.Entry)&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260931759&sdata=tBdc%2FPmMicFBKc82w7s10TvP5r9Sl7%2B7FLPJidwsFsw%3D&reserved=0>
 and 
writeAll<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstatic.javadoc.io%2Fjavax.cache%2Fcache-api%2F1.0.0%2Fjavax%2Fcache%2Fintegration%2FCacheWriter.html%23writeAll(java.util.Collection)&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260931759&sdata=Sw5W5BSEgyrBRfoIUpx7pwIfYl5gXSNXtYefE4ghmBk%3D&reserved=0>
 methods will be called, when you put some data into cache.
It works the same way with MySQL or any other relational DB.
So, CacheStore gives you a possibility to implement synchronization with any 
external data source. You can do it for MongoDB, if you need.

Denis

ср, 27 июн. 2018 г. в 13:18, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Thanks Denis for the pointers.

But the case explained in 
https://www.youtube.com/watch?v=XBtI2Z01kAA<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DXBtI2Z01kAA&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf08122ce8c394e2c7a1e08d5dc193829%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656923260941765&sdata=HLmtH02Dr4h455PggnRBQxe0eZJxENxp7nDlPXb5xek%3D&reserved=0>
 -  Using Ignite Web Console for Automatic RDBMS Integration with Apache Ignite 
- Part 3.
shows that any deletions happening on ignite cache are getting reflected in the 
mysql database.

Which I thought is ignite feature of autosyncing data to and from RDBMS 
databases.
Please correct my understanding.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Wednesday, June 27, 2018 3:28 PM

To

RE: Information regarding Ignite Web Console

2018-06-27 Thread Sriveena Mattaparthi

Thanks Denis for the pointers.

But the case explained in https://www.youtube.com/watch?v=XBtI2Z01kAA -  Using 
Ignite Web Console for Automatic RDBMS Integration with Apache Ignite - Part 3.
shows that any deletions happening on ignite cache are getting reflected in the 
mysql database.

Which I thought is ignite feature of autosyncing data to and from RDBMS 
databases.
Please correct my understanding.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov [mailto:dmekhani...@gmail.com]
Sent: Wednesday, June 27, 2018 3:28 PM
To: user@ignite.apache.org
Subject: Re: Information regarding Ignite Web Console

Sriveena,

Web Console can generate schema in Ignite based on an existing schema in a 
relational database.
But you can do it yourself, without use of Web Console.
Web Console only makes it easier to wire-up stuff, i.e. generate required data 
classes and configuration.

Unfortunately, this feature is not available for NoSQL databases. But you still 
can configure everything yourself.
You will need to implement a 
CacheStore<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fignite.apache.org%2Freleases%2Flatest%2Fjavadoc%2Forg%2Fapache%2Fignite%2Fcache%2Fstore%2FCacheStore.html&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf4918a96e28644d507b908d5dc1491ba%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656903279754570&sdata=V09AYASdhDUexLS4ZNs44zvEWjJ1lmZFqjVRwQft2xs%3D&reserved=0>,
 that will load data from your database into Ignite.
Here is documentation on this feature: 
https://apacheignite.readme.io/docs/3rd-party-store<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2F3rd-party-store&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Cf4918a96e28644d507b908d5dc1491ba%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656903279754570&sdata=9w94GuXNlswyUb9XshSsZtol3Qp8ib7GIk9dpwbZiYQ%3D&reserved=0>

Denis

ср, 27 июн. 2018 г. в 12:41, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:
Hi Denis,

Thank you so much for the quick turn around
Could you also confirm if there is a similar integration from ignite to NoSQL 
database like MongoDB ?

Our requirement also has mongo db changes to be automatically synced up to 
Ignite?

Please help.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov 
[mailto:dmekhani...@gmail.com<mailto:dmekhani...@gmail.com>]
Sent: Wednesday, June 27, 2018 2:58 PM
To: user@ignite.apache.org<mailto:user@ignite.apache.org>
Subject: Re: Information regarding Ignite Web Console

Sriveena,

You can find sources of Web Console in the Ignite Git repository: 
https://github.com/apache/ignite/tree/master/modules/web-console<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fapache%2Fignite%2Ftree%2Fmaster%2Fmodules%2Fweb-console&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C1bd39c9b865f43eca6d408d5dc104bee%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656884921777570&sdata=J6LSkoURVCvHJDnKyWrjpFRj02E9T0njpXSxFJPJAvU%3D&reserved=0>

If you want to run Web Console by yourself, you can use the following Docker 
image: 
https://hub.docker.com/r/apacheignite/web-console-standalone/<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fhub.docker.com%2Fr%2Fapacheignite%2Fweb-console-standalone%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C1bd39c9b865f43eca6d408d5dc104bee%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656884921777570&sdata=xQKYRGlEn9UQQ2EDM9nc6RTZLEbHH7eCl7vGCf2UbLM%3D&reserved=0>
There is also Web Console, hosted by GridGain, available at 
https://console.gridgain.com/<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fconsole.gridgain.com%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C1bd39c9b865f43eca6d408d5dc104bee%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656884921787575&sdata=yyxqlC%2BcnR9yLRwgGxD6aCvy0t9eh2J4djvNsztr2YM%3D&reserved=0>

Denis

ср, 27 июн. 2018 г. в 10:14, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Hi,

I am interested to know if Ignite Webconsole is opensource as the document says

Ignite can integrate with any relational database (RDBMS) that supports a JDBC 
driver - Oracle, PostgreSQL, Microsoft SQL Server, and MySQL

Ignite supports automatic RDBMS integration via Ignite Web 
Console<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fconsole.gridgain.com%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C1bd39c9b865f43eca6d408d5dc104bee%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656884921797580&sdata=CorLQYS%2FCirN%2BOxK72fvwKFGL5E%2BSQ%2FY4Qn0hPzNvW0%3D&reserved=0>.

Please confirm.
Thanks & Regards,
Sriveena

RE: Information regarding Ignite Web Console

2018-06-27 Thread Sriveena Mattaparthi

Hi Denis,

Thank you so much for the quick turn around
Could you also confirm if there is a similar integration from ignite to NoSQL 
database like MongoDB ?

Our requirement also has mongo db changes to be automatically synced up to 
Ignite?

Please help.

Thanks & Regards,
Sriveena

From: Denis Mekhanikov [mailto:dmekhani...@gmail.com]
Sent: Wednesday, June 27, 2018 2:58 PM
To: user@ignite.apache.org
Subject: Re: Information regarding Ignite Web Console

Sriveena,

You can find sources of Web Console in the Ignite Git repository: 
https://github.com/apache/ignite/tree/master/modules/web-console<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fapache%2Fignite%2Ftree%2Fmaster%2Fmodules%2Fweb-console&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C1bd39c9b865f43eca6d408d5dc104bee%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656884921777570&sdata=J6LSkoURVCvHJDnKyWrjpFRj02E9T0njpXSxFJPJAvU%3D&reserved=0>

If you want to run Web Console by yourself, you can use the following Docker 
image: 
https://hub.docker.com/r/apacheignite/web-console-standalone/<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fhub.docker.com%2Fr%2Fapacheignite%2Fweb-console-standalone%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C1bd39c9b865f43eca6d408d5dc104bee%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656884921777570&sdata=xQKYRGlEn9UQQ2EDM9nc6RTZLEbHH7eCl7vGCf2UbLM%3D&reserved=0>
There is also Web Console, hosted by GridGain, available at 
https://console.gridgain.com/<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fconsole.gridgain.com%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C1bd39c9b865f43eca6d408d5dc104bee%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656884921787575&sdata=yyxqlC%2BcnR9yLRwgGxD6aCvy0t9eh2J4djvNsztr2YM%3D&reserved=0>

Denis

ср, 27 июн. 2018 г. в 10:14, Sriveena Mattaparthi 
mailto:sriveena.mattapar...@ekaplus.com>>:

Hi,

I am interested to know if Ignite Webconsole is opensource as the document says

Ignite can integrate with any relational database (RDBMS) that supports a JDBC 
driver - Oracle, PostgreSQL, Microsoft SQL Server, and MySQL

Ignite supports automatic RDBMS integration via Ignite Web 
Console<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fconsole.gridgain.com%2F&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C1bd39c9b865f43eca6d408d5dc104bee%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636656884921797580&sdata=CorLQYS%2FCirN%2BOxK72fvwKFGL5E%2BSQ%2FY4Qn0hPzNvW0%3D&reserved=0>.

Please confirm.
Thanks & Regards,
Sriveena

Information regarding Ignite Web Console

2018-06-27 Thread Sriveena Mattaparthi

Hi,

I am interested to know if Ignite Webconsole is opensource as the document says

Ignite can integrate with any relational database (RDBMS) that supports a JDBC 
driver - Oracle, PostgreSQL, Microsoft SQL Server, and MySQL

Ignite supports automatic RDBMS integration via Ignite Web 
Console.

Please confirm.
Thanks & Regards,
Sriveena

57 matches

Mail list logo