kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 崔苗 <cuim...@danale.com>
Subject Re:Re: what's the meaning of " RowKey columns count (7) doesn't match dimensions columns count (6) "?
Date Mon, 16 Oct 2017 08:06:18 GMT
the column count don't include in 'derived' columns,so according the message ,there was 6 normal
columns ,but 7 rowkey columns,it doesn't match.

在 2017-10-16 15:57:32,"liubo@fcyun.com" <liubo@fcyun.com> 写道:
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


 
From: liubo@fcyun.com
Date: 2017-10-16 15:55
To: user
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)













Dimensions:







thanks a lot,


Best Regards!
liubo@fcyun.com









Mime
View raw message