Can I set a none date integer as partition column value to build the kylin cube?

2017-03-10 Thread JunxiangHe
Hi, I have two table. The date time join table, DTID is the primary key DTID YEAR MONTH DAY HOUR 745 2017 2 1 0 746 2017 2 1 1 747 2017 2 1 2 The fact table, DTID is FK and partition column DTID USERID Click Count 745 1 2 745 2 1 746 1 2 747 2

[jira] [Created] (KYLIN-2501) Stream Aggregate GTRecords at Query Server

2017-03-10 Thread Dayue Gao (JIRA)
Dayue Gao created KYLIN-2501: Summary: Stream Aggregate GTRecords at Query Server Key: KYLIN-2501 URL: https://issues.apache.org/jira/browse/KYLIN-2501 Project: Kylin Issue Type: Improvement

Re: count(distinct case when condittion) &count(distinct) return same result

2017-03-10 Thread Li Yang
The behavior resembles KYLIN-2341. Still worth a new JIRA to track. https://issues.apache.org/jira/browse/KYLIN-2500 On Thu, Mar 9, 2017 at 2:48 PM, Roy wrote: > Hi there, > > Use kylin insight submit below sentence, > --select > sentence

[jira] [Created] (KYLIN-2500) count(distinct case when condittion) gives incorrect result

2017-03-10 Thread liyang (JIRA)
liyang created KYLIN-2500: - Summary: count(distinct case when condittion) gives incorrect result Key: KYLIN-2500 URL: https://issues.apache.org/jira/browse/KYLIN-2500 Project: Kylin Issue Type: Bug

Re: 3 Issues when I tried sample cube creation with Apache Kylin

2017-03-10 Thread Li Yang
> Exception in thread "Thread-8" java.lang.RuntimeException: > java.lang.IllegalStateException: Cannot start job scheduler due to lack of job lock There must be another Kylin process still running and holding the lock of metadata. Find it, kill it, and try again. On Sun, Mar 5, 2017 at 10:03 PM,

Re: wait for stpe1 : Create Intermediate Flat Hive Table

2017-03-10 Thread Alberto Ramón
try to use ORC format in Hive with compression, the result: https://github.com/albertoRamon/Kylin/raw/master/KylinPerformance/Images/08.png (My apologies, I'm in process to improve these notes and put un kylin manual) Also partition fact table: http://kylin.apache.org/docs16/howto/howto_optimize_b

[jira] [Created] (KYLIN-2499) HybridInstance cache wasn't cleaned when underlying Cube be updated

2017-03-10 Thread Shaofeng SHI (JIRA)
Shaofeng SHI created KYLIN-2499: --- Summary: HybridInstance cache wasn't cleaned when underlying Cube be updated Key: KYLIN-2499 URL: https://issues.apache.org/jira/browse/KYLIN-2499 Project: Kylin

Re: [jira] [Created] (KYLIN-2498) Unable to install Kylin

2017-03-10 Thread Kaige Liu
You are using wrong version. Please check your HBase version and choose corresponding Kylin. http://kylin.apache.org/download/ Best regards, Kaige Liu(刘凯歌) On 3/10/17, 6:06 PM, "amitav (JIRA)" wrote: amitav created KYLIN-2498: - Summa

[jira] [Created] (KYLIN-2498) Unable to install Kylin

2017-03-10 Thread amitav (JIRA)
amitav created KYLIN-2498: - Summary: Unable to install Kylin Key: KYLIN-2498 URL: https://issues.apache.org/jira/browse/KYLIN-2498 Project: Kylin Issue Type: Bug Components: Environment

[jira] [Created] (KYLIN-2497) Optimize the performance of SelfDefineSortableKey

2017-03-10 Thread XIE FAN (JIRA)
XIE FAN created KYLIN-2497: -- Summary: Optimize the performance of SelfDefineSortableKey Key: KYLIN-2497 URL: https://issues.apache.org/jira/browse/KYLIN-2497 Project: Kylin Issue Type: Improvement

Re: kylin build cube时,状态一直是PENDING

2017-03-10 Thread ShaoFeng Shi
could you provide the full kylin.log? 在 2017年3月6日 下午4:49,赵俊 写道: > 你好,我的主机服务能够正常启动,但是build cube时状态一直停留在PENDING。 > > > > Model的Datasource里同步下来的hive表,Cardinality没有计算出来。 > > > > 这可能是什么原因造成的?相关软件的版本信息如下: > > > > Kylin: 1.5.2.1 > > Hadoop: 2.6.0 > > Hive: 0.14.0 > > Zookeeper: 3.4.6 > > Hbase: 0.98.8 >

Re: 求 编译 kylin 源码 方法

