Re: SqlQuery Deprecated Since 2.8, please use SqlFieldsQuery instead....How to get result as passing model Type with SqlFieldsQuery?

2021-01-25 Thread Ilya Kasnacheev
Hello! Why not: SELECT t.*, t._val from materials t INNER JOIN ... Regards, -- Ilya Kasnacheev чт, 21 янв. 2021 г. в 19:19, siva : > Hi, > > It's working fine in "select _val from mytesttable" query but in case of > sub > query or joins it's failing with an error like column not found > >

Re: Ignite with Docker on Raspberry Pi

2021-01-25 Thread Ilya Kasnacheev
Hello! This does look like some control.sh issue, such as that it is unable to complete request and activation never happens. Can you try to activate this node in some other way, such as connecting a thick client node to it and doing client.cluster().state(ACTIVE) from there? Regards, -- Ilya

Re: Ignite with Docker on Raspberry Pi

2021-01-25 Thread Edwind
Hello! Here is my full logs with Stephen's image :) I think I have enabled INFO logging but I'm not sure tell me if you need more. Ignite Logs wrote > [15:55:08]__ > [15:55:08] / _/ ___/ |/ / _/_ __/ __/ > [15:55:08] _/ // (7 7// / / / / _/ > [15:55:08]

Re: Ignite with Docker on Raspberry Pi

2021-01-25 Thread Ilya Kasnacheev
Hello! 52 seconds response time suggests you have a timeout here. Maybe you run out of memory when checkpoint page buffer is considered? Maybe your system starts swapping? Can you enable INFO logging and share complete log from your server node? Regards, -- Ilya Kasnacheev сб, 23 янв. 2021

Re: 2.8.1 : Continuous Query Initial query not returning any result sometimes

2021-01-25 Thread VeenaMithare
HI Andrei, Some more points : 1. Also the javadocs for the querycursor says : https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/cache/query/QueryCursor.html#getAll-- List getAll() Gets all query results and stores them in the collection. Use this method when you know in

Re: SQL strategy for Apache Ignite 3.0

2021-01-25 Thread Ilya Kasnacheev
Hello! Please do not overestimate the extent in which we rely on H2 in Apache Ignite. We mostly use it for query parsing/planning while the rest is done by our own code/ 1) I think that the usage of MERGE is not recommended, since it is not providing additional guarantees from SELECT and then

RE: Implementing HA among Ignite Clusters

2021-01-25 Thread Naveen
Hi Alex This got ignored for a while But the known drawbacks of this approach, can you please let me know as I need to finalize an approach on how to route requests to secondary site if primary is not in working condition etc Thanks -- Sent from:

SQL strategy for Apache Ignite 3.0

2021-01-25 Thread Lukas Eder
Hello folks, I'm currently working on the jOOQ integration for Apache Ignite's SQL language support. I was invited by Denis Magda to post my questions here, see: https://twitter.com/denismagda/status/1352316238806958080 >From what I understand, you're going to use calcite to parse and run your