Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Hive and Birt
Hive and Birt [message #896737] Thu, 19 July 2012 10:21 Go to next message
Dabe Elie is currently offline Dabe Elie
Messages: 5
Registered: July 2012
Junior Member
Hello everyone,

I am having trouble configuring the new JDBC driver between Hive and Birt : I have Hive set up nicely and working, when I add a new data source, i add the right jar files, and when i click on "test connection", nothing happens. I configured the url as : jdbc:hive://localhost:10000/default
Then I click okay, and i try to add a new data set, but Birt wont let me do it...what do I do wrong?

Thanks a lot!

[Updated on: Fri, 20 July 2012 17:45]

Report message to a moderator

Re: Hive and Birt [message #896803 is a reply to message #896737] Thu, 19 July 2012 17:04 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Dabe,

Look for a .log file in your workspace .metada folder and see if any
error is in the log.

Jason


On 7/19/2012 10:22 AM, Dabe Elie wrote:
> Hello everyone,
> I am having trouble configuring the new JDBC driver between Hive and
> Birt : I have Hive set up nicely and working, when I add a new data
> source, i ad the right jar files, and when i click on "test connection",
> nothing happens. I configured the url as :
> jdbc:hive://localhost:10000/default
> Then I click okay, and i try to add a new data set, but Birt wont let me
> do it...what do I do wrong?
>
> Thanks a lot!
Re: Hive and Birt [message #896874 is a reply to message #896803] Fri, 20 July 2012 04:54 Go to previous messageGo to next message
Dabe Elie is currently offline Dabe Elie
Messages: 5
Registered: July 2012
Junior Member
Hello Jason, thanks for your very quick answer!
Let me explain you a few things I did :
-I started hadoop, and hive, I have tables in have, containing data, i can do queries on the terminal, no problem
-I added all the exact same jars as written here :
http://www.eclipse.org/birt/phoenix/project/notable3.7.php
-I used the database jdbc:hive://localhost:10000/default
-Should I launch the hive server? through $ bin/hive --service hiveserver?

I clicked on "Test connection", but it didnt do anything, so I looked at the logs and apparently here is the problem :

Quote:

!ENTRY org.eclipse.ui 4 0 2012-07-20 09:40:00.339
!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:92)
at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1234)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:273)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:787)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:687)
at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)
.....................
quinox.launcher.Main.basicRun(Main.java:584)
at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
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(ClassLoader.java:306)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
... 58 more


Seeing that, I thought maybe I needed an sl4j jar, so I added 2 jars from hive:
-slf4j-log4j12-1.6.1.jar
-slf4j-api-1.6.1
I don't know if it is a good idea, but I thought i could try.
And here is the new log messages I get when I try to test the connection (I still have nothing happenning when I click on "test connection")
Quote:

!ENTRY org.eclipse.ui 4 0 2012-07-20 09:47:49.069
!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.NoClassDefFoundError: Could not initialize class org.apache.thrift.transport.TSocket
at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:92)
at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1234)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:273)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)
...............
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
at org.eclipse.equinox.launcher.Main.run(Main.java:1438)


I restarted birt a few times, tried with one new jar, with two new jars, and now, when I click on "Test Connection", I have a message saying :

Quote:

org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, Could not establish connection to localhost:10000/default: java.net.ConnectException: Connection refused.
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:303)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:787)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:687)
at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)
at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:138)
at org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper.testConnection(HiveSelectionPageHelper.java:404)
at org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper.access$4(HiveSelectionPageHelper.java:392)
at org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper$2.widgetSelected(HiveSelectionPageHelper.java:333)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
..........


I hope you could understand my problems, my english isnt perfect, I am french, but if you could help me set this up, I would be very grateful.

Thanks

[Updated on: Fri, 20 July 2012 08:20]

Report message to a moderator

