I choose Table Types as TABLE and i was able to import the tables
Now i choose Table Types as TABLE,VIEW as seen above but see error as below. I also choose Table Types as just the VIEW but still same error.
Please let me knowif i have to change some properties or if im doing something wrong. Thank you
Since i wasn't able to import VIEWS using Teiid Importer i tried using JDBC Connection and same issue. I wasn't able to see the VIEWS.
There is NO Teiid 11.2, that is version number for Teiid Designer. Teiid Designer 11.2 only works with Teiid 9.x, which is deployed on WildFly 10. Teiid Designer does not yet support Teiid 10.x which is deployed on WildFly 11.
In the above you can set "useDatabaseMetaData" to true, then that might help. If it does not then Hive JDBC driver is not sending correct Database Metadata, which is beyond the control of Teiid. You can verify that using any other SQL based client applications.
We set "useDatabaseMetaData" to true. It might be issue with Hive JDBC driver