Following https://community.jboss.org/wiki/MicrosoftExcelDocumentIntoRelationalTable (Option 1 using Teiid Designer), the imported model has the ROW_ID column modeled with datatype "integer", which results in BigInteger runtime datatype. After adding this model to a vdb and deploying, the following queries work ok:
but the following query fails:
The error is
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: java.math.BigInteger cannot be cast to java.lang.Integer
After changing the datatype to "int : xs:long" and redeploying, the above query works as expected.
However, if I copy the generated dynamic vdb (attached) and deploy it on the server (without using Designer), running the query against that works.
The DDL for import is