Download Hive JDBC driver?

I need to download a driver to connect from BIRT to Hadoop/Hive. I Googled and saw that BIRT 3.7 is supposed to include a Hive driver, but after downloading and installing twice, I still don't have a driver on my desktop.

Anybody know where I can get one?

Thanks
Judy

Find more posts tagged with

Comments

mwilliams

Are you using BIRT 3.7? There is a dataSource in that version for connecting to Hadoop/Hive.

jmulders

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="97836" data-time="1331838902" data-date="15 March 2012 - 12:15 PM">
Are you using BIRT 3.7? There is a dataSource in that version for connecting to Hadoop/Hive. </blockquote>
 
Hi Michael, 
 
Thanks for the reply. For some reason, today I can connect using the Derby driver that comes with 3.7 ("org.apache.derby.jdbc.EmbeddedDriver"). However, I still can't create queries using the driver. I tried "select * from [table_name]" and it's not working. I get the error message "The established connection to the data source is not active." 
 
If you have any suggestions, that would be great! 
 
Thanks 
Judy

mwilliams

You probably need to use this driver:

org.apache.hadoop.hive.jdbc.HiveDriver

Are you not using BIRT 3.7 so that you can use the Hive dataSource?

jmulders

Well, I'm obviously a bit confused so bear with me...

1) I originally download "BIRT Designer Professional" and used that to develop a few reports against an Oracle database. No Hive data source is listed.
2) Then we needed to connect to Hadoop for some other reports, so I downloaded Eclipse. I see Hive as a data source type, but I get the error about a missing driver.

Version information:

1) BIRT:

Actuate BIRT Designer Professional
Version: 11.0.3
Build id: 20111028

2) Eclipse:

Eclipse IDE for Java and Report Developers
Version: Indigo Service Release 2
Build id: 20120216-1857

Regards,
Judy

mwilliams

Take a look at this for setting up the Hadoop/Hive dataSource:

http://www.eclipse.org/birt/phoenix/project/notable3.7.php#jump_4

jmulders

Hi Michael,

I could only find the first file/driver on my desktop (log4j-1.2.15.jar) -- the others weren't on my machine. I am going to try re-installing BIRT to see if that helps.

Regards,
Judy

jmulders

Update: I re-installed from "eclipse-reporting-indigo-SR2-win32.zip" but still can't find many of the *.jar files I need. Does anyone know where I can get the jar files needed for Hadoop connectivity? Thanks.