|
Re: Hive dataset : column sum [message #750074 is a reply to message #749432] |
Tue, 25 October 2011 16:04 |
|
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
>
|
|
|
Powered by
FUDForum. Page generated in 0.03489 seconds