Join is done transparently. Think it as a bridge that leads to the attribute on the other side. But there's no need to persist the temporary bridge in cube.
On Tue, Apr 21, 2015 at 6:02 PM, Abhishek Sinha <[email protected]> wrote: > The aggregation group picks only the attributes defined in the column name. > Should it not pick up the attribute which is defined as the join criteria > as well? > > On Tue, Apr 7, 2015 at 8:15 AM, Li Yang <[email protected]> wrote: > > > HBase KV is simple. > > > > Key is - CuboidID+D1+D2+..+Dn > > Value is - M1+M2+..+Mm > > > > On Wed, Apr 1, 2015 at 9:57 PM, Luke Han <[email protected]> wrote: > > > > > There's sample cube shipped with source code and binary package, try to > > > load it:-) > > > > > > Regards! > > > Luke Han > > > > > > _____________________________ > > > From: Abhishek Sinha <[email protected]> > > > Sent: 星期三, 四月 1, 2015 16:45 > > > Subject: Re: RowKey column and Aggregation group > > > To: <[email protected]> > > > > > > > > > Thanks. Really good explanation :)How is the cube data stored in HBase? > > > Can you consider a very small example(1Fact, 1Dim, 1Measure) and > explain > > > how the final data looks like in HBase?On Tue, Mar 31, 2015 at 5:01 PM, > > > jason zhong wrote:> BTW, only when derived column exist will add > foreign > > > key to rowkey and> aggregation group.>> On Tue, Mar 31, 2015 at 5:11 > PM, > > > jason zhong > wrote:>> > Kylin will pick up* foreign key* of lookup > > > table,and* dimension column*> > as rowkey by default.> >> > and also > add > > > these items to aggregation group ,each group has *10 items*> > at most> > > >> > > > > one relative hierarchy columns are treat as one item in aggregation> > > > group> > .> >> > e.g.> >> > We have fact table TEST_FACT with dmensions > > > *a,b,c,d,e,f,g* primary key> > on fact table is *id*> > and lookup > table > > > TEST_LOOKUP with dimensions *h,i,j,k*> >> > the rowkey item will > contain > > > *a,b,c,d,e,f,g,h,i,j,k,id*> >> > and aggregation groups will be like:> > > > > > group 1:> > a,b,c,d,e,f,g,id,h,i> > group 2:> > > j,k> > > >> > > > > the auto generate group may not be the best,so you need to adjust > > > depends> > on your own business logic.> >> >> > On Tue, Mar 31, 2015 at > > > 2:35 PM, Abhishek Sinha > > wrote:> >> >> Thanks. Good explanation :)> > > >>> > > > >> By default, Kylin picks up aggregation groups and rowkey > > automatically> > > > in> >> the advanced setting. How is that done?> >> Is aggregation group > > and > > > rowkey connected?> >>> >> On Tue, Mar 31, 2015 at 11:55 AM, Shi, > > Shaofeng > > > > wrote:> >>> >> > Aggregation groups is to reduce the cube calculation > and > > > storage; Lets> >> see> >> > a simple case:> >> >> >> > Say we have a > cube > > > has 6 dimensions:> >> >> >> > [A B C D E F] It will has 2^6 cuboids: > > 64;> > > > >> >> >> > If your query pattern is: [group by A, B, C] or [group by D, > > E, > > > F],> then> >> > you can split the 6 dimensions to two groups:> >> > [A > B > > > C], [D E F];> >> >> >> > Then Kylin will skip some cuboid like AD, AE, > > Š;> > > > >> >> >> > The total cuboid count will be 2^3 + 2^3 = 16, which is much > > > less than> >> the> >> > original 64;> >> >> >> > On 3/31/15, 1:49 PM, > > > "Abhishek Sinha" wrote:> >> >> >> > >Went through the slide. Doesn't > > give > > > much information about Advanced> >> > >Settings.> >> > >> >> > >On Tue, > > Mar > > > 31, 2015 at 9:01 AM, jason zhong >> >> > >wrote:> >> > >> >> > >> Hi > > > Abhishek,> >> > >>> >> > >> Aggregation Group is for cube > optimization,> > > >> > > > > >>> >> > >> Kylin will pick up dimension column and *fk on lookup > > table* > > > as> >> default> >> > >> rowkey and aggregation group item.> >> > >>> > >> > > > > >> you can refer> >> > >> > > > http://www.slideshare.net/YangLi43/design-cube-in-apache-kylin> >> > > >> > > > to know more about cube creation first.> >> > >>> >> > >> and for kylin > > > architecture> >> > >>> >> > >>> >> > >>> >> > >>> >> >> >>> > > > > > > http://www.slideshare.net/YangLi43/apache-kylin-deep-dive-2014-dec?next_s> > > > >> > >>lideshow=1> >> > >>> >> > >>> >> > >>> >> > >> On Mon, Mar 30, > > 2015 > > > at 2:16 PM, Abhishek Sinha <> >> [email protected]>> >> > >> > wrote:> > > > >> > >>> >> > >> > Can someone explain the following while designing > the > > > cube in> >> Kylin?> >> > >> >> >> > >> > 1. New Aggregation Groups> >> > > > > >> > > > > 2. New RowKey Column> >> > >> >> >> > >> > By default, Kylin > > > automatically picks up the some values for> RowKey> >> > >>and> >> > > >> > > > > Aggregation groups in Advanced Settings Page.> >> > >> > a) How is that > > > done?> >> > >> > b) When do we need add our own Aggregation Groups and > > > RowKey?> >> > >> > c) How is RowKey related to Aggregation Groups?> >> > > > > >> > > > > d) What does length, dictionary and mandatory indicate?> >> > >> >> > >> > > > > > > >> > --> >> > >> > Abhishek Sinha> >> > >> > Mobile: +919035191078> > >> > > > > >> > infoworks.io> >> > >> >> >> > >>> >> > >> >> > >> >> > >> >> > > >--> > > > >> > >Abhishek Sinha> >> > >Mobile: +919035191078> >> > >infoworks.io> > > >> > > > >> >> >> >>> >>> >> --> >> Abhishek Sinha> >> Mobile: +919035191078> > >> > > > infoworks.io> >>> >> >>-- Abhishek SinhaMobile: + > > 919035191078infoworks.io > > > > > > -- > Abhishek Sinha > Mobile: +919035191078 > infoworks.io >
