Apache Hive Server 2 ODA

trainor

1. Download and extract the BIRT HiveServer2 ODA zip file.<br />
<br />
2. To install we simply copy the downloaded files to the appropriate plugins directories in your downloaded eclipse IDE.

<br />
• Copy the 2 ODA driver files to the "plugins" directory of your eclipse install.<br />

<br />

e.g. "c:\eclipse\plugins"

<br />
• Copy the 9 dependent jar files to the "drivers" directory of your eclipse install located under the "plugins\org.eclipse.birt.report.data.oda.jdbc_version-number" directory.<br />

<br />

e.g. "c:\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_4.3.0.v201306041519\drivers"

<br />
<br />
3. To use this new driver, select "Hive2 Data Source" when creating a new data source in your report, then for the URL, specify "jdbc:hive2" where you would have specified "" to connect to a Hive 1 server.