In teiid designer-JBossDataVirtualization6.3.0, hive connectivity is established but it points only to default database only.

[alohchab]

In teiid designer-JBossDataVirtualization6.3.0, hive connectivity is established but it points on to default database only. Even i have mentioned different database in the jdbc url ,then also it fetches tables from default db.

[rareddy]

Typically this is based on the JDBC driver, I do not believe Designer does anything above and beyond to change the database type or any other properties. So, I will double check all the properties URL etc and consult Hive JDBC driver documents to make sure.

[alohchab]

Thanks Ramesh,

This is my module.xml for Hive12.

[rareddy]

In that case, I suggest, you use "Teiid Connection Importer" to import metadata than using JDBC importer.

[alohchab]

I am using "Teiid connection importer" only to import metadata.

[rareddy]

How does your data source configuration look like?

[alohchab]

[rareddy]

That looks correct. I see you are using 0.12 version of the JDBC driver, depending on the Hive Server you are using that *may be* incompatible, Is that version that came with JDV? The documentation says 2.0 here Red Hat JBoss Data Virtualization 6.x Supported Configurations - Red Hat Customer Portal  It maybe it is worth exploring using other clients like SquirreL and see if anything is different.

[alohchab]

Now I  have changed my hive12 driver jars to following:

And getting this error on importing from hive datasource :

[jstastny]

Hello alohchab

I've verified that I can import from database other than 'default' using Teiid Designer 11.1.1 accessing both JDV6.3.8 and JDV 6.4.0.

Both JDBC import and Teiid connection import work as expected.

I am using JDBC url similar to yours. I use 1.2.1 hive jdbc driver.