1) Imported the Books.xsd, BookDataTypes.xsd
2) Open the Books, xml schema and select "bibilography" element
3) Right click "Modeling -> Create XML to Scalar Transformation"

The generated transformation for the "published" column is set as "gYear", thus the transformation validation fails.

"gYear" is not a Teiid "runtime" data type. "gYear" is design time XML data type, however there are mappings defined for each design time data type to runtime type. I suspect, we are not doing the translations. For Teiid "gYear" should be mapped to "biginteger". Although "gYear" definition can not really map to biginteger (as it has optional timezone its definition), that how Teiid understands currently. We need to also make sure other 'g' types are also mapped correctly.

If there is complex type that can not be deciphered correctly it may be good to leave as xml fragment.