Re: IGNITE_EXCHANGE_HISTORY_SIZE value for Ignite client

2018-11-01 Thread Cristica
Thank you very much for the answer. We will test version 2.7 once it will be released. Cristi -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Unable to load more than 5g data through sqlline

2018-11-01 Thread debashissinha
Also at the same time the ignite node is restarting -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Unable to load more than 5g data through sqlline

2018-11-01 Thread debashissinha
Hi , I am using the sql line utility to do this . Also the exact error that am getting is ignite.sh : line 181: 1387 killed "$JAVA" ${JVM_OPTS} ${QUIET} "${RESTART_SUCCESS_OPT}" ${JMX_MON} \ -DIGNITE_HOME="${IGNITE_HOME}" \ -DIGNITE_PROG_NAME="$0" ${JVM_XOPTS}

Re: IGNITE_EXCHANGE_HISTORY_SIZE value for Ignite client

2018-11-01 Thread Denis Mekhanikov
Cristian, I don't see any critical consequences, if you set IGNITE_EXCHANGE_HISTORY_SIZE to 0 on clients. Exchange futures just will be removed after each exchange. By default they are removed only once in a while. Don't do it on server nodes though. Coordinator needs exchange history. Your

Re: What is the username of ignite web console

2018-11-01 Thread Denis Mekhanikov
Justin, The first registered user becomes an admin. And he/she may grant admin rights to other users after they register. Denis чт, 1 нояб. 2018 г. в 15:03, wt : > click register and enter your details and it will let you in > > > > -- > Sent from:

java.lang.UnsupportedOperationException: Invalid fast index type: -21

2018-11-01 Thread Yuriy
I have made the index on bite[] field: @QuerySqlField (index = true, notNull = true) private byte[] sha1; After loading data the cluster (Ignate 2.4) break down with errors in log: org.apache.ignite.IgniteException: Runtime failure on row: Row@4eaa09d2[ key: 63654, val: model.File

Re: What is the username of ignite web console

2018-11-01 Thread wt
click register and enter your details and it will let you in -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: An error occured when recreate cache

2018-11-01 Thread Denis Mekhanikov
Could you describe steps to reproduce the issue in more details? What is the cluster topology and sequence of operations? Denis чт, 25 окт. 2018 г. в 6:50, Justin Ji : > The following is the stack: > > 2018-10-25 03:47:02:992 [exchange-worker-#42] ERROR >

Re: Unable to load more than 5g data through sqlline

2018-11-01 Thread wt
a different machine is fine all you need to do is build a client using either java, c++,.net, scala, and probably powershell as well i have something like this in .Net and can parallel load files (one per thread in a pool of 10 threads) using (var ldr =

What is the username of ignite web console

2018-11-01 Thread Justin Ji
I do not know how to log in the web console as admin, and I can not find any information about admin in the ignite docs. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Unable to load more than 5g data through sqlline

2018-11-01 Thread debashissinha
Hi , I am running sql line from a differnt machine which is not related to the cluster also . Tried with smaller chunks but difficulty is after around 2.5 gb the issue persists. Thanks & Regards Debashis Sinha -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Durable memory with native persistence isssue

2018-11-01 Thread debashissinha
I figured out it is a different issue with tpcds. Thanks & Regards Debashis Sinha -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Long activation times with Ignite persistence enabled

2018-11-01 Thread Denis Mekhanikov
Naveen, How many caches do you have? As Alexey mentioned, usage of cache groups could reduce the number of created partitions and improve the startup time. Denis сб, 27 окт. 2018 г. в 11:12, Naveen : > Do we have any update long activation

Re: Durable memory with native persistence isssue

2018-11-01 Thread Denis Mekhanikov
What version of Ignite do you use? Did you try checking the number of loaded entries using a cache API, but not SQL? For example, you can iterate over all stored entries using a scan query . Denis пт, 26 окт. 2018 г. в 5:02,

Re: spring XML configuration to connect ignite database using org.apache.ignite.IgniteJdbcThinDriver

2018-11-01 Thread Denis Mekhanikov
Malashree, Refer to the following page for information about Ignite thin JDBC driver: https://apacheignite-sql.readme.io/docs/jdbc-driver If you need information on how to use JDBC from Spring, refer to Spring documentation:

Re: Ouch! Argument is invalid: Cache name must not be null or empty.

2018-11-01 Thread Evgenii Zhuravlev
> executing scala code (using %ignite) makes the entire Ignite interpreter in Zeppelin hang, without any errors in logs. How do I debug this? When something hangs, you have to check thread dumps to understand where and why it hangs. Also, sometimes, it worth to enable another level of the logging

Re: client thread dumps

2018-11-01 Thread Cristica
Could you please specify what value you set for IGNITE_EXCHANGE_HISTORY_SIZE What would be the impact if we set it to 0 for all our java client applications? We have a similar issue presented on

Re: Does ignite provide a Comparator for Sort?

2018-11-01 Thread Dmitriy Setrakyan
Yes, instead of utilizing custom comparators, just use "order by" clause in your SQL query. D. On Thu, Nov 1, 2018 at 12:43 AM Mikael wrote: > Hi! > > I don't think so but can't you use an index and an SQL query instead ? > > Mikael > > Den 2018-11-01 kl. 06:33, skrev Ignite Enthusiast: > > I

Re: Ouch! Argument is invalid: Cache name must not be null or empty.

2018-11-01 Thread sv
Hi, to clarify: 1) Thin client works fine 2) Thick client using port 11211 works fine 3) The "Client Node" connection is the one that was not working. I got the Client Node connection (#3) to work by specifying the cache name in the connection string. Now it connects, and all SQL works well.

Re: Does ignite provide a Comparator for Sort?

2018-11-01 Thread Mikael
Hi! I don't think so but can't you use an index and an SQL query instead ? Mikael Den 2018-11-01 kl. 06:33, skrev Ignite Enthusiast: I am new to Apache ignite.  I have used HAzelcast extensively and one of the features I really liked about it is the Comparator that it provides on the Cache

Re: how ignite distribute sql query to all nodes when use REPLICATED mode

2018-11-01 Thread kcheng.mvp
I found the document here https://apacheignite-sql.readme.io/docs/select *SELECT queries can be executed against both replicated and partitioned data. When executed against fully replicated data, Ignite will send a query it to a single cluster node and run it over the local data there. On the