Connecting kylin with JDBC, where do I know ,which cube to hit?

2018-10-22 Thread ??????
Hi All, Connecting kylin with JDBC, where do I know ,which cube to hit? kylin.log and kylin.outDid not see it.

答复: how to change columns name to lower case in kylin?

2018-10-22 Thread Francis Liang
What’s the point to do this? 发送自 Windows 10 版邮件应用 发件人: liangg...@qutoutiao.net 发送时间: Monday, October 22, 2018 2:16:36 PM 收件人: user@kylin.apache.org 主题: how to change columns name to lower case in kylin? Hi All,

Slow Query Performance With 'WHERE' Clause

2018-10-22 Thread Shrikant Bang
Hi Team, We are working on benchmark test for Kylin v2.5-Hbase-1.x as part of PoC. Here is my cube (pseudo) : *Dimension Table* : D1 *Fact Table* : F1, F2 *Metrics* : SUM(D1.m1), SUM(D2.m2) *Dimension Columns* -- Normal (D1.d1, D1.d2, D1.d3, F1.a1, F2.b1 ) JOIN (D1.d1 = F1.a1 AND D2.d2 =

how to change columns name to lower case in kylin?

2018-10-22 Thread lianggang
Hi All, We found the columns name is upper case in kylin. How to change the columns name to lower case? Pls help. Thanks!

Re: Slow Query Performance With 'WHERE' Clause

2018-10-22 Thread Shrikant Bang
Thanks ShaoFeng for response. I will try this and will update the results of my queries. I would like to learn, how to identify the bottleneck in query executions. Can we trace the query execution in each stage with timestamp? Also is there way we can get physical plan of query? This could help

Re: Connecting kylin with JDBC, where do I know ,which cube to hit?

2018-10-22 Thread ShaoFeng Shi
Here is a sample of connecting to Kylin via JDBC: https://kylin.apache.org/docs/tutorial/squirrel.html You couldn't specify which cube to hit in the SQL, but you can specify the project to query. 安卫华 <158989...@qq.com> 于2018年10月22日周一 下午4:48写道: > Hi All, > Connecting kylin with JDBC, where

kylin.log Deleted, how to restore

2018-10-22 Thread ??????
hi all: kylin.log Deleted,Logs do not write this files how to restore?

Re: Slow Query Performance With 'WHERE' Clause

2018-10-22 Thread ShaoFeng Shi
Hi Shrikant, What's the order of the dimensions in the rowkey? In this case, you need to put "d3" at the heading position of the rowkey. Here is a good reference on how to design a cube, maybe we need add that into the FAQ or as a part of document:

Re:Coprocessor passed deadline error!

2018-10-22 Thread Ma Gang
The error means the HBase coprocessor execution timeout, you need to identify why it is timeout: 1. Is the cube design not properly, so coprocessor need to scan too many rows to do runtime aggregation or can not skipped rows efficiently if the rowkey is not properly designed? 2. Is the related

?????? kylin.log Deleted, how to restore

2018-10-22 Thread ??????
Thank you very much shaofeng reply!! restart and Redeployment,Can not solve the problem! The deployment of new machines can be solved. -- -- ??: "ShaoFeng Shi"; : 2018??10??22??(??) 10:24 ??: "user"; :

Kylin Count(col) Result Is Different With Hive

2018-10-22 Thread Haitao SONG
Hi all, Run the same sql on kylin and hive, but got different result.It seems kylin has count NULL as 1, but hive count it as 0. The sql is as below: select count(fzy_bill_code) from gjst.sh_fetch_sale_base_fact where dates between '2018-09-01' and '2018-10-18' The

Re: kylin.log Deleted, how to restore

2018-10-22 Thread Billy Liu
It seems the file handler pointing to kylin.log could not be released. Please check if there is any kylin process is still there, and try to kill it and restart. With Warm regards Billy Liu 安卫华 <158989...@qq.com> 于2018年10月23日周二 上午10:12写道: > > Thank you very much shaofeng reply!! > >

Re: NPE In QueryMetricsFacade

2018-10-22 Thread ShaoFeng Shi
There is already a JIRA for this NPE: https://issues.apache.org/jira/browse/KYLIN-3609 ShaoFeng Shi 于2018年10月22日周一 上午9:08写道: > It seems the result set is null, and there is a bug which didn't handle > this situation. Would you like to report a JIRA to Kylin? > > Regarding the dashboard, have