Re: Question Regrading Cube Query Time

2017-03-18 Thread shailesh prajapati
Hi All, Thanks for replying. The problem has been resolved, queries are running in sub second now. Actually, i was using dimensions as "derived" instead of "normal". Thanks On Sunday, 19 March 2017 12:29 AM, Alberto Ramón wrote: Hi can you try to rebuild cube with a new measure? TopN

Re: Ozone

2017-03-18 Thread Li Yang
Thank you Alberto! Direct implementation on HDFS will be most ideal, removing all the unnecessary dependencies. However that also means Kylin will be on its own to do more storage level tasks like indexing and fast random lookup etc.. A very good option to look into. Cheers Yang On Sun, Mar 19,

Re: 问题咨询

2017-03-18 Thread Li Yang
I'm more interested on where you come from. Could you explain a bit why Kylin connecting Impala or Kudu will be beneficial? On Thu, Mar 16, 2017 at 4:04 PM, Alberto Ramón wrote: > fyi > > http://apache-kylin.74782.x6.nabble.com/Hive-server-vs- > Impala-server-td5639.html > > 2017-03-14 5:17 GMT+

Re: can't load hive table

2017-03-18 Thread Li Yang
Typically it is some env issue. The error is about Kylin expect "org.apache.hadoop.hive.ql.session.SessionState" on classpath but it is not. Check the console logs printed by "kylin.sh start" carefully. See if it catch the necessary Hive jars. On Thu, Mar 16, 2017 at 1:41 AM, nigestream wrote:

Ozone

2017-03-18 Thread Alberto Ramón
Hi I saw the PPT of Apahe Kylin 2.0 for the Haodoop Summit of Li Yang In the "What is the next" section, can be interesting for Apache Kylin, evaluate Apache Ozone (PPT of Summit 2015 Video

Re: Question Regrading Cube Query Time

2017-03-18 Thread Alberto Ramón
Hi can you try to rebuild cube with a new measure? TopN 2017-03-17 17:58 GMT+00:00 Li Yang : > You didn't mention the Kylin version. Seems to be 1.6 from the > configuration property. > > The properties related to region number are (note names are slightly > differently in 1.6): > kylin.stor

Re: wait for stpe1 : Create Intermediate Flat Hive Table

2017-03-18 Thread Alberto Ramón
@Li Yang, yes, I have an improved version in my laptop, Im adatpting to kelly (also of the other tech notes) If somebody want review fell free to said me :) 2017-03-17 18:33 GMT+00:00 Li Yang : > Thank you Alberto! Looking forward to a better kylin manual. :-) > > Yang > > On Sat, Mar 11,