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
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
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
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
> 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,
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
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
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
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
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
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
>
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
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
你好,我的主机服务能够正常启动,但是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
谢谢
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
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
您好:
我遇到一个问题,kylin的cube job 一直卡在stpe1 : Create Intermediate Flat Hive
Table,已经72分钟,没有发现任何错误日志。是我什么地方配置有问题吗?
谢谢
h...@soonchina.cn
sql单独执行没有问题, 在多条并发执行的query后,会爆出来下面的异常
我的java代码:
public JSONArray findApiStatistic(ApiRequest request) {
JSONArray jsonArray = null;
try {
KylinRepoDO kylinRepoDO = makeKylinRepoDO();
driver = kylinRepoDO.getDriver();
conn = driver.connect(aresDat
我的环境是 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
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:
>
谢谢 史少锋 !
还有一个问题,请问我编译源码的时候碰到一个 ,就是不能修改
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
21 matches
Mail list logo