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.