Re: Hive and Birt [message #897029 is a reply to message #896874] Fri, 20 July 2012 16:34 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

I just tested this with those jars and the latest hadoop/hive servers
and it worked for me. I then replaced all the jars in the manage
drivers button with the ones attached in the screenshot and it worked as
well. This was with hadoop 1.0.3 and hive .90 . I assume you have the
thrift server running on your cluster?

Jason



On 7/20/2012 4:54 AM, Dabe Elie wrote:
> Hello Jason, thanks for your very quick answer!
> Let me explain you a few things I did :
> -I started hadoop, and hive, I have on table in have, containing data, i
> can do queries on the terminal, no problem
> -I added all the exact same jars as written here :
> http://www.eclipse.org/birt/phoenix/project/notable3.7.php
> -I used the database jdbc:hive://localhost:10000/default
>
> I clicked on "Test connection", bu it didnt do anything, so I looked at
> the logs and apparently here is the problem :
>
> Quote:
>> !ENTRY org.eclipse.ui 4 0 2012-07-20 09:40:00.339
>> !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:92)
>> at
>> org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
>> at
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1234)
>>
>> at
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:273)
>>
>> at
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)
>>
>> at
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:787)
>>
>> at
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:687)
>>
>> at
>> org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)
>>
>> .....................
>> quinox.launcher.Main.basicRun(Main.java:584)
>> at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
>> 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(ClassLoader.java:306)
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
>> ... 58 more
>
>
> Seeing that, I thought maybe I needed an sl4j jar, so I added 2 jars
> from hive:
> -slf4j-log4j12-1.6.1.jar
> -slf4j-api-1.6.1
> I don't know if it is a good idea, but I thought i could try.
> And here is the new log messages I get when I try to test the connection
> (I still have nothing happenning when I click on "test connection")
> Quote:
>> !ENTRY org.eclipse.ui 4 0 2012-07-20 09:47:49.069
>> !MESSAGE Unhandled event loop exception
>> !STACK 0
>> java.lang.NoClassDefFoundError: Could not initialize class
>> org.apache.thrift.transport.TSocket
>> at
>> org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:92)
>> at
>> org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
>> at
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1234)
>>
>> at
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:273)
>>
>> at
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)
>>
>> ...............
>> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
>> at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
>
>
> I restarted birt a few times, tried with one new jar, with two new jars,
> and now, when I click on "Test Connection", I have a message saying :
>
> Quote:
>> org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error
>> in get connection, Could not establish connection to
>> localhost:10000/default: java.net.ConnectException: Connection refused.
>> at
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:303)
>>
>> at
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)
>>
>> at
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:787)
>>
>> at
>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:687)
>>
>> at
>> org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)
>>
>> at
>> org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:138)
>>
>> at
>> org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper.testConnection(HiveSelectionPageHelper.java:404)
>>
>> at
>> org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper.access$4(HiveSelectionPageHelper.java:392)
>>
>> at
>> org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper$2.widgetSelected(HiveSelectionPageHelper.java:333)
>>
>> at
>> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
>> ..........
>
>
> I hope you could understand my problems, my english isnt perfect, I am
> french, but if you could help me set this up, I would be very grateful.
>
> Thanks
>
>
  • Attachment: hivejars.png
    (Size: 34.07KB, Downloaded 98 times)
