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
