You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by siva <si...@bizruntime.com> on 2020/12/16 07:53:59 UTC
Failed to generate REDUCE query. Data table found:"
Hi All,
I am using Apache Ignite DotNet client Server application v2.7.6.
I have two caches And each having separate model
class(SECURITYGROUPS,TASKS_TASKS) and separate cache group name.
here is the both cache name
1."F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_TASKS"
2."F2DEDF6E-393E-42BC-9BB3-E835A1063B30_862C7264-8C8A-4217-AFA4-30CD49AC050F_SECURITY"
*SQLField cross cache Join query*
SELECT * from (SELECT DISTINCT nestedunderid as
parententityid,tasks_tasks.entityid as uuid, wbs as
wbs,tasks_tasks.entityname as entityname,duration as duration,_start as
start, _finish as finish,percentagecomplete as
percentagecomplete,nestedunderwbs as nestedunderwbs,nestedunderid as
nestedunderid FROM tasks_tasks INNER JOIN
"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_862C7264-8C8A-4217-AFA4-30CD49AC050F_SECURITY".SecurityGroups
ON tasks_tasks.entityid = SecurityGroups.SGEntityId WHERE securityGroupId
in
('bbe5df6a-e6be-4943-be4f-d2eafeb7ecb6','5076c7f6-da01-412d-a23f-7d44a17a0c2d','c01cb194-81d7-479f-9dec-5269ecd7bafa','25c8eff1-1607-4a57-bd88-b4be9a1c3b73')
and tasks_tasks.Project = 'Test' ) as A where A.nestedunderwbs not in
(Select wbs from (SELECT DISTINCT nestedunderid as
parententityid,tasks_tasks.entityid as uuid, wbs as
wbs,tasks_tasks.entityname as entityname,duration as duration,_start as
start, _finish as finish,percentagecomplete as
percentagecomplete,nestedunderwbs as nestedunderwbs,nestedunderid as
nestedunderid FROM tasks_tasks INNER JOIN
"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_862C7264-8C8A-4217-AFA4-30CD49AC050F_SECURITY".SecurityGroups
ON tasks_tasks.entityid = SecurityGroups.SGEntityId WHERE securityGroupId
in
('bbe5df6a-e6be-4943-be4f-d2eafeb7ecb6','5076c7f6-da01-412d-a23f-7d44a17a0c2d','c01cb194-81d7-479f-9dec-5269ecd7bafa','25c8eff1-1607-4a57-bd88-b4be9a1c3b73')
and tasks_tasks.Project = 'Test' ) as B) or A.nestedunderwbs is null
*DotNet Client query request code:*
using (IIgniteClient client =
Ignition.StartClient(this._igniteClientConfiguration))
{
var cache = client.GetCache<object,
IConstructionCacheStore>("F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_TASKS");
SqlFieldsQuery sqlQuery = new SqlFieldsQuery(query);
var queryCursor = cache.Query(sqlQuery);//Error
foreach (var rcursor in queryCursor)
{
}
}
*Exception*
Failed to generate REDUCE query. Data table found:
"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_TASKS".TASKS_TASKS
SELECT
A__Z2.PARENTENTITYID,
A__Z2.UUID,
A__Z2.WBS,
A__Z2.ENTITYNAME,
A__Z2.DURATION,
A__Z2.START,
A__Z2.FINISH,
A__Z2.PERCENTAGECOMPLETE,
A__Z2.NESTEDUNDERWBS,
A__Z2.NESTEDUNDERID
FROM (SELECT DISTINCT
__C0_0 PARENTENTITYID,
__C0_1 UUID,
__C0_2 WBS,
__C0_3 ENTITYNAME,
__C0_4 DURATION,
__C0_5 START,
__C0_6 FINISH,
__C0_7 PERCENTAGECOMPLETE,
__C0_8 NESTEDUNDERWBS,
__C0_9 NESTEDUNDERID
FROM PUBLIC.__T0) A__Z2
WHERE (A__Z2.NESTEDUNDERWBS IS NULL) OR (NOT (A__Z2.NESTEDUNDERWBS IN(
SELECT
B__Z5.WBS
FROM (SELECT DISTINCT
__Z3.NESTEDUNDERID AS PARENTENTITYID,
__Z3.ENTITYID AS UUID,
__Z3.WBS AS WBS,
__Z3.ENTITYNAME AS ENTITYNAME,
__Z3.DURATION AS DURATION,
__Z3._START AS START,
__Z3._FINISH AS FINISH,
__Z3.PERCENTAGECOMPLETE AS PERCENTAGECOMPLETE,
__Z3.NESTEDUNDERWBS AS NESTEDUNDERWBS,
__Z3.NESTEDUNDERID AS NESTEDUNDERID
FROM
"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_TASKS".TASKS_TASKS
__Z3
INNER JOIN
"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_862C7264-8C8A-4217-AFA4-30CD49AC050F_SECURITY".SECURITYGROUPS
__Z4
ON TRUE
WHERE ((__Z4.SECURITYGROUPID IN('bbe5df6a-e6be-4943-be4f-d2eafeb7ecb6',
'5076c7f6-da01-412d-a23f-7d44a17a0c2d',
'c01cb194-81d7-479f-9dec-5269ecd7bafa',
'25c8eff1-1607-4a57-bd88-b4be9a1c3b73')) AND (__Z3.PROJECT = 'MR GAT')) AND
(__Z3.ENTITYID = __Z4.SGENTITYID)) B__Z5 )))
How to solve above error and to perform cross cache join query.
Thanks.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Failed to generate REDUCE query. Data table found:"
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
Indeed it seems like a bug. I have filed a ticket:
https://issues.apache.org/jira/browse/IGNITE-13961
Regards,
--
Ilya Kasnacheev
ср, 6 янв. 2021 г. в 14:18, siva <si...@bizruntime.com>:
> Hi,
> please find the below given cache config and models class details.
>
> cache
> config:
> https://github.com/CP-Ram/DotNetIgniteQueryTestApp/blob/main/DotNetIgniteQueryTestApp/Program.cs
>
> model
> classes:
> https://github.com/CP-Ram/DotNetIgniteQueryTestApp/tree/main/DotNetIgniteQueryTestApp/Models
>
> Thanks.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
Re: Failed to generate REDUCE query. Data table found:"
Posted by siva <si...@bizruntime.com>.
Hi,
please find the below given cache config and models class details.
cache
config:https://github.com/CP-Ram/DotNetIgniteQueryTestApp/blob/main/DotNetIgniteQueryTestApp/Program.cs
model
classes:https://github.com/CP-Ram/DotNetIgniteQueryTestApp/tree/main/DotNetIgniteQueryTestApp/Models
Thanks.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Failed to generate REDUCE query. Data table found:"
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
Can you please provide DDL or specify cache configurations for these
tables? I will check it, file a ticket if necessary.
Regards,
--
Ilya Kasnacheev
ср, 16 дек. 2020 г. в 10:54, siva <si...@bizruntime.com>:
> Hi All,
> I am using Apache Ignite DotNet client Server application v2.7.6.
> I have two caches And each having separate model
> class(SECURITYGROUPS,TASKS_TASKS) and separate cache group name.
> here is the both cache name
>
> 1."F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_TASKS"
>
> 2."F2DEDF6E-393E-42BC-9BB3-E835A1063B30_862C7264-8C8A-4217-AFA4-30CD49AC050F_SECURITY"
>
>
> *SQLField cross cache Join query*
>
> SELECT * from (SELECT DISTINCT nestedunderid as
> parententityid,tasks_tasks.entityid as uuid, wbs as
> wbs,tasks_tasks.entityname as entityname,duration as duration,_start as
> start, _finish as finish,percentagecomplete as
> percentagecomplete,nestedunderwbs as nestedunderwbs,nestedunderid as
> nestedunderid FROM tasks_tasks INNER JOIN
>
> "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_862C7264-8C8A-4217-AFA4-30CD49AC050F_SECURITY".SecurityGroups
> ON tasks_tasks.entityid = SecurityGroups.SGEntityId WHERE securityGroupId
> in
>
> ('bbe5df6a-e6be-4943-be4f-d2eafeb7ecb6','5076c7f6-da01-412d-a23f-7d44a17a0c2d','c01cb194-81d7-479f-9dec-5269ecd7bafa','25c8eff1-1607-4a57-bd88-b4be9a1c3b73')
> and tasks_tasks.Project = 'Test' ) as A where A.nestedunderwbs not in
> (Select wbs from (SELECT DISTINCT nestedunderid as
> parententityid,tasks_tasks.entityid as uuid, wbs as
> wbs,tasks_tasks.entityname as entityname,duration as duration,_start as
> start, _finish as finish,percentagecomplete as
> percentagecomplete,nestedunderwbs as nestedunderwbs,nestedunderid as
> nestedunderid FROM tasks_tasks INNER JOIN
>
> "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_862C7264-8C8A-4217-AFA4-30CD49AC050F_SECURITY".SecurityGroups
> ON tasks_tasks.entityid = SecurityGroups.SGEntityId WHERE securityGroupId
> in
>
> ('bbe5df6a-e6be-4943-be4f-d2eafeb7ecb6','5076c7f6-da01-412d-a23f-7d44a17a0c2d','c01cb194-81d7-479f-9dec-5269ecd7bafa','25c8eff1-1607-4a57-bd88-b4be9a1c3b73')
> and tasks_tasks.Project = 'Test' ) as B) or A.nestedunderwbs is null
>
>
> *DotNet Client query request code:*
> using (IIgniteClient client =
> Ignition.StartClient(this._igniteClientConfiguration))
> {
> var cache = client.GetCache<object,
>
> IConstructionCacheStore>("F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_TASKS");
>
> SqlFieldsQuery sqlQuery = new SqlFieldsQuery(query);
>
> var queryCursor = cache.Query(sqlQuery);//Error
>
> foreach (var rcursor in queryCursor)
> {
> }
> }
>
> *Exception*
> Failed to generate REDUCE query. Data table found:
> "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_TASKS".TASKS_TASKS
>
> SELECT
> A__Z2.PARENTENTITYID,
> A__Z2.UUID,
> A__Z2.WBS,
> A__Z2.ENTITYNAME,
> A__Z2.DURATION,
> A__Z2.START,
> A__Z2.FINISH,
> A__Z2.PERCENTAGECOMPLETE,
> A__Z2.NESTEDUNDERWBS,
> A__Z2.NESTEDUNDERID
> FROM (SELECT DISTINCT
> __C0_0 PARENTENTITYID,
> __C0_1 UUID,
> __C0_2 WBS,
> __C0_3 ENTITYNAME,
> __C0_4 DURATION,
> __C0_5 START,
> __C0_6 FINISH,
> __C0_7 PERCENTAGECOMPLETE,
> __C0_8 NESTEDUNDERWBS,
> __C0_9 NESTEDUNDERID
> FROM PUBLIC.__T0) A__Z2
> WHERE (A__Z2.NESTEDUNDERWBS IS NULL) OR (NOT (A__Z2.NESTEDUNDERWBS IN(
> SELECT
> B__Z5.WBS
> FROM (SELECT DISTINCT
> __Z3.NESTEDUNDERID AS PARENTENTITYID,
> __Z3.ENTITYID AS UUID,
> __Z3.WBS AS WBS,
> __Z3.ENTITYNAME AS ENTITYNAME,
> __Z3.DURATION AS DURATION,
> __Z3._START AS START,
> __Z3._FINISH AS FINISH,
> __Z3.PERCENTAGECOMPLETE AS PERCENTAGECOMPLETE,
> __Z3.NESTEDUNDERWBS AS NESTEDUNDERWBS,
> __Z3.NESTEDUNDERID AS NESTEDUNDERID
> FROM
>
> "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_TASKS".TASKS_TASKS
> __Z3
> INNER JOIN
>
> "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_862C7264-8C8A-4217-AFA4-30CD49AC050F_SECURITY".SECURITYGROUPS
> __Z4
> ON TRUE
> WHERE ((__Z4.SECURITYGROUPID IN('bbe5df6a-e6be-4943-be4f-d2eafeb7ecb6',
> '5076c7f6-da01-412d-a23f-7d44a17a0c2d',
> 'c01cb194-81d7-479f-9dec-5269ecd7bafa',
> '25c8eff1-1607-4a57-bd88-b4be9a1c3b73')) AND (__Z3.PROJECT = 'MR GAT')) AND
> (__Z3.ENTITYID = __Z4.SGENTITYID)) B__Z5 )))
>
> How to solve above error and to perform cross cache join query.
>
> Thanks.
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>