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.

Reply via email to