Re: SqlQuery deprecated

Yes. ignite-dataframe > On 17 Jan 2022, at 13:31, capitnfrak...@free.fr wrote: > > Can Ignite support the spark like dataframe API? Thanks > > On 17/01/2022 20:31, Pavel Tupitsyn wrote: >> Hi,

Re: SqlQuery deprecated

Can Ignite support the spark like dataframe API? Thanks On 17/01/2022 20:31, Pavel Tupitsyn wrote: Hi, The reason for deprecation is that SqlQuery is a limited subset of SqlFieldsQuery, which may be confusing. https://issues.apache.org/jira/browse/IGNITE-11334 On Mon, Jan 17, 2022 at 2:59 PM

Re: SqlQuery deprecated

Hi, The reason for deprecation is that SqlQuery is a limited subset of SqlFieldsQuery, which may be confusing. https://issues.apache.org/jira/browse/IGNITE-11334 On Mon, Jan 17, 2022 at 2:59 PM Surinder Mehra wrote: > I found the link how to read full object. But would still like to >

Re: SqlQuery deprecated

I found the link how to read full object. But would still like to understand why SqlQuery is deprecated. https://stackoverflow.com/questions/66248464/how-to-get-ignite-cache-sql-query-to-return-value-object On Mon, Jan 17, 2022 at 4:54 PM Surinder Mehra wrote: > Hi, > With Ignite 2.9 or

SqlQuery deprecated

Hi, With Ignite 2.9 or before Ignite supported SqlQuery but in 2.11 I see it is deprecated. Could you please tell us why and what is the alternative to it. SqlFieldQuery does not allow to read full object like below but individual fields which is cumbersome String sql1 = "select * from Person";

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

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: 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

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

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