Re: About how to unsubscribe mailing list

il number of the > mailing lists. I think mail should be the first contact channel to share > our ideas, use cases, troubleshooting questions. And English is the > preferred language, for this is a global community. > > --------- > > Best regards, > > > > Ni Chunen / George > > -- Regards, Hongbin Ma

Re: IN_THRESHOLD

and FYI, the size of IN_THRESHOLD is configurable after https://issues.apache.org/jira/browse/KYLIN-2193 On Mon, Nov 21, 2016 at 4:35 PM, Alberto Ramón wrote: > very very clear, > thanks ¡¡ > > 2016-11-18 4:16 GMT+01:00 Li Yang : > >> For filter on derived column, it has to translate into a filt

Re: Most Used BI Tools

nice stuff! On Mon, Nov 7, 2016 at 1:09 AM, Alberto Ramón wrote: > fyi: > > https://image-store.slidesharecdn.com/0d3c9706- > b8a6-4716-afc1-26beb82c8704-large.png > -- Regards, *Bin Mahone | 马洪宾*

Re: kylin-1.5.4同步hive元数据报错

cannot reproduce either when you run kylin.sh, there will be stdout telling the extracted hive/hbase dependency paths, can you attach them for further analysis? On Tue, Sep 20, 2016 at 10:51 AM, Li Yang wrote: > We may not be able to reproduce the problem (at least I cannot). Both 1.5.4 > and 1

Re: Kylin ODBC

Hi Alberto the observed error: *[INFO ][2016-09-14.06:48:47]select "PART_DT", * *"LEAF_CATEG_ID", * *"LSTG_SITE_ID", * *"LSTG_FORMAT_NAME", * *"PRICE", * *"SELLER_ID" * *from "DEFAULT"."KYLIN_SALES"* *[ERROR][2016-09-14.06:49:53]The REST query request failed, the error message

Re: kylin-1.5.3版本页面登录报错

actually when I fixed KYLIN-1963, I wasn't fixing the described issue here. Anyway it's glad to see the issue does not appear in 1.5.4 On Fri, Sep 16, 2016 at 10:10 PM, ShaoFeng Shi wrote: > today on a new environment (EMR) with Kylin 1.5.3, I also encounter > this " class > path resource [kylin

Re: [Announce] Apache Kylin 1.5.4 released

thanks shaofeng! On Fri, Sep 16, 2016 at 10:34 PM, Billy(Yiming) Liu wrote: > 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 bas

Re: Metadata II

​is sisense using ODBC to connect with Kylin? will the query work in kylin's web GUI?​ On Mon, Sep 5, 2016 at 12:45 AM, Alberto Ramón wrote: > Hello > > I'm testing Sisense Software , and saw similar > integration-problem like with other vendors with "get Metadata" > >

Re: KYLIN-1656

​@shaofeng any insights?​ On Wed, Aug 3, 2016 at 9:56 AM, Joel Victor wrote: > ld think about making this feature optional (A per cube config until we > find a better solution). This feature is useful when data sets are really > large, the size of the distinct count step contributes much more to

Re: how to optimize kylin query

how many results are being returned for the slow queries? can you attach kylin.log under KYLIN_HOME/logs? On Fri, Sep 2, 2016 at 7:17 PM, Mars J wrote: > Hi , > How can I optimize my kylin query ? > > Cluster env. : Our cluster has 5 nodes for 1 master and 4 slaves, the > hadoop cluster

Re: fail Build Dimension Dictionary

can you pastebin the cube desc and the look up table's hive schema? On Wed, Aug 24, 2016 at 3:17 PM, Yiming Liu wrote: > Please double check the cube definition which is a json file. > > 2016-08-24 15:13 GMT+08:00 Jose Raul Perez Rodriguez < > joseraul.w...@gmail.com>: > >> Yes, seems logical, b

Re: Use Apache HUE with Kylin

​thanks Alberto!​ -- Regards, *Bin Mahone | 马洪宾*

Re: Tableau & Kylin Manual

thanks @shaofeng @​Alberto thanks for your suggestions, we can definitely improve on documents:) -- Regards, *Bin Mahone | 马洪宾*

Re: Tableau & Kylin Manual

​It's awesome! can we repost it to our blog http://kylin.apache.org/blog/? do you have any concerns? @Alberto​ On Thu, Aug 4, 2016 at 8:35 AM, Yiming Liu wrote: > Thanks, Alberto, great contribution. > > Very useful. > > 2016-08-04 7:46 GMT+08:00 Alberto Ramón : > >> Hello >> >> I wrote an exam

Re: Query server occupy memory too high

after you run such query, check out the KYLIN_HOME/logs/kylin.log, there should be snippet like: 2016-08-04 00:48:31,990 INFO [http-bio-7070-exec-7] service.QueryService:399 : Scan count for each storageContext: 12306477, 2016-08-04 00:48:31,991 INFO [http-bio-7070-exec-7] controller.QueryContro

Re: Coprocesor

​currently kylin will by default use coprocessor. if you could share why you worry about it we can better answer your question​ -- Regards, *Bin Mahone | 马洪宾*

