Re: GlobalDict should have 0 or 1 append dict but 2?

2017-03-19 Thread 446463...@qq.com
solution:
http://apache-kylin.74782.x6.nabble.com/java-lang-IllegalStateException-GlobalDict-dict-tableName-column-should-have-0-or-1-append-dict-but-y-td6848.html
 
some steps:
.1 find the different global_dictionary rowkey in segment 
.2 you should delete the segment first
.3 delete the rowkey in Hbase tables which start with '/dict' and '/cube'


446463...@qq.com
 
From: 赵亮
Date: 2017-03-20 10:51
To: dev@kylin.apache.org
Subject: GlobalDict should have 0 or 1 append dict but 2?
Hi all,
   I build a cube with a column named “USER_ID” using global dictionary day 
by day. Last day I met a problem that this column has 2 global dictionary like :
In this pic , DW.INCR_D_USER_NEW_CHANNEL is the hive table name.
 
I found that the dictionary ID of USER_ID in last segments is different from 
other segments:
 
 
so my idea is delete the last segment and rebuild it , but I don’t know  how to 
do it.
I found there is an rest-api in 
https://issues.apache.org/jira/browse/KYLIN-1540 but is’t not in the kylin 
official doc. Is this api working ? if so , someone can give me a example?
 
I also found a solution in 
http://apache-kylin.74782.x6.nabble.com/Re-more-than-1-append-dict-for-globalDict-td7028.html
 but it’s useless for me because I can not login cluster as Hadoop 
administrator,I just have the admin privilege of kylin.
I wondering if there is a solution without using Hadoop cmd.
 
 
In the above solution, I can’t not find how this error happened and I want know 
it.
 
Thanks!
 
 
Best wishes,
Light


Re: kylin jdbc meet exception

2017-03-19 Thread Billy Liu
Could you prepare the code which could reproduce the issue?

2017-03-19 1:36 GMT-07:00 yangchao :

> private KylinRepoDO makeKylinRepoDO() {
> KylinRepoDO kylinRepoDO = null;
> try {
> driver = (Driver)
> Class.forName(aresDataSourceConfig.getDriverClassName()).newInstance();
> properties = new Properties();
> properties.put("user", aresDataSourceConfig.getUsername());
> properties.put("password", aresDataSourceConfig.getPasswo
> rd());
> conn = driver.connect(aresDataSourceConfig.getUrl(),
> properties);
> state = conn.createStatement();
> kylinRepoDO = new KylinRepoDO(driver, properties, conn, state);
> } catch (Exception e) {
> logger.error("kylin config=" +
> JSON.toJSONString(aresDataSourceConfig) + " meet exception: " +
> e.getMessage());
> try {
> if (state != null) {
> state.close();
> }
> if (conn != null) {
> conn.close();
> }
> } catch (Exception e1) {
> logger.error("db close meet exception", e1.getMessage());
> }
> }
> return kylinRepoDO;
> }
>
> --
> View this message in context: http://apache-kylin.74782.x6.n
> abble.com/kylin-jdbc-meet-exception-tp7368p7473.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>


Re: Local development environment configuration run test

2017-03-19 Thread George Ni (Chunen Ni)
Hi,
Please follow steps in articles of http://kylin.apache.org/development/

Best regards,
 
Chun’en Ni(倪春恩)
Mail: chunen...@kyligence.io 
Shanghai Kyligence Information Technology Co., Ltd
上海市浦东新区亮秀路112号Y1座405室
 

在 2017/3/17 上午11:01,“独孤依人”<459994...@qq.com> 写入:

hi:  I want to be a contributor to the kylin code, so I need to 
configure the local development environment, local testing, etc., should be how 
to do, can give a developer documentation?
thanks



kylin 无法加载hive classpath 内得lib

2017-03-19 Thread wu lihu
Hi All
我是用得 AWS EMR, 我把JSON-SERDE 得 jar 加入了 hive 得 classpath 里面了,修改了
find-hive-dependency.sh ,把这个JAR 得路径也加入进去了。可是还是加载不了 hivemeta  报错
 Caused by: MetaException(message:java.lang.ClassNotFoundException
Class org.openx.data.jsonserde.JsonSerDe not found)

但是我在 System tab 里面可以看到
/usr/lib/hive/lib/json-serde-1.3.8-SNAPSHOT-jar-with-dependencies.jar
在classpath 里面。 请问这个怎么解决?


Re: kylin jdbc meet exception

2017-03-19 Thread yangchao
private KylinRepoDO makeKylinRepoDO() {
KylinRepoDO kylinRepoDO = null;
try {
driver = (Driver)
Class.forName(aresDataSourceConfig.getDriverClassName()).newInstance();
properties = new Properties();
properties.put("user", aresDataSourceConfig.getUsername());
properties.put("password", aresDataSourceConfig.getPassword());
conn = driver.connect(aresDataSourceConfig.getUrl(),
properties);
state = conn.createStatement();
kylinRepoDO = new KylinRepoDO(driver, properties, conn, state);
} catch (Exception e) {
logger.error("kylin config=" +
JSON.toJSONString(aresDataSourceConfig) + " meet exception: " +
e.getMessage());
try {
if (state != null) {
state.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e1) {
logger.error("db close meet exception", e1.getMessage());
}
}
return kylinRepoDO;
}

--
View this message in context: 
http://apache-kylin.74782.x6.nabble.com/kylin-jdbc-meet-exception-tp7368p7473.html
Sent from the Apache Kylin mailing list archive at Nabble.com.