In order to import the correct metadata from the ModeShape repository to build a Teiid model, the connection url must contain the "teiidsupport=true" property

Change the ModeShape connection profile used for importing metadata to create a Teiid model to contain the connection propery: teiidsupport=true. This can either be on the url or defined as an additional connection property.

This property is required in order to import the additional metadata that is exposed for Teiid. This is because, in order to make JCR sql conform to standard SQL symantics, Teiid requires additional metadata that is used to transform the sql in the ModeShape translator before it is used to execute against the ModeShape jdbc driver. This metadata is only used in the transformation on the Teiid side, not in ModeShape.