This is a bug, could you please report it as a JIRA?
To bypass this error for now, please use the FK on fact table as the
dimension ("TXN_BOOK_DT_KEY" in this case).
2016-03-28 22:35 GMT+08:00 sdangi <[email protected]>:
> I have designed model/cubes in the past on version 1.2 and 1.3 no issue.
> I'm
> hitting this issue with 1.5. Please check the model and cube JSON and let
> me know if there is anything that stands out to cause this.
>
>
> *Error Message
> Cannot find rowkey column DT_KEY in cube CubeDesc [name=TEST_CUBE]*
>
>
> MODEL:
> ========================================================
> {
> "uuid": "dd8395e2-0da3-48b1-8a0c-4165d477e7c5",
> "version": "1.5.0",
> "name": "TEST_MODEL",
> "description": "",
> "lookups": [
> {
> "table": "SCHM.DT_DIM_ORC",
> "join": {
> "type": "inner",
> "primary_key": [
> "DT_KEY"
> ],
> "foreign_key": [
> "TXN_BOOK_DT_KEY"
> ]
> }
> },
> {
> "table": "SCHM.CST_DIM_ORC",
> "join": {
> "type": "inner",
> "primary_key": [
> "CST_KEY"
> ],
> "foreign_key": [
> "FIRM_CST_KEY"
> ]
> }
> }
> ],
> "dimensions": [
> {
> "table": "SCHM.TXN_FCT_ORC_SM",
> "columns": []
> },
> {
> "table": "SCHM.DT_DIM_ORC",
> "columns": [
> "DT_KEY"
> ]
> },
> {
> "table": "SCHM.CST_DIM_ORC",
> "columns": [
> "CST_NM"
> ]
> }
> ],
> "metrics": [
> "USD_TXN_AMT"
> ],
> "capacity": "MEDIUM",
> "last_modified": 1459175903495,
> "fact_table": "SCHM.TXN_FCT_ORC_SM",
> "filter_condition": "",
> "partition_desc": {
> "partition_date_column": "SCHM.TXN_FCT_ORC_SM.TXN_BOOK_DT_KEY",
> "partition_time_column": null,
> "partition_date_start": 0,
> "partition_date_format": "yyyy-MM-dd",
> "partition_time_format": "HH:mm:ss",
> "partition_type": "APPEND",
> "partition_condition_builder":
>
> "org.apache.kylin.metadata.model.PartitionDesc$DefaultPartitionConditionBuilder"
> }
> }
>
>
> CUBE:
> ===================================================
>
> {
> "name": "TEST_CUBE",
> "model_name": "TEST_MODEL",
> "description": "",
> "dimensions": [
> {
> "name": "CST_DIM_CST_NM",
> "table": "SCHM.CST_DIM_ORC",
> "derived": null,
> "column": "CST_NM"
> },
> {
> "name": "DT_DIM_DT_KEY",
> "table": "SCHM.DT_DIM_ORC",
> "derived": null,
> "column": "DT_KEY"
> }
> ],
> "measures": [
> {
> "name": "_COUNT_",
> "function": {
> "expression": "COUNT",
> "returntype": "bigint",
> "parameter": {
> "type": "constant",
> "value": "1",
> "next_parameter": null
> }
> }
> },
> {
> "name": "USD_TXN_AMT",
> "function": {
> "expression": "SUM",
> "returntype": "decimal(32,8)",
> "parameter": {
> "type": "column",
> "value": "USD_TXN_AMT",
> "next_parameter": null
> }
> }
> }
> ],
> "rowkey": {
> "rowkey_columns": [
> {
> "column": "CST_NM",
> "encoding": "dict"
> },
> {
> "column": "DT_KEY",
> "encoding": "dict"
> }
> ]
> },
> "aggregation_groups": [
> {
> "includes": [
> "CST_NM",
> "DT_KEY"
> ],
> "select_rule": {
> "hierarchy_dims": [],
> "mandatory_dims": [],
> "joint_dims": []
> }
> }
> ],
> "partition_date_start": 1388534400000,
> "notify_list": [],
> "hbase_mapping": {
> "column_family": [
> {
> "name": "f1",
> "columns": [
> {
> "qualifier": "m",
> "measure_refs": [
> "_COUNT_",
> "USD_TXN_AMT"
> ]
> }
> ]
> }
> ]
> },
> "retention_range": "0",
> "auto_merge_time_ranges": [
> 604800000,
> 2419200000
> ],
> "engine_type": 2,
> "storage_type": 2
> }
>
> Thanks,
> Regards,
>
> --
> View this message in context:
> http://apache-kylin.74782.x6.nabble.com/VER1-5-Cannot-find-rowkey-column-DT-KEY-in-cube-CubeDesc-name-TEST-CUBE-tp3982.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>
--
Best regards,
Shaofeng Shi
