Re: High heap on ignite client

2017-06-14 Thread Anil
Sure. thanks On 14 June 2017 at 19:51, afedotov wrote: > Hi, Anil. > > Could you please share your full code (class/method) you are using to read > data. > > Kind regards, > Alex > > 12 июня 2017 г. 4:07 PM пользователь "Anil [via Apache Ignite Users]" <[hidden > email]

Re: Configuring Ignite Services to deploy on Server nodes only

2017-06-14 Thread waterg
Hi there, I was looking into the same thing. This seems to be working for me https://apacheignite.readme.io/v2.0/docs/service-configuration

Re: Exception when Ignite server starts up and also when a new node joins the cluster

2017-06-14 Thread jaipal
Hi Agura. You can try with this configuration but it is with out write behind I have been using jdk7 (build 1.7.0_45-b18) on Red Hat Linux 7.3. Regards Jaipal -- View this message in context: http://apache-igni

assign alias for table name using annotations

2017-06-14 Thread Doug
Related to this pull request: https://issues.apache.org/jira/browse/IGNITE-3964 Is there a way to assign an alias for a table name using the annotation method similar to how you can assign an alias for a field name using the following: @QuerySqlField (name="foo") private Short bar; -- View th

Re: odd query plan with joins?

2017-06-14 Thread djardine
Hi Vladimir, Thanks for the reply. Excuse my noob-ness, but "reproducer"? What do you need for that? It appears the issue had to do with the multi-field index "CALENDAR_METRIC_PERIOD_DAYS_R_IDX". Considering the test query filters both on period and days_r I thought this index would be ideal, but

Re: NoClassDefFoundError org/h2/server/Service

2017-06-14 Thread murphyRic
@ezhuravlev I know the issue is different but since it is related to the same application and you were able to successfully execute it, so posting it here in this thread. If you like this to be opened fresh in another thread I can do that. - The SparkStreamerStartup starts with the below logs and

Re: NoClassDefFoundError org/h2/server/Service- Resolved

2017-06-14 Thread murphyRic
After I updated the POM file with the below by excluding the jars, it worked. org.apache.ignite ignite-spark 2.0.0 org.apache.ignite ignite-indexing

Re: Can java code look up cache in server without Ignition.start(cfg)

2017-06-14 Thread vkulichenko
Saji, You're using try-with-resources syntax, which calls Ignite.close() at the end and therefore stops the node. Getting rid of it will do the trick. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Can-java-code-look-up-cache-in-server-without-Ignition-st

Re: Can java code look up cache in server without Ignition.start(cfg)

