[jira] [Updated] (KYLIN-913) Cannot find rowkey column XXX in cube CubeDesc

["Vadim Semenov (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/KYLIN-913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vadim Semenov updated KYLIN-913:
--------------------------------
    Attachment: Cube Dimensions.png
                Cube Data Model.png
                Comparison.png

> Cannot find rowkey column XXX in cube CubeDesc
> ----------------------------------------------
>
>                 Key: KYLIN-913
>                 URL: https://issues.apache.org/jira/browse/KYLIN-913
>             Project: Kylin
>          Issue Type: Bug
>    Affects Versions: v0.7.2
>            Reporter: Vadim Semenov
>         Attachments: Comparison.png, Cube Data Model.png, Cube Dimensions.png
>
>
> While trying to save a cube with a derived column I get the following error:
> {code}
> 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)
> {code}
> cubeDescData:
> {code}
> {"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"}
> {code}
> modelDescData:
> {code}
> {"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}
> {code}
> 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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)