Eclipse Community Forums: BIRT » BigDecimal columns not showing up in chart from HIVE source

Home » Eclipse Projects » BIRT » BigDecimal columns not showing up in chart from HIVE source(HIVE as a datasource for BIRT report)

Show: Today's Messages :: Show Polls :: Message Navigator

BigDecimal columns not showing up in chart from HIVE source [message #780839]

Thu, 19 January 2012 10:01

Rod MacDonald
Messages: 4
Registered: January 2012

Junior Member

I am trying to use HIVE as a datasource for a report. I was seeing the exception
described in a bug report (bugs.eclipse.org/bugs/show_bug.cgi?id=362714).

So, I upgraded to the latest stable version of the BIRT plugin (3.7.2.v20120117).

My report is now generated, however, all of the columns of type BigDecimal are blank and I don't see any errors in the logs.

Is anyone successfully using HIVE as a datasource?

Report message to a moderator

Re: BigDecimal columns not showing up in chart from HIVE source [message #780890 is a reply to message #780839]

Thu, 19 January 2012 14:45

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Rod,

What does the data type set to in the data set editor? Look at output
columns.

Jason

On 1/19/2012 10:01 AM, Rod MacDonald wrote:
> I am trying to use HIVE as a datasource for a report. I was seeing the
> exception
> described in a bug report (bugs.eclipse.org/bugs/show_bug.cgi?id=362714).
>
> So, I upgraded to the latest stable version of the BIRT plugin
> (3.7.2.v20120117).
>
> My report is now generated, however, all of the columns of type
> BigDecimal are blank and I don't see any errors in the logs.
>
> Is anyone successfully using HIVE as a datasource?
>

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: BigDecimal columns not showing up in chart from HIVE source [message #780896 is a reply to message #780890]

Thu, 19 January 2012 15:16

Rod MacDonald
Messages: 4
Registered: January 2012

Junior Member

The columns are "Decimal".
I have hadoop-hive-0.7.1+42.9-2 installed and running on my cluster.
Thanks,
Rod

Report message to a moderator

Re: BigDecimal columns not showing up in chart from HIVE source [message #780899 is a reply to message #780896]

Thu, 19 January 2012 15:56

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

When you preview the dataset is it returning rows and the one column
just shows empty? Any chance you could deploy the report in a runtime
and set the log level to fine and post the log?

Jason

On 1/19/2012 3:16 PM, Rod MacDonald wrote:
> The columns are "Decimal".
> I have hadoop-hive-0.7.1+42.9-2 installed and running on my cluster.
> Thanks,
> Rod

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: BigDecimal columns not showing up in chart from HIVE source [message #781139 is a reply to message #780899]

Fri, 20 January 2012 11:52

Rod MacDonald
Messages: 4
Registered: January 2012

Junior Member

Sorry, the "WARNING: Method not supported" is showing up for getBigDecimal.
The org.eclipse.birt.report.data.oda.jdbc.ResultSet is being passed a
org.apache.hadoop.hive.jdbc.HiveQueryResultSet, which does not support
getBigDecimal. The "getObject" from HiveQueryResultSet returns a Long.
That appears to be the reason for my empty columns.
By adding the following to the getBigDecimal methods of org.eclipse.birt.report.data.oda.jdbc.ResultSet I am able to get results:

if (value instanceof Number) {
return new BigDecimal(((Number)value).longValue());
}

Thanks,
Rod

Report message to a moderator

Re: BigDecimal columns not showing up in chart from HIVE source [message #781150 is a reply to message #781139]

Fri, 20 January 2012 12:58

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Rod,

Thanks for the update. Any chance you could put that info in a bugzilla
entry?

Jason

On 1/20/2012 11:52 AM, Rod MacDonald wrote:
> Sorry, the "WARNING: Method not supported" is showing up for getBigDecimal.
> The org.eclipse.birt.report.data.oda.jdbc.ResultSet is being passed a
> org.apache.hadoop.hive.jdbc.HiveQueryResultSet, which does not support
> getBigDecimal. The "getObject" from HiveQueryResultSet returns a Long.
> That appears to be the reason for my empty columns.
> By adding the following to the getBigDecimal methods of
> org.eclipse.birt.report.data.oda.jdbc.ResultSet I am able to get results:
>
> if (value instanceof Number) {
> return new BigDecimal(((Number)value).longValue());
> }
>
> Thanks,
> Rod

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: BigDecimal columns not showing up in chart from HIVE source [message #781156 is a reply to message #781150]

Fri, 20 January 2012 13:21

Rod MacDonald
Messages: 4
Registered: January 2012

Junior Member

I create a bug report (bugs.eclipse.org/bugs/show_bug.cgi?id=369267)

Report message to a moderator

Re: BigDecimal columns not showing up in chart from HIVE source [message #782380 is a reply to message #781156]

Mon, 23 January 2012 11:17

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Thanks for posting this.

Jason

On 1/20/2012 1:21 PM, Rod MacDonald wrote:
> I create a bug report (bugs.eclipse.org/bugs/show_bug.cgi?id=369267)
>

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:	OSGI platform failing to start
Next Topic:	org.eclipse.birt.report.engine.api.EngineException: A BIRT exception occurred: Invalid javascript ex

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 19:39:25 EDT 2013