Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Hive dataset : column sum(Question about Hive and the sum column)
Hive dataset : column sum [message #749432] Tue, 25 October 2011 08:08 Go to next message
Laurent Vaills is currently offline Laurent Vaills
Messages: 1
Registered: July 2009
Junior Member
Hi,

I want to use BIRT for some reporting against data stored in Hive.

I defined a simple dataset with the following query :
SELECT day, site, responsecode, sum(occurences) FROM access_logs GROUP BY day, site, responsecode .

The query runs fine in the Hive client.

However, in BIRT I have an exception : BIRT tries to get the value of the column "sum(occurences)" as a BigDecimal, unfortunately the method getBigDecimal is not implement in the Hive JDBC driver.

I tried to change the value of the output column from Decimal to Integer but BIRT still wants to get the value as a BigDecimal.

Is there any other Hive / BIRT users who have the same problem ? How do you solve it ?

Laurent
Re: Hive dataset : column sum [message #750074 is a reply to message #749432] Tue, 25 October 2011 16:04 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Laurent,

This sounds like a bug. Can you open a bugzilla entry for this?
If you select the occurences and not the sum does it work?

Jason

On 10/25/2011 4:08 AM, Laurent Vaills wrote:
> Hi,
>
> I want to use BIRT for some reporting against data stored in Hive.
>
> I defined a simple dataset with the following query :
> SELECT day, site, responsecode, sum(occurences) FROM access_logs GROUP
> BY day, site, responsecode .
>
> The query runs fine in the Hive client.
>
> However, in BIRT I have an exception : BIRT tries to get the value of
> the column "sum(occurences)" as a BigDecimal, unfortunately the method
> getBigDecimal is not implement in the Hive JDBC driver.
>
> I tried to change the value of the output column from Decimal to Integer
> but BIRT still wants to get the value as a BigDecimal.
> Is there any other Hive / BIRT users who have the same problem ? How do
> you solve it ?
>
> Laurent
>
Previous Topic:Create reportdesign with the Birt API in java
Next Topic:Viewer query parameters in Reload.rptlibrary
Goto Forum:
  


Current Time: Wed Oct 01 04:22:40 GMT 2014

Powered by FUDForum. Page generated in 0.01538 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software