Re: cube query error in Cuboid.translateToValidCuboid

someone reported similar issues in https://issues.apache.org/jira/browse/KYLIN-1785, but we cannot reproduce it. can you please provide your cube desc to us? If that's sensitive, can you please try to reproduce the issue with the sample cube in Kylin? On Thu, Aug 4, 2016 at 4:25 PM, 赵天烁 wrote: >

Re: Re: Scan row count exceeded threshold

Hi Tiansheng and Tianshuo Kylin is basically limiting the footprint on storage visit, the size of each row is inversely proportional to the number of rows to be read. The cuboid row size grows when there's a distinct count measure, so you're observing threshold being 49121, this is normal. The u

Re: Kylin auto refresh is not working

hi alberto 1892 and 774 are not same thing. 1892 is same as https://issues.apache.org/jira/browse/KYLIN-1864 On Thu, Jul 28, 2016 at 3:57 PM, Alberto Ramón wrote: > Kylin 1892 its same that 774 ?? > > https://issues.apache.org/jira/browse/KYLIN-1892 > https://issues.apache.org/jira/browse/KYLIN

Re: 1.5.0 版本 Aggregation Groups 疑惑

http://kylin.apache.org/blog/2016/02/18/new-aggregation-group/ 2016-07-25 10:44 GMT+08:00 热爱大发挥 <385639...@qq.com>: > 对于Aggregation Groups 一直有些疑惑: > includes: 组合的维度 如果选择A,B,C 将会组成 group by (A,B,C)? > Mandatory Dimensions: 强制字段 ? 啥意思 > Hierarchy Dimensions:基于includes的字段的下层计算 > > 假设有如下设计: > i

Re: Re: Re: Process hang up during buiding cube on kylin?

​seems yarn cannot allocate enough containers. what's your yarn config? can you increase resources?​ if you're using a hdp or cdh sandbox, try to give it more than 8G RAM On Mon, Jul 25, 2016 at 10:08 AM, GuoGuo wrote: > 2.app.rm.RMContainerAllocator: Recalculating schedule, headroom= vCores:0>2

Re: Re: Process hang up during buiding cube on kylin?

​Skipping is normal as it reflects switching from layered cubing to fast cubing. There's a icon in "Build Cube" step linking to the hadoop job status, you should checkout that​ -- Regards, *Bin Mahone | 马洪宾*

Re: Process hang up during buiding cube on kylin?

​the picture does not display if you want to use picture attachments you'd better use http://apache-spark-user-list.1001560.n3.nabble.com/ to post. BTW can you attach yarn logs for the hanging job/mappers/reducers? On Sun, Jul 24, 2016 at 6:33 PM, GuoGuo wrote: > ong time for me to wait during

Re: How Kylin use bitmap to calculte the cardinality of non-integer field?

the original JIRA for global dict is https://issues.apache.org/jira/browse/KYLIN-1705, now it's pending on GUI part https://issues.apache.org/jira/browse/KYLIN-1904 On Tue, Jul 19, 2016 at 2:01 PM, big data wrote: > Thank you ,Sun. I'm still downloading the code, so I first browse the > articles

Re: Model Designer Dimensions

hi shaofeng can you attach the JIAR here, too?

Re: Model Designer Dimensions

I got it, it's KYLIN-1838 On Fri, Jul 1, 2016 at 6:43 PM, hongbin ma wrote: > hi shaofeng > > can you attach the JIAR here, too? > -- Regards, *Bin Mahone | 马洪宾*

Re: Support for weighted mean & median.

we don't have such plan yet. As a workaround you can create a hive view with an additional column for cnt * val, and use the view as fact table in your cube On Fri, Jul 1, 2016 at 1:06 PM, Joel Victor wrote: > Hi, > > I have a fact table with two measure columns one is cnt and other is val > wit

Re: Question about query sample cube table KYLIN_SALES

On Tue, Jun 14, 2016 at 12:08 PM, lxw wrote: > got a problem about query samle cube table "KYLIN_SALES" > The cube SQL is : > > SELECT > KYLIN_SALES.PART_DT > ,KYLIN_SALES.LEAF_CATEG_ID > ,KYLIN_SALES.LSTG_SITE_ID > ,KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME > ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL

Re: Support Hive View as Lookup Table

