Re: Build Erro in Step : Build Dimension Dictionary

2016-11-22 Thread Billy(Yiming) Liu
not included in the cube,just in the dimension > table. > > 在 2016年11月19日,下午7:57,Billy(Yiming) Liu <liuyiming@gmail.com> 写道: > > Please check if the step before build dimension has finished successfully. > > 2016-11-18 18:54 GMT+08:00 Mars J <xujiao.myc...@gm

Re: some confuse about Mandatory Dimensions

2016-11-16 Thread Billy(Yiming) Liu
If you set A, B, and C as mandatory dimensions, that means Kylin will save the cuboid result by grouping A, B, C internally. But that not means you could only query by grouping A, B, C. If you only query A, B. The final result will do post-aggregation by grouping the above cuboid. Same as query

Re: query hbase table data from kylin

2016-11-15 Thread Billy(Yiming) Liu
Kylin supports Hive and Kafka as data source, not HBase. As a workaround, maybe you could find some tools to transfer the data from HBase to Hive first. 2016-11-16 12:21 GMT+08:00 夏天松 : > hi kylin team, > the version of kylin is 1.5.3 > Now I want to use kylin as our data

Re: Kylin Dependencies

2016-11-02 Thread Billy(Yiming) Liu
Here is a quick start for running Kylin on docker, https://github.com/kyligence/kylin-docker >From the docker file, you could find the kylin dependencies. 2016-11-02 22:46 GMT+08:00 Alberto Ramón : > With configs ... I can try it (Will be an interesting exercise

Re: [Announce] Apache Kylin 1.5.4.1 released

2016-09-28 Thread Billy(Yiming) Liu
Thanks Shaofeng. Release is a hard work. 2016-09-28 17:34 GMT+08:00 ShaoFeng Shi : > The Apache Kylin team is pleased to announce the immediate availability of > the 1.5.4.1 release. > > This is a bug fix release based on 1.5.4; All of the changes in this > release can be

Re: [Award] Kylin won InfoWord Bossie Awards 2016, again!

2016-09-22 Thread Billy(Yiming) Liu
So cool. Congrats. 2016-09-23 11:09 GMT+08:00 Hao Chen : > Congratulation! > > Hao > > On Sep 23, 2016, at 12:35 AM, Luke Han wrote: > > Hi community, > You may already know, in the latest announced news from InfoWorld, > Apache Kylin has been

Re: group by on varchar column

2016-09-21 Thread Billy(Yiming) Liu
So, you hit this bug, https://issues.apache.org/jira/browse/KYLIN-1971 2016-09-21 19:41 GMT+08:00 Sandeep Khurana : > Found the issue, when fact and dimension have same column names on which > group by is being done then this problem occurs. I removed similar named > column

Re: Sample Cube Building Error during #4 Step Name: Build Dimension Dictionary

2016-09-21 Thread Billy(Yiming) Liu
The function initializeSerDe introduced by Hive 1.0+, it seems some old hive libraries exist in the $hive_dependency. 2016-09-21 13:47 GMT+08:00 Sunwei : > Hi all: > > I'm using *apache-kylin-1.5.4-HBase1.x-bin* with* hadoop2.6.4 Hive1.2.1 > Hbase1.1.4*. > > When i

Re: Kylin and BI Tools

2016-09-19 Thread Billy(Yiming) Liu
So cool, impressive. Thank you, Alberto. 2016-09-19 21:42 GMT+08:00 Alberto Ramón : > Hello > > This is the end of all my previous articles, about Kylin and differents > tools > With some successful and some failures :) > > >

Re: [Announce] Apache Kylin 1.5.4 released

2016-09-16 Thread Billy(Yiming) Liu
Thanks Shaofeng and our community. 2016-09-16 21:25 GMT+08:00 ShaoFeng Shi : > The Apache Kylin team is pleased to announce the immediate availability of > the 1.5.4 release. > > This is a bug fix release based on 1.5.3; All of the changes in this > release can be found

Re: How does Kylin communicate with underlying Hadoop services ?

2016-09-14 Thread Billy(Yiming) Liu
Hive is the data source, not the query engine for Kylin. Kylin is the query engine itself. The Hive command you found is the command to retrieve the data source, not user query. 2016-09-14 10:42 GMT+08:00 udana pathirana : > So basically you execute Beeline or Hive

Re: which cube to use when u build many cubes under a model

2016-09-13 Thread Billy(Yiming) Liu
Kylin has a cost-based router algorithm to find the lowest cost cube to serve the query. 2016-09-13 15:04 GMT+08:00 Mars J : > Hi , > I'm every curious about that if I define and build many cubes under > one specific model, e.g cube1,cube2,cube3, these cubes may

Re: Cassandra?

2016-09-13 Thread Billy(Yiming) Liu
https://community.mapr.com/docs/DOC-1558 There is a document introducing run Kylin on MapR. HBase is the mandatory component. 2016-09-13 14:43 GMT+08:00 Something Something : > One of my clients uses MarR distribution & they don't use HBase. We tried > using Kylin with