Hello!
Why not:
SELECT t.*, t._val from materials t INNER JOIN ...
Regards,
--
Ilya Kasnacheev
чт, 21 янв. 2021 г. в 19:19, siva <siva.ka...@bizruntime.com>:
> 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/
>
