|Re: Hive dataset : column sum [message #750074 is a reply to message #749432]
||Tue, 25 October 2011 16:04
| Jason Weathersby
Registered: July 2009
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?
On 10/25/2011 4:08 AM, Laurent Vaills wrote:
> 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 ?
Powered by FUDForum
. Page generated in 0.13841 seconds