2017-06-14 Thread StartCoding
Hi Val, I remember you helping me with getOrStart(IgniteConfiguration) to ensure that Ignite is started only once. Currently I am having an issue try (Ignite ignite = Ignition.getOrStart(ClientConfigurationFactory.createConfiguration())) { when the above code is executed the Ignite node is start

IgniteRDD SQL query stalled or extremly slow on large input argument

2017-06-14 Thread amgad
I have a query that stalls/hangs over large argument inputs. The same code works well on smaller SQL argument input. The code is as follows: CODE: -- *subEntries = dataRDD.sql("SELECT v.id,v.sub,v.obj FROM VPRow v JOIN table(id bigint = ?) i ON v.id = i.id",new Object[] {subKeyEntries.toArray

Re: using hdfs as secondary file system

2017-06-14 Thread Antonio Si
Hi Viadimir, I got this issue resolved. I believe ignite is using asm 4 library internally and I need to use jdk7 in order to work with asm 4. Switching to jdk7 resolve this issue. Thanks. Antonio. On Wed, Jun 14, 2017 at 4:15 AM, Vladimir Ozerov wrote: > Hi Antonio, > > Is it possible to att

Re: ODBC driver issue

2017-06-14 Thread Riccardo Iacomini
Yes, I've set the env variable, globally in /etc/environment. Just for completeness, I am running Ubuntu 16.04. Best Riccardo Iacomini *RDSLab* On Wed, Jun 14, 2017 at 1:02 PM, Igor Sapego wrote: > Do you set LD_LIBRARY_PATH to /usr/local/lib? If 'yes' then > can you describe in details how

Re: Range queries on indexed columns

2017-06-14 Thread Andrey Mashenkov
Hi Anil, Yes, in your case map queries results already sorted and there is only merge on reduce side. Sorting can be disabled on map side when e.g. aggregates is used. On Wed, Jun 14, 2017 at 3:20 PM, Anil wrote: > Hi Team, > > Can some help in understanding the below ? Thanks. > > On 13 June 2

Re: High heap on ignite client

2017-06-14 Thread afedotov
Hi, Anil. Could you please share your full code (class/method) you are using to read data. Kind regards, Alex 12 июня 2017 г. 4:07 PM пользователь "Anil [via Apache Ignite Users]" < ml+s70518n13626...@n6.nabble.com> написал: > Do you have any advice on implementing large records export from ign

Re: Exception when Ignite server starts up and also when a new node joins the cluster

2017-06-14 Thread Andrey Gura
Hi, I can't run Ignite with provided configuration because some benas like writeBehind_one don't exist. Without cache stores I can't reproduce problem. Could you please provide minimal reproducer in order to investigate the problem. Also could you please share environment details that can be help

Re: Ignite web console not running in browser

2017-06-14 Thread Alexey Kuznetsov
Hi! Did you try exactly: http://localhost:9000/ ? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Ignite-web-console-not-running-in-browser-tp13701p13702.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Range queries on indexed columns

2017-06-14 Thread Anil
Hi Team, Can some help in understanding the below ? Thanks. On 13 June 2017 at 11:07, Anil wrote: > HI Team, > > I have a table TEST with a indexed column COL_A. Does the following query > works ? > > select * from Test where COL_A > '1' and COL_A < '2' offset 10 ROWS FETCH > NEXT 20 ROWS ONLY

Re: using hdfs as secondary file system

2017-06-14 Thread Vladimir Ozerov
Hi Antonio, Is it possible to attach logs from server nodes? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/using-hdfs-as-secondary-file-system-tp13580p13696.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: ODBC driver issue

2017-06-14 Thread Igor Sapego
Do you set LD_LIBRARY_PATH to /usr/local/lib? If 'yes' then can you describe in details how you do that? This may help to identify an issue. Best Regards, Igor On Wed, Jun 14, 2017 at 12:30 PM, Riccardo Iacomini < riccardo.iacom...@rdslab.com> wrote: > Hello Igor, > I double checked the document

Re: odd query plan with joins?

2017-06-14 Thread Vladimir Ozerov
Hi, "1=1" is normal thing in the plan provided that index is used (see "/* PropertyCache.PROPERTY_CITY_ID_IDX: CITY_ID = 59053 */"). Is it possible to attach a reproducer? Vladimir. On Wed, Jun 14, 2017 at 5:10 AM, djardine wrote: > Hi, > I'm attempting to run a query that does a join between

"Found long running transaction" with Arjuna and rollback

2017-06-14 Thread Kristian Rosenvold
We are running ignite 2.0.0 with the Arjuna transaction manger, configuration snippet follows: igniteConfiguration.getTransactionConfiguration().setTxManagerFactory((Factory) () -> jtaTransactionManager); igniteConfiguration.getTransactionConfiguration().setUseJtaSynchronization(true); config.set

Re: ODBC driver issue

2017-06-14 Thread Riccardo Iacomini
Hello Igor, I double checked the documentation and went over the steps again to be sure everything is ok. I tried running your command, that's the output: linux-vdso.so.1 => (0x7fff75dd6000) > libignite-binary-2.0.0.19668.so.0 => > /usr/local/lib/libignite-binary-2.0.0.19668.

Re: ODBC driver issue

2017-06-14 Thread Igor Sapego
So, setting LD_LIBRARY_PATH to /usr/local/lib should definetly help. Are you sure your did everything right? Try the following command (in one line): LD_LIBRARY_PATH=/usr/local/lib ldd /usr/local/lib/libignite-odbc.so Best Regards, Igor On Wed, Jun 14, 2017 at 10:15 AM, Riccardo Iacomini < riccar

Re: Affinity Issue(Collocate compute) in Ignite JDBC Query

2017-06-14 Thread Taras Ledkov
Hi, I think you mean queries with condition on affinity columns. In this case see more: https://issues.apache.org/jira/browse/IGNITE-4509 On 14.06.2017 9:15, sandeepbellary wrote: Hi, Thanks for the reply.I understand that query will be split into a number of subqueries for final reduce in PAR

Re: NoClassDefFoundError org/h2/server/Service

2017-06-14 Thread ezhuravlev
Do you run the example in IDE? Most likely it incorrectly resolves transitive dependencies - this exception happens if ignite-indexing.jar is on classpath, but H2 is not. I'm using Intellij Idea and everything works fine. -- View this message in context: http://apache-ignite-users.70518.x6.nab

Ignite with Camel

2017-06-14 Thread Pranay Tonpay
Hi, Can someone please point me to a good example of Camel routes with - 1) ignite topic as receiving end point 2) ignite cache as receiving end point 3) ignite event as receiving end point I know that this question could be for Apache Camel community too, but if someone can give any pointer here,

Re: ODBC driver issue

2017-06-14 Thread Riccardo Iacomini
As asked: > > linux-vdso.so.1 => (0x7ffca6776000) > libignite-binary-2.0.0.19668.so.0 => not found > libodbcinst.so.2 => /usr/lib/x86_64-linux-gnu/libodbcinst.so.2 > (0x7fb92ead4000) > libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 > (0x7fb92e751000) > libc.so.6 => /lib/x8