You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by hadoop n00b <ne...@gmail.com> on 2011/03/11 06:40:52 UTC

OLAP Tool for Hive

Hi,

Just curious, has anybody experience on or is aware of an OLAP tool that
works directly on Hive?

OLAP4Cloud claims that ability on HBase but I don't have much details on
that.

Cheers!

Re: OLAP Tool for Hive

Posted by hadoop n00b <ne...@gmail.com>.
Thanks for the response Joe and Austin. Will check out Pentaho and
Jasperforge.

I knew about Pentaho's integration with Hadoop on PDI but did not know if I
could create reports directly from Hive using the BI server. Will check it
out.

Cheers!

On Fri, Mar 11, 2011 at 8:47 PM, Swinney, Austin
<Au...@vimeo.com>wrote:

>  Hi hadoop n00b:
>
> Jasperforge has some connectors for Hadoop.  I have not tried them out yet
> as I am new to the JasperServer platform.  It is on my todo list.  It's
> presence on JasperForge suggests you can run it with the community edition
> of their JasperServer (and enterprise too).
>
> JasperServer: http://jasperforge.org/projects/jasperserver
>
> Jasper "Big Data" connectors:
> http://jasperforge.org/projects/bigdatareportingfornosqlandhadoop/downloads
>
> <http://jasperforge.org/projects/bigdatareportingfornosqlandhadoop/downloads>The
> Jasper Hadoop related connectors, including Hive:
> http://jasperforge.org/plugins/esp_frs/release.php?group_id=428&id=117
>
> Pentaho has Hadoop & Hive connectors, PDI connectors and whatnot:
>
> http://ci.pentaho.com/view/Data%20Integration/job/apache-hive-0.5.0/<http://ci.pentaho.com/view/Data+Integration/job/apache-hive-0.5.0/>
>
> Some info:
> http://forums.pentaho.com/showthread.php?77826-Hive-amp-Hadoop
>
> Both the JasperServer connector and the Pentaho connector might only work
> with their ETL tools, and not the OLAP tools.
>
> I'll check out OLAP4Cloud, thanks.
>
> Cheers!
>
>  On Mar 11, 2011, at 1:19 AM, Joe Andrew Key wrote:
>
>  Pentaho
>
> On 03/10/2011 09:40 PM, hadoop n00b wrote:
>
> Hi,
>
> Just curious, has anybody experience on or is aware of an OLAP tool
>
> that works directly on Hive?
>
> OLAP4Cloud claims that ability on HBase but I don't have much details
>
> on that.
>
> Cheers!
>
>
>
>

Re: OLAP Tool for Hive

Posted by "Swinney, Austin" <Au...@vimeo.com>.
Hi hadoop n00b:

Jasperforge has some connectors for Hadoop.  I have not tried them out yet as I am new to the JasperServer platform.  It is on my todo list.  It's presence on JasperForge suggests you can run it with the community edition of their JasperServer (and enterprise too).

JasperServer: http://jasperforge.org/projects/jasperserver

Jasper "Big Data" connectors: http://jasperforge.org/projects/bigdatareportingfornosqlandhadoop/downloads

<http://jasperforge.org/projects/bigdatareportingfornosqlandhadoop/downloads>The Jasper Hadoop related connectors, including Hive: http://jasperforge.org/plugins/esp_frs/release.php?group_id=428&id=117

Pentaho has Hadoop & Hive connectors, PDI connectors and whatnot:

http://ci.pentaho.com/view/Data%20Integration/job/apache-hive-0.5.0/

Some info:
http://forums.pentaho.com/showthread.php?77826-Hive-amp-Hadoop

Both the JasperServer connector and the Pentaho connector might only work with their ETL tools, and not the OLAP tools.

I'll check out OLAP4Cloud, thanks.

Cheers!

On Mar 11, 2011, at 1:19 AM, Joe Andrew Key wrote:

Pentaho

On 03/10/2011 09:40 PM, hadoop n00b wrote:
Hi,
Just curious, has anybody experience on or is aware of an OLAP tool
that works directly on Hive?
OLAP4Cloud claims that ability on HBase but I don't have much details
on that.
Cheers!



Re: OLAP Tool for Hive

Posted by Joe Andrew Key <jo...@gmail.com>.
Pentaho

On 03/10/2011 09:40 PM, hadoop n00b wrote:
> Hi,
> Just curious, has anybody experience on or is aware of an OLAP tool 
> that works directly on Hive?
> OLAP4Cloud claims that ability on HBase but I don't have much details 
> on that.
> Cheers!