You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by "Donald,Zheng(vip.com)" <do...@vipshop.com> on 2017/10/16 09:14:21 UTC
答复: what's the meaning of " RowKey columns count (7) doesn't match dimensions columns count (6) "?
1. Hi liubo, if your Kylin version is 2.1.0 and cube created though Kylin web UI, you may encounter a known bug(KYLIN-2798<https://issues.apache.org/jira/browse/KYLIN-2798>) which will be fixed in Kylin 2.2.0.
发件人: liubo@fcyun.com [mailto:liubo@fcyun.com]
发送时间: 2017年10月16日 15:58
收件人: liubo@fcyun.com; user
主题: Re: what's the meaning of " RowKey columns count (7) doesn't match dimensions columns count (6) "?
Cube Schema:
{
"name": "pay_cube",
"model_name": "fcpay",
"description": "",
"dimensions": [
{
"name": "DEAL_HISTORY_ID",
"table": "T_DEAL_HISTORY",
"derived": null,
"column": "DEAL_HISTORY_ID"
},
{
"name": "COMPANY_ID",
"table": "T_DEAL_HISTORY",
"derived": null,
"column": "COMPANY_ID"
},
{
"name": "STORE_ID",
"table": "T_DEAL_HISTORY",
"derived": null,
"column": "STORE_ID"
},
{
"name": "DEAL_FINISH_DATE",
"table": "T_DEAL_HISTORY",
"derived": null,
"column": "DEAL_FINISH_DATE"
},
{
"name": "PAY_TYPE",
"table": "T_DEAL_HISTORY",
"derived": null,
"column": "PAY_TYPE"
},
{
"name": "YY",
"table": "T_DIMENSION_DATE",
"derived": [
"YY"
],
"column": null
},
{
"name": "MM",
"table": "T_DIMENSION_DATE",
"derived": [
"MM"
],
"column": null
},
{
"name": "DD",
"table": "T_DIMENSION_DATE",
"derived": [
"DD"
],
"column": null
},
{
"name": "WW",
"table": "T_DIMENSION_DATE",
"derived": [
"WW"
],
"column": null
},
{
"name": "PAY_TYPE",
"table": "T_PAY_TYPE",
"derived": [
"PAY_TYPE"
],
"column": null
},
{
"name": "PAY_TYPE_NAME",
"table": "T_PAY_TYPE",
"derived": [
"PAY_TYPE_NAME"
],
"column": null
},
{
"name": "COMPANY_ID",
"table": "T_SELLER_STORE_RELATION",
"derived": [
"COMPANY_ID"
],
"column": null
},
{
"name": "STORE_ID",
"table": "T_SELLER_STORE_RELATION",
"derived": [
"STORE_ID"
],
"column": null
},
{
"name": "SELLER_ID",
"table": "T_SELLER_STORE_RELATION",
"derived": [
"SELLER_ID"
],
"column": null
},
{
"name": "BIZ_ORDER_ID",
"table": "T_THIRD_PAID_DETAIL",
"derived": [
"BIZ_ORDER_ID"
],
"column": null
},
{
"name": "STORE_ID",
"table": "T_STORE",
"derived": [
"STORE_ID"
],
"column": null
},
{
"name": "COMPANY_ID",
"table": "T_COMPANY",
"derived": [
"COMPANY_ID"
],
"column": null
},
{
"name": "SELLER_ID",
"table": "T_SELLER",
"derived": [
"SELLER_ID"
],
"column": null
},
{
"name": "SELLER_GROUP_ID",
"table": "T_SELLER_GROUP",
"derived": [
"SELLER_GROUP_ID"
],
"column": null
}
],
"measures": [
{
"name": "_COUNT_",
"function": {
"expression": "COUNT",
"returntype": "bigint",
"parameter": {
"type": "constant",
"value": "1",
"next_parameter": null
},
"configuration": {}
}
},
{
"name": "pay_money",
"function": {
"expression": "SUM",
"returntype": "decimal(19,2)",
"parameter": {
"type": "column",
"value": "T_DEAL_HISTORY.PAY_MONEY",
"next_parameter": null
},
"configuration": null
},
"showDim": false
},
{
"name": "deal_count",
"function": {
"expression": "COUNT_DISTINCT",
"returntype": "hllc12",
"parameter": {
"type": "column",
"value": "T_DEAL_HISTORY.DEAL_HISTORY_ID",
"next_parameter": null
},
"configuration": null
},
"showDim": true
},
{
"name": "commission",
"function": {
"expression": "SUM",
"returntype": "bigint",
"parameter": {
"type": "column",
"value": "T_THIRD_PAID_DETAIL.COMMISSION",
"next_parameter": null
},
"configuration": null
},
"showDim": true
},
{
"name": "store_name",
"function": {
"expression": "EXTENDED_COLUMN",
"returntype": "extendedcolumn(100)",
"parameter": {
"type": "column",
"value": "T_DEAL_HISTORY.STORE_ID",
"next_parameter": {
"type": "column",
"value": "T_STORE.STORE_NAME",
"next_parameter": null
}
},
"configuration": null
},
"showDim": false
},
{
"name": "company_name",
"function": {
"expression": "EXTENDED_COLUMN",
"returntype": "extendedcolumn(100)",
"parameter": {
"type": "column",
"value": "T_DEAL_HISTORY.COMPANY_ID",
"next_parameter": {
"type": "column",
"value": "T_COMPANY.COMPANY_NAME",
"next_parameter": null
}
},
"configuration": null
},
"showDim": false
},
{
"name": "group_name",
"function": {
"expression": "RAW",
"returntype": "raw",
"parameter": {
"type": "column",
"value": "T_SELLER_GROUP.SELLER_GROUP_NAME",
"next_parameter": null
},
"configuration": null
},
"showDim": true
},
{
"name": "seller_name",
"function": {
"expression": "RAW",
"returntype": "raw",
"parameter": {
"type": "column",
"value": "T_SELLER.SELLER_NAME",
"next_parameter": null
},
"configuration": null
},
"showDim": true
}
],
"dictionaries": [],
"rowkey": {
"rowkey_columns": [
{
"column": "T_DEAL_HISTORY.DEAL_HISTORY_ID",
"encoding": "dict",
"isShardBy": "false",
"encoding_version": "1"
},
{
"column": "T_DEAL_HISTORY.COMPANY_ID",
"encoding": "dict",
"isShardBy": "false",
"encoding_version": "1"
},
{
"column": "T_DEAL_HISTORY.STORE_ID",
"encoding": "dict",
"isShardBy": "false",
"encoding_version": "1"
},
{
"column": "T_DEAL_HISTORY.DEAL_FINISH_DATE",
"encoding": "dict",
"isShardBy": "false",
"encoding_version": "1"
},
{
"column": "T_DEAL_HISTORY.PAY_TYPE",
"encoding": "dict",
"isShardBy": "false",
"encoding_version": "1"
},
{
"column": "T_SELLER_STORE_RELATION.SELLER_ID",
"encoding": "dict",
"isShardBy": "false",
"encoding_version": "1"
},
{
"column": "T_SELLER.SELLER_GROUP_ID",
"encoding": "dict",
"isShardBy": "false",
"encoding_version": "1"
}
]
},
"aggregation_groups": [
{
"includes": [
"T_DEAL_HISTORY.DEAL_HISTORY_ID",
"T_DEAL_HISTORY.COMPANY_ID",
"T_DEAL_HISTORY.STORE_ID",
"T_DEAL_HISTORY.DEAL_FINISH_DATE",
"T_DEAL_HISTORY.PAY_TYPE",
"T_SELLER_STORE_RELATION.SELLER_ID",
"T_SELLER.SELLER_GROUP_ID"
],
"select_rule": {
"hierarchy_dims": [],
"mandatory_dims": [],
"joint_dims": []
}
}
],
"partition_date_start": 1456876800000,
"notify_list": [],
"hbase_mapping": {
"column_family": [
{
"name": "F1",
"columns": [
{
"qualifier": "M",
"measure_refs": [
"_COUNT_",
"pay_money",
"commission",
"store_name",
"company_name",
"group_name",
"seller_name"
]
}
]
},
{
"name": "F2",
"columns": [
{
"qualifier": "M",
"measure_refs": [
"deal_count"
]
}
]
}
]
},
"retention_range": "0",
"status_need_notify": [
"ERROR",
"DISCARDED",
"SUCCEED"
],
"auto_merge_time_ranges": [
604800000,
2419200000
],
"engine_type": 2,
"storage_type": 2,
"override_kylin_properties": {}
}
________________________________
liubo@fcyun.com<ma...@fcyun.com>
From: liubo@fcyun.com<ma...@fcyun.com>
Date: 2017-10-16 15:55
To: user<ma...@kylin.apache.org>
Subject: what's the meaning of " RowKey columns count (7) doesn't match dimensions columns count (6) "?
hi all,
I got this error when save cube, but I don't understand why this eroor ocuurs?
I have 15 dimension columns, and 7 row keys, all row keys are in the dimension columns, when I save the cube it's the error:
RowKey columns count (7) doesn't match dimensions columns count (6)
[cid:image001.jpg@01D346A1.F85BEF90]
Dimensions:
[cid:image002.jpg@01D346A1.F85BEF90]
thanks a lot,
Best Regards!
________________________________
liubo@fcyun.com<ma...@fcyun.com>
本电子邮件可能为保密文件。如果阁下非电子邮件所指定之收件人，谨请立即通知本人。敬请阁下不要使用、保存、复印、打印、散布本电子邮件及其内容，或将其用于其他任何目的或向任何人披露。谢谢您的合作！ This communication is intended only for the addressee(s) and may contain information that is privileged and confidential. You are hereby notified that, if you are not an intended recipient listed above, or an authorized employee or agent of an addressee of this communication responsible for delivering e-mail messages to an intended recipient, any dissemination, distribution or reproduction of this communication (including any attachments hereto) is strictly prohibited. If you have received this communication in error, please notify us immediately by a reply e-mail addressed to the sender and permanently delete the original e-mail communication and any attachments from all storage devices without making or otherwise retaining a copy.