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/04/08 12:30:39 UTC
Get SqlFieldQueryResults by name
Hi,
I was going through the below example and have a question if we can get
fields using field names from query results.
like "select name as person_name, p.age as person_age from Person p"
It would return List<List?>. The inner list is each person row returned
with results as per order in sql query. While this works fine but I was
wondering if we can fetch row fields by name just like Oracle sql query
rowMapper
https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/sql/SqlDmlExample.java
Re: Get SqlFieldQueryResults by name
Posted by Surinder Mehra <re...@gmail.com>.
Created: https://issues.apache.org/jira/browse/IGNITE-17158
Thanks
On Tue, Jun 14, 2022 at 2:10 PM Stephen Darlington <
stephen.darlington@gridgain.com> wrote:
> You can file a ticket on Ignite’s Jira:
> https://issues.apache.org/jira/browse/IGNITE
>
> More, in general, about how to get involved here:
> https://ignite.apache.org/our-community.html#faq
>
> On 13 Jun 2022, at 11:38, Surinder Mehra <re...@gmail.com> wrote:
>
> Hello,
> Can someone please log a feature request. This would be very useful
> feature for everyone using SQL queries
>
> On Fri, Apr 8, 2022 at 8:03 PM Surinder Mehra <re...@gmail.com> wrote:
>
>> Ok thanks for letting me know. Is there a guideline for raising feature
>> request.
>>
>> On Fri, 8 Apr 2022, 18:10 Stephen Darlington, <
>> stephen.darlington@gridgain.com> wrote:
>>
>>> That would be a nice feature but I don’t think it’s currently possible.
>>> It may be worth creating a feature request ticket.
>>>
>>> On 8 Apr 2022, at 13:30, Surinder Mehra <re...@gmail.com> wrote:
>>>
>>> Hi,
>>> I was going through the below example and have a question if we can get
>>> fields using field names from query results.
>>> like "select name as person_name, p.age as person_age from Person p"
>>> It would return List<List?>. The inner list is each person row returned
>>> with results as per order in sql query. While this works fine but I was
>>> wondering if we can fetch row fields by name just like Oracle sql query
>>> rowMapper
>>>
>>>
>>> https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/sql/SqlDmlExample.java
>>>
>>>
>>>
>>>
>
Re: Get SqlFieldQueryResults by name
Posted by Stephen Darlington <st...@gridgain.com>.
You can file a ticket on Ignite’s Jira: https://issues.apache.org/jira/browse/IGNITE
More, in general, about how to get involved here: https://ignite.apache.org/our-community.html#faq
> On 13 Jun 2022, at 11:38, Surinder Mehra <re...@gmail.com> wrote:
>
> Hello,
> Can someone please log a feature request. This would be very useful feature for everyone using SQL queries
>
> On Fri, Apr 8, 2022 at 8:03 PM Surinder Mehra <rednirus@gmail.com <ma...@gmail.com>> wrote:
> Ok thanks for letting me know. Is there a guideline for raising feature request.
>
> On Fri, 8 Apr 2022, 18:10 Stephen Darlington, <stephen.darlington@gridgain.com <ma...@gridgain.com>> wrote:
> That would be a nice feature but I don’t think it’s currently possible. It may be worth creating a feature request ticket.
>
>> On 8 Apr 2022, at 13:30, Surinder Mehra <rednirus@gmail.com <ma...@gmail.com>> wrote:
>>
>> Hi,
>> I was going through the below example and have a question if we can get fields using field names from query results.
>> like "select name as person_name, p.age as person_age from Person p"
>> It would return List<List?>. The inner list is each person row returned with results as per order in sql query. While this works fine but I was wondering if we can fetch row fields by name just like Oracle sql query rowMapper
>>
>> https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/sql/SqlDmlExample.java <https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/sql/SqlDmlExample.java>
>
Re: Get SqlFieldQueryResults by name
Posted by Surinder Mehra <re...@gmail.com>.
Hello,
Can someone please log a feature request. This would be very useful feature
for everyone using SQL queries
On Fri, Apr 8, 2022 at 8:03 PM Surinder Mehra <re...@gmail.com> wrote:
> Ok thanks for letting me know. Is there a guideline for raising feature
> request.
>
> On Fri, 8 Apr 2022, 18:10 Stephen Darlington, <
> stephen.darlington@gridgain.com> wrote:
>
>> That would be a nice feature but I don’t think it’s currently possible.
>> It may be worth creating a feature request ticket.
>>
>> On 8 Apr 2022, at 13:30, Surinder Mehra <re...@gmail.com> wrote:
>>
>> Hi,
>> I was going through the below example and have a question if we can get
>> fields using field names from query results.
>> like "select name as person_name, p.age as person_age from Person p"
>> It would return List<List?>. The inner list is each person row returned
>> with results as per order in sql query. While this works fine but I was
>> wondering if we can fetch row fields by name just like Oracle sql query
>> rowMapper
>>
>>
>> https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/sql/SqlDmlExample.java
>>
>>
>>
>>
Re: Get SqlFieldQueryResults by name
Posted by Surinder Mehra <re...@gmail.com>.
Ok thanks for letting me know. Is there a guideline for raising feature
request.
On Fri, 8 Apr 2022, 18:10 Stephen Darlington, <
stephen.darlington@gridgain.com> wrote:
> That would be a nice feature but I don’t think it’s currently possible. It
> may be worth creating a feature request ticket.
>
> On 8 Apr 2022, at 13:30, Surinder Mehra <re...@gmail.com> wrote:
>
> Hi,
> I was going through the below example and have a question if we can get
> fields using field names from query results.
> like "select name as person_name, p.age as person_age from Person p"
> It would return List<List?>. The inner list is each person row returned
> with results as per order in sql query. While this works fine but I was
> wondering if we can fetch row fields by name just like Oracle sql query
> rowMapper
>
>
> https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/sql/SqlDmlExample.java
>
>
>
>
Re: Get SqlFieldQueryResults by name
Posted by Stephen Darlington <st...@gridgain.com>.
That would be a nice feature but I don’t think it’s currently possible. It may be worth creating a feature request ticket.
> On 8 Apr 2022, at 13:30, Surinder Mehra <re...@gmail.com> wrote:
>
> Hi,
> I was going through the below example and have a question if we can get fields using field names from query results.
> like "select name as person_name, p.age as person_age from Person p"
> It would return List<List?>. The inner list is each person row returned with results as per order in sql query. While this works fine but I was wondering if we can fetch row fields by name just like Oracle sql query rowMapper
>
> https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/sql/SqlDmlExample.java <https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/sql/SqlDmlExample.java>