Status of general lateral join support for the Osisoft translator

Solution Verified - Updated -


  • TEIID-5224
  • Osisoft PI only supports a lateral join between a table and a table value function - not between a table and a derived table / inline view. However those joins are pushed down as pi advertises general lateral join support. Additional capabilities and possibly extension metadata may be required for the engine to differentiate these cases.


  • Red Hat JBoss Data Virtualization 6.4
  • Osisoft PI

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In