hi, it is expected. kylin only stores aggregated results (saving all the original data is a heavy burden). for select * queries kylin choose to return the base cuboid's data. That is, select * is regarded same as "select dimA,dimB,dimC,metricX,metricY from fact group by dimA,dimB,dimC", where A,B,C is all the dimensions and metricX,metricY are all the metrics you defined.
Take Aways: kylin is good at aggregated queries, the higher the aggregation level is, the better perfomance it can deliver. On Thu, Dec 31, 2015 at 3:35 PM, Kiriti Sai <kiriti163.i...@gmail.com> wrote: > Hi, > Thank you Hongbin Ma for suggestion to upgrade. > I've just now changed the version of Kylin to 1.2 and I'm able to see some > results when I perform 'select *' on the tables. But the number of results > returned are not exactly as expected. > In my case, I have 100 rows in a table, some of which might be repeated. > But when I'm using select *, it's kind of performing group by over all the > columns in the cube and returning very few rows. > Is this behavior intended or a bug? > If the second, please let me know if there is a way to correct it. > > Thank you guys for responding quickly on new year's eve. > On Dec 31, 2015 4:04 PM, "Shi, Shaofeng" <shao...@ebay.com> wrote: > > > This “how to_upgrade” is specifically for v0.6 to v0.7 upgrade, not for > > other versions; > > > > Between v0.7 to v1.2, the metadata is compatible; What user need do is > > just backup and restore the $KYLIN_HOME/conf folder after switch to a new > > Kylin binary; All the cube metadata and cube data are in HBase so no need > > to re-create or rebuild; > > > > On 12/31/15, 2:49 PM, "250635...@qq.com" <250635...@qq.com> wrote: > > > > >Have you checked out this one ? > > >http://kylin.apache.org/docs/howto/howto_upgrade.html > > > > > > > > > > > > > > >250635...@qq.com > > > > > >From: Kiriti Sai > > >Date: 2015-12-31 14:36 > > >To: dev > > >Subject: Re: Select * not returning any rows > > >Since I'm just working with binaries, can you please explain how to > > >upgrade > > >from v1.1 to v1.2? > > >Should I just extract and replace the whole folder or should I backup > and > > >restore the data also in some way? > > > > > >Thank you for the immediate response. :) > > >On Dec 31, 2015 3:25 PM, "hongbin ma" <mahong...@apache.org> wrote: > > > > > >> i believe this issue has been fixed in v1.2, why not use the latest > > >> version? > > >> > > >> > > >> -- > > >> Regards, > > >> > > >> *Bin Mahone | 马洪宾* > > >> Apache Kylin: http://kylin.io > > >> Github: https://github.com/binmahone > > >> > > > > > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
