The coprocessor thread stopped itself due to scan timeout or scan threshold(check region server log)

2016-11-01 Thread ????????
Hi my Kylin version is 1.5.4.1 for CDH5.7/5.8 when I query in kylin, it return a error like {cellset: null, rowTotalsLists: null, colTotalsLists: null, runtime: null,??}cellset:nullcolTotalsLists:nullerror:"IOException: org.apache.commons.httpclient.methods.PostMethod@4d54f318 failed,

Re: 13 Step Name: Load HFile to HBase Table

2016-11-01 Thread mnagy
This folder is empty /kylin/kylin_metadata/kylin-1ee8b8f5-6708-43db-8285-e70b9181ca79/fact_smpl_big_cube/hfile/F1/ what could cause that ? -- View this message in context: http://apache-kylin.74782.x6.nabble.com/13-Step-Name-Load-HFile-to-HBase-Table-tp6144p6148.html Sent from the Apache Kylin

[jira] [Created] (KYLIN-2148) ActiveMq server not responding after some time

2016-11-01 Thread Vidya Sagar D (JIRA)
Vidya Sagar D created KYLIN-2148: Summary: ActiveMq server not responding after some time Key: KYLIN-2148 URL: https://issues.apache.org/jira/browse/KYLIN-2148 Project: Kylin Issue Type: Bug

[jira] [Created] (KYLIN-2147) Move the creation of HTable after cube be built

2016-11-01 Thread Shaofeng SHI (JIRA)
Shaofeng SHI created KYLIN-2147: --- Summary: Move the creation of HTable after cube be built Key: KYLIN-2147 URL: https://issues.apache.org/jira/browse/KYLIN-2147 Project: Kylin Issue Type: Impro

Re: 13 Step Name: Load HFile to HBase Table

2016-11-01 Thread mnagy
I am using. kylin 1.6 ubuntu 14.04 hbase 1.1.1 hive 1.2 -- View this message in context: http://apache-kylin.74782.x6.nabble.com/13-Step-Name-Load-HFile-to-HBase-Table-tp6144p6145.html Sent from the Apache Kylin mailing list archive at Nabble.com.

13 Step Name: Load HFile to HBase Table

2016-11-01 Thread mnagy
I am facing this issue when I try to build a cube. Any ideas about what is going on ? java.io.IOException: BulkLoad encountered an unrecoverable problem at org.apache.hadoop.hbase.mapreduce.LoadIncrementalHFiles.bulkLoadPhase(LoadIncrementalHFiles.java:510) at org.apache.hadoop.hba

回复: Exceed scan threshold at 10000001

2016-11-01 Thread 张磊
Hi shaofeng I read this article, but i also do not know why limit 10001 should scan 10,000,001 more rows? Does not pre-calculate? when do pre-calculate,it should scan 10001 rows. limit 1 and 10001 should be the same? I only want test the kylin and want to konw the theory of the Kylin. I

[jira] [Created] (KYLIN-2146) "Streaming Cluster" page should remove "Margin" inputbox

2016-11-01 Thread Shaofeng SHI (JIRA)
Shaofeng SHI created KYLIN-2146: --- Summary: "Streaming Cluster" page should remove "Margin" inputbox Key: KYLIN-2146 URL: https://issues.apache.org/jira/browse/KYLIN-2146 Project: Kylin Issue Ty

答复: How to filter dimension from look-up table

2016-11-01 Thread 万里通科技及数据中心商务智能团队数据分析组
Hi shaofeng, In recently version,1.5.3, kylin support it, I can put dimension from look-up table into Filter on Data Model's "setting" page, but cube ran error when built at step 1 or step 2, telling us it can't find the dimension ,such as " invalid table alias or column reference". Afte

Re: Unable to connect to Kylin Web UI

2016-11-01 Thread BigdataGR
Thank you so much. I got it. I am able to login kylin now. -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Unable-to-connect-to-Kylin-Web-UI-tp6036p6140.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: How to filter dimension from look-up table

2016-11-01 Thread ShaoFeng Shi
hi zhihua, "can only put dimensions from fact table into filter fields": do you mean the "Filter" attribute on Data Model's "setting" page? It can support look-up table I think. Can you provide a sample? 2016-11-01 16:30 GMT+08:00 胡志华(万里通科技及数据中心商务智能团队数据分析组) < huzhihua...@pingan.com.cn>: > Hi all

Re: Exceed scan threshold at 10000001

2016-11-01 Thread ShaoFeng Shi
Hi Lei, When you create the cube, in the "Advanced settings" step, the rowkey is composed by the dimension columns; The sequence can be adjusted by drag & drop; Usually we suggest to move the columns that used as filter (in "where" condition") be ahead of other columns, so they can be used to narr

Re: Exceed scan threshold at 10000001

2016-11-01 Thread Alberto Ramón
Sorry, The pictures can't arrive you OK See this: http://www.slideshare.net/HBaseCon/apache-kylins-performance-boost-from-apache-hbase#9 2016-11-01 7:52 GMT+01:00 张磊 <121762...@qq.com>: > You say Kylin is "smart" when compose Hbase Row Key, there is something i > can not see. Could you send agai

[jira] [Created] (KYLIN-2145) StorageCleanupJob will fail when beeline enabled

2016-11-01 Thread hongbin ma (JIRA)
hongbin ma created KYLIN-2145: - Summary: StorageCleanupJob will fail when beeline enabled Key: KYLIN-2145 URL: https://issues.apache.org/jira/browse/KYLIN-2145 Project: Kylin Issue Type: Bug

[jira] [Created] (KYLIN-2144) move useful operation tools to org.apache.kylin.tool

2016-11-01 Thread hongbin ma (JIRA)
hongbin ma created KYLIN-2144: - Summary: move useful operation tools to org.apache.kylin.tool Key: KYLIN-2144 URL: https://issues.apache.org/jira/browse/KYLIN-2144 Project: Kylin Issue Type: Impr

How to filter dimension from look-up table

2016-11-01 Thread 万里通科技及数据中心商务智能团队数据分析组
Hi all, Our analyst are faced a problem. When she built a cube, she wanted to filter dimensions from look-up table. But KYLIN don’t let it, we can only put dimensions from fact table into filter fields. Therefore I can only set dimensions from look-up table which I want to filter as manda

[jira] [Created] (KYLIN-2143) allow more options from Extended Columns,COUNT_DISTINCT,RAW_TABLE

2016-11-01 Thread Zhong,Jason (JIRA)
Zhong,Jason created KYLIN-2143: -- Summary: allow more options from Extended Columns,COUNT_DISTINCT,RAW_TABLE Key: KYLIN-2143 URL: https://issues.apache.org/jira/browse/KYLIN-2143 Project: Kylin