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 <[email protected]>:
> 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" <[email protected]> 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
>
>
