Thanks Luke; @Kaine, please get the latest build and retry the cube building; just let us know if still have the problem;
https://kylin.incubator.apache.org/download/ On 3/25/15, 9:20 AM, "Luke Han" <[email protected]> wrote: >The package already be updated with latest fix. > >Thanks. > > >Best Regards! >--------------------- > >Luke Han > >2015-03-24 17:58 GMT-07:00 Shi, Shaofeng <[email protected]>: > >> This problem has already been fixed in last week, the original JIRA is: >> https://issues.apache.org/jira/browse/KYLIN-644 >> >> @Luke, from the commit number on download page, it seems the current >> binary package doesn¹t include this fix; Could you upload a new one? >> >> >> On 3/24/15, 11:53 PM, "Luke Han" <[email protected]> wrote: >> >> >What's exactly issue you have? Can't build cube or can't query result? >> >Could you please share more details for further analysis? >> > >> >For null value of alias name, please refer to this JIRA for tracking: >> >https://issues.apache.org/jira/browse/KYLIN-652 >> > >> >Thanks. >> > >> > >> >Best Regards! >> >--------------------- >> > >> >Luke Han >> > >> >2015-03-24 0:51 GMT-07:00 Kaine Yan <[email protected]>: >> > >> >> Hello , I sent this problem several days ago and have not solved it >>yet. >> >> >> >> Here is the SQL >> >> >> >> SELECT >> >> FACT_TABLE.QKDYDM >> >> FROM DEFAULT.ZSJ_FACT_YT as FACT_TABLE >> >> LEFT JOIN DEFAULT.ZSJ_DIM_ORG as null >> >> ON FACT_TABLE.QKDYDM = null.YTDM >> >> >> >> I wonder why the lookup table's alias name is null . I selected >>default >> >> settings and used Auto Generator to generate dimensions and error >>still >> >> occured. >> >> >> >> Here is the related json >> >> >> >> { >> >> "uuid": "098e7255-5bb1-4830-a2be-bcfc22a44836", >> >> "name": "ZSJ", >> >> "description": "", >> >> "dimensions": [ >> >> { >> >> "id": 1, >> >> "name": "DEFAULT.ZSJ_FACT_YT.QKDYDM", >> >> "table": "DEFAULT.ZSJ_FACT_YT", >> >> "column": [ >> >> "QKDYDM" >> >> ], >> >> "derived": null, >> >> "hierarchy": false >> >> } >> >> ], >> >> "measures": [ >> >> { >> >> "id": 1, >> >> "name": "_COUNT_", >> >> "function": { >> >> "expression": "COUNT", >> >> "parameter": { >> >> "type": "constant", >> >> "value": "1" >> >> }, >> >> "returntype": "bigint" >> >> }, >> >> "dependent_measure_ref": null >> >> } >> >> ], >> >> "rowkey": { >> >> "rowkey_columns": [ >> >> { >> >> "column": "QKDYDM", >> >> "length": 0, >> >> "dictionary": "true", >> >> "mandatory": false >> >> } >> >> ], >> >> "aggregation_groups": [ >> >> [ >> >> "QKDYDM" >> >> ] >> >> ] >> >> }, >> >> "signature": "QHi8TYV6oXuxC6L0UWHnsA==", >> >> "last_modified": 1427165774865, >> >> "model_name": "ZSJ", >> >> "null_string": null, >> >> "hbase_mapping": { >> >> "column_family": [ >> >> { >> >> "name": "F1", >> >> "columns": [ >> >> { >> >> "qualifier": "M", >> >> "measure_refs": [ >> >> "_COUNT_" >> >> ] >> >> } >> >> ] >> >> } >> >> ] >> >> }, >> >> "notify_list": [] >> >> } >> >> >> >> Could I be helped? >> >> >> >>
