[ https://issues.jboss.org/browse/TEIID-4187?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4187: ------------------------------------- Examples of executing the queries on PI through Teiid. See usage of LATERAL JOIN to execute TVF functions {code} SELECT eh.Path, eh.Name, ea.Name, a."Time", a."Value" FROM Sample.Asset.ElementHierarchy eh INNER JOIN Sample.Asset.ElementAttribute ea ON ea.ElementID = eh.ElementID INNER JOIN Sample.Data.Archive a ON a.ElementAttributeID = ea.ID WHERE eh.Path = '\Data Center\' AND a."Time" BETWEEN TIMESTAMPADD(SQL_TSI_HOUR, -1, now()) AND now() SELECT g_0."StartTime", g_1."Name", g_0."Time", g_0."Number of Computers", g_0."Temperature" FROM "Sample"."DataT"."ft_TransposeArchive_Building Template" AS g_0, "Sample"."Asset"."ElementHierarchy" AS g_1 WHERE g_1."ElementID" = g_0."ElementID" AND g_0."EndTime" = '2016-06-16 16:16:50.187' AND g_0."ElementID" IN (SELECT cast(g_2."ElementID" as String) FROM "Sample"."Asset"."ElementHierarchy" AS g_2 WHERE g_2."Path" = '\Data Center\') SELECT EH.Name, BT."Time", BT."Number of Computers", BT."Temperature" FROM Sample.Asset.ElementHierarchy EH LEFT JOIN LATERAL (exec "TransposeArchive_Building Template"(EH.ElementID, TIMESTAMPADD(SQL_TSI_HOUR, -1, now()), now())) BT on 1=1 WHERE EH.ElementID IN (SELECT ElementID FROM Sample.Asset.ElementHierarchy WHERE Path='\Data Center\') {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)