2 Replies Latest reply on Jun 20, 2017 4:45 PM by Steven Hawkins

    Ambiguos group error on query

    Cristiano Limiti Newbie

      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