Failed to init CubeDescManager from kylin_metadata@hbase

Hi,

I tried to create cube of kylin_sales_model sample model according to the get started guide v1.6.0 but met the following error, could you tell me what’s wrong and how to make it? Thanks a lot!

Error:

Caused by: java.lang.IllegalStateException: Failed to init CubeDescManager from kylin_metadata@hbase
at org.apache.kylin.cube.CubeDescManager.getInstance(CubeDescManager.java:78)
at org.apache.kylin.rest.service.BasicService.getCubeDescManager(BasicService.java:80)
at org.apache.kylin.rest.service.CubeService.createCubeAndDesc(CubeService.java:153)
at org.apache.kylin.rest.service.CubeService$$FastClassBySpringCGLIB$$17a07c0e.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:633)
at org.apache.kylin.rest.service.CubeService$$EnhancerBySpringCGLIB$$f6333fdc.createCubeAndDesc(<generated>)
at org.apache.kylin.rest.controller.CubeController.saveCubeDesc(CubeController.java:430)
... 71 more
Caused by: com.fasterxml.jackson.core.JsonParseException: Unexpected character ('%' (code 37)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')
at [Source: java.io.DataInputStream@65075cfd; line: 263, column: 20]
at com.fasterxml.jackson.core.JsonParser._constructError(JsonParser.java:1581)
at com.fasterxml.jackson.core.base.ParserMinimalBase._reportError(ParserMinimalBase.java:533)
at com.fasterxml.jackson.core.base.ParserMinimalBase._reportUnexpectedChar(ParserMinimalBase.java:462)
at com.fasterxml.jackson.core.json.UTF8StreamJsonParser._handleUnexpectedValue(UTF8StreamJsonParser.java:2613)
at com.fasterxml.jackson.core.json.UTF8StreamJsonParser.nextFieldName(UTF8StreamJsonParser.java:1055)
at com.fasterxml.jackson.databind.deser.BeanDeserializer.vanillaDeserialize(BeanDeserializer.java:265)
at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:125)
at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:3736)
at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:2796)
at org.apache.kylin.common.util.JsonUtil.readValue(JsonUtil.java:62)
at org.apache.kylin.common.persistence.JsonSerializer.deserialize(JsonSerializer.java:40)
at org.apache.kylin.common.persistence.ResourceStore.getResource(ResourceStore.java:146)
at org.apache.kylin.cube.CubeDescManager.loadCubeDesc(CubeDescManager.java:173)
at org.apache.kylin.cube.CubeDescManager.reloadAllCubeDesc(CubeDescManager.java:252)
at org.apache.kylin.cube.CubeDescManager.<init>(CubeDescManager.java:99)
at org.apache.kylin.cube.CubeDescManager.getInstance(CubeDescManager.java:71)
... 82 more


And here is the Cube Schema:

{
"name": "kylin_sales_cube",
"model_name": "kylin_sales_model",
"description": "",
"dimensions": [
{
"name": "PART_DT",
"table": "DEFAULT.KYLIN_SALES",
"derived": null,
"column": "PART_DT"
},
{
"name": "LSTG_FORMAT_NAME",
"table": "DEFAULT.KYLIN_SALES",
"derived": null,
"column": "LSTG_FORMAT_NAME"
},
{
"name": "SELLER_ID",
"table": "DEFAULT.KYLIN_SALES",
"derived": null,
"column": "SELLER_ID"
},
{
"name": "CAL_DT",
"table": "DEFAULT.KYLIN_CAL_DT",
"derived": [
"CAL_DT"
],
"column": null
}
],
"measures": [
{
"name": "_COUNT_",
"function": {
"expression": "COUNT",
"returntype": "bigint",
"parameter": {
"type": "constant",
"value": "1",
"next_parameter": null
},
"configuration": {}
}
}
],
"dictionaries": ,
"rowkey": {
"rowkey_columns": [
{
"column": "PART_DT",
"encoding": "dict",
"isShardBy": "false"
},
{
"column": "LSTG_FORMAT_NAME",
"encoding": "dict",
"isShardBy": "false"
},
{
"column": "SELLER_ID",
"encoding": "dict",
"isShardBy": "false"
}
]
},
"aggregation_groups": [
{
"includes": [
"PART_DT",
"LSTG_FORMAT_NAME",
"SELLER_ID"
],
"select_rule": {
"hierarchy_dims": ,
"mandatory_dims": ,
"joint_dims":
}
}
],
"partition_date_start": 0,
"notify_list": ,
"hbase_mapping": {
"column_family": [
{
"name": "f1",
"columns": [
{
"qualifier": "m",
"measure_refs": [
"_COUNT_"
]
}
]
}
]
},
"retention_range": "0",
"status_need_notify": [
"ERROR",
"DISCARDED",
"SUCCEED"
],
"auto_merge_time_ranges": [
604800000,
2419200000
],
"engine_type": 2,
"storage_type": 2,
"override_kylin_properties": {
"kylin.hbase.region.cut": "1"
}
}

limix

赞同来自:

同求这个问题的答案, 是否已经将这个问题解决了?

limix

赞同来自:

hbase shell

get 'kylin_metadata','/cube_desc/kylin_sales_cube.json'

"engine_type" : %default_engine_type%,\x0A  "storage_type" : %default_engine_type%,\x0A

first use the hbase shell to check the content stored in hbase, you will find something like this for me %default_engine_type%, so what you should do is to check your bin/sample.sh if you want to skip this error, you can just modify the template/cube_desc/kylin_sales_cube.json to the correct number , for me it is 2 说明: 首先登陆 hbase shell , 检查立方体配置信是否正确 template/cube_desc/kylin_sales_cube.json ===> 2 for the %default_engine_type%  

要回复问题请先登录注册