[
https://issues.apache.org/jira/browse/KYLIN-3333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16447606#comment-16447606
]
Zhixiong Chen commented on KYLIN-3333:
--------------------------------------
I find there is limitation for count distinct measure which 'param ** value' is
int type column.
Hi,[~kangkaisen] I remember you add the limitation in
https://issues.apache.org/jira/browse/KYLIN-2604
Could you explain why you do this?
> Web ui shows successfully adding global dictionary, but it does not actually
> ----------------------------------------------------------------------------
>
> Key: KYLIN-3333
> URL: https://issues.apache.org/jira/browse/KYLIN-3333
> Project: Kylin
> Issue Type: Bug
> Components: Web , Website
> Affects Versions: v2.3.1
> Environment: cdh 5.14
> centos 6.9
> oracle jdk 1.8_131
> Reporter: YIJIANHUI
> Assignee: Zhixiong Chen
> Priority: Major
>
> I define a measure is count_distinct(order_id),when i add the column
> "order_id" as global dictionary,web ui prompt created successfully.but global
> dictionary column are not displayed on the web ui ,and there are no any
> errors in the log file.
>
> 2018-04-02 10:43:22,354 DEBUG [http-bio-7070-exec-6]
> controller.CubeController:1010 : Saving cube {
> "name": "GLD_MR_TEST",
> "model_name": "M_ORDER",
> "description": "",
> "dimensions": [
> {
> "name": "CALENDAR_DATE",
> "table": "OD",
> "column": "CALENDAR_DATE",
> "normal": "true"
> },
> {
> "name": "YEAR_MONTH",
> "table": "OD",
> "column": "YEAR_MONTH",
> "normal": "true"
> }
> ],
> "measures": [
> {
> "name": "_COUNT_",
> "function": {
> "expression": "COUNT",
> "returntype": "bigint",
> "parameter": {
> "type": "constant",
> "value": "1"
> },
> "configuration": {}
> }
> },
> {
> "name": "CD",
> "function": {
> "expression": "COUNT_DISTINCT",
> "returntype": "bitmap",
> "parameter": {
> "type": "column",
> "value": "FACT_ORDER_DETAIL.ORDER_ID"
> }
> },
> "showDim": false
> }
> ],
> "dictionaries": [],
> "rowkey": {
> "rowkey_columns": [
> {
> "column": "OD.CALENDAR_DATE",
> "encoding": "dict",
> "isShardBy": "false",
> "encoding_version": 1
> },
> {
> "column": "OD.YEAR_MONTH",
> "encoding": "dict",
> "isShardBy": "false",
> "encoding_version": 1
> }
> ]
> },
> "aggregation_groups": [
> {
> "includes": [
> "OD.CALENDAR_DATE",
> "OD.YEAR_MONTH"
> ],
> "select_rule": {
> "hierarchy_dims": [],
> "mandatory_dims": [
> "OD.CALENDAR_DATE",
> "OD.YEAR_MONTH"
> ],
> "joint_dims": []
> }
> }
> ],
> "mandatory_dimension_set_list": [],
> "partition_date_start": 1514764800000,
> "notify_list": [],
> "hbase_mapping": {
> "column_family": [
> {
> "name": "F1",
> "columns": [
> {
> "qualifier": "M",
> "measure_refs": [
> "_COUNT_"
> ]
> }
> ]
> },
> {
> "name": "F2",
> "columns": [
> {
> "qualifier": "M",
> "measure_refs": [
> "CD"
> ]
> }
> ]
> }
> ]
> },
> "volatile_range": "0",
> "retention_range": "0",
> "status_need_notify": [
> "ERROR",
> "DISCARDED",
> "SUCCEED"
> ],
> "auto_merge_time_ranges": [],
> "engine_type": 2,
> "storage_type": "2",
> "override_kylin_properties": {}
> }
> 2018-04-02 10:43:22,356 DEBUG [http-bio-7070-exec-6]
> cachesync.CachedCrudAssist:190 : Saving CubeDesc at
> /cube_desc/GLD_MR_TEST.json
> 2018-04-02 10:43:22,359 DEBUG [pool-6-thread-1] cachesync.Broadcaster:113 :
> Servers in the cluster: [localhost:7070]
> 2018-04-02 10:43:22,359 DEBUG [pool-6-thread-1] cachesync.Broadcaster:123 :
> Announcing new broadcast to all: BroadcastEvent\{entity=cube_desc,
> event=create, cacheKey=GLD_MR_TEST}
> 2018-04-02 10:43:22,361 DEBUG [http-bio-7070-exec-4]
> cachesync.Broadcaster:247 : Broadcasting CREATE, cube_desc, GLD_MR_TEST
> 2018-04-02 10:43:22,361 INFO [http-bio-7070-exec-6] service.CubeService:211
> : New cube GLD_MR_TEST has 1 cuboids
> 2018-04-02 10:43:22,362 INFO [http-bio-7070-exec-6] cube.CubeManager:219 :
> Creating cube 'dw_zyb-->GLD_MR_TEST' from desc 'GLD_MR_TEST'
> 2018-04-02 10:43:22,362 INFO [http-bio-7070-exec-6] cube.CubeManager:297 :
> Updating cube instance 'GLD_MR_TEST'
> 2018-04-02 10:43:22,362 DEBUG [http-bio-7070-exec-6]
> cachesync.CachedCrudAssist:190 : Saving CubeInstance at /cube/GLD_MR_TEST.json
> 2018-04-02 10:43:22,362 DEBUG [http-bio-7070-exec-4]
> cachesync.Broadcaster:247 : Broadcasting UPDATE, project_schema, dw_zyb
> 2018-04-02 10:43:22,364 DEBUG [pool-6-thread-1] cachesync.Broadcaster:113 :
> Servers in the cluster: [localhost:7070]
> 2018-04-02 10:43:22,364 DEBUG [pool-6-thread-1] cachesync.Broadcaster:123 :
> Announcing new broadcast to all: BroadcastEvent\{entity=cube, event=create,
> cacheKey=GLD_MR_TEST}
> 2018-04-02 10:43:22,365 DEBUG [http-bio-7070-exec-6]
> cachesync.CachedCrudAssist:190 : Saving ProjectInstance at
> /project/dw_zyb.json
> 2018-04-02 10:43:22,367 DEBUG [pool-6-thread-1] cachesync.Broadcaster:113 :
> Servers in the cluster: [localhost:7070]
> 2018-04-02 10:43:22,367 DEBUG [pool-6-thread-1] cachesync.Broadcaster:123 :
> Announcing new broadcast to all: BroadcastEvent\{entity=project,
> event=update, cacheKey=dw_zyb}
> 2018-04-02 10:43:22,376 DEBUG [http-bio-7070-exec-4]
> project.ProjectL2Cache:195 : Loading L2 project cache for dw_zyb
> 2018-04-02 10:43:22,376 WARN [http-bio-7070-exec-4]
> realization.RealizationRegistry:91 : No provider for realization type
> INVERTED_INDEX
> 2018-04-02 10:43:22,378 INFO [http-bio-7070-exec-4] service.CacheService:120
> : cleaning cache for project dw_zyb (currently remove all entries)
> 2018-04-02 10:43:22,378 DEBUG [http-bio-7070-exec-4]
> cachesync.Broadcaster:281 : Done broadcasting UPDATE, project_schema, dw_zyb
> 2018-04-02 10:43:22,378 DEBUG [http-bio-7070-exec-4]
> cachesync.Broadcaster:281 : Done broadcasting CREATE, cube_desc, GLD_MR_TEST
> 2018-04-02 10:43:22,381 DEBUG [http-bio-7070-exec-1]
> cachesync.Broadcaster:247 : Broadcasting CREATE, cube, GLD_MR_TEST
> 2018-04-02 10:43:22,383 DEBUG [http-bio-7070-exec-1]
> cachesync.Broadcaster:247 : Broadcasting UPDATE, project_data, dw_zyb
> 2018-04-02 10:43:22,383 INFO [http-bio-7070-exec-1] service.CacheService:120
> : cleaning cache for project dw_zyb (currently remove all entries)
> 2018-04-02 10:43:22,383 DEBUG [http-bio-7070-exec-1]
> cachesync.Broadcaster:281 : Done broadcasting UPDATE, project_data, dw_zyb
> 2018-04-02 10:43:22,383 DEBUG [http-bio-7070-exec-1]
> cachesync.Broadcaster:281 : Done broadcasting CREATE, cube, GLD_MR_TEST
> 2018-04-02 10:43:22,386 DEBUG [http-bio-7070-exec-1]
> cachesync.Broadcaster:247 : Broadcasting UPDATE, project, dw_zyb
> 2018-04-02 10:43:22,387 DEBUG [http-bio-7070-exec-1]
> project.ProjectL2Cache:195 : Loading L2 project cache for dw_zyb
> 2018-04-02 10:43:22,387 WARN [http-bio-7070-exec-1]
> realization.RealizationRegistry:91 : No provider for realization type
> INVERTED_INDEX
> 2018-04-02 10:43:22,387 DEBUG [http-bio-7070-exec-1]
> cachesync.Broadcaster:247 : Broadcasting UPDATE, project_schema, dw_zyb
> 2018-04-02 10:43:22,402 DEBUG [http-bio-7070-exec-1]
> project.ProjectL2Cache:195 : Loading L2 project cache for dw_zyb
> 2018-04-02 10:43:22,402 WARN [http-bio-7070-exec-1]
> realization.RealizationRegistry:91 : No provider for realization type
> INVERTED_INDEX
> 2018-04-02 10:43:22,404 INFO [http-bio-7070-exec-1] service.CacheService:120
> : cleaning cache for project dw_zyb (currently remove all entries)
> 2018-04-02 10:43:22,404 DEBUG [http-bio-7070-exec-1]
> cachesync.Broadcaster:281 : Done broadcasting UPDATE, project_schema, dw_zyb
> 2018-04-02 10:43:22,405 DEBUG [http-bio-7070-exec-1]
> cachesync.Broadcaster:247 : Broadcasting UPDATE, project_data, dw_zyb
> 2018-04-02 10:43:22,405 INFO [http-bio-7070-exec-1] service.CacheService:120
> : cleaning cache for project dw_zyb (currently remove all entries)
> 2018-04-02 10:43:22,405 DEBUG [http-bio-7070-exec-1]
> cachesync.Broadcaster:281 : Done broadcasting UPDATE, project_data, dw_zyb
> 2018-04-02 10:43:22,405 DEBUG [http-bio-7070-exec-1]
> cachesync.Broadcaster:281 : Done broadcasting UPDATE, project, dw_zyb
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
