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 <jopandy...@gmail.com> 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 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-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_CONSTRUCTIONPROJECTROLE".ProjectsRole > AS t2 ON t1.UUID = t2.ProjectId where t2.PersonId = > 'a91f8995-2c28-4f33-9587-817749526a55' AND t2.ProjectAccessStatus = 'true' > and t2.IsDeleted != 'true' and t1.IsDeleted != 'true' AND > t1.TableName='common_project'; > > Exception: > Failed to parse query. Column > > "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON.COMMONCONSTRUCTION._KEY" > not found; SQL statement: > SELECT > > "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON"."COMMONCONSTRUCTION"._KEY, > > "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON"."COMMONCONSTRUCTION"._VAL > FROM CommonConstruction As t1 INNER JOIN > > "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_CONSTRUCTIONPROJECTROLE".ProjectsRole > AS t2 ON t1.UUID = t2.ProjectId where t2.PersonId = > 'a91f8995-2c28-4f33-9587-817749526a55' AND t2.ProjectAccessStatus = 'true' > and t2.IsDeleted != 'true' and t1.IsDeleted != 'true' AND > t1.TableName='common_project' [42122-197] > > is this issue exists or i commiting mistake somewhere? Can you please give > me suggestion. > > Thanks. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
