Ambiguos group error on query

[Cristiano Limiti]

Hello,

I have created a VDB that contains a data source (data_source.xmi) to a oracle database with JDBC connection.
In the VDB there is a "metadata model" of type View that maps the JDBC data source. By running a query like: "select * from users" I get this error: org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryResolverException: Group specified is ambiguous, resubmit the query by fully qualifying the group name : Users.

I know if I run the query this way "select * from data_view. Users" I can get the results. I would like to avoid specifying the schema but pointing directly to the view type model metadata.

Thanks

[Ramesh Reddy]

There must be another table n different model with the same name thus the issue. Without resolving this you must fully qualify it.

[Steven Hawkins]

There is no default schema or schema search path in Teiid, but you can mark models as hidden to prevent the tables from being seen as ambiguous.