Re: Hive and Birt [message #897030 is a reply to message #897029] Fri, 20 July 2012 16:36 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

A couple of things. Make sure you are choosing Hive in the data source
type and that you restart the designer after making jar changes with the
manage drivers button. Also list your BIRT version.

Jason

On 7/20/2012 4:34 PM, Jason Weathersby wrote:
> I just tested this with those jars and the latest hadoop/hive servers
> and it worked for me. I then replaced all the jars in the manage
> drivers button with the ones attached in the screenshot and it worked as
> well. This was with hadoop 1.0.3 and hive .90 . I assume you have the
> thrift server running on your cluster?
>
> Jason
>
>
>
> On 7/20/2012 4:54 AM, Dabe Elie wrote:
>> Hello Jason, thanks for your very quick answer!
>> Let me explain you a few things I did :
>> -I started hadoop, and hive, I have on table in have, containing data, i
>> can do queries on the terminal, no problem
>> -I added all the exact same jars as written here :
>> http://www.eclipse.org/birt/phoenix/project/notable3.7.php
>> -I used the database jdbc:hive://localhost:10000/default
>>
>> I clicked on "Test connection", bu it didnt do anything, so I looked at
>> the logs and apparently here is the problem :
>>
>> Quote:
>>> !ENTRY org.eclipse.ui 4 0 2012-07-20 09:40:00.339
>>> !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:92)
>>>
>>> at
>>> org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1234)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:273)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:787)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:687)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)
>>>
>>>
>>> .....................
>>> quinox.launcher.Main.basicRun(Main.java:584)
>>> at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
>>> 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(ClassLoader.java:306)
>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
>>> ... 58 more
>>
>>
>> Seeing that, I thought maybe I needed an sl4j jar, so I added 2 jars
>> from hive:
>> -slf4j-log4j12-1.6.1.jar
>> -slf4j-api-1.6.1
>> I don't know if it is a good idea, but I thought i could try.
>> And here is the new log messages I get when I try to test the connection
>> (I still have nothing happenning when I click on "test connection")
>> Quote:
>>> !ENTRY org.eclipse.ui 4 0 2012-07-20 09:47:49.069
>>> !MESSAGE Unhandled event loop exception
>>> !STACK 0
>>> java.lang.NoClassDefFoundError: Could not initialize class
>>> org.apache.thrift.transport.TSocket
>>> at
>>> org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:92)
>>>
>>> at
>>> org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1234)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:273)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)
>>>
>>>
>>> ...............
>>> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
>>> at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
>>
>>
>> I restarted birt a few times, tried with one new jar, with two new jars,
>> and now, when I click on "Test Connection", I have a message saying :
>>
>> Quote:
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error
>>> in get connection, Could not establish connection to
>>> localhost:10000/default: java.net.ConnectException: Connection refused.
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:303)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:787)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:687)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:138)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper.testConnection(HiveSelectionPageHelper.java:404)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper.access$4(HiveSelectionPageHelper.java:392)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper$2.widgetSelected(HiveSelectionPageHelper.java:333)
>>>
>>>
>>> at
>>> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
>>>
>>> ..........
>>
>>
>> I hope you could understand my problems, my english isnt perfect, I am
>> french, but if you could help me set this up, I would be very grateful.
>>
>> Thanks
>>
>>
>
> I just tested this with those jars and the latest hadoop/hive servers
> and it worked for me. I then replaced all the jars in the manage
> drivers button with the ones attached in the screenshot and it worked as
> well. This was with hadoop 1.0.3 and hive .90 . I assume you have the
> thrift server running on your cluster?
>
> Jason
>
>
>
> On 7/20/2012 4:54 AM, Dabe Elie wrote:
>> Hello Jason, thanks for your very quick answer!
>> Let me explain you a few things I did :
>> -I started hadoop, and hive, I have on table in have, containing data, i
>> can do queries on the terminal, no problem
>> -I added all the exact same jars as written here :
>> http://www.eclipse.org/birt/phoenix/project/notable3.7.php
>> -I used the database jdbc:hive://localhost:10000/default
>>
>> I clicked on "Test connection", bu it didnt do anything, so I looked at
>> the logs and apparently here is the problem :
>>
>> Quote:
>>> !ENTRY org.eclipse.ui 4 0 2012-07-20 09:40:00.339
>>> !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:92)
>>>
>>> at
>>> org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1234)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:273)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:787)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:687)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)
>>>
>>>
>>> .....................
>>> quinox.launcher.Main.basicRun(Main.java:584)
>>> at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
>>> 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(ClassLoader.java:306)
>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
>>> ... 58 more
>>
>>
>> Seeing that, I thought maybe I needed an sl4j jar, so I added 2 jars
>> from hive:
>> -slf4j-log4j12-1.6.1.jar
>> -slf4j-api-1.6.1
>> I don't know if it is a good idea, but I thought i could try.
>> And here is the new log messages I get when I try to test the connection
>> (I still have nothing happenning when I click on "test connection")
>> Quote:
>>> !ENTRY org.eclipse.ui 4 0 2012-07-20 09:47:49.069
>>> !MESSAGE Unhandled event loop exception
>>> !STACK 0
>>> java.lang.NoClassDefFoundError: Could not initialize class
>>> org.apache.thrift.transport.TSocket
>>> at
>>> org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:92)
>>>
>>> at
>>> org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1234)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:273)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)
>>>
>>>
>>> ...............
>>> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
>>> at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
>>
>>
>> I restarted birt a few times, tried with one new jar, with two new jars,
>> and now, when I click on "Test Connection", I have a message saying :
>>
>> Quote:
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error
>>> in get connection, Could not establish connection to
>>> localhost:10000/default: java.net.ConnectException: Connection refused.
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:303)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:205)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:787)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:687)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:138)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper.testConnection(HiveSelectionPageHelper.java:404)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper.access$4(HiveSelectionPageHelper.java:392)
>>>
>>>
>>> at
>>> org.eclipse.birt.report.data.oda.hive.ui.profile.HiveSelectionPageHelper$2.widgetSelected(HiveSelectionPageHelper.java:333)
>>>
>>>
>>> at
>>> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
>>>
>>> ..........
>>
>>
>> I hope you could understand my problems, my english isnt perfect, I am
>> french, but if you could help me set this up, I would be very grateful.
>>
>> Thanks
>>
>>
>
Re: Hive and Birt [message #897037 is a reply to message #897030] Fri, 20 July 2012 17:38 Go to previous messageGo to next message
Dabe Elie is currently offline Dabe Elie
Messages: 5
Registered: July 2012
Junior Member
Hello Jason,
Thanks again for your efforts!

My birt version is 4.2.0, hive is 0.8 and hadoop in 0.20.2, maybe this is why it doesnt work, I will try with the latest versions as soon as possible!
(but the thing is, i tried with hadoop 1.0.3 and hive 0.8 but Hive told me that Hadoop had to be in version 0.20.x with x>1, but maybe they changed this with hive 0.9!)
And yes I launched the Hive server with :
hive --service hiveserver.
Can you give me precise instructions about your settings, because maybe there is something I did wrong, because I never really found clear instructions or tutorial, just the page from the birt site, and the instructions are not so detailled! Especially the hive part, is there something special to do on Hive?

Thanks!
Re: Hive and Birt [message #897040 is a reply to message #897037] Fri, 20 July 2012 18:11 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Dabe,

The original list of jars was for the hadoop .20 release. I just
updated today to test it out on my ubuntu machine. Probably the
simplest way to get it running is to collect the jars I posted (Will
depend on your version). Browse to the plugins directory of your birt
install. Locate the jdbc plugin/drivers directory. Mine is here:

C:\birt\eclipse-reporting-juno-win32\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_4.2.0.v20120611\drivers

Copy the list of jars to this folder.

Startup the BIRT designer and create a new BIRT Report Project. Then
create a new BIRT report. Add a data source. Make sure to use the Hive
data source (see attached shot). Put in the right ip for the node
running hive server and test the connection.

BTW what os are you running the designer on. Are you using CDH or
Apache Hadoop and what os are you running on?

Jason


On 7/20/2012 5:38 PM, Dabe Elie wrote:
> Hello Jason,
> Thanks again for your efforts!
>
> My birt version is 4.2.0, hive is 0.8 and hadoop in 0.20.2, maybe this
> is why it doesnt work, I will try with the latest versions as soon as
> possible!
> (but the thing is, i tried with hadoop 1.0.3 and hive 0.8 but Hive told
> me that Hadoop had to be in version 0.20.x with x>1, but maybe they
> changed this with hive 0.9!)
> And yes I launched the Hive server with : hive --service hiveserver.
> Can you give me precise instructions about your settings, because maybe
> there is something I did wrong, because I never really found clear
> instructions or tutorial, just the page from the birt site, and the
> instructions are not so detailled! Especially the hive part, is there
> something special to do on Hive?
>
> Thanks!
  • Attachment: newhive.png
    (Size: 98.20KB, Downloaded 91 times)
Re: Hive and Birt [message #897076 is a reply to message #897040] Sat, 21 July 2012 09:20 Go to previous messageGo to next message
Dabe Elie is currently offline Dabe Elie
Messages: 5
Registered: July 2012
Junior Member
Hello Jason,

I updated my Hadoop and Hive setup, now I am on 1.0.3 and 0.9.0. I am running everything (hadoop, birt, hive) on MAC OSX Lion, and not through Cloudera.
I added the exact same jars as you, I did exactly what you said but nothing works, what happens when you test the connection? What IP adress do you enter? I use localhost as I am running local, no?
Now when I click on test connection, it makes birt crash. When I don't test the connection, i click ok, then I add a new data set with the hive data source I just created, then I click next and then it tells me that the connection took to long (timeout error)...
I really don't know where the problem is. I have one hadoop cluster, with one datanode, hive is working fine, i launched the thrift server, but nothing works...maybe it's birt that is not working? Or maybe i should use CDH?

[Updated on: Sat, 21 July 2012 09:21]

Report message to a moderator

Re: Hive and Birt [message #897227 is a reply to message #897076] Mon, 23 July 2012 05:41 Go to previous messageGo to next message
Dabe Elie is currently offline Dabe Elie
Messages: 5
Registered: July 2012
Junior Member
It works!! Finally I managed to get it running!
The problem was that I launched the hive server with hive working. I mean, on the terminal, I had Hive launched, i did queries, etc, and then I launched the terminal. This time I just launched the hive server and it worked! So it was a silly thing that prevented everything from working. The only thing I want to add is that configuring the hive birt connector isnt really explained anywhere...but now it worked for me Smile

THanks again Jason for your time!
Re: Hive and Birt [message #897399 is a reply to message #897227] Mon, 23 July 2012 21:31 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

If you are using the hive default embedded db I believe this only allows
one connection. That might have been the issue.

Jason

On 7/23/2012 5:41 AM, Dabe Elie wrote:
> It works!! Finally I managed to get it running! The problem was that I
> launched the hive server with hive working. I mean, on the terminal, I
> had Hive launched, i did queries, etc, and then I launched the terminal.
> This time I just launched the hive server and it worked! So it was a
> silly thing that prevented everything from working. The only thing I
> want to add is that configuring the hive birt connector isnt really
> explained anywhere...but now it worked for me :)
>
> THanks again Jason for your time!
Previous Topic:BIRT SWT + dynamic data
Next Topic:BIRT Chart Engine Tutorial
Goto Forum:
  


Current Time: Thu Aug 28 07:18:48 EDT 2014

Powered by FUDForum. Page generated in 0.02388 seconds