[KYLIN-913] Cannot find rowkey column XXX in cube CubeDesc

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v0.7.2
• Fix Version/s: v1.1, v1.4.0
• Sprint: Sprint 47
• Assignee: liyang
• Reporter: Vadim Semenov
• Created: 28/Jul/15 10:01
• Updated: 26/Oct/15 03:25
• Resolved: 05/Oct/15 13:37

Description

While trying to save a cube with a derived column I get the following error:

Caused by: java.lang.IllegalArgumentException: Cannot find rowkey column PART_DT in cube CubeDesc [name=test]
        at org.apache.kylin.cube.model.RowKeyDesc.buildRowKey(RowKeyDesc.java:193)
        at org.apache.kylin.cube.model.RowKeyDesc.init(RowKeyDesc.java:172)
        at org.apache.kylin.cube.model.CubeDesc.init(CubeDesc.java:448)
        at org.apache.kylin.cube.CubeDescManager.createCubeDesc(CubeDescManager.java:150)
        at org.apache.kylin.rest.service.CubeService.createCubeAndDesc(CubeService.java:156)

cubeDescData:

{"name":"test","description":"","dimensions":[{"name":"DEFAULT.KYLIN_SALES.PART_DT","table":"DEFAULT.KYLIN_SALES","hierarchy":false,"derived":null,"column":["PART_DT"],"id":1},{"name":"DEFAULT.KYLIN_SALES.SELLER_ID","table":"DEFAULT.KYLIN_SALES","hierarchy":false,"derived":null,"column":["SELLER_ID"],"id":2},{"name":"DEFAULT.KYLIN_CAL_DT_derived","table":"DEFAULT.KYLIN_CAL_DT","hierarchy":false,"derived":["CAL_DT"],"column":null,"id":3}],"measures":[{"id":1,"name":"_COUNT_","function":{"expression":"COUNT","returntype":"bigint","parameter":{"type":"constant","value":"1"}}}],"rowkey":{"rowkey_columns":[{"column":"PART_DT","length":0,"dictionary":"true","mandatory":false},{"column":"SELLER_ID","length":0,"dictionary":"true","mandatory":false}],"aggregation_groups":[["PART_DT","SELLER_ID"]]},"notify_list":[],"capacity":"","hbase_mapping":{"column_family":[{"name":"f1","columns":[{"qualifier":"m","measure_refs":["_COUNT_"]}]}]},"project":"learn_kylin","model_name":"test"}

modelDescData:

{"name":"test","fact_table":"DEFAULT.KYLIN_SALES","lookups":[{"table":"DEFAULT.KYLIN_CAL_DT","join":{"type":"left","primary_key":["CAL_DT"],"foreign_key":["PART_DT"]}}],"filter_condition":"","capacity":"MEDIUM","partition_desc":{"partition_date_column":"","partition_date_start":0,"partition_type":"APPEND"},"last_modified":0}

The issue comes from PART_DT being in CubeDesc:derivedToHostMap therefore it's excluded from list of dimension columns in CubeDesc:listDimensionColumnsExcludingDerived(). So colNameAbbr doesn't have PART_DT in RowKeyDesc:170 which causes the exception.

Issue Links

• duplicates: KYLIN-658 java.lang.IllegalArgumentException: Cannot find rowkey column XXX in cube CubeDesc