Manager employee hierarchy in Kylin

Hello I am plannning to implement Manager - Employee Hierarchy in Dimension table and join with the fact table similarly its been explain in following link http://brazenly.blogspot.com/2015/02/datawarehouse-dimensional-modeling.html So far, I am unable to achieve. How do I achieve? If no

Re: Manager employee hierarchy in Kylin

– All hierarchy >> needs to be do that. >> >> >> >> Regards, >> >> Manoj >> >> >> >> *From:* deva namaste [mailtoohd...@gmail.com] >> *Sent:* Thursday, February 01, 2018 9:07 PM >> *To:* user@kylin.apache.org >> *Su

Re: Manager employee hierarchy in Kylin

<manoj.h.ku...@jpmorgan.com> wrote: > One Employee – Manager1-manager2-manager3 – It will be like that.. It > depends upon data set > > > > Write the code for flattening out for per employee – in that case, > employee code wont be repeated.. > > > > Regards,

Apache Kylin examples with apache ranger

Hello, I plan to use Apache Ranger for fine grained security for Apache Kylin. Anyone please point me to any demo (not just plugin install but actual query accessed data) or blog link which has examples? Thanks Deva

Re: Date with hhmi

with substr function). Then use this > view as the fact table in Kylin cube. > > 2018-07-30 4:08 GMT+08:00 deva namaste : > >> Hello friends, Any idea? Thanks >> >> On Fri, Jul 27, 2018 at 3:58 PM, deva namaste wrote: >> >>> Hello, >>> >&g

Re: Date with hhmi

Hello friends, Any idea? Thanks On Fri, Jul 27, 2018 at 3:58 PM, deva namaste wrote: > Hello, > > I do have fact table with date column where dates are in this format > "-MM-DD" ( e.g. 2016-01-01). The same fact table is joined with date > dimension

Re: Date with hhmi

Thanks ShaoFeng. Deva On Mon, Jul 30, 2018 at 11:14 PM, ShaoFeng Shi wrote: > Hi Deva, > > There is a blog in Chinese about using Hive view for Kylin: > https://www.cnblogs.com/hark0623/p/5584922.html > > You can try it with Google translate :-) > > 2018-07-31 2:3

Re: Get daily average for periodic readings

> - as extra: Kylin can't use partition format columns on weeks, the > minimum es days > > Alb > > On 28 February 2018 at 21:51, deva namaste <ohd...@gmail.com> wrote: > >> Hello, >> >> How would I calculate value for a week while I have bi-

Re: Get daily average for periodic readings

> > Alb > > On 28 February 2018 at 22:59, deva namaste <ohd...@gmail.com> wrote: > >> I was thinking of saving only 6 records in kylin instead of splitting >> them outside in daily avg and adding 365 records for each item. So is >> there anyway I can ach

Re: v 2.3 Storage Engine (id=0) is not supported error

I able to correct the issue by deleting intermediate files. http://kylin.apache.org/docs23/howto/howto_cleanup_storage.html On Tue, Mar 6, 2018 at 10:46 AM, deva namaste <ohd...@gmail.com> wrote: > > > > After I upgrade to latest release I am getting following error - > >

Re: [Announce] Apache Kylin 2.3.0 released

I able to correct the issue by deleting intermediate files. http://kylin.apache.org/docs23/howto/howto_cleanup_storage.html On Tue, Mar 6, 2018 at 11:18 AM, deva namaste <ohd...@gmail.com> wrote: > Thanks Billy. > > After I upgrade to 2.3 I am getting

Re: RAW Measure kylin 2.3

to disable RAW from UI > > On 6 Mar 2018 1:38 p.m., "deva namaste" <ohd...@gmail.com> wrote: > >> Hello, >> >> I do not see RAW measure after I upgraded to kylin version 2.3. >> >> Any other alternative measure we should use to show the raw dat

v 2.3 Storage Engine (id=0) is not supported error

After I upgrade to latest release I am getting following error - 2018-03-06 09:43:04,607 ERROR [http-bio-7070-exec-9] controller.BasicController:61 : org.apache.kylin.rest.exception.InternalErrorException: Storage Engine (id=0) is not supported any more while executing SQL: "select * from

Re: Get daily average for periodic readings

latencies (= there is no difference >>> between sum one int or 365, I thought the same when I started with >>> Kylin) >>> - The YY-MM-WW, is not implemented, but can be nice if you can >>> contribute to it >>> >>> Alb >>> >>> On 28 F

RAW Measure kylin 2.3

Hello, I do not see RAW measure after I upgraded to kylin version 2.3. Any other alternative measure we should use to show the raw data as is? (Instead of RAW measure, any other alternative which can be used?) Thanks Deva

Failed to find metadata store by url: kylin_metadata@hbase

Hi, I am getting following error when I try to start Kylin using ./kylin.sh start command in HDP environment. It does not even create or update kylin.log file. Can someone could help me. Really appreciated. 2018-06-27 18:58:27,670 INFO [main] zookeeper.ZooKeeper:100 : Client

Re: Failed to find metadata store by url: kylin_metadata@hbase

8:00 我的神啊 <1609749...@qq.com>: > >> Hi: >> >> Did you run the bin/check-env.sh to make sure your environment such Hbase >> is ready? >> >> >> -- 原始邮件 -- >> *发件人:* "deva namaste"; >> *发送时

installation error - log4j.properties is not found. HADOOP_CONF_DIR may be incomplete.

Hello, I installed Kylin version 2.5 "apache-kylin-2.5.0-bin-hbase1x" on HDP version 3.0, which is red hat linux platform. I installed and configured Kylin. But when I start ./kylin.sh start, I am getting error - KYLIN_HOME is set to /opt/apache-kylin-2.5.0-bin-hbase1x WARNING: log4j.properties

Ranger Plugin Destination

Where should I find the Kylin plugin with Ranger? Can someone please provide me download destination? Thanks

Unsubscribe

Sent from my iPhone > On Nov 24, 2020, at 8:47 AM, dan young wrote: > >