Issue in connection between Jboss and Hive

[biswajeetsahoo]

Hi All,

Can any one help me on below issue?

I am trying to connect Hive from Jboss. I have downloaded hive driver and added while give connection to hive from Jboss.

Got below message when tried to connect to hive

Got below error message when tried to ping connection

Need assistance to deliver the work.

Thanks,

Bisu

[rareddy]

Biswajeet,

I believe there are more than single JAR file that are needed to connected to HIVE. Last time tried I needed all the below

• commons-logging-1.1.3.jar
• hadoop-common-2.4.0.jar
• hive-exec-0.13.1.jar
• hive-jdbc-0.13.1.jar
• hive-service-0.13.1.jar
• httpclient-4.2.5.jar
• httpcore-4.2.5.jar
• libfb303-0.9.0.jar
• libthrift-0.9.0.jar
• log4j-1.2.16.jar
• slf4j-api-1.7.5.jar

In Designer, you may need to add all of them using the Data Tools wizard. When it comes to Teiid Server, these will not be automatically deployed, you then have to manually create a "module" and supply all these JAR files in there. You can find instructions for that at "teiid-{version}/docs/teiid/datasources/hive" directory. It also shows how to add the driver definition to the configuration, along with data source configuration. Once those are done, you need to restart the server to take effect

HTH

Ramesh..

[biswajeetsahoo]

Hi Ramesh,

Thanks for your response could you please tell me where can i find "teiid-{version}/docs/teiid/datasources/hive" directory ?

So that i can follow instruction.

Thanks,

Biswajeet

[biswajeetsahoo]

Hi Ramesh,

I have followed added the jar files as mentioned but facing same issue.
Could you please help me with link/url so that i can follow.

Do we need kerberos authentication for this issue, i found in some blogs please advice me.

Please assist me...

Thanks,

Biswajeet

[rareddy]

Have you installed Teiid Server? Look inside where you installed Teiid.

[rareddy]

I want to make sure that you understand there are two different places, you are (will be) connecting the Hive. One in Designer and another in Teiid Server. We can reduce this to one place that is in the Server. For that, you need to follow above directions, and create a module in WildFly/Teiid server and then create a driver definition in the standalone-teiid.xml file, and create the data source itself in the standalone-teiid.xml. Then restart the server.

Once the above is done, in Teiid Designer, use "Teiid Connection Importer" and select the JNDI name that you created for the Hive in the previous step, and import the metadata to build the VDB, then you can test the connection.

See here for more detailed directions Connect to a Hadoop Source using Hive2

Here is one to pull the required JARs Hive integration

An example Hive/Hadoop as a Data Source Example · Teiid Quickstarts 

Once you can do the above, then you can follow the does teiid support connecting to kerberos enabled hive via jdbc?  for Kerberos configuration.

Ramesh..