Re: SqlQuery Deprecated Since 2.8, please use SqlFieldsQuery instead....How to get result as passing model Type with SqlFieldsQuery?

[siva]

Hi,

It's working fine in "select _val from mytesttable" query but in case of sub
query or joins it's failing with an error like column not found

It's failing access column with and without table Aliases.
for example

Query::>

SELECT t.* from (select _val FROM materials ) as t INNER JOIN
"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_862C7264-8C8A-4217-AFA4-30CD49AC050F_SECURITY".SecurityGroups
ON t.EntityId = SecurityGroups.SGEntityId  WHERE securityGroupId in
('25c8eff1-1607-4a57-bd88-b4be9a1c3b73') order by t.MaterialName offset 0
rows fetch next 7000 rows only

Exception::>

Failed to parse query. Column "T.MATERIALNAME" not found; SQL statement:
SELECT t.* from (select _val FROM materials ) as t INNER JOIN
"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_862C7264-8C8A-4217-AFA4-30CD49AC050F_SECURITY".SecurityGroups
ON t.EntityId = SecurityGroups.SGEntityId  WHERE securityGroupId in
('25c8eff1-1607-4a57-bd88-b4be9a1c3b73') order by t.MaterialName offset 0
rows fetch next 7000 rows only [42122-197]

Thanks.




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/