2017-03-10 Thread ShaoFeng Shi
Kylin maintains three branches for each version: hbase 0.98, hbase 1.x and cdh 5.7; Please use a hbase 1.x version to start, like https://github.com/apache/kylin/tree/kylin-1.6.0-HBase1.x 在 2017年3月6日 上午10:56,kylin_liu 写道: > 谢谢 史少锋 ! > > 还有一个问题,请问我编译源码的时候碰到一个 ,就是不能修改 > 0.98.8-hadoop2 > 0

Re: Tutorial for Spark cubing

2017-03-10 Thread Luke Han
Cool~~~ Best Regards! - Luke Han On Mon, Mar 6, 2017 at 7:36 PM, ShaoFeng Shi wrote: > Hi, > > Newly added a tutorial on using Apache Spark as the cube engine in v2.0 > beta; Your comment/suggestion is welcomed: > > https://kylin.apache.org/docs16/tutorial/cube_spark.html

kylin build cube时,状态一直是PENDING

2017-03-10 Thread 赵俊
你好,我的主机服务能够正常启动,但是build cube时状态一直停留在PENDING。 [cid:image001.jpg@01D29699.9410D720] Model的Datasource里同步下来的hive表,Cardinality没有计算出来。 [cid:image002.jpg@01D29699.9410D720] 这可能是什么原因造成的?相关软件的版本信息如下: Kylin: 1.5.2.1 Hadoop: 2.6.0 Hive: 0.14.0 Zookeeper: 3.4.6 Hbase: 0.98.8 谢谢

TIMEOUT

2017-03-10 Thread icely
hi: my system is?? hadoop 2.6+zookeeper3.4.6+hbase1.2.4+hive1.2 when i run the sql of the example,meet the problem: Error while executing SQL "select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt LIMIT 5": Ti

Fw: Re: 关于kylin的一个问题

2017-03-10 Thread wang...@aspirecn.com
wang...@aspirecn.com 发件人: ShaoFeng Shi 发送时间: 2017-03-08 12:40 收件人: wang...@aspirecn.com 主题: Re: Re: 关于kylin的一个问题 Hi Lin, please send to dev@kylin.apache.org, not to me. 2017-03-07 17:51 GMT+08:00 wang...@aspirecn.com : hi,ShaoFeng Shi while i running the kylin job, at step 3 (Extract Fac

wait for stpe1 : Create Intermediate Flat Hive Table

2017-03-10 Thread h...@soonchina.cn
您好: 我遇到一个问题,kylin的cube job 一直卡在stpe1 : Create Intermediate Flat Hive Table,已经72分钟,没有发现任何错误日志。是我什么地方配置有问题吗? 谢谢 h...@soonchina.cn

kylin jdbc meet exception

2017-03-10 Thread yangchao
sql单独执行没有问题, 在多条并发执行的query后,会爆出来下面的异常 我的java代码: public JSONArray findApiStatistic(ApiRequest request) { JSONArray jsonArray = null; try { KylinRepoDO kylinRepoDO = makeKylinRepoDO(); driver = kylinRepoDO.getDriver(); conn = driver.connect(aresDat

kylin 架设问题

2017-03-10 Thread kylin_liu
我的环境是 hadoop 2.7.3 +hbase 1.2.4 +hive 2.1.0 apache-kylin-1.6.0-hbase1.x-bin KYLIN 自带的 cube 编译的时候到 #17 Step Name: Convert Cuboid Data to HFile 出现错误 我查看了mr 的错误日志,日志如下:请问这个是hadoop 环境问题呢 ,还是 kylin 跟 hbase 版本问题,纠结了很久了, 我同样的一套环境,可以正常通过。请大神指点迷津,万分感觉!! 2017-03-06 02:14:24,359 FATAL [IPC Server handle

Re: [jira] [Created] (KYLIN-2496) Table snapshot should be no greater than 300MB

2017-03-10 Thread Alberto Ramón
This jira is repeteated On build cube process the Lookup tables are stored in RAM Check these: https://issues.apache.org/jira/browse/KYLIN-1869 *kylin.table.snapshot.max_mb * 2017-03-10 8:42 GMT+01:00 Kailun Zhang (JIRA) : > Kailun Zhang created KYLIN-2496: >

Re: 求 编译 kylin 源码 方法

2017-03-10 Thread kylin_liu
谢谢 史少锋 ! 还有一个问题,请问我编译源码的时候碰到一个 ,就是不能修改 0.98.8-hadoop2 0.10.0.0 hbase 版本,我hbase 用的是1.2.4当我修改后就编译失败,这个是源码的问题吗? 还是其他问题呢? 我修改 hadoop 跟 Hive版本都可以正常编译的。 -- View this message in context: http://apache-kylin.74782.x6.nabble.com/kylin-tp7333p7358.html Sent from the Apache Kylin mailing l