Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Accessing Hive from external reporting tools

avatar
Explorer

Dear All,

 

I am quite new to Hadoop environment. Can experts please help with the below queries :

 

Things done until now :

 

1. I have Cloudera Hadoop running on AWS (ubuntu 14).

2. Have successfully installed Cloudera manager and a cluster is also created. The web link for CM and HUE are functioning good.

3. Have loaded csv files on HDFS and created hive tables ( as per guidance provided by experts here in this forum).

4. I am able to access these tables from Impala and create some simple graphs.

 

Questions :

 

1. we are using a reporting tool called BIRST. I would like to connect BIRST to the Hadoop environment.

Should I directly connect to Hive and access the tables created in Hive.

 

2. Should I use JDBC connectivity.

 

3. In BIRST for JDBC connectivity, I need the driver name and  connection string. I am not able to find the connection details in the cloudera manager for Hive. Is there any pre-requisities required.

 

Thanks.

 

1 ACCEPTED SOLUTION

avatar
Explorer
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
1 REPLY 1

avatar
Explorer
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login