|
Re: BigDecimal columns not showing up in chart from HIVE source [message #780890 is a reply to message #780839] |
Thu, 19 January 2012 19:45 |
|
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?
>
|
|
|
|
Re: BigDecimal columns not showing up in chart from HIVE source [message #780899 is a reply to message #780896] |
Thu, 19 January 2012 20:56 |
|
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
|
|
|
|
Re: BigDecimal columns not showing up in chart from HIVE source [message #781150 is a reply to message #781139] |
Fri, 20 January 2012 17:58 |
|
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
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.05465 seconds