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? >
