Failed to generate REDUCE query. Data table found:"

classic Classic list List threaded Threaded
4 messages Options
siva siva
Reply | Threaded
Open this post in threaded view
|

Failed to generate REDUCE query. Data table found:"

This post was updated on .
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/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Failed to generate REDUCE query. Data table found:"

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 <[hidden email]>:
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/
siva siva
Reply | Threaded
Open this post in threaded view
|

Re: Failed to generate REDUCE query. Data table found:"

ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Failed to generate REDUCE query. Data table found:"

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 <[hidden email]>:
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/