"_key" and "_val" are predefined column names returning full key and value
objects:
select _key, _val from CommonConstruction
On Wed, May 26, 2021 at 12:52 PM JP wrote:
> Hi,
> Thanks for reply.Appriciated.
> Please use SqlFieldsQuery and list specific columns.
> Actually i m getting values
Hi,
Thanks for reply.Appriciated.
Please use SqlFieldsQuery and list specific columns.
Actually i m getting values corresponding to the query column.
how to get key value pair as result instead of getting list of value using
SqlFieldsQuery .Any sample query reference if possible.
Thanks in advanc
Now I see the problem - you use SqlQuery, which is deprecated (obsolete)
and has some limitations.
Please use SqlFieldsQuery and list specific columns.
Alternatively, use Ignite LINQ provider [1] to perform strongly-typed SQL
queries, for example:
CommonConstruction.AsCacheQueryable()
.Join(P
1. What if you do "select * from CommonConstruction" - does it work?
yes it is working with sqlquery.
2. Can you try listing specific columns instead of "*"?
if i am using specific column then i have to go with sqlfieldsquery
instead of using sqlquery.
--
Sent from: http://apache-ignit
1. What if you do "select * from CommonConstruction" - does it work?
2. Can you try listing specific columns instead of "*"?
On Wed, May 26, 2021 at 6:24 AM JP wrote:
> Hi,
> I am with Apache Ignite V2.9.1.And using .net thin client to perform query
> on cache.
> And using cache query as SqlQuer
Hi,
I am with Apache Ignite V2.9.1.And using .net thin client to perform query
on cache.
And using cache query as SqlQuery.
here is the query statement:
SELECT * FROM
"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON".CommonConstruction
As t1 INNER JOIN
"F2DEDF6E
