You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Surinder Mehra <re...@gmail.com> on 2022/01/17 11:24:31 UTC
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";
cache.query(new SqlQuery<LocalDateTime, Person>(Person.class, sql1))
.getAll()
.forEach(e ->System.out.println("Value: "+ e.getValue()));
Re: SqlQuery deprecated
Posted by Stephen Darlington <st...@gridgain.com>.
Yes. ignite-dataframe <https://ignite.apache.org/docs/latest/extensions-and-integrations/ignite-for-spark/ignite-dataframe>
> On 17 Jan 2022, at 13:31, capitnfrakass@free.fr wrote:
>
> 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 Surinder Mehra <re...@gmail.com>
>> wrote:
>>> 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 by<re...@gmail.com>
>>> wrote:
>>>> 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";
>>>> cache.query(new SqlQuery<LocalDateTime, Person>(Person.class,
>>>> sql1))
>>>> .getAll()
>>>> .forEach(e ->System.out.println("Value: "+ e.getValue()));
Re: SqlQuery deprecated
Posted by ca...@free.fr.
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 Surinder Mehra <re...@gmail.com>
> wrote:
>
>> 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 by<re...@gmail.com>
>> wrote:
>>
>>> 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";
>>> cache.query(new SqlQuery<LocalDateTime, Person>(Person.class,
>>> sql1))
>>> .getAll()
>>> .forEach(e ->System.out.println("Value: "+ e.getValue()));
Re: SqlQuery deprecated
Posted by Pavel Tupitsyn <pt...@apache.org>.
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 <re...@gmail.com> wrote:
> 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 <re...@gmail.com> wrote:
>
>> 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";
>> cache.query(new SqlQuery<LocalDateTime, Person>(Person.class, sql1))
>> .getAll()
>> .forEach(e ->System.out.println("Value: "+ e.getValue()));
>>
>>
>>
Re: SqlQuery deprecated
Posted by Surinder Mehra <re...@gmail.com>.
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 <re...@gmail.com> wrote:
> 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";
> cache.query(new SqlQuery<LocalDateTime, Person>(Person.class, sql1))
> .getAll()
> .forEach(e ->System.out.println("Value: "+ e.getValue()));
>
>
>