I create a cube with kylin sample data, cube defination is below :
{
"uuid": "e6cf2ccc-edca-41c6-b637-b3bc50894b5e",
"version": "1.5.1",
"name": "kylin_sales_cube_desc_2_clone",
"description": null,
"dimensions": [
{
"name": "CAL_DT",
"table": "DEFAULT.KYLIN_CAL_DT",
"column": "{FK}",
"derived": [
"WEEK_BEG_DT"
]
},
{
"name": "CATEGORY",
"table": "DEFAULT.KYLIN_CATEGORY_GROUPINGS",
"column": "{FK}",
"derived": [
"USER_DEFINED_FIELD1",
"USER_DEFINED_FIELD3",
"UPD_DATE",
"UPD_USER"
]
},
{
"name": "CATEGORY_HIERARCHY",
"table": "DEFAULT.KYLIN_CATEGORY_GROUPINGS",
"column": "META_CATEG_NAME",
"derived": null
},
{
"name": "CATEGORY_HIERARCHY",
"table": "DEFAULT.KYLIN_CATEGORY_GROUPINGS",
"column": "CATEG_LVL2_NAME",
"derived": null
},
{
"name": "CATEGORY_HIERARCHY",
"table": "DEFAULT.KYLIN_CATEGORY_GROUPINGS",
"column": "CATEG_LVL3_NAME",
"derived": null
},
{
"name": "LSTG_FORMAT_NAME",
"table": "DEFAULT.KYLIN_SALES",
"column": "LSTG_FORMAT_NAME",
"derived": null
}
],
"measures": [
{
"name": "TRANS_CNT",
"function": {
"expression": "COUNT",
"parameter": {
"type": "constant",
"value": "1",
"next_parameter": null
},
"returntype": "bigint"
},
"dependent_measure_ref": null
},
{
"name": "SELLER_CNT_HLL",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "SELLER_ID",
"next_parameter": null
},
"returntype": "hllc16"
},
"dependent_measure_ref": null
},
{
"name": "SELLER_FORMAT_CNT",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "LSTG_FORMAT_NAME",
"next_parameter": null
},
"returntype": "hllc12"
},
"dependent_measure_ref": null
},
{
"name": "ITEM_COUNT_DISTINCT_COUNT",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "ITEM_COUNT",
"next_parameter": null
},
"returntype": "bitmap"
},
"dependent_measure_ref": null
},
{
"name": "TOP",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "PRICE",
"next_parameter": {
"type": "column",
"value": "META_CATEG_NAME",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "SOURCE",
"function": {
"expression": "RAW",
"parameter": {
"type": "column",
"value": "PRICE",
"next_parameter": null
},
"returntype": "raw"
},
"dependent_measure_ref": null
},
{
"name": "TOPP",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "PRICE",
"next_parameter": {
"type": "column",
"value": "ITEM_COUNT",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
}
],
"rowkey": {
"rowkey_columns": [
{
"column": "PART_DT",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LEAF_CATEG_ID",
"encoding": "dict",
"isShardBy": false
},
{
"column": "META_CATEG_NAME",
"encoding": "dict",
"isShardBy": false
},
{
"column": "CATEG_LVL2_NAME",
"encoding": "dict",
"isShardBy": false
},
{
"column": "CATEG_LVL3_NAME",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LSTG_FORMAT_NAME",
"encoding": "fixed_length:16",
"isShardBy": false
},
{
"column": "LSTG_SITE_ID",
"encoding": "dict",
"isShardBy": false
}
]
},
"signature": "RU4IejPOo8asXrxnelDHSw==",
"last_modified": 1464771861329,
"model_name": "kylin_sales_model",
"null_string": null,
"hbase_mapping": {
"column_family": [
{
"name": "F1",
"columns": [
{
"qualifier": "M",
"measure_refs": [
"TRANS_CNT",
"TOP",
"SOURCE",
"TOPP"
]
}
]
},
{
"name": "F2",
"columns": [
{
"qualifier": "M",
"measure_refs": [
"SELLER_CNT_HLL",
"SELLER_FORMAT_CNT",
"ITEM_COUNT_DISTINCT_COUNT"
]
}
]
}
]
},
"aggregation_groups": [
{
"includes": [
"CATEG_LVL2_NAME",
"CATEG_LVL3_NAME",
"LEAF_CATEG_ID",
"LSTG_FORMAT_NAME",
"LSTG_SITE_ID",
"META_CATEG_NAME",
"PART_DT"
],
"select_rule": {
"hierarchy_dims": [
[
"META_CATEG_NAME",
"CATEG_LVL2_NAME",
"CATEG_LVL3_NAME"
]
],
"mandatory_dims": [
"PART_DT"
],
"joint_dims": [
[
"LEAF_CATEG_ID",
"LSTG_SITE_ID"
]
]
}
}
],
"notify_list": null,
"status_need_notify": [],
"partition_date_start": 1325376000000,
"partition_date_end": 3153600000000,
"auto_merge_time_ranges": [],
"retention_range": 0,
"engine_type": 2,
"storage_type": 2,
"override_kylin_properties": {}
}
Threr are two TOPN deminsions on group by META_CATEG_NAME and one
group by ITEM_COUNT(just for test),I run query :
select cal_dt, META_CATEG_NAME, sum(price) from KYLIN_SALES as f
inner join KYLIN_CAL_DT as d on d.cal_dt = f.part_dt inner join
kylin_category_groupings as g on f.LEAF_CATEG_ID = g.LEAF_CATEG_ID
and f.LSTG_SITE_ID = g.SITE_ID group by cal_dt , META_CATEG_NAME order
by sum(price) desc limit 10;
it return :Can't find any realization. Please confirm with providers.
And I run query :
select cal_dt, ITEM_COUNT, sum(price) from KYLIN_SALES as f inner
join KYLIN_CAL_DT as d on d.cal_dt = f.part_dt inner join
kylin_category_groupings as g on f.LEAF_CATEG_ID = g.LEAF_CATEG_ID
and f.LSTG_SITE_ID = g.SITE_ID group by cal_dt , ITEM_COUNT order by
sum(price) desc limit 10;
It return success !
I check code and find kylin will remove defined dimension from
dimensions that used in the query, and try to influenceCapabilityCheck
with unmatchedDimensions and unmatchedAggregations, as the
dimension(like META_CATEG_NAME) has been remove and can not find in
TopNMeasureType.influenceCapabilityCheck, Am I right? or sth I do not
get.
Thanks a lot.
