[
https://issues.apache.org/jira/browse/KYLIN-4914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17289719#comment-17289719
]
xue lin edited comment on KYLIN-4914 at 2/24/21, 7:10 AM:
----------------------------------------------------------
[~zzcclp]
but in my another cube, select * from \{fact_table} does work, which result
contains demensions and measures, demensions is as what it is and measures is
null
detailed results please refer to fig1 !select_dash_result.png!
was (Author: linlin994395):
[~zzcclp]
but in my another cube, select * from \{fact_table} does work, which result
contains demensions and measures, demensions is as what it is and measures is
null
detailed results please refer to fig1 !select_dash_result.png!
> Failed to query "select * from {fact_table}" if a fact table used in two
> different cubes
> -----------------------------------------------------------------------------------------
>
> Key: KYLIN-4914
> URL: https://issues.apache.org/jira/browse/KYLIN-4914
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v3.0.2
> Reporter: xue lin
> Priority: Major
> Attachments: select_dash_result.png
>
>
> Steps to reproduce:
> 1. Create one model only use one fact table
> 2. Create two cubes with the same models, they have different dimensions and
> measures, one cube measures contain COUNT_DISTINCT（return type : bitmap）the
> other cube measures containEXTENDED_COLUMN (return type :
> extendedcolumn(100)) and build the 2 cubes
> 3. Run query with "select * from
> {fact_table}
> " with the 2 cubes in ready status, it should be failed with exception
> message like
> "
> No model found for OLAPContext,
> CUBE_NOT_CONTAIN_ALL_COLUMN[1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.SUBSCRIBER_ID],
>
> CUBE_NOT_CONTAIN_ALL_COLUMN[1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.SUBSCRIBER_STATUS_ID,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.PBO_SOURCE_TYPE_ID,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_CREATE_CHANNEL_TYPE_NAME,
>
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.SUB_AR_RESOURCE_TYPE_NAME,
>
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_CREATE_CHANNEL_TYPE_ID,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_REGION,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_COMPANY_NAME,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_CREATE_CHANNEL_ID,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_SALE_AREA,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.SUBSCRIBER_PROTOCOL_TYPE_ID,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.RATE_BILLING_CYCLE_ID,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.MAIN_AR_RESOURCE_TYPE_NAME,
>
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.PBO_PRESENT_SOURCE_TYPE,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.ACTUAL_DAY_AMOUNT,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_TYPE,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_ADDRESS_ID,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_STATUS_ID,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_TYPE_ID,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.SUBSCRIBER_PROTOCOL_TYPE,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.DAY_AMOUNT,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.PBO_SOURCE_TYPE,
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.SUBSCRIBER_BUSINESS_NAME,
>
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.PBO_PRESENT_SOURCE_TYPE_ID,
>
> 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_CREATE_CHANNEL_NAME],
> rel#2656421:OLAPTableScan.OLAP.[](table=[BOSS_DATABUS,
> MIRROR_DATABUS_SUBSCRIPTIONFEE],ctx=,fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9,
> 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28,
> 29, 30, 31, 32, 33]) while executing SQL: "select * from
> MIRROR_DATABUS_SUBSCRIPTIONFEE limit 10"
>
> this issue is similar but different with
> https://issues.apache.org/jira/browse/KYLIN-4120
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
