The description is not accurate enough. When you say something wrong, you
need tell others how to reproduce your issue on other's environment.
2017-06-08 18:39 GMT+08:00 梁永雄 <liangyongxiong1...@foxmail.com>:
> 下面是我的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"
> }
> }
>
>