@xianbin can you take a look? On Thu, Jun 16, 2016 at 5:16 AM, Bhanu Mohanty wrote: > Getting error at Build Dimension Dictionary > java.io.IOException: > NoSuchObjectException(message:DEFAULT.kylin_intermediate_DEFAULT_ > > On Wed, Jun 15, 2016 at 2:14 PM, Bhanu Mohanty > wrote: > >> I am

Re: An open source data visualization tool for Kylin -- Based on Caravel

looks nice! On Mon, Jun 13, 2016 at 11:05 AM, lxw wrote: > Hi,All : > >This is an open source data visualization tool for Kylin (also support > some other DataSources like MySQL、ORACLE、Druid etc.) , > I hope you can try and discuss it , and find some issues. > > https://github.com/rocky1001/

Re: How to set timzezone to UTC+8

Is it UCT or UTC? On Sat, Jun 4, 2016 at 9:16 AM, 王晓雨 wrote: > You can try to set the property in the $KYLIN_HOME/conf/kylin.properties > and restart the kylin server. > kylin.rest.timezone=UCT+8 > > > 在 2016年6月3日，12:04，Sun 写道： > > > > Current timezone is PST ,how to set timzezone to UTC+8 ? t

Re: Blog to introduce the Diagnosis Tool

cool! hope it could help people more from the community :) On Sun, Jun 12, 2016 at 11:37 AM, Dong Li wrote: > Hello community, > > > I wrote a blog about the Diagnosis functionality introduced since 1.5.2. > > http://kylin.apache.org/blog/2016/06/10/diagnosis-tool/ > > > Please have a view if yo

Re: kylin.properties中文配置乱码

https://issues.apache.org/jira/browse/KYLIN 2016-06-12 11:37 GMT+08:00 hongbin ma : > can you please open a jira and submit a patch? > > 2016-06-12 11:29 GMT+08:00 赵天烁 : > >> 如果在kylin的ldap.user.searchPattern中需要包含中文的过滤条件，则实际执行的时候会出现乱码问题。我现在是通过修改 >> KylinConfi

Re: kylin.properties中文配置乱码

can you please open a jira and submit a patch? 2016-06-12 11:29 GMT+08:00 赵天烁 : > 如果在kylin的ldap.user.searchPattern中需要包含中文的过滤条件，则实际执行的时候会出现乱码问题。我现在是通过修改 > KylinConfig，将加载properties文件的代码改为使用inputstreamReader，在reader的参数中指定utf-8来解决： > > File cfile = new File(KylinConfig.getKylinHome() + "/conf/" + >

Re: Create model and cube using rest api

take a look at CubeController#saveCubeDesc, you can use the API directly however without the frontend wizard, your program needs to keep the request in a valid format. Otherwise cube save will fail. On Tue, May 17, 2016 at 9:55 PM, Orval TOUITOU < orval.toui...@iut-dijon.u-bourgogne.fr> wrote: >

Re: kylin.cube.aggrgroup.max.combination setting

Hi Mars please don't increase kylin.cube.aggrgroup.max.combination to a huge number to address the issue. kylin.cube.aggrgroup.max.combination is to prevent a cube from having too many combinations(cuboids), which might lead to a hard time for cube building. You're suggested to take a look at how

Re: The monitor web page cannot load jobs

suggest to update to 1.5.1 1.5.1 metadata is compatible with 1.5.1 On Sun, May 15, 2016 at 8:55 PM, Li Yang wrote: > Try refresh kylin metadata from "Admin" tab, or restart Kylin. If the > problem persists and you can reproduce stably, open a JIRA. > > On Sat, May 14, 2016 at 11:37 AM, jyzheng

Re: Fw: Re: NullPointerException in .CubeHBaseEndpointRPC$1.run

I checked the code throwing the exception: https://github.com/apache/kylin/blob/kylin-1.5.1/storage-hbase/src/main/java/org/apache/kylin/storage/hbase/cube/v2/CubeHBaseEndpointRPC.java#L326 seems nothing will be null here... On Wed, May 4, 2016 at 1:29 PM, lidong wrote: > > > Thanks, > Dong >

Re: why I got nothing when I select from KYLIN_SALES

however I'm still confused why the issue is related to history server? can you please share some insights with us? On Wed, May 4, 2016 at 1:04 PM, kevin wrote: > I dound the reason is : the hadoop historyserver need to be started! > > 2016-05-04 11:05 GMT+08:00 Dong Li : > > > Hi Kevin, > > > >

[ANNOUNCE] Apache Kylin 1.3.0 released

The Apache Kylin team is pleased to announce the immediate availability of the 1.3.0 release. The release note can be found here [1]; The source code and binary package can be downloaded from Kylin's download page [2]. The Apache Kylin Team would like to hear from you and welcomes your comments an

Re: Powered By page has been updated

​let's keep the list growing!​ On Fri, Dec 11, 2015 at 5:48 PM, Li Yang wrote: > Looks cool~ > > On Thu, Dec 3, 2015 at 10:26 PM, Luke Han wrote: > > > URL: http://kylin.apache.org/community/poweredby.html > > > > > > Best Regards! > > - > > > > Luke Han > > > > On Thu, Dec

Re: The Apache Software Foundation Announces Apache™ Kylin™ as a Top-Level Project

​cheers!​ On Thu, Dec 10, 2015 at 5:21 PM, Hao Chen wrote: > Congrats, Apache™ Kylin™ > > -- > > Hao > > > On Thu, Dec 10, 2015 at 4:09 PM, Li Yang wrote: > > > Cheers! > > > > On Wed, Dec 9, 2015 at 12:13 PM, Xiaoyu Wang wrote: > > > >> Congratulations! > >> > >> > >> 在 2015年12月09日 11:22, Abh