RE: [External]Re: removeAll operation on same cache causing deadlock

Ohh! Anyways thanks for the update ! Regards, Kamlesh Joshi From: Alex Plehanov Sent: 21 January 2021 13:20 To: user@ignite.apache.org Subject: [External]Re: removeAll operation on same cache causing deadlock The e-mail below is from an external source. Please do not open attachments or click

Re: Column not found using _val and sqlfieldsquery

> is there any specific reason why does not working if i use like this t._val.EntityId I think the reason here is that SQL (the standardized language) does not support this kind of syntax. Think of it as a flat table, _key and _val are just additional columns. On Fri, Jan 22, 2021 at 9:04 AM siv

Re: Column not found using _val and sqlfieldsquery

Hi ptupitsyn, yes it is working fine. I have one query is there any specific reason why does not working if i use like this t._val.EntityId SELECT t._val from (select _val FROM materials ) as t where t_val.EntityId='123' Thanks. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Column not found using _val and sqlfieldsquery

Hi, I guess it should be like this: SELECT t._val from (select _val, EntityId FROM materials ) as t where t.EntityId='123' On Fri, Jan 22, 2021 at 8:10 AM siva wrote: > Hi, > I have .Net Ignite client and server app Ignite v2.9.1. > > I am using SqlFieldsQuery using thin client to query ignite

Column not found using _val and sqlfieldsquery

Hi, I have .Net Ignite client and server app Ignite v2.9.1. I am using SqlFieldsQuery using thin client to query ignite. here is the query what i am trying: SELECT t._val from (select _val FROM materials ) as t where EntityId='123' exception msg: Failed to parse query. Column "ENTITYID" not fo

unsubscribe

> On Jan 21, 2021, at 5:17 PM, akorensh wrote: > > Hi, > Can you actually see what the data distribution of itemid is. > > AffinityKey will direct Ignite to use that specific column (itemid) for > partition mapping. > If the data in itemid is in a narrow range, then all data will be put in

Re: Slow cache loading with an object key using affinity key

Hi, Can you actually see what the data distribution of itemid is. AffinityKey will direct Ignite to use that specific column (itemid) for partition mapping. If the data in itemid is in a narrow range, then all data will be put into fewer partitions. This might affect loading times. more

Re: Slow cache loading with an object key using affinity key

Hi Alex, I am simply using GridGain/Ignite web console to generate a project for testing cacheload of a single table from my persistent storage. For evaluation/testing purposes, I am running a single node in my cluster on a 2CPU 32Gb Windows machine. For testing, I created 2 projects. Test1 is w

Re: Disappointing SQL update performance - no stored procedures?

StephenThanks, the team is going through all of the performance guides for a second time. We also understand that this operates on a version of the H2 database and are looking at the documentation around that also. The performance bottleneck is for large transactions which comprise of, what in a SQ

Re: 2.8.1 : INFO org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi [] - Accepted incoming communication connection

Sure. Let me get back on this. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

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

Hi Andrei, >>From your source code, I can see that the QueryCursor was created inside startContinuousQuery. Then you return it from that method, but don't store it in any variable: >>continuousQueryHelper.startContinuousQuery(ignite,qry,testCache,subscribeParameters.callBackList,outputFieldsList);

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

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 It's failing access column with and without table Aliases. for example Query::> SELECT t.* from (select _val FROM materials ) as t INNER JOIN "F2DEDF6

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

Hi, From your source code, I can see that the QueryCursor was created inside startContinuousQuery. Then you return it from that method, but don't store it in any variable: continuousQueryHelper.startContinuousQuery(ignite,qry,testCache,subscribeParameters.callBackList,outputFieldsList); for

Re: Slow cache loading with an object key using affinity key

Hi, Can you give more context regarding your data load. How big is your cluster?* Are the load times comparable if you use only one node for both use cases? * If you remove the affinity column in the second use case, does the load speed up in a cluster env? If you lower the amount o

Re: Ever increasing startup times as data grow in persistent storage

Hi, I don't think there are any other options at the moment other than the ones you mentioned. However, you can also create your own application that will check the topology and activate it when all nodes from the baseline are online. For example, additional java code when starting a server

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

Hello, Try this: "select _val from mytesttable" чт, 21 янв. 2021 г. в 17:38, siva : > Hi, > I am using .net Ignite v2.9.1 and > > Since SqlQuery deprecated in documentation suggesting please use > SqlFieldsQuery. > > what is the way to get result as Type using sqlfieldsquery? > > for example que

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

Hi, I am using .net Ignite v2.9.1 and Since SqlQuery deprecated in documentation suggesting please use SqlFieldsQuery. what is the way to get result as Type using sqlfieldsquery? for example query select * from mytesttable Thanks. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com

Re: Disappointing SQL update performance - no stored procedures?

This is the General Performance Tips guide: general-perf-tips There’s no one-size-fits-all solution, but as a general point, Ignite is optimised to work as a cluster. Operating a single server node isn’t where you

Re: 2.8.1 : INFO org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi [] - Accepted incoming communication connection

Could you plz attach DEBUG log of the server node running on Linux machine from the moment server starts until client re-connect after being stopped? So, full logs basically - Alexey Plotnik -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: 2.8.1 : INFO org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi [] - Accepted incoming communication connection

Hi Alexey, I am able to reproduce this on my linux env. by doing a kill -9 . Please find the logs from my linux env. attached. temp.log Also note in our linux env. we have dual ip for our boxes - not sure if that contributes