Re: Need Suggestion for a usecase where my hive table schema changes periodically.

[ShaoFeng Shi <sh...@apache.org>]

This is the use case of hybrid. Here is a document shared by Roberto:

https://drive.google.com/file/d/1qbvB1iONBcFMFE__SuF0ayq_l1_0vwXN/view?usp=sharing

mvneethu <ne...@tigeranalytics.com> 于2018年8月28日周二 下午7:03写道：

> Hi,
>
> I have a use case and need suggestion.
> I have a hive table where in the future there can be new dimensions added.
> Currently I have a cube on that hive table with say 10 dimensions computed.
> Now as and when the new dimensions are added (say 3 dimensions are added),
> we have to refresh with the historical data. That means, I have to rebuild
> a
> new cube again with (10 "old"+ 3 "new") 13 dimensions. I feel this will be
> inefficient process, as again in the future new dimensions can added and
> also because we will refreshing again the whole set.
>
> How to handle this type of usecase?
>
> I have few thoughts and I need your suggestion in terms of time and
> performance of building the cube.
> 1. I have cube_1 with old dimensions computed. Now I will create cube_2
> with
> the new dimensions and build for historical dataset. Then in the kylin
> query, I use these two cubes by joining and get the result.
>
> 2. Can I use hybrid concept in this case. Is it that hybrid can be used
> only
> when you don't need to refresh cube_2 with historical data?
>
> Please help.
>
> Thanks,
> Neethu
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>


-- 
Best regards,

Shaofeng Shi 史少锋

Need learning resources and small sample projects

[Asim Ali <as...@easyemployer.com>]

Hi All,
I am new in Kylin and Hadoop, and trying to learn Kylin.
Can you suggest any learning material or small examples which help me
clarify concepts and give me some practice for Kylin.
There is limited learning resources available on Kylin.
Thanks

Asim Ali
*Software Developer*

Email: asim@easyemployer.com <al...@easyemployer.com>

Phone: 1300 855 642 <1300855642>
Website: www.easyemployer.com

[image: easyemployer] <http://www.easyemployer.com/>


On Tue, 11 Sep 2018 at 16:31, ShaoFeng Shi <sh...@apache.org> wrote:

> Hi Neethu,
>
> You're correct; If need new dimension/measure be available for history
> data, then hybrid doesn't fit; You need to clone to a new Cube, add the
> dimension/measures, and then rebuild it.
>
>
> mvneethu <ne...@tigeranalytics.com> 于2018年9月11日周二 下午12:28写道：
>
> > Hi,
> >
> > Thanks for your response. But in hybrid model, it says that the cube 1
> will
> > not be built anymore and will only be queried. But in my usecase the new
> > measures and dimensions has to built for the historical period also. In
> > that
> > case, hybrid doesn't fit right? Please clarify
> >
> > Thanks,
> > Neethu
> >
> > --
> > Sent from: http://apache-kylin.74782.x6.nabble.com/
> >
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>

Re: Need Suggestion for a usecase where my hive table schema changes periodically.

[ShaoFeng Shi <sh...@apache.org>]

Hi Neethu,

You're correct; If need new dimension/measure be available for history
data, then hybrid doesn't fit; You need to clone to a new Cube, add the
dimension/measures, and then rebuild it.


mvneethu <ne...@tigeranalytics.com> 于2018年9月11日周二 下午12:28写道：

> Hi,
>
> Thanks for your response. But in hybrid model, it says that the cube 1 will
> not be built anymore and will only be queried. But in my usecase the new
> measures and dimensions has to built for the historical period also. In
> that
> case, hybrid doesn't fit right? Please clarify
>
> Thanks,
> Neethu
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>


-- 
Best regards,

Shaofeng Shi 史少锋

Re: Need Suggestion for a usecase where my hive table schema changes periodically.

[mvneethu <ne...@tigeranalytics.com>]

Hi,

Thanks for your response. But in hybrid model, it says that the cube 1 will
not be built anymore and will only be queried. But in my usecase the new
measures and dimensions has to built for the historical period also. In that
case, hybrid doesn't fit right? Please clarify

Thanks,
Neethu

--
Sent from: http://apache-kylin.74782.x6.nabble.com/