when included more than 1 lookup table,cube defination failed(the same
defination works on kylin 0,7.1), the error message as follow:
Error Message
Failed to deal with the request: null
cube schema :
{
"uuid": "2b1ab7f1-e341-4f06-898b-c17a1f0a676e",
"name": "test01",
"description": "",
"dimensions": [
{
"id": 1,
"name": "MIN5",
"table": "DEFAULT.D_MINUTE_5",
"column": null,
"derived": [
"MINUTE_5_ID"
],
"hierarchy": false
},
{
"id": 2,
"name": "TIME",
"table": "DEFAULT.D_MINUTE_5",
"column": [
"MONTH_ID",
"DAY_ID",
"HOUR_ID"
],
"derived": null,
"hierarchy": true
},
{
"name": "ecellid",
"table": "DEFAULT.DIM_ECELL",
"hierarchy": false,
"derived": [
"ECELL_OID"
],
"column": null,
"id": 3
}
],
"measures": [
{
"id": 1,
"name": "_COUNT_",
"function": {
"expression": "COUNT",
"parameter": {
"type": "constant",
"value": "1"
},
"returntype": "bigint"
},
"dependent_measure_ref": null
},
{
"id": 2,
"name": "FLUX",
"function": {
"expression": "SUM",
"parameter": {
"type": "column",
"value": "FLUX"
},
"returntype": "bigint"
},
"dependent_measure_ref": null
}
],
"rowkey": {
"rowkey_columns": [
{
"column": "MONTH_ID",
"length": 0,
"dictionary": "true",
"mandatory": true
},
{
"column": "DAY_ID",
"length": 0,
"dictionary": "true",
"mandatory": true
},
{
"column": "HOUR_ID",
"length": 0,
"dictionary": "true",
"mandatory": true
},
{
"column": "ECELLOID",
"length": 0,
"dictionary": "true",
"mandatory": false
}
],
"aggregation_groups": [
[
"ECELLOID"
]
]
},
"signature": "aUVkAHK2hEG7h3zavqy3sQ==",
"last_modified": 1438224731907,
"model_name": "test01",
"null_string": null,
"hbase_mapping": {
"column_family": [
{
"name": "f1",
"columns": [
{
"qualifier": "m",
"measure_refs": [
"_COUNT_",
"FLUX"
]
}
]
}
]
},
"notify_list": [],
"project": "ana"
}
梁猛
中国移动广东公司 网管维护中心 网管支撑室
电话：13802880779
邮箱: [email protected] ，[email protected]
地址：广东省广州市珠江新城珠江西路11号 广东全球通大厦北3楼
邮编：510623
