How are you importing the metadata? Using the Designer's Teiid Connecton Importer? Try setting the "useDatabaseMetaData" import property to "true" and see if that helps.
Thanks for the reply.
I am already setting useDatabaseMetaData to true, still I am getting this error.
> I am getting this error
What error/exception are you seeing?
> 3. Also the tables contain _ character in it. Is it the problem ?
> 4. Also I am using schema pattern to import schema. Again schema with _ is the problem.
That is not a problem for Teiid, but it is a like meta character, which may be causing an issue with the DatabaseMetaData implementation supplied with Hive.