You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by John Skillings <js...@gmail.com> on 2015/04/21 19:54:49 UTC

Alternative to Hive

Hi all,

We have large Oracle based OLAP data warehouse (star schema), and I was
wondering if it is possible to connect Kylin to our existing data warehouse
instead of using Hive.

Is this possible and if so, any guidance is appreciated.

Best,

John

Re: Alternative to Hive

Posted by Luke Han <lu...@gmail.com>.
Hi John,
    There are two options:
     #1, copy your data to Hive and then build cube through Kylin. There
are some cases are running this model to bring data into Hive from DW and
leveraging Kylin very well.
     #2, rewrite  data read module to pull data from Oracle directly.
Actually, the first step of cube build is generate Hive Query to read data
and generate one temp table in Hive, so it should be not too complicated to
do this (but it depends network and others, otherwise, #1 will be more
efficient one). Then process cube build as normal.

     Please let's know if you have interesting about this, we could bring
it into our further roadmap, and, if you also could like to contribute, it
will be perfect:)

    Thanks.



Best Regards!
---------------------

Luke Han

2015-04-22 4:02 GMT+08:00 Adunuthula, Seshu <sa...@ebay.com>:

> John,
>
> Unfortunately not possible as the product exists today, but the beauty of
> Open source, if you have development resources that can contribute to the
> Project, the Hive based Cube build/refreshes can be extended to Oracle
> Star Schema as well.
>
> Please do go ahead and file a JIRA at
> https://issues.apache.org/jira/browse/KYLIN/
>
>
> Regards
> Seshu Adunuthula
>
>
> On 4/21/15, 10:54 AM, "John Skillings" <js...@gmail.com> wrote:
>
> >Hi all,
> >
> >We have large Oracle based OLAP data warehouse (star schema), and I was
> >wondering if it is possible to connect Kylin to our existing data
> >warehouse
> >instead of using Hive.
> >
> >Is this possible and if so, any guidance is appreciated.
> >
> >Best,
> >
> >John
>
>

Re: Alternative to Hive

Posted by "Adunuthula, Seshu" <sa...@ebay.com>.
John,

Unfortunately not possible as the product exists today, but the beauty of
Open source, if you have development resources that can contribute to the
Project, the Hive based Cube build/refreshes can be extended to Oracle
Star Schema as well.

Please do go ahead and file a JIRA at
https://issues.apache.org/jira/browse/KYLIN/


Regards
Seshu Adunuthula


On 4/21/15, 10:54 AM, "John Skillings" <js...@gmail.com> wrote:

>Hi all,
>
>We have large Oracle based OLAP data warehouse (star schema), and I was
>wondering if it is possible to connect Kylin to our existing data
>warehouse
>instead of using Hive.
>
>Is this possible and if so, any guidance is appreciated.
>
>Best,
>
>John