Hi Meng, I’m a little confused; The Cube JSON you pasted, is it the content before the change you made, or after you made the change? If it is the origin version, could you please describe what changes you made in the edit and paste the whole content of the Cube JSON after edit (it can be found in kylin.log)? Thanks;
On 7/30/15, 5:07 PM, "liangmeng" <[email protected]> wrote: > >ID Table Name Join Type Join Condition >1 DEFAULT.DIM_ECELL left >DEFAULT.DIM_ECELL.ECELL_OID = DEFAULT.LTE_HTTP_ETL.ECELLOID >2 DEFAULT.DIM_ENODEB_IPADDR left >DEFAULT.DIM_ENODEB_IPADDR.IPADDR_ID = DEFAULT.LTE_HTTP_ETL.ENODEBIPOID >3 DEFAULT.DIM_SGW_IPADDR left >DEFAULT.DIM_SGW_IPADDR.SGW_IPADDR_OID = DEFAULT.LTE_HTTP_ETL.SGWIPADDROID >4 DEFAULT.D_MINUTE_5 inner >DEFAULT.D_MINUTE_5.MINUTE_5_ID = DEFAULT.LTE_HTTP_ETL.MINUTE_5_ID > > > >梁猛 >中国移动广东公司 网管维护中心 网管支撑室 >电话：13802880779 >邮箱: [email protected] ，[email protected] >地址：广东省广州市珠江新城珠江西路11号 广东全球通大厦北3楼 >邮编：510623 > >发件人： Shi, Shaofeng >发送时间： 2015-07-30 11:20 >收件人： [email protected] >主题： Re: kylin0.7.2 exception >Hi Meng, > >Could you please check the tomcat/logs/kylin.log and paste the full >exception trace here? That will be helpful, thanks; > >On 7/30/15, 11:03 AM, "liangmeng" <[email protected]> wrote: > >>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 >
