??????????cube??build??????
{
"uuid": "cdd44345-88b7-42dd-a58e-44eaec1f1a9d",
"last_modified": 1496915989310,
"version": "2.0.0",
"name": "H5_CUBE",
"model_name": "H5_MODEL",
"description": "",
"null_string": null,
"dimensions": [
{
"name": "EVENTID",
"table": "H5_LOG",
"column": "EVENTID",
"derived": null
},
{
"name": "CHANNELID",
"table": "H5_LOG",
"column": "CHANNELID",
"derived": null
},
{
"name": "SOURCEPAGEID",
"table": "H5_LOG",
"column": "SOURCEPAGEID",
"derived": null
},
{
"name": "PRESENTPAGEID",
"table": "H5_LOG",
"column": "PRESENTPAGEID",
"derived": null
},
{
"name": "LIMITACTIVITYID",
"table": "H5_LOG",
"column": "LIMITACTIVITYID",
"derived": null
},
{
"name": "ITEM_ID",
"table": "H5_LOG",
"column": "ITEM_ID",
"derived": null
},
{
"name": "BRAND_ID",
"table": "H5_LOG",
"column": "BRAND_ID",
"derived": null
},
{
"name": "SUBJECT_ID",
"table": "H5_LOG",
"column": "SUBJECT_ID",
"derived": null
},
{
"name": "DAY",
"table": "H5_LOG",
"column": "DAY",
"derived": null
}
],
"measures": [
{
"name": "PV",
"function": {
"expression": "COUNT",
"parameter": {
"type": "constant",
"value": "1"
},
"returntype": "bigint"
}
},
{
"name": "UV",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "H5_LOG.USER_ID"
},
"returntype": "hllc(16)"
}
}
],
"dictionaries": [
{
"column": "H5_LOG.USER_ID",
"builder": "org.apache.kylin.dict.GlobalDictionaryBuilder"
}
],
"rowkey": {
"rowkey_columns": [
{
"column": "H5_LOG.DAY",
"encoding": "dict",
"isShardBy": false
},
{
"column": "H5_LOG.PRESENTPAGEID",
"encoding": "dict",
"isShardBy": true
},
{
"column": "H5_LOG.CHANNELID",
"encoding": "dict",
"isShardBy": false
},
{
"column": "H5_LOG.EVENTID",
"encoding": "dict",
"isShardBy": false
},
{
"column": "H5_LOG.SOURCEPAGEID",
"encoding": "dict",
"isShardBy": false
},
{
"column": "H5_LOG.LIMITACTIVITYID",
"encoding": "dict",
"isShardBy": false
},
{
"column": "H5_LOG.ITEM_ID",
"encoding": "dict",
"isShardBy": false
},
{
"column": "H5_LOG.BRAND_ID",
"encoding": "dict",
"isShardBy": false
},
{
"column": "H5_LOG.SUBJECT_ID",
"encoding": "dict",
"isShardBy": false
}
]
},
"hbase_mapping": {
"column_family": [
{
"name": "F1",
"columns": [
{
"qualifier": "M",
"measure_refs": [
"PV"
]
}
]
},
{
"name": "F2",
"columns": [
{
"qualifier": "M",
"measure_refs": [
"UV"
]
}
]
}
]
},
"aggregation_groups": [
{
"includes": [
"H5_LOG.CHANNELID",
"H5_LOG.SOURCEPAGEID",
"H5_LOG.PRESENTPAGEID",
"H5_LOG.LIMITACTIVITYID",
"H5_LOG.ITEM_ID",
"H5_LOG.DAY",
"H5_LOG.EVENTID"
],
"select_rule": {
"hierarchy_dims": [],
"mandatory_dims": [
"H5_LOG.CHANNELID",
"H5_LOG.SOURCEPAGEID",
"H5_LOG.PRESENTPAGEID",
"H5_LOG.LIMITACTIVITYID",
"H5_LOG.ITEM_ID",
"H5_LOG.DAY",
"H5_LOG.EVENTID"
],
"joint_dims": []
}
},
{
"includes": [
"H5_LOG.DAY",
"H5_LOG.PRESENTPAGEID",
"H5_LOG.CHANNELID",
"H5_LOG.SOURCEPAGEID"
],
"select_rule": {
"hierarchy_dims": [],
"mandatory_dims": [
"H5_LOG.DAY",
"H5_LOG.PRESENTPAGEID",
"H5_LOG.CHANNELID"
],
"joint_dims": []
}
}
],
"signature": "kGuAwA43qbYCZJn/el0bbA==",
"notify_list": [],
"status_need_notify": [
"ERROR",
"DISCARDED",
"SUCCEED"
],
"partition_date_start": 1496707200000,
"partition_date_end": 3153600000000,
"auto_merge_time_ranges": [
259200000,
777600000
],
"retention_range": 1296000000,
"engine_type": 2,
"storage_type": 2,
"override_kylin_properties": {
"mapreduce.map.child.java.opts": "-Xmx7g",
"mapreduce.map.memory.mb": "7168",
"kylin.dictionary.max.cardinality": "100000000",
"kylin.table.snapshot.max_mb": "1500"
}
}
