You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Zhixiong Chen (JIRA)" <ji...@apache.org> on 2018/04/23 05:55:00 UTC
[jira] [Commented] (KYLIN-3333) Web ui shows successfully adding
global dictionary, but it does not actually
[ 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)