Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Birt and Hive
Birt and Hive [message #692511] Mon, 04 July 2011 11:59 Go to next message
Wouter de Bie is currently offline Wouter de Bie
Messages: 2
Registered: July 2011
Junior Member
Hi all,

Today I stumbled upon BIRT and saw that the 3.7 release is able to communicate with Hive 0.7.0 (clouderas cdh3u0 release). I've tried setting this up, but I have been unlucky so far. When I setup a data source select hive and add the jars that are shown on the "Notable 3.7" page, testing the connection doesn't give any feedback. When I finish creating the datasource and want to add a data set, clicking Finish does nothing.

I have a hive server running on port 10000 and with a commandline tool, I'm able to query hive tables.

Does anyone know where I can look for errors or have a set of hive jars that are supposed to work?

Thanks,

Wouter
Re: Birt and Hive [message #692528 is a reply to message #692511] Mon, 04 July 2011 12:47 Go to previous messageGo to next message
Wouter de Bie is currently offline Wouter de Bie
Messages: 2
Registered: July 2011
Junior Member
I've come a little further on this. Birt connects, but I get "Method not supported" (see stacktrace below). I've seen this before when trying out different applications that do JDBC. Am I doing something completely wrong or should I get hive drivers from somewhere else?

Jul 4, 2011 6:44:20 PM org.eclipse.birt.report.data.oda.jdbc.ui.editors.MetaDataRetriever <init>
WARNING: Cannot retrieve the parameter metadata.
SQL error #1:Method not supported

org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot retrieve the parameter metadata.
SQL error #1:Method not supported
;
java.sql.SQLException: Method not supported
at org.eclipse.birt.report.data.oda.jdbc.Statement.getParameterMetaData(Statement.java:897)
at org.eclipse.birt.report.data.oda.jdbc.ui.editors.MetaDataRetriever.<init>(MetaDataRetriever.java:70)
at org.eclipse.birt.report.data.oda.jdbc.ui.editors.SQLDataSetEditorPage.collectDataSetDesign(SQLDataSetEditorPage.java:665)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardPageCore.finishDataSetDesign(DataSetWizardPageCore.java:395)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.collectDataSetDesignFromPage(DataSetWizardBase.java:365)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.finishDataSetDesign(DataSetWizardBase.java:387)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.performFinish(DataSetWizardBase.java:99)
at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:827)
at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:432)
at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:240)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4125)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1457)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1480)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1465)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1270)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3971)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3610)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
at org.eclipse.jface.window.Window.open(Window.java:801)
Re: Birt and Hive [message #692912 is a reply to message #692528] Tue, 05 July 2011 08:45 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Wouter,

Are all the exceptions listed as warning? Does the data set still
return data?

Jason

On 7/4/2011 12:47 PM, Wouter de Bie wrote:
> I've come a little further on this. Birt connects, but I get "Method not
> supported" (see stacktrace below). I've seen this before when trying out
> different applications that do JDBC. Am I doing something completely
> wrong or should I get hive drivers from somewhere else?
>
> Jul 4, 2011 6:44:20 PM
> org.eclipse.birt.report.data.oda.jdbc.ui.editors.MetaDataRetriever <init>
> WARNING: Cannot retrieve the parameter metadata.
> SQL error #1:Method not supported
>
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot retrieve the
> parameter metadata.
> SQL error #1:Method not supported
> ;
> java.sql.SQLException: Method not supported
> at
> org.eclipse.birt.report.data.oda.jdbc.Statement.getParameterMetaData(Statement.java:897)
>
> at
> org.eclipse.birt.report.data.oda.jdbc.ui.editors.MetaDataRetriever.<init>(MetaDataRetriever.java:70)
>
> at
> org.eclipse.birt.report.data.oda.jdbc.ui.editors.SQLDataSetEditorPage.collectDataSetDesign(SQLDataSetEditorPage.java:665)
>
> at
> org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardPageCore.finishDataSetDesign(DataSetWizardPageCore.java:395)
>
> at
> org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.collectDataSetDesignFromPage(DataSetWizardBase.java:365)
>
> at
> org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.finishDataSetDesign(DataSetWizardBase.java:387)
>
> at
> org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.performFinish(DataSetWizardBase.java:99)
>
> at
> org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:827)
> at
> org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:432)
> at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624)
> at
> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:240)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4125)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1457)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1480)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1465)
> at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1270)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3971)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3610)
> at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
> at org.eclipse.jface.window.Window.open(Window.java:801)
Re: Birt and Hive [message #698800 is a reply to message #692511] Wed, 20 July 2011 04:45 Go to previous message
al  is currently offline al
Messages: 3
Registered: July 2011
Junior Member
Hi all,

I am currently trying to connect Birt 3.7 to Hive 0.7.0 with the new plugin, but I am experiencing troubles as well. My configuration is a windows 7 on which I run Birt 3.7 and a virtual machine with the pre-packed cloudera : CDH3u0 on ubuntu 10.10. The VM is accessible at 192.168.18.129 from my local and I can run Hue beeswax from both the VM and windows.

The only documentation I found on this matter is the Birt's new feature page..Here are the points where I am blocking:

- First the validation button in birt does not work, but it's no big deal..

- Then the lack of description regarding the syntax : I use "jdbc:hive://192.168.18.129:10000/default" but I can only assume it's correct.

- Regarding the id/pwd I use cloudera/cloudera as they are the one set for hive.

- The "Add file statement" is not very clear also, I didn't find any documentation on that point, so I tried several things such as "add file /user/hive/warehouse/sample_07/sample_07.csv" which seems to look like the print screen on Birt's new feature page...

So you would have understood that I cannot connect and the log only says :

!ENTRY org.eclipse.ui 4 0 2011-07-20 10:44:11.947
!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.NoClassDefFoundError: org/slf4j/LoggerFactory
at org.apache.thrift.transport.TIOStreamTransport.<clinit>(TIOStreamTransport.java:38)
at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:100)
at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:110)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1159)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:253)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:188)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:728)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:634)
at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:120)
at org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper.testConnection(HiveSelectionPageHelper.java:410)
at org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper.access$4(HiveSelectionPageHelper.java:398)
at org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper$2.widgetSelected(HiveSelectionPageHelper.java:340)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:240)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
at org.eclipse.jface.window.Window.open(Window.java:801)
at org.eclipse.birt.report.designer.data.ui.actions.NewDataSourceAction.run(NewDataSourceAction.java:126)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2696)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.birt.report.designer.ui.rcp.DesignerApplication.run(DesignerApplication.java:38)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppContainer.callMethodWithException(EclipseAppContainer.java:587)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:198)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
Caused by: java.lang.ClassNotFoundException: org.slf4j.LoggerFactory
at org.eclipse.birt.core.framework.URLClassLoader.findClass1(URLClassLoader.java:188)
at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClassLoader.java:156)
at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClassLoader.java:1)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.birt.core.framework.URLClassLoader.findClass(URLClassLoader.java:151)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 55 more



I hope someone was able to go further than me and take some time to explain how he managed to..
Thank you in advance,

Al
Previous Topic:(no subject)
Next Topic:Birt connexion to Hive
Goto Forum:
  


Current Time: Tue Sep 02 00:24:49 EDT 2014

Powered by FUDForum. Page generated in 0.01771 seconds