Have physical table with Native query errors with TEIID11020

virtualdatabase Jul 18, 2014 3:44 PM

I've created a number of physical tables utilizing native query (Oracle).

However, in my most recent I am getting the following error.

What should I look for?

Error: TEIID11020 no alias found on RRD_GEOSPATIAL_COMPLETE. When native query is being used, then alias name must be defined for table in the query.

SQLState: 38000

ErrorCode: 0

Thanks!

1. Re: Have physical table with Native query errors with TEIID11020

rareddy Jul 20, 2014 8:39 PM (in response to virtualdatabase)

Please see documents about native queries with JDBC JDBC Translator - Teiid 8.8 (draft) - Project Documentation Editor
Actions
2. Re: Have physical table with Native query errors with TEIID11020

shawkins Jul 21, 2014 9:51 AM (in response to rareddy)

Are you using a translator with supportsTableAlias turned off? We expect the tables in the query to have aliases so that we can create an inline view from the native query:

select * from foo as x
becomes
select * from (some query...) as